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 3Order 2 is for 60 units to be delivered in period 4Order 3 is for 70 units to be delivered in period 6Order 4 is for 40 units to be delivered in period 3Order 5 is for 20 units to be delivered in period 5Order 6 is for 115 units to be delivered in period 9Assuming 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)?

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 3Order 2 is for 60 units to be delivered in period 4Order 3 is for 70 units to be delivered in period 6Order 4 is for 40 units to be delivered in period 3Order 5 is for 20 units to be delivered in period 5Order 6 is for 115 units to be delivered in period 9Assuming 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)?

Name: An end item’s demand forecasts for the next 6 weeks are 30 units, foll
Uploaded: 2024-03-20T06:57:05.000Z
Channel: Bartleby
Description: 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 i

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter4: Linear Programming Models

Section: Chapter Questions

Problem 111P

See similar textbooks

Similar questions

An end item’s demand forecasts for the next 10 weeks are 30, 30, 30, 30, 20, 20, 30, 30, 30, and 30 units. The current onhand inventory is 100 units. The order policy is to produce in lots of 75. The booked customer orders for the item, starting with week 1, are 15, 38, 7, 5, 0, 3, 10, 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 five orders for this item in the following sequence:Order 1 is for 20 units to be delivered in period 1Order 2 is for 75 units to be delivered in period 4Order 3 is for 90 units to be delivered in period 6Order 4 is for 75 units to be delivered in period 7Order 5 is for 90 units to be delivered in period 10Assuming 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)?
An end item’s demand forecasts for the next 10 weeks are 30,20, 35, 50, 25, 25, 0, 40, 0, and 50 units. The current on-handinventory is 80 units. The order policy is to produce in lots of100. The booked customer orders for the item, starting withweek 1, are 22, 30, 15, 9, 0, 0, 5, 3, 7, and 0 units. At present,no MPS quantities are on-hand for this item. The lead time is2 weeks. Develop an MPS for this end item.
An electric hand drill would take 15, 40, 10, 20, 50, and 30 units in the next 6 weeks. The marketing department has booked orders for the first, second, third, and fourth weeks for 20, 25, 10 and 20 units in all. Currently, there are 30 hand boxes in order. The strategy should be ordered in several 60 units. One week is lead period. Lead time. A. Develop the MPS hand drill log. b. A hand drill dealer puts an order for 15 units. What is the correct date of shipment for the whole order?
An end item’s demand forecasts for the next 10 weeks are30, 30, 30, 30, 20, 20, 30, 30, 30, and 30 units. The current on-hand inventory is 100 units. The order policy is to produce inlots of 75. The booked customer orders for the item, startingwith week 1, are 15, 38, 7, 5, 0, 3, 10, 0, 0, and 0 units. The leadtime is 2 weeks.a. Develop an MPS for this end item.b. The marketing department has received five orders forthis item in the following sequence:Order 1 is for 20 units to be delivered in period 1Order 2 is for 75 units to be delivered in period 4Order 3 is for 90 units to be delivered in period 6 Order 4 is for 75 units to be delivered in period 7Order 5 is for 90 units to be delivered in period 10 Assuming that the prospective MPS you developed in part (a)does not change, which orders would you be able to acceptbased on the available to promise (ATP)?
Eighty units of end item E are needed at the beginning of week 6. Three cases (30 units per case) of Jhave been ordered and one case is scheduled to arrive in week 3, one in week 4, and one in week 5.Note: J must be ordered by the case, and B must be produced in multiples of 120 units. There are 60 unitsof B and 20 units of J now on hand. Lead times are two weeks each for E and B, and one week for J.E a. Prepare a material requirements plan for component J.b. Suppose that in week 4 the quantity of E needed is changed from 80 to 70. The planned-order releasesthrough week 3 have all been executed. How many more Bs and Js will be on hand in week 6?
Figure shows the BOMs for two products, A and B. Table 1 shows the MPS quantity start date for each one. Table 2 contains data from inventory records for items C, D, and E. There are no safety stock requirements for any of the items.a. Determine the material requirements plan for items C, D, and E for the next 8 weeks.b. What specific managerial actions are required in week 1?c. Suppose that a very important customer places an emergency order for a quantity of product A. To satisfy this order, a new MPS of 200 units of product A is now required in week 5. Determine the changes to the material requirements plan if this order is accepted and note any problems that you detect. MPS Quantity Start Dates Date Product 1 2 3 4 5 6 7 8 A 125 95 150 130 B 80 70 Inventory Record Data Item Data Category C D E Lot-sizing rule L4L POQ 1P = 32 FOQ = 800 Lead time 3 weeks 2 weeks 1 weeks Scheduled receipts 200 (week 2) None 800 (week 1) Beginning…
WSS company makes weatherproof surveillance systems for parking lots. Demand estimates for the next four quarters are 25, 9, 13, and 17 units. Prepare an aggregate plan that uses inventory, regular time, and over time, and backorders. Subcontracting is not allowed. The regular time capacity is 15 units for quarters 1 and 2, 18 units for quarters 3 and 4. Overtime capacity is 3 units per quarter. The regular time cost is $2000 per unit, while the overtime cost is $3000 per unit. Backorder costs $300 per unit per quarter; inventory holding costs $100 per unit per quarter. The beginning inventory is zero. How many total units will be produced in quarter 1 for delivery in quarter 1? How many units in total will be used to fill back orders over the four quarters? What is the cost to produce one unit in Quarter 4 using overtime to fill a back order in quarter one?
The BOM for product A is shown in Figure 11.40, and datafrom the inventory records are shown in Table 11.9. In theMPS for product A, the MPS start row has 100 units in week 3and 200 in week 6. Develop the material requirements planfor the next 6 weeks for items C, D, and E. a. Develop the material requirements plan for the next6 weeks for items C, D, and E.b. What specific managerial actions are required inweek 1?
Product X is made of 2 units of Y and 3 of Z. Y is made of 1 unit of A and 2 units of B. Z is made of 2 units of A and 4 units of C. Lead Time of X is 1 week: Y - 2 weeks; Z – 3 weeks; A – 2 weeks; B – 1 week; and C – 3 weeks. Scheduled receipt on week 5 are: A = 250 and Z = 135. If 150 units of X are needed in week 10 & 100 units in week 12, develop a planning schedule showing when each item should be ordered and in what quantity. Use lot for lot except for Y & C which requires minimum of 400 units. Determine the timing of planned release of component Z for the order of 150 units.
The opening backlog is 800 units. Forecast demand is as shown here. Calculate theweekly production for level production if the backlog is to be reduced to 100 units.
A phone production company must prepare the production planning for the next 9 weeks. Complete the below table considering this information: Lead Time = 3 Weeks On-hand inventory of 52 phones from week 1. Receipt from an outside supplier of 15 phones at start of week 7 We need to supply 75 phones on week 4. We need to supply 120 phones on week 9. Product A Week 1 2 3 4 5 6 7 8 9 Gross Requirement On-hand inventory Planned order
The BOM for product A is shown in Figure 11.45. The MPS forproduct A calls for 120 units to be started in weeks 2, 4, 5, and8. Table 11.14 shows data from the inventory records.a. Develop the material requirements plan for the next8 weeks for each item.b. What specific managerial actions are required in week 1?Make sure you address any specific difficulties youencounter in the inventory records.