Answered step by step
Verified Expert Solution
Link Copied!

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?

image text in transcribed

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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Accounting

Authors: Joe Hoyle, Thomas Schaefer, Timothy Doupnik

10th edition

0-07-794127-6, 978-0-07-79412, 978-0077431808

Students also viewed these Accounting questions