How do I fill out this Total Cost Analysis excel template based on the information given? 1

How do I fill out this Total Cost Analysis excel template based on the information given?

 

Transcribed Image Text:

1 2 Conversions 3 4 Price/lb 5 lb/pallet 6 Pallets / Container 7 Shipping Costs 8 9 10 11 12 13 14 Ocean Freight Duties (% value of container) Transportation Costs Trans Port to Warehouse / Container Trans from Whse to Public / Pallet Warehouse Charges / Pallet (pick & pack) Inventory Carrying cost (% Purchase price] 15 Warehouse to Plant / Container 16 Quality Control / pallet 17 18 Factory Yield Loss 19 Spoilage at customer (grocer) / 6 containers 20 21 Loss in Transit & Storage $ 0.29 2,000 B $ $ $ $ 2,500 $ $ 20 15% 250 6.50 6.25 24% 175 4.00 3% 2% $ 25,000 C D Price Shipping Costs To U.S. Duties Trans Costs To Warehouse To Public Warehouse Charges Inventory Carrying Cost Whse to Plant Quality Control E Loss in Transit & Storage Factory Yield Loss Spoilage @ Customer Total SG&A Total with SG&A F G Costs Per Unit Pound Pallet Container $0.2900 $ 580.00 $11,600.00 Sub-Total $0.2900 $ 580.00 $11,600.00 $0.2900 $ 580.00 $11,600.00 $0.2900 $ 580.00 $11,600.00 H Cost Drivers 100% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 100% 1 2 Conversions 3 4 Price/lb 5 lb/pallet 6 Pallets / Container 7 Shipping Costs 8 9 10 11 12 13 14 Ocean Freight Duties (% value of container) Transportation Costs Trans Port to Warehouse / Container Trans from Whse to Public / Pallet Warehouse Charges / Pallet (pick & pack) Inventory Carrying cost (% Purchase price] 15 Warehouse to Plant / Container 16 Quality Control / pallet 17 18 Factory Yield Loss 19 Spoilage at customer (grocer) / 6 containers 20 21 Loss in Transit & Storage $ 0.29 2,000 B $ $ $ $ 2,500 $ $ 20 15% 250 6.50 6.25 24% 175 4.00 3% 2% $ 25,000 C D Price Shipping Costs To U.S. Duties Trans Costs To Warehouse To Public Warehouse Charges Inventory Carrying Cost Whse to Plant Quality Control E Loss in Transit & Storage Factory Yield Loss Spoilage @ Customer Total SG&A Total with SG&A F G Costs Per Unit Pound Pallet Container $0.2900 $ 580.00 $11,600.00 Sub-Total $0.2900 $ 580.00 $11,600.00 $0.2900 $ 580.00 $11,600.00 $0.2900 $ 580.00 $11,600.00 H Cost Drivers 100% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 100%

Answer rating: 100% (QA)

Solution Total Cost Formula The term total cost refers to the overall cost of production ... View the full answer