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
