Please use Excel to calculate missing fields above.

7. A warehouse storage planner is trying to decide how much space a new product with a large quantity will need for storage. Since the quantities are so large, the planner has selected the warehouse's pallet rack area as the appropriate storage area. The pallet racks in the warehouse are a standard 4-ft high (plus allowance of 6-in. for pallet height). The racks are wide enough to stage two pallets of 4-ft width side-by-side on a shelf. The product's packaging dimensions are 2-ft. The order point for the item is 20 units and the order quantity is 48 units. If the demand is 16 units a week and the replenishment lead time is 1 week, how many pallets should the planner plan to stock in the warehouse? Data Factors Order Point/units -Order Quantity/units Size (sq.ft.) -Pallet Height (ft.) Pallet Width (ft.) 1 Pallet Depth (ft.) 2 Lead Time (weeks) 3 Average Demand During Lead Time 5 Analysis 5 Quantity per Pallet Average Quantity On Hand 3 Total Quantity Available at Receipt Total Number of Pallets Required 20 48 4 44 4 1 16