3 Suppose end items had to be ordered in multiples of 100 units, components in multiples of...
Question:
3 Suppose end items had to be ordered in multiples of 100 units, components in multiples of 500 units, and raw materials in multiples of 1,000 units. How would this change your schedule?
Use Microsoft Excel to solve the Nichols Company case. (Note that if you start from scratch, it will take several hours to answer Question 1, about the same for Question 2, and perhaps double that for Question 3. A spreadsheet is on the DVD included with this book to help with this problem.) Simplifying assumption: To get the program started, some time is needed at the beginning because MRP backloads the system. For simplicity, assume that the forecasts (and therefore demands) are zero for Periods 1 through 3. Also assume that the starting inventory specified in Exhibit 16.27 is available from Week 1. For the master production schedule, use only End Items A, B, and C. To modify production quantities, adjust only Products A, B, and C. Do not adjust the quantities of D, E, F, G, H, and I. These should be linked so that changes in A, B, and C automatically adjust them.
Step by Step Answer:
Operations Management For Competitive Advantage
ISBN: 1572
11th Edition
Authors: Richard B. Chase, F. Robert Jacobs