must use excel & show formulas #4

4) Savor Summer has just received an order for 1000 gift baskets, which must be ready for delivery at the start of week 3. An MRP planner has prepared the following table showing product structure, lead times (orders are lot-for-lot), and quantities on hand: Deluxe Gift Basket Lead Time On-Hand Deluxe Gift Basket 1 week Non perishable food (6 per) 2 weeks 24 Perishable food (4 per) 1 week 0 What is the net requirement for non-perishable food to fill this order? (10 pts) 7