Answered step by step
Verified Expert Solution
Question
1 Approved Answer
How do I fill out this Total Cost Analysis excel template based on the information given? B C D E F. G $ 0.29 2,000
How do I fill out this Total Cost Analysis excel template based on the information given?
B C D E F. G $ 0.29 2,000 20 $ 2,500 15% 1 2 Conversions 3 4 Price / lb 5 lb / pallet 6 Pallets / Container 7 Shipping Costs 8 Ocean Freight 9 Duties (% value of container) 10 Transportation Costs 11 Trans Port to Warehouse / Container 12 Trans from Whse to Public / Pallet 13 Warehouse Charges / Pallet (pick & pack) 14 Inventory Carrying cost (% Purchase price 15 Warehouse to Plant / Container 16 Quality Control / pallet 17 Loss in Transit & Storage 18 Factory Yield Loss 19 Spoilage at customer (grocer) / 6 containers 20 21 $ 250 $ 6.50 $ 6.25 24% $ 175 $ 4.00 3% 2% $ 25,000 Costs Per Unit Pound Pallet Container Cost Drivers Price $ 0.2900 $ 580.00 $ 11,600.00 100% Shipping Costs To U.S. 0% Duties 0% Trans Costs To Warehouse 0% To Public 0% Warehouse Charges 0% Inventory Carrying Cost 0% Whse to Plant 0% Quality Control 0% Sub-Total $ 0.2900 $ 580.00 $ 11,600.00 Loss in Transit & Storage 0% Factory Yield Loss 0% Spoilage @ Customer 0% Total $0.2900 $ 580.00 $11,600.00 SG&A 0% Total with SG&A $0.2900 $ 580.00 $11,600.00 100% B C D E F. G $ 0.29 2,000 20 $ 2,500 15% 1 2 Conversions 3 4 Price / lb 5 lb / pallet 6 Pallets / Container 7 Shipping Costs 8 Ocean Freight 9 Duties (% value of container) 10 Transportation Costs 11 Trans Port to Warehouse / Container 12 Trans from Whse to Public / Pallet 13 Warehouse Charges / Pallet (pick & pack) 14 Inventory Carrying cost (% Purchase price 15 Warehouse to Plant / Container 16 Quality Control / pallet 17 Loss in Transit & Storage 18 Factory Yield Loss 19 Spoilage at customer (grocer) / 6 containers 20 21 $ 250 $ 6.50 $ 6.25 24% $ 175 $ 4.00 3% 2% $ 25,000 Costs Per Unit Pound Pallet Container Cost Drivers Price $ 0.2900 $ 580.00 $ 11,600.00 100% Shipping Costs To U.S. 0% Duties 0% Trans Costs To Warehouse 0% To Public 0% Warehouse Charges 0% Inventory Carrying Cost 0% Whse to Plant 0% Quality Control 0% Sub-Total $ 0.2900 $ 580.00 $ 11,600.00 Loss in Transit & Storage 0% Factory Yield Loss 0% Spoilage @ Customer 0% Total $0.2900 $ 580.00 $11,600.00 SG&A 0% Total with SG&A $0.2900 $ 580.00 $11,600.00 100%Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started