Question: Please, prepare the cost sheet, based on the following information. Commodity: Icumsa 45 Sugar Quantity: 100,000 MT in bulk Exchange rate: US $1.00 = CAD

Please, prepare the cost sheet, based on the following information.

Commodity: Icumsa 45 Sugar

Quantity: 100,000 MT in bulk

Exchange rate: US $1.00 = CAD $1.25

Cost Ex-warehouse: CAD$25,000,000

Trucking (freight to dock): CAD$500,000

Wharfage and handling: CAD$4 per MT

Finance charge: 2.5%

Profit margin: 7%

Agent's commission: CAD$100,000

Ocean freight: US$5,000,000 for total shipment

Marin insurance: 1% on110% of the C&F value

Please, use the attached cost sheet to make your calculations, show all calculations,

Round your final answer to the nearest dollar amount; then, put the final price to the nearest $5 amount.

Costs

CAD$

Cost

US$

Cost

Notes
Cost [EXW] Ex-warehouse
Trucking (freight to dock)
Cost to Dock
Wharfage and Handling
Cost FAS (beside vessel)
Finance Charge
Profit Margin
Agent's Commission
Price FOB

Convert to US$

(move to new column)

Ocean Freight
Price [CFR] C&F
Marine Insurance
Total [CIF] CIF
Round to the nearest US$
Round to the nearest US$5

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!