Concept explainers
Videos
a)
To develop: A gross requirements plan for all the items.
Introduction:
Gross requirements plan:
The gross requirements plan is the plan where the independent and dependent demand for a product or a component before the on-hand inventory and the scheduled receipts are netted with.
a)
Explanation of Solution
Given information:
Product structure:
Master production
| MPS for X1 | ||||||
| Period | 7 | 8 | 9 | 10 | 11 | 12 |
| Gross requirements | 50 | 20 | 100 | |||
Inventory and lead time:
| Item | X1 | B1 | B2 | A1 | C | D | E |
| Lead time | 1 | 2 | 2 | 1 | 1 | 1 | 3 |
| On hand | 50 | 20 | 20 | 5 | 0 | 0 | 10 |
Item X1:
| Week | ||||||||||||
| Item X1 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| Gross requirements | 50 | 20 | 100 | |||||||||
| Order release | 50 | 20 | 100 | |||||||||
The gross requirements are 50, 20 and 100 (1 assembly of X1) in weeks 8, 10 and 12 respectively derived from the master production schedule of X1. The lead time is 1 week. Therefore, the order release will be 50, 20 and 100 in weeks 7, 9 and 11 respectively.
Item B1:
| Week | ||||||||||||
| Item B1 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| Gross requirements | 50 | 20 | 100 | |||||||||
| Order release | 50 | 20 | 100 | |||||||||
The order release of X1 will become the gross requirements of B1. The gross requirements are 50, 20 and 100 (1 assembly of B1) in weeks 7, 9 and 11 respectively. The lead time is 2 weeks. Therefore, the order release will be 50, 20 and 100 in weeks 5, 7 and 9 respectively.
Item B2:
| Week | ||||||||||||
| Item B2 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| Gross requirements | 100 | 40 | 200 | |||||||||
| Order release | 100 | 40 | 200 | |||||||||
The order release of X1 will become the gross requirements of B2. The gross requirements are 100, 40 and 200 (2 assemblies of B2) in weeks 7, 9 and 11 respectively. The lead time is 2 weeks. Therefore, the order release will be 100, 40 and 200 in weeks 5, 7 and 9 respectively.
Item A1:
| Week | ||||||||||||
| Item A1 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| Gross requirements | 50 | 20 | 100 | |||||||||
| Order release | 50 | 20 | 100 | |||||||||
The order release of B1 will become the gross requirements of A1. The gross requirements are 50, 20 and 100 (1 assembly of A1) in weeks 5, 7 and 9 respectively. The lead time is 1 week. Therefore, the order release will be 50, 20 and 100 in weeks 4, 6 and 8 respectively.
Item C:
| Week | ||||||||||||
| Item C | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| Gross requirements | 200 | 80 | 400 | |||||||||
| Order release | 200 | 80 | 400 | |||||||||
The order release of B2 will become the gross requirements of C. The gross requirements are 200, 80 and 400 (2 assemblies of C) in weeks 5, 7 and 9 respectively. The lead time is 1 week. Therefore, the order release will be 200, 80 and 400 in weeks 4, 6 and 8 respectively.
Item D:
| Week | ||||||||||||
| Item D | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| Gross requirements | 100 | 40 | 200 | |||||||||
| Order release | 100 | 40 | 200 | |||||||||
The order release of B2 will become the gross requirements of D. The gross requirements are 100, 40 and 200 (2 assemblies of C) in weeks 5, 7 and 9 respectively. The lead time is 1 week. Therefore, the order release will be 100, 40 and 200 in weeks 4, 6 and 8 respectively.
Item E:
| Week | ||||||||||||
| Item E | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| Gross requirements | 200 | 50 | 80 | 20 | 400 | 100 | ||||||
| Order release | 200 | 50 | 80 | 20 | 400 | 100 | ||||||
The order release of B1 and D will become the gross requirements of E. The gross requirements are 50, 20 and 100 (1 assembly of E) in weeks 5, 7 and 9 respectively. The lead time is 3 weeks. Therefore, the order release will be 50, 20 and 100 in weeks 2, 4 and 6 respectively.
The gross requirements are 200, 80 and 400 (2 assembly of E) in weeks 4, 6 and 8 respectively. The lead time is 3 weeks. Therefore, the order release will be 200, 80 and 400 in weeks 1, 3 and 5 respectively.
b)
To develop: A net requirements plan for all the items.
Introduction:
Net requirements plan:
The net requirements plan is the plan which is established on the gross requirements plan formed by deducting the stock on and the scheduled receipts. If the total requirement is below the safety stock levels, a planned order is made based on the given lot sizing technique.
b)
Explanation of Solution
Given information:
Product structure:
Master production schedule for X1:
| MPS for X1 | ||||||
| Period | 7 | 8 | 9 | 10 | 11 | 12 |
| Gross requirements | 50 | 20 | 100 | |||
Inventory and lead time:
| Item | X1 | B1 | B2 | A1 | C | D | E |
| Lead time | 1 | 2 | 2 | 1 | 1 | 1 | 3 |
| On hand | 50 | 20 | 20 | 5 | 0 | 0 | 10 |
Item X1:
| Week | ||||||||||||
| Item X1 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| Gross requirements | 50 | 20 | 100 | |||||||||
| Scheduled receipt | ||||||||||||
| On hand (50) | 50 | 0 | 0 | |||||||||
| Net requirement | 0 | 20 | 100 | |||||||||
| Planned order receipt | 20 | 100 | ||||||||||
| Planned order release | 20 | 100 | ||||||||||
Week 8:
The gross requirement is 50 (1 assembly)derived from the master production schedule of X1. The on hand inventory is 50. Hence, the net requirement is 0. The lead time is 1 week. Therefore, there will be no planned order release.
Week 10:
The gross requirement is 20 (1 assembly) derived from the master production schedule of X1. The on hand inventory is 0. Hence, the net requirement is 20. The lead time is 1 week. Therefore, the planned order release will be 20 in week 9 which will be the planned order receipt in week 10.
Week 12:
The gross requirement is 100 (1 assembly) derived from the master production schedule of X1. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 1 week. Therefore, the planned order release will be 100 in week 11 which will be the planned order receipt in week 12.
Item B1:
| Week | ||||||||||||
| Item B1 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| Gross requirements | 20 | 100 | ||||||||||
| Scheduled receipt | ||||||||||||
| On hand (20) | 20 | 0 | ||||||||||
| Net requirement | 0 | 100 | ||||||||||
| Planned order receipt | 100 | |||||||||||
| Planned order release | 100 | |||||||||||
Week 9:
The gross requirement is 20 (1 assembly) derived from the planned order release of X1. The on hand inventory is 20. Hence, the net requirement is 0. The lead time is 2 weeks. Therefore, there will be no planned order release.
Week 11:
The gross requirement is 100 (1 assembly) derived from planned order release of X1. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 9 which will be the planned order receipt in week 11.
Item B2:
| Week | ||||||||||||
| Item B2 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| Gross requirements | 40 | 200 | ||||||||||
| Scheduled receipt | ||||||||||||
| On hand (20) | 20 | 0 | ||||||||||
| Net requirement | 20 | 200 | ||||||||||
| Planned order receipt | 20 | 200 | ||||||||||
| Planned order release | 20 | 200 | ||||||||||
Week 9:
The gross requirement is 40 (2 assembly) derived from the planned order release of X1. The on hand inventory is 20. Hence, the net requirement is 20. The lead time is 2 weeks. Therefore, the planned order release will be 20 in week 7 which will be the planned order receipt in week 9.
Week 11:
The gross requirement is 200 (2 assembly) derived from planned order release of X1. The on hand inventory is 0. Hence, the net requirement is 200. The lead time is 2 weeks. Therefore, the planned order release will be 200 in week 9 which will be the planned order receipt in week 11.
Item A1:
| Week | ||||||||||||
| Item A1 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| Gross requirements | 100 | |||||||||||
| Scheduled receipt | ||||||||||||
| On hand (5) | 5 | |||||||||||
| Net requirement | 95 | |||||||||||
| Planned order receipt | 95 | |||||||||||
| Planned order release | 95 | |||||||||||
Week 9:
The gross requirement is 100 (1 assembly) derived from the planned order release of B1. The on hand inventory is 5. Hence, the net requirement is 95. The lead time is 1 week. Therefore, the planned order release will be 95 in week 8 which will be the planned order receipt in week 9.
Item C:
| Week | ||||||||||||
| Item C | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| Gross requirements | 40 | 400 | ||||||||||
| Scheduled receipt | ||||||||||||
| On hand (0) | 0 | 0 | ||||||||||
| Net requirement | 40 | 400 | ||||||||||
| Planned order receipt | 40 | 400 | ||||||||||
| Planned order release | 40 | 400 | ||||||||||
Week 7:
The gross requirement is 40 (2 assembly) derived from the planned order release of B2. The on hand inventory is 0. Hence, the net requirement is 40. The lead time is 1 week. Therefore, the planned order release will be 40 in week 6 which will be the planned order receipt in week 7.
Week 9:
The gross requirement is 400 (2 assembly) derived from planned order release of B2. The on hand inventory is 0. Hence, the net requirement is 400. The lead time is 1 week. Therefore, the planned order release will be 400 in week 8 which will be the planned order receipt in week 9.
Item D:
| Week | ||||||||||||
| Item D | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| Gross requirements | 20 | 200 | ||||||||||
| Scheduled receipt | ||||||||||||
| On hand (0) | 0 | 0 | ||||||||||
| Net requirement | 20 | 200 | ||||||||||
| Planned order receipt | 20 | 200 | ||||||||||
| Planned order release | 20 | 200 | ||||||||||
Week 7:
The gross requirement is 20 (1 assembly) derived from the planned order release of B2. The on hand inventory is 0. Hence, the net requirement is 20. The lead time is 1 week. Therefore, the planned order release will be 20 in week 6 which will be the planned order receipt in week 7.
Week 9:
The gross requirement is 200 (1 assembly) derived from planned order release of B2. The on hand inventory is 0. Hence, the net requirement is 200. The lead time is 1 week. Therefore, the planned order release will be 200 in week 8 which will be the planned order receipt in week 9.
Item E:
| Week | ||||||||||||
| Item E | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| Gross requirements | 40 | 400 | 100 | |||||||||
| Scheduled receipt | ||||||||||||
| On hand (10) | 10 | 0 | 0 | |||||||||
| Net requirement | 30 | 400 | 100 | |||||||||
| Planned order receipt | ||||||||||||
| Planned order release | 30 | 400 | 100 | |||||||||
Week 6:
The gross requirement is 40 (2 assembly) derived from the planned order release of B2. The on hand inventory is 10. Hence, the net requirement is 30. The lead time is 3 weeks. Therefore, the planned order release will be 30 in week 3 which will be the planned order receipt in week 6.
Week 8:
The gross requirement is 400 (2 assembly) derived from the planned order release of B2. The on hand inventory is 0. Hence, the net requirement is 400. The lead time is 3 weeks. Therefore, the planned order release will be 400 in week 5 which will be the planned order receipt in week 8.
Week 9:
The gross requirement is 100 (1 assembly) derived from the master production schedule of B1. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 3 weeks. Therefore, the planned order release will be 100 in week 6 which will be the planned order receipt in week 9.
Want to see more full solutions like this?
Chapter 14 Solutions
PRIN.OF OPERATIONS MANAGEMENT-MYOMLAB
- There was a most recent poll for which 571 adults that flew in the past year had info collected. This info was their number 1 complaints about flying. A - small cramped seat - 45 complaints B - cost - 18 complaints C - fear or dislike - 81 complaints D - security - 123 complaints E - Poor service - 12 complaints F - Conntected flight issue - 8 complaints G - overcrowded - 41 complaints H - Late and wait - 81 complaints I - Food - 5 complaints J - Lost/missing luggage - 5 complaints K - Other - 51 complaints What percentage of those surveyed found nothing they didnt dislike?arrow_forwardCan you help me with this, and explain what a product by value analysis is? Thanks in advancearrow_forwardOperations Management Questionarrow_forward
- can you explain and breakdown the "ATB: digital disruption in the parking meter industry" case in detail outlining the key issuesarrow_forwardAt Quick Car Wash, the wash process is advertised to take less than 6 minutes. Consequently, management has set a target average of 330 seconds for the wash process. Suppose the average range for a sample of 7 cars is 10 seconds. Use the accompanying table to establish control limits for sample means and ranges for the car wash process. Click the icon to view the table of factors for calculating three-sigma limits for the x-chart and R-chart. The UCLR equals seconds and the LCLR equals seconds. (Enter your responses rounded to two decimal places.)arrow_forwardIf Jeremy who is the VP for the operations, proceeds with their existing prototype (which is option a), the firm can then expect sales to be 120,000 units at $550 each. And with a probability of 0.52 and a 0.48 probability of 65,000 at $550. we However, he uses his value analysis team (option b), the firm expects sales of 75,000 units at $770, with a probability of 0.78 and a 0.22 probability of 65,000 units at $770. Value engineering, at a cost of $100,000, is only used in option b. Which option for this has the highest expected monetary value (EMV)? The EMV for option a is $? The EMV for option b is $? Which has the highest expected monetary value. A or B?arrow_forward
- Part 1 of 2 Jim's Outfitters, Inc., makes custom western shirts. The shirts could be flawed in various ways, including flaws in the weave or color of the fabric, loose buttons or decorations, wrong dimensions, and uneven stitches. Jim randomly examined 10 shirts, with the following results shown to the right. Shirt Defects 1 7 2 1 4 13 3 10 2 8 5 9 10 8 7 a. Assuming that 10 observations are adequate for these purposes, determine the three-sigma control limits for defects per shirt. The UCLC equals and the LCL equals (Enter your responses rounded to two decimal places. If your answer for LCL is negative, enter this value as 0.)arrow_forwardManagement at Webster Chemical Company is concerned as to whether caulking tubes are being properly capped. If a significant proportion of the tubes are not being sealed, Webster is placing its customers in a messy situation. Tubes are packaged in large boxes of 144. Several boxes are inspected, and the following numbers of leaking tubes are found: Sample Tubes Sample Tubes Sample Tubes 1 7 8 7 15 7 2 7 9 8 16 9 3 6 10 7 17 3 4 4 11 1 18 7 5 8 12 8 19 7 6 7 2 9 13 14 1 20 6 7 Total 121 Calculate p-chart three-sigma control limits to assess whether the capping process is in statistical control. The UCLp equals and the LCLp equals (Enter your responses rounded to three decimal places. If your answer for LCLp is negative, enter this value as 0.)arrow_forwardAspen Plastics produces plastic bottles to customer order. The quality inspector randomly selects four bottles from the bottle machine and measures the outside diameter of the bottle neck, a critical quality dimension that determines whether the bottle cap will fit properly. The dimensions (in.) from the last six samples are Bottle Sample 1 2 3 4 1 0.624 0.586 0.602 0.591 2 0.613 0.599 0.578 0.618 3 0.606 0.585 0.587 0.623 4 0.581 0.623 0.571 0.610 5 0.609 0.610 0.623 0.617 6 0.605 0.573 0.570 0.602 Click the icon to view the table of factors for calculating three-sigma limits for the x-chart and R-chart. Suppose that the specification for the bottle neck diameter is 0.600 ± 0.050 in. and the population standard deviation is 0.014 in. a. What is the process capability index? The Cpk is (Enter your response rounded to two decimal places.)arrow_forward
- How would you handle the Apple 'batterygate' scandal as an operations manager? What quality measures would you take to fix the problem and prevent it from happening again? When would you implement these measures and communicate with the stakeholders?arrow_forwardPerosnal Thoughts about the articlearrow_forwardRevenue retrieval for Brew Mini= $ round response to two decimal places What would be the best design alternative? Brew master or brew miniarrow_forward
MarketingMarketingISBN:9780357033791Author:Pride, William MPublisher:South Western Educational Publishing
Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning
Contemporary MarketingMarketingISBN:9780357033777Author:Louis E. Boone, David L. KurtzPublisher:Cengage Learning
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,