John Jacobs recently invented a new storm proof umbrella with an aerodynamic design that will withstand winds of 60 mph. The umbrella scheduled to be featured in 5 weeks on Good Morning America’s hot products and he expects sales to remain strong for several weeks afterward. John is very excited about this opportunity and wants to make sure that he has enough product ready for the promotion. He has worked with his advertiser and produced the expected weekly demand for the next 12 weeks below. Each umbrella requires 1 canopy, 1 handle rods, and 2 spring sets. The ordering specifics for each are as follows: • Final Product (Umbrella) – Lead Time 1 week, Lot for Lot, Initial Inventory =100. Requires 1 Canopy , 1 Rod, and 2 Springs • Canopy – Lead Time 4 weeks, Fixed Order Quantity of 100, Safety Stock of 50, Initial Inventory = 500 • Rod – Lead Time 2 weeks, Lot for Lot, Safety Stock of 200, Initial Inventory = 300 • Springs – Lead Time 1 week, Fixed Order Period of 2 weeks, Initial Inventory = 1000 Generate the MRP for the Final Product, Canopy, Rod, and Springs given the following demand for the umbrellas. Denote any expedited orders with an * by them. Week 0 1 2 3 4 5 6 7 8 9 10 11 12 Demand 50 75 100 150 2000 1200 850 800 700 750 600 550