solution

The BOMs for products A & B and data from the inventory records are shown in Figure 11.41. Data from the inventory records are shown in Table 11.10. In the MPS for product A, the MPS start row has 85 units in week 2 and 200 in week 4 and 50 in week 8. In the MPS for product B, the MPS start row has 65 units in week 3 and 50 in week 4 and 50 in week 5 and 75 in week 8. a. Develop the material requirements plan for the next 8 weeks for items C, D, and E. Note any difficulties you observe in the inventory records. b. Can the difficulties noted in part (a) be rectified by expediting any Scheduled Receipts?

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

solution

A forecast of 320 units in January, 400 units in February, and 240 units in March has been approved for the seismicsensory product family manufactured at the Rockport facility of Maryland Automated, Inc. Three products, A, B, and C, comprise this family. The product mix ratio for products A, B, and C for the past 2 years has been 35 percent, 40 percent, and 25 percent, respectively. Management believes that the monthly forecast requirements are evenly spread over the 4 weeks of each month. Currently, 15 units of product C are on hand. The company produces product C in lots of 40, and the lead time is 2 weeks. A production quantity of 40 units from the previous period is scheduled to arrive in week 1. The company has accepted orders of 25, 9, 11, 5, 4, and 9 units of product C in weeks 1 through 6, respectively. Prepare a prospective MPS for product C and calculate the availableto-promise inventory quantities.

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

solution

An end item’s demand forecasts for the next 6 weeks are 30 units, followed by forecasts of 25 units for weeks 7 through 10. The current on-hand inventory is 60 units. The order policy is to produce in lots of 100. The booked customer orders for the item, starting with week 1, are 22, 30, 15, 11, 0, 0, 9, 0, 0, and 0 units. The lead time is 2 weeks. a. Develop an MPS for this end item. b. The marketing department has received six orders for this item in the following sequence: Order 1 is for 40 units to be delivered in period 3 Order 2 is for 60 units to be delivered in period 4 Order 3 is for 70 units to be delivered in period 6 Order 4 is for 40 units to be delivered in period 3 Order 5 is for 20 units to be delivered in period 5 Order 6 is for 115 units to be delivered in period 9 Assuming that the prospective MPS you developed in part (a) does not change, which orders would you be able to accept based on the available to promise (ATP)?

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

solution

The Holloway Calendar Company produces a variety of printed calendars for both commercial and private use. The demand for calendars is highly seasonal, peaking in the third quarter. Current inventory is 165,000 calendars, and ending inventory should be 200,000 calendars. Ann Ritter, Holloway’s manufacturing manager, wants to determine the best production plan for the demand requirements and capacity plan shown in the following table. (Here, demand and capacities are expressed as thousands of calendars rather than as employee-period equivalents.) Ritter knows that the regular-time cost is $0.50 per unit, overtime cost is $0.75 per unit, subcontracting cost is $0.90 per unit, and inventory holding cost is $0.10 per calendar per quarter. Unused regular-time capacity is not paid. Quarter 1 2 3 4 Total Demand 250 515 1,200 325 2,290 Capacities Regular time 300 300 600 300 1,500 Overtime 75 75 150 75 375 Subcontracting 150 150 150 150 600 a. Recommend a production plan to Ritter, using the Transportation Method (Production Planning) module of POM for Windows. (Do not allow any stockouts or backorders to occur.) b. Interpret and explain your recommendation. c. Calculate the total cost of your recommended production plan.

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"