Four Warehouse options have information about the various costs to help make a good economic decision on which is the best choice. Use a formula to calculate each of the yellow boxes on the Warehouse problem page. Note: On variable cost you may use either cost per pound (orange box) or cost per pallet to get your final answer. You decide which you want to use. At present, the plan is to store 30 million pounds of frozen product in a leased warehouse. Cells B13, D13, F13, and G13 are the final total cost for each option and are in gray. Make sure to show your formulas for full credit. All the information and calculations may or may not be needed to calculate cost as there are multiple ways and formulas to get to the correct answers. All of the highlighted boxes must be populated even if you do not use them in the final calculation. All options have good access to the interstate highway system. Option 4 has a rail dock and the others do not. The hours of operation at Options 1 and 2 are 5 am to 1 am while Options 3 and 4 are open from 5:30 am to 1:30 am. Options 1 and 2 use the same outside freight hauler to make deliveries, Option 3 uses a service that uses special software that allows you to track exactly where the trailer is from the time it leaves the warehouse, and Option 4 operates it's own fleet of trailers. D27 VIX fx A C D E G H 1 Warehouse Problem See Instruction tab for further information Option 3 $ 750,000 Option 4 2 3 4 Lease cost 5 Pallet charge in 6 Pallet charge out 7 Pallet charge per month 8 Freight charge per mile 9 Miles to plant Option 1 s 250,000 12.00 12.00 5.00 2.10 15 20.00 Option 2 $ 100,000 14.00 12.50 10.00 2.10 23 5.00 2.25 5 20.00 1.55 48 10 Variable cost per pallet or 11 Variable cost per pound 12 Fixed cost 13 Total cost 14 15 Volume (lbs) 16 30,000,000 17 18 Best option at 30 million pounds 19 20 21 22 Ibs per Pallets Pallets Trucks trucks per trucks total pounds pallet per truck per year per year month 30,000,000 1500 24 per week Four Warehouse options have information about the various costs to help make a good economic decision on which is the best choice. Use a formula to calculate each of the yellow boxes on the Warehouse problem page. Note: On variable cost you may use either cost per pound (orange box) or cost per pallet to get your final answer. You decide which you want to use. At present, the plan is to store 30 million pounds of frozen product in a leased warehouse. Cells B13, D13, F13, and G13 are the final total cost for each option and are in gray. Make sure to show your formulas for full credit. All the information and calculations may or may not be needed to calculate cost as there are multiple ways and formulas to get to the correct answers. All of the highlighted boxes must be populated even if you do not use them in the final calculation. All options have good access to the interstate highway system. Option 4 has a rail dock and the others do not. The hours of operation at Options 1 and 2 are 5 am to 1 am while Options 3 and 4 are open from 5:30 am to 1:30 am. Options 1 and 2 use the same outside freight hauler to make deliveries, Option 3 uses a service that uses special software that allows you to track exactly where the trailer is from the time it leaves the warehouse, and Option 4 operates it's own fleet of trailers. D27 VIX fx A C D E G H 1 Warehouse Problem See Instruction tab for further information Option 3 $ 750,000 Option 4 2 3 4 Lease cost 5 Pallet charge in 6 Pallet charge out 7 Pallet charge per month 8 Freight charge per mile 9 Miles to plant Option 1 s 250,000 12.00 12.00 5.00 2.10 15 20.00 Option 2 $ 100,000 14.00 12.50 10.00 2.10 23 5.00 2.25 5 20.00 1.55 48 10 Variable cost per pallet or 11 Variable cost per pound 12 Fixed cost 13 Total cost 14 15 Volume (lbs) 16 30,000,000 17 18 Best option at 30 million pounds 19 20 21 22 Ibs per Pallets Pallets Trucks trucks per trucks total pounds pallet per truck per year per year month 30,000,000 1500 24 per week