Please provide formulas needed and show work for the attached picture, filling in all blanks. Thanks.

A B D 1 Problem 12.7 2 A warehouse storage planner is trying to decide how mu space a new product with a large quantity will need for storage. Since the quantities are so large, the planner ha selected the warehouse's pallet rack area as the appropriate storage area. If the demand is 16 units a week and the replenishment lead time is 1 week, how many pallets should the planne plan to stock in the warehouse? 3 Data Factors 4 Order Point/units 5 Order Quantity/units 6 Size (sq.ft.) 7 Pallet Height (ft.) 8 Pallet Width (ft.) 9 Pallet Depth (ft.) 10 Lead Time (weeks) 11 Average Demand During Lead Time 13 Analysis 74 Quantity per Pallet 75 Average Quantity On Hand 16 Total Quantity Available at Receipt 17 Total Number of Pallets Required 20 48 4 4 4 4 1 16 18 A B D 1 Problem 12.7 2 A warehouse storage planner is trying to decide how mu space a new product with a large quantity will need for storage. Since the quantities are so large, the planner ha selected the warehouse's pallet rack area as the appropriate storage area. If the demand is 16 units a week and the replenishment lead time is 1 week, how many pallets should the planne plan to stock in the warehouse? 3 Data Factors 4 Order Point/units 5 Order Quantity/units 6 Size (sq.ft.) 7 Pallet Height (ft.) 8 Pallet Width (ft.) 9 Pallet Depth (ft.) 10 Lead Time (weeks) 11 Average Demand During Lead Time 13 Analysis 74 Quantity per Pallet 75 Average Quantity On Hand 16 Total Quantity Available at Receipt 17 Total Number of Pallets Required 20 48 4 4 4 4 1 16 18