Cost per Shipment 2017 2018 Percent increase od decrease Cost if at 2017 cost per shipment Amount of Islation Atlanta Boston Chicago Denver Fargo Los Angeles Portland St. Louis 2017 Figures 2018 Figures Units Shipped Warchouc Costs Units Shipped Warehouse Cost 12 Months 12 Months 12 Months January 12 Months Januar - December January January December December December 18,300 $172,513 18.500 $201.500 7,200 $69.759 7.560 $71,300 30,200 $270,947 28.400 $272,300 3.200 $30,821 3.560 $38.600 2,010 S18,052 1.850 524,650 17,800 S167,173 18,500 $168.500 8.500 S80,317 11.000 $105.600 6,000 $$7.001 7.500 SS8.000 $866,581 $940.450.00 Answer: This can be in the column above Question: In the above spreadsheet calculate the cost per shipment for 2107 and 2018 for each warehosuc. To do this divide the cost or dollars by the units shipped Answer: This can be in the column above Question2 In the above spreadsheet calculate the % increase or decrease in cost per unit shipped. % increase or decrease. Do this for each warehouse. -new-oldyold or in this case (2018 cost per shipment - 2017 cost per shipmenty2017 cost per shipment Answer: This can be in the column above Question: In the above spreadsheet calculate What the 2018 cost would be if there was no increase in cost per unit shipped. Do this for each warehouse -2017 cost per unit shipped X 2018 units Answer: This can be in the column above Question What is the amount of cost due to Inflation? Take the 2018 cost - the answer to Question 3. Do this for each warehouse. Answer: Question: Which Warehouse is doing the best job for Brandt Freezer? For what reasons? Answer: Question 4 Which Warehouse is doing the worst job for Brandt Freezer? For what reasons