
Concept explainers
Using the data for the coffee table in Problem 14.31, build a labor

To determine: The number of labor hours and employees needed each day.
Explanation of Solution
Given information:
- Table requires 1 top, 4 legs, 1/8 gallon of strain, 1/16 gallon of blue, 2 short braces, 2 long braces, and brass cap on the bottom of each leg.
- 100 gallons of glue as inventory.
- All items except brass caps, stain and glue are planned on a Lot for lot basis.
- Caps are purchased in 1000’s, stain and glue by gallon.
- Lead time = 1 (for each item).
- 640 coffee tables needed on day 5 and 6.
- 128 coffee tables needed on days 7 and 8.
- Labor standard for each top is 2 labor hours.
- Each leg with brass cap installation and each pair of braces need ¼ hour.
- Base assembly needs 1 labor hour.
- Final assembly of table requires 2 labor hours.
- Number of hours per day is 8.
Product structure:
Net requirements plan:
Table:
Period (Day) | ||||||||
Table | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
Gross requirements | 640 | 640 | 128 | 128 | ||||
Scheduled receipt | ||||||||
On hand (0) | 0 | 0 | 0 | 0 | ||||
Net requirement | 640 | 640 | 128 | 128 | ||||
Planned order receipt | 640 | 640 | 128 | 128 | ||||
Planned order release | 640 | 640 | 128 | 128 |
Day 5:
The gross requirement is 640 (1 assembly) of Coffee table derived from the given information. The On hand is 0. Therefore, the net requirement is 640. The lead time is 1 week. The planned order release will be 640 in day 4 which will be the planned order receipt in day 5.
Day 6:
The gross requirement is 640 (1 assembly) of Coffee table derived from the given information. The On hand is 0. Therefore, the net requirement is 640. The lead time is 1 week. The planned order release will be 640 in day 5 which will be the planned order receipt in day 6.
Day 7:
The gross requirement is 128 (1 assembly) of Coffee table derived from the given information. The On hand is 0. Therefore, the net requirement is 128. The lead time is 1 week. The planned order release will be 128 in day 6 which will be the planned order receipt in day 7.
Day 8:
The gross requirement is 128 (1 assembly) of Coffee table derived from the given information. The On hand is 0. Therefore, the net requirement is 128. The lead time is 1 week. The planned order release will be 128 in day 7 which will be the planned order receipt in day 8.
Top:
Period (Day) | ||||||||
Top | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
Gross requirements | 640 | 640 | 128 | 128 | ||||
Scheduled receipt | ||||||||
On hand (0) | 0 | 0 | 0 | 0 | ||||
Net requirement | 640 | 640 | 128 | 128 | ||||
Planned order receipt | 640 | 640 | 128 | 128 | ||||
Planned order release | 640 | 640 | 128 | 128 |
Day 4:
The gross requirement is 640 (1 assembly) of Top derived from the planned order release of Table. The On hand is 0. Therefore, the net requirement is 640. The lead time is 1 week. The planned order release will be 640 in day 3 which will be the planned order receipt in day 4.
Day 5:
The gross requirement is 640 (1 assembly) of Top derived from the planned order release of Table. The On hand is 0. Therefore, the net requirement is 640. The lead time is 1 week. The planned order release will be 640 in day 4 which will be the planned order receipt in day 5.
Day 6:
The gross requirement is 128 (1 assembly) of Top derived from the planned order release of Table. The On hand is 0. Therefore, the net requirement is 128. The lead time is 1 week. The planned order release will be 128 in day 5 which will be the planned order receipt in day 6.
Day 7:
The gross requirement is 128 (1 assembly) of Top derived from the planned order release of Table. The On hand is 0. Therefore, the net requirement is 128. The lead time is 1 week. The planned order release will be 128 in day 6 which will be the planned order receipt in day 7.
Stain:
Period (Day) | ||||||||
Stain | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
Gross requirements | 80 | 80 | 16 | 16 | ||||
Scheduled receipt | ||||||||
On hand (0) | 0 | 0 | 0 | 0 | ||||
Net requirement | 80 | 80 | 16 | 16 | ||||
Planned order receipt | 80 | 80 | 16 | 16 | ||||
Planned order release | 80 | 80 | 16 | 16 |
Day 4:
The gross requirement is 80 (1 assembly) of Stain derived from the planned order release of Table. The On hand is 0. Therefore, the net requirement is 80. The lead time is 1 week. The planned order release will be 80 in day 3 which will be the planned order receipt in day 4.
Day 5:
The gross requirement is 80 (1 assembly) of Stain derived from the planned order release of Table. The On hand is 0. Therefore, the net requirement is 80. The lead time is 1 week. The planned order release will be 80 in day 4 which will be the planned order receipt in day 5.
Day 6:
The gross requirement is 16 (1 assembly) of Stain derived from the planned order release of Table. The On hand is 0. Therefore, the net requirement is 16. The lead time is 1 week. The planned order release will be 16 in day 5 which will be the planned order receipt in day 6.
Day 7:
The gross requirement is 16 (1 assembly) of Stain derived from the planned order release of Table. The On hand is 0. Therefore, the net requirement is 16. The lead time is 1 week. The planned order release will be 16 in day 6 which will be the planned order receipt in day 7.
Glue:
Period (Day) | ||||||||
Glue | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
Gross requirements | 40 | 40 | 8 | 8 | ||||
Scheduled receipt | ||||||||
On hand (100) | 100 | 60 | 20 | 12 | 4 | |||
Net requirement | 0 | 0 | 0 | 0 | ||||
Planned order receipt | ||||||||
Planned order release |
Day 4:
The gross requirement is 40 (1 assembly) of Glue derived from the planned order release of Table. The On hand is 100. Therefore, the net requirement is 0. Therefore there will be no planned order release. The excess inventory 60 will be available at week 5.
Day 5:
The gross requirement is 40 (1 assembly) of Glue derived from the planned order release of Table. The On hand is 60. Therefore, the net requirement is 0. Therefore there will be no planned order release. The excess inventory 20 will be available at week 6.
Day 6:
The gross requirement is 8 (1 assembly) of Glue derived from the planned order release of Table. The On hand is 20. Therefore, the net requirement is 0. Therefore there will be no planned order release. The excess inventory 12 will be available at week 7.
Day 7:
The gross requirement is 8 (1 assembly) of Glue derived from the planned order release of Table. The On hand is 12. Therefore, the net requirement is 0. Therefore there will be no planned order release. The excess inventory 8 will be available at week 8.
Base assembly:
Period (Day) | ||||||||
Base | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
Gross requirements | 640 | 640 | 128 | 128 | ||||
Scheduled receipt | ||||||||
On hand (0) | 0 | 0 | 0 | 0 | ||||
Net requirement | 640 | 640 | 128 | 128 | ||||
Planned order receipt | 640 | 640 | 128 | 128 | ||||
Planned order release | 640 | 640 | 128 | 128 |
Day 4:
The gross requirement is 640 (1 assembly) of base assembly derived from the planned order release of Table. The On hand is 0. Therefore, the net requirement is 640. The lead time is 1 week. The planned order release will be 640 in day 3 which will be the planned order receipt in day 4.
Day 5:
The gross requirement is 640 (1 assembly) of base assembly derived from the planned order release of Table. The On hand is 0. Therefore, the net requirement is 640. The lead time is 1 week. The planned order release will be 640 in day 4 which will be the planned order receipt in day 5.
Day 6:
The gross requirement is 128 (1 assembly) of base assembly derived from the planned order release of Table. The On hand is 0. Therefore, the net requirement is 128. The lead time is 1 week. The planned order release will be 128 in day 5 which will be the planned order receipt in day 6.
Day 7:
The gross requirement is 128 (1 assembly) of base assembly derived from the planned order release of Table. The On hand is 0. Therefore, the net requirement is 128. The lead time is 1 week. The planned order release will be 128 in day 6 which will be the planned order receipt in day 7.
Short brace:
Period (Day) | ||||||||
Short Brace | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
Gross requirements | 1,280 | 1,280 | 256 | 256 | ||||
Scheduled receipt | ||||||||
On hand (0) | 0 | 0 | 0 | 0 | ||||
Net requirement | 1,280 | 1,280 | 256 | 256 | ||||
Planned order receipt | 1,280 | 1,280 | 256 | 256 | ||||
Planned order release | 1,280 | 1,280 | 256 | 256 |
Day 3:
The gross requirement is 1,280 (2 assembly) of short brace derived from the planned order release of base assembly. The On hand is 0. Therefore, the net requirement is 1,280. The lead time is 1 week. The planned order release will be 1,280 in day 2 which will be the planned order receipt in day 3.
Day 4:
The gross requirement is 1,280 (2 assembly) of short brace derived from the planned order release of base assembly. The On hand is 0. Therefore, the net requirement is 1,280. The lead time is 1 week. The planned order release will be 1,280 in day 3 which will be the planned order receipt in day 4.
Day 5:
The gross requirement is 256 (2 assembly) of short brace derived from the planned order release of base assembly. The On hand is 0. Therefore, the net requirement is 256. The lead time is 1 week. The planned order release will be 256 in day 4 which will be the planned order receipt in day 5.
Day 6:
The gross requirement is 256 (2 assembly) of short brace derived from the planned order release of base assembly. The On hand is 0. Therefore, the net requirement is 256. The lead time is 1 week. The planned order release will be 256 in day 5 which will be the planned order receipt in day 6.
Long brace:
Period (Day) | ||||||||
Long Brace | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
Gross requirements | 1,280 | 1,280 | 256 | 256 | ||||
Scheduled receipt | ||||||||
On hand (0) | 0 | 0 | 0 | 0 | ||||
Net requirement | 1,280 | 1,280 | 256 | 256 | ||||
Planned order receipt | 1,280 | 1,280 | 256 | 256 | ||||
Planned order release | 1,280 | 1,280 | 256 | 256 |
Day 3:
The gross requirement is 1,280 (2 assembly) of long brace derived from the planned order release of base assembly. The On hand is 0. Therefore, the net requirement is 1,280. The lead time is 1 week. The planned order release will be 1,280 in day 2 which will be the planned order receipt in day 3.
Day 4:
The gross requirement is 1,280 (2 assembly) of long brace derived from the planned order release of base assembly. The On hand is 0. Therefore, the net requirement is 1,280. The lead time is 1 week. The planned order release will be 1,280 in day 3 which will be the planned order receipt in day 4.
Day 5:
The gross requirement is 256 (2 assembly) of long brace derived from the planned order release of base assembly. The On hand is 0. Therefore, the net requirement is 256. The lead time is 1 week. The planned order release will be 256 in day 4 which will be the planned order receipt in day 5.
Day 6:
The gross requirement is 256 (2 assembly) of long brace derived from the planned order release of base assembly. The On hand is 0. Therefore, the net requirement is 256. The lead time is 1 week. The planned order release will be 256 in day 5 which will be the planned order receipt in day 6.
Leg:
Period (Day) | ||||||||
Leg | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
Gross requirements | 2,560 | 2,560 | 512 | 512 | ||||
Scheduled receipt | ||||||||
On hand (0) | ||||||||
Net requirement | 2,560 | 2,560 | 512 | 512 | ||||
Planned order receipt | 2,560 | 2,560 | 512 | 512 | ||||
Planned order release | 2,560 | 2,560 | 512 | 512 |
Day 3:
The gross requirement is 2,560 (4 assembly) of leg derived from the planned order release of base assembly. The On hand is 0. Therefore, the net requirement is 2,560. The lead time is 1 week. The planned order release will be 2,560 in day 2 which will be the planned order receipt in day 3.
Day 4:
The gross requirement is 2,560 (4 assembly) of leg derived from the planned order release of base assembly. The On hand is 0. Therefore, the net requirement is 2,560. The lead time is 1 week. The planned order release will be 2,560 in day 3 which will be the planned order receipt in day 4.
Day 5:
The gross requirement is 512 (4 assembly) of leg derived from the planned order release of base assembly. The On hand is 0. Therefore, the net requirement is 512. The lead time is 1 week. The planned order release will be 512 in day 4 which will be the planned order receipt in day 5.
Day 6:
The gross requirement is 512 (4 assembly) of leg derived from the planned order release of base assembly. The On hand is 0. Therefore, the net requirement is 256. The lead time is 1 week. The planned order release will be 512 in day 5 which will be the planned order receipt in day 6.
Brass caps:
Period (Day) | ||||||||
Brass caps | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
Gross requirements | 2,560 | 2,560 | 512 | 512 | ||||
Scheduled receipt | ||||||||
On hand (0) | 0 | 440 | 880 | 368 | 856 | 856 | 856 | |
Net requirement | 2,560 | 2,120 | 0 | 144 | ||||
Planned order receipt | 3,000 | 3,000 | 1,000 | |||||
Planned order release | 3,000 | 3,000 | 1,000 |
Day 2:
The gross requirement is 2,560 (1 assembly) of brass caps derived from the planned order release of legs. The On hand is 0. Therefore, the net requirement is 2,560. The lead time is 1 week. The planned order release will be 3,000 (1 Lot = 1,000) in day 1 which will be the planned order receipt in day 2. The excess inventory of 440 is available at day 3.
Day 3:
The gross requirement is 2,560 (1 assembly) of brass caps derived from the planned order release of legs. The On hand is 440. Therefore, the net requirement is 2,120. The lead time is 1 week. The planned order release will be 3,000 (1 Lot = 1,000) in day 2 which will be the planned order receipt in day 3. The excess inventory of 880 is available at day 4.
Day 4:
The gross requirement is 512 (1 assembly) of brass caps derived from the planned order release of legs. The On hand is 880. Therefore, the net requirement is 0. Therefore, there will be no planned release. The excess inventory of 368 is available at day 5.
Day 5:
The gross requirement is 512 (1 assembly) of brass caps derived from the planned order release of legs. The On hand is 368. Therefore, the net requirement is 144. The lead time is 1 week. The planned order release will be 1,000 (1 Lot = 1,000) in day 4 which will be the planned order receipt in day 5. The excess inventory of 856 is available at the next day.
Calculation of labor hours / day:
Master Schedule | Hours Required | Day 1 | Day 2 | Day 3 | Day 4 | Day 5 | Day 6 | Day 7 | Day 8 |
Table assembly | 2 | 1280 | 1280 | 256 | 256 | ||||
Top preparation | 2 | 1280 | 1280 | 256 | 256 | ||||
Assemble base | 1 | 640 | 640 | 128 | 128 | ||||
Long brace (2) | 0.25 | 320 | 320 | 64 | 64 | ||||
Short brace (2) | 0.25 | 320 | 320 | 64 | 64 | ||||
Leg (4) | 0.25 | 640 | 640 | 128 | 128 | ||||
Total Hours | 0 | 1280 | 3200 | 3456 | 1920 | 640 | 256 | ||
Employees need @ 8 hours / day | 0 | 160 | 400 | 432 | 240 | 80 | 32 |
The master production schedule is derived from net requirements plan.
Formula to calculate number of hours / each day:
Formula to calculate the number of employees per 8 hour day:
Day 2:
Calculation of total hours for each day for each component:
Long brace:
Short brace:
Leg:
Calculation of total hours / day:
The total hours is calculated by summing all the hours needed for each component in a day.
Calculation of number of employees per 8 hour day:
The number of employees is calculated by dividing the total hours per day with the number of hours per day.
Day 3:
Calculation of total hours for each day for each component:
Top preparation:
Assemble base:
Long brace:
Short brace:
Leg:
Calculation of total hours / day:
The total hours is calculated by summing all the hours needed for each component in a day.
Calculation of number of employees per 8 hour day:
The number of employees is calculated by dividing the total hours per day with the number of hours per day.
Day 4:
Calculation of total hours for each day for each component:
Table assembly:
Top preparation:
Assemble base:
Long brace:
Short brace:
Leg:
Calculation of total hours / day:
The total hours is calculated by summing all the hours needed for each component in a day.
Calculation of number of employees per 8 hour day:
The number of employees is calculated by dividing the total hours per day with the number of hours per day.
Day 5:
Calculation of total hours for each day for each component:
Table assembly:
Top preparation:
Assemble base:
Long brace:
Short brace:
Leg:
Calculation of total hours / day:
The total hours is calculated by summing all the hours needed for each component in a day.
Calculation of number of employees per 8 hour day:
The number of employees is calculated by dividing the total hours per day with the number of hours per day.
Day 6:
Calculation of total hours for each day for each component:
Table assembly:
Top preparation:
Assemble base:
Calculation of total hours / day:
The total hours is calculated by summing all the hours needed for each component in a day.
Calculation of number of employees per 8 hour day:
The number of employees is calculated by dividing the total hours per day with the number of hours per day.
Day 7:
Calculation of total hours for each day for each component:
Table assembly:
Calculation of total hours / day:
The total hours is calculated by summing all the hours needed for each component in a day.
Calculation of number of employees per 8 hour day:
The number of employees is calculated by dividing the total hours per day with the number of hours per day.
Want to see more full solutions like this?
Chapter 14 Solutions
Principles Of Operations Management
- 1. Hofstede’s Cultural Dimensions in Managerial Decision-MakingChoose two of Hofstede’s dimensions (e.g., Power Distance, Individualism–Collectivism, Uncertainty Avoidance, Masculinity–Femininity) and analyze how differences between two specific countries impact managerial decisions such as delegation, risk-taking, or performance appraisal. Provide real or hypothetical business scenarios that illustrate these effects. 2. Communication Styles Across CulturesCompare and contrast high-context versus low-contextcommunication cultures (Hall’s framework). Select one high-context country and one low-context country and evaluate the implications for written reports, virtual meetings, and feedback delivery. Develop three practical guidelines for an international manager to navigate these differences effectively.arrow_forwardCalculate the Current Ratio for Home Depot for the fiscal year-end February 2019? Enter the response as a ratio, rounded to two decimal places (X.XX) Calculate the Debt to Equity Ratiof or Home Depot for the fiscal year-end February 2019. Enter the response as a ratio, rounded to two decimal places (X.XX) Calculate the Rate of Return on Total Assets for Home Depot for the fiscal year-end February 2019. Round your answer to two decimal places For disclosure purposes, how many segments did the company report?arrow_forwardDiscuss Probability and Probability Distributions, Provide good rationale and share some examples.arrow_forward
- 3. Conducting Research:What types of information should a negotiator research before entering a negotiation? Provide an example of how effective research can strengthen a negotiator’s position. 4. Anticipating the Other Party’s Interests:Why is it important to understand the interests and objectives of the other party? How can this knowledge improve the chances of a successful negotiation? 5. Chapter Summary Reflection:Reflect on the key lessons from Chapter 3. How do preparation and research work together to build confidence and increase your negotiation effectiveness?arrow_forwardUse real-life or hypothetical examples where appropriate to support your responses. 1. Preparation and Planning:Why is preparation and planning considered essential for negotiation success? Describe at least two steps negotiators should take during the planning phase. 2. Setting Goals and Priorities:When preparing for a negotiation, how should a negotiator set their goals and determine their priorities? How do clear goals impact the negotiation outcome?arrow_forwardWhat was the closing stock price on the last day of business for the fiscal year-end February 2019 for Home Depot? Look it up. Enter the response in terms of dollars and cents Calculate the Price/Earnings ratio at the end of the fiscal year-end February 2019 for Home Depot. Round your answer to two decimal places. Enter as (XX.XX) How many shares of Treasury Stock does the Home Depot have at their fiscal year-end February 2019? If none, enter “0”. Did the Home Depot pay dividends? What is the amount per share for the entire fiscal year-end Februaruy 2019? If none, enter “0”. Enter the response in terms of dollars and cents ($XXX.XX)arrow_forward
- What were the Basic Earnings Per Share for the fiscal year-end February 2019 for Home Depot published in the financial statements? Enter the response in terms of dollars and cents ($XXX.XX)arrow_forwardCalculate the Current Ratio for Home Depot for the fiscal year-end February 2019? Enter the response as a ratio, rounded to two decimal places (X.XX) Calculate the Debt to Equity Ratiof or Home Depot for the fiscal year-end February 2019. Enter the response as a ratio, rounded to two decimal places (X.XX) Calculate the Rate of Return on Total Assets for Home Depot for the fiscal year-end February 2019. Round your answer to two decimal places For disclosure purposes, how many segments did the company report?arrow_forwardWhat was the closing stock price on the last day of business for the fiscal year-end February 2019 for Home Depot? Look it up. Enter the response in terms of dollars and cents ($XXX.XX) Calculate the Price/Earnings ratio at the end of the fiscal year-end February 2019?.Round your answer to two decimal places. Enter as (XX.XX) How many shares of Treasury Stock does the company have at their fiscal year-end February 2019? If none, enter “0”. Did the company pay dividends? What is the amount per share for the entire fiscal year-end February 2019? If none, enter “0”. Enter the response in terms of dollars and cents ($XXX.XX) What is the amount of cash generated (or used) by Operating Activities on the Statement of Cash Flows for the fiscal year-end February 2019 ? (Enter the response in terms of dollars ($XXX,XXX,XXX,XXX or (-$XXX,XXX,XXX,XXX)) Calculate the Gross Profit Ratio for the fiscal year-end February 2019.Round your answer to two decimal places. Enter the response in terms of…arrow_forward
- What is the name of the Auditing Firm that conducted the audit for Home Depot for the fiscal year-end February 2019? What is the fiscal year-end date for the financials? State the answer in this format: MMDD19 What inventory method does the company use for the majority of their merchandise inventory? What depreciation method(s) are used to prepare the financial statements? Select all that apply. List the useful lives of the fixed assets used to calculate depreciation. Select all that apply. What were the number of common shares outstanding on the last day of the fiscal year? State the answer in the following format: (XXX,XXX,XXX) (not in millions)…arrow_forwardWalmart is one of the most important supermarket chains in the United States. It has subsidiaries in over 25 countries, with more than 6,000 stores. In 2014, however, it had problems in China. Based on the contents of the units, and any secondary sources that you consider relevant (such as articles published online or in another format), answer the following questions, providing support for your answers. Why did Walmart’s internationalization in China fail? What was the strategic option for entering the Chinese market? What would you have recommended? Which groups of stakeholders were not taken into consideration? What would the correct stakeholder analysis have been?arrow_forwarddescribe a company you believe uses these 3 items.arrow_forward
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,MarketingMarketingISBN:9780357033791Author:Pride, William MPublisher:South Western Educational Publishing
- Contemporary MarketingMarketingISBN:9780357033777Author:Louis E. Boone, David L. KurtzPublisher:Cengage LearningPurchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning


