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
Get step-by-step solutions from verified subject matter experts
