Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units.

1. Savor Summer has just received an order for 500 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 3

Non-perishable food (5 per) 2 weeks 25

Perishable food (4 per) 1 week 0

What is the net requirement for non-perishable food to fill this order?