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
EBK PRINCIPLES OF OPERATIONS MANAGEMENT
- In the context of the material in Chapter 9, provide a critical analysis of the decisions that Henry has made in assigning Martin to this role.arrow_forwardpanies (pp. 80-118). New York, NY: Times Books, specifically Chap. 4, "Robert Eaton and Robert Lutz; The Copilots." CASE STUDY 9-2 Performance Management Leadership at Henry's Commercial Sales and Leasing H enry is the owner of a small real estate agency that handles the sale and leasing of commercial property. He has two real estate agents working in the office, along with himself. He also has two customer service representatives (CSRs), each of whom has a real estate license, and one receptionist who has worked for the company for about three months. Henry has recently decided that he needs another customer service representative. He hasarrow_forwardDiscuss possible solutions to help Tara become an effective CSR. What should martin be doing to help her?arrow_forward
- What are the ethical challenges regarding employees (i.e., diversity, discrimination, sexual harassment, privacy, employee theft, bad leadership, etc.) that Apple Inc. has faced over the past five to ten years and that they should prepare to face in the next five to ten years. Once a developed list of challenges is created, consider how having faced those challenges will impact and be impacted by the social cause you've selected. Propose the findings on the ethical challenges faced by Apple Inc. in recent history and the near future. Analyze ways in which each challenge was (and/or could be) appropriately handled and areas for improvement. Evaluate the ethical/moral aspects of Apple Inc. that protected it from ethical challenges in the past and could protect it in the future. Assess how ethical challenges and handling of ethical challenges could positively or negatively impact the charitable cause are selected and how the selection of your social cause could positively or negatively…arrow_forwardBy selecting Cigna Accredo pharmacy that i identify in my resand compare the current feedback system against the “Characteristics of a Good Multiple Source Feedback Systems” described in section 8-3-3. What can be improved? As a consultant, what recommendations would you make?arrow_forwardScenario You have been given a task to create a demand forecast for the second year of sales of a premium outdoor grill. Accurate forecasts are important for many reasons, including for the company to ensure they have the materials they need to create the products required in a certain period of time. Your objective is to minimize the forecast error, which will be measured using the Mean Absolute Percentage Error (MAPE) with a goal of being below 25%. You have historical monthly sales data for the past year and access to software that provides forecasts based on five different forecasting techniques (Naïve, 3-Month Moving Average, Exponential Smoothing for .2, Exponential Smooth for .5, and Seasonal) to help determine the best forecast for that particular month. Based on the given data, you will identify trends and patterns to create a more accurate forecast. Approach Consider the previous month's forecast to identify which technique is most effective. Use that to forecast the next…arrow_forward
- Approach Consider the previous month's forecast to identify which technique is most effective. Use that to forecast the next month. Remember to select the forecasting technique that produces the forecast error nearest to zero. For example: a. Naïve Forecast is 230 and the Forecast Error is -15. b. 3-Month Moving Forecast is 290 and the Forecast Error is -75. c. Exponential Smoothing Forecast for .2 is 308 and the Forecast Error is -93. d. Exponential Smoothing Forecast for .5 is 279 and the Forecast Error is -64. e. Seasonal Forecast is 297 and the Forecast Error is -82. The forecast for the next month would be 230 as the Naïve Forecast had the Forecast Error closest to zero with a -15. This forecasting technique was the best performing technique for that month. You do not need to do any external analysis-the forecast error for each strategy is already calculated for you in the tables below. Naïve Month Period Actual Demand Naïve Forecast Error 3- Month Moving Forecast 3- Month Moving…arrow_forwardScenario You have been given a task to create a demand forecast for the second year of sales of a premium outdoor grill. Accurate forecasts are important for many reasons, including for the company to ensure they have the materials they need to create the products required in a certain period of time. Your objective is to minimize the forecast error, which will be measured using the Mean Absolute Percentage Error (MAPE) with a goal of being below 25%. You have historical monthly sales data for the past year and access to software that provides forecasts based on five different forecasting techniques (Naïve, 3-Month Moving Average, Exponential Smoothing for .2, Exponential Smooth for .5, and Seasonal) to help determine the best forecast for that particular month. Based on the given data, you will identify trends and patterns to create a more accurate forecast. Approach Consider the previous month's forecast to identify which technique is most effective. Use that to forecast the next…arrow_forwardUse the internet to obtain crash safety ratings for passenger vehicles. Then, answer thesequestions:a. Which vehicles received the highest ratings? The lowest ratings?b. How important are crash-safety ratings to new car buyers? Does the degree of importancedepend on the circumstances of the buyer?c. Which types of buyers would you expect to be the most concerned with crash-safety ratings?d. Are there other features of a new car that might sway a buyer from focusing solely on crashsafety? If so, what might they be?arrow_forward
- “Implementing a Performance Management Communication Plan at Accounting, Inc.” Evaluate Accounting Inc.’s communication plan. Specifically, does it answer all of the questions that a good communication plan should answer? Which questions are left unanswered? How would you provide answers to the unanswered questions? “Implementing an Appeals Process at Accounting, Inc.” If you were to design an appeals process to handle these complaints well, what would be the appeal process? Describe the recommended process and why.arrow_forwardThe annual demand for water bottles at Mega Stores is 500 units, with an ordering cost of Rs. 200 per order. If the annual inventory holding cost is estimated to be 20%. of unit cost, how frequently should he replenish his stocks? Further, suppose the supplier offers him a discount on bulk ordering as given below. Can the manager reduce his costs by taking advantage of either of these discounts? Recommend the best ordering policy for the store. Order size Unit cost (Rs.) 1 – 49 pcs. 20.00 50 – 149 pcs. 19.50 150 – 299 pcs. 19.00 300 pcs. or more 18.00arrow_forwardHelp answer showing level work and formulasarrow_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,