find the MPS start quantity in week 5, and the projected on-hand inventory in week 5. **I need clear a clear step by step solution please** thank you :) Item B Order Policy: 80 units Lead Time: 2 weeks Week Quantity on Hand Forecast 2 3 4 5 6 7 8. 35 35 60 1 50 40 40 40 40 40 Customer orders (booked) | 60 Projected on Hand MPS quantity MPS start 20 15 45 10 12 Available-to-promise

• What is the Reorder Point (ROP)? • What is the fill rate? What is the average inventory? • What is the average flow time? Given Data: Coefficient of variation (CV) = 0.24 Average weekly demand = 540 units Standard deviation = 130 units Lead time=2 Lot size = 1641 Safety inventory: NORMSINV(0.95) = 1.64 Standard deviation * sqrt(2) * 1.64 130*√√2*1.64 301.51 301 = 301 units

QUESTION 2 When used effectively, S&OP Planning does not require cross-functional collaboration. O True False

The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows: 2,200 January 1,400 May February 1,600 June 2,200 March April 1,800 1,800 July August 1,800 1,400 Her operations manager is considering a new plan, which begins in January with 200 units of inventory on hand. Stockout cost of lost sales is $100 per unit. Inventory holding cost is $25 per unit per month. Ignore any idle-time costs. The plan is called plan C. Plan C: Keep a stable workforce by maintaining a constant production rate equal to the average gross requirements excluding initial inventory and allow varying inventory levels. Conduct your analysis for January through August.