Martitime Economics

Have attached the task. For task 1 you must complete THREE spreadsheets. Then also send THREE spreadsheets with the formulas.
For task 2 you must use the additional/rider clauses to the cal charter party/CoA (Volcoa) sheet. I have also attached other stuff you may need.
You are operations assistant for a dry bulk ship owner, responsible for the commercial operation of the company?s supramax bulk carriers. The company is considering bidding for the annual shipment of coal to Pakistan Steel Terminal at Port Muhammad Bin Qasim, Karachi.
The tender notice contract invites freight offers (US$ per tonne) for the transport of 850,000 tonnes (?10% CHOPT) of coal to Pakistan Steel IOC Terminal, by shipment size of 50,000t (?10% CHOPT) from three loading ports as follows:
Port Gladstone (Australia)
Port Newcastle (Australia)
Port Roberts Bank (Canada)
450,000 tonnes 200,000 tonnes 200,000 tonnes.
Write a report for the Operations Manager, which includes the following:
TASK 1 (30%)
Calculate the cost per tonne of coal for a round voyage from each load port to the Pakistan Steel Terminal and return, based on shipment size 50,000t plus 10%. Calculate the Time Charter Equivalent (TCE) for each round voyage, assuming CoA freight rate of $25 per tonne from Gladstone and Newcastle and $35 per tonne from Roberts Bank. Determine the maximum ship deadweight on each round voyage and the minimum number of ships required to complete the CoA.
TASK 2 (20%)
Summarise the ship owner?s obligations and liabilities in the ?Additional/Rider clauses to the coal charter party/CoA (Volcoa)?, in respect of:
a. Requirements for ships on the CoA.
b. Nominating ships
c. Notice of arrival at the load and discharge ports.
d. Cargo operations in port.
All statements must be referenced to the relevant clause.
TASK 3 (30%)
Recommend, with reasons, whether the company should submit a bid for this contract. In making your recommendation, discuss factors such as ship costs and revenue over the contract period (including the implications of the charterer?s option to ship 50,000t less 10%), clauses of concern, current and future freight market conditions and any other considerations.
REPORT (20%)
The report will be marked on structure, presentation and writing style. Report format is to be used, e.g. Executive Summary; Contents; Introduction; Terms of Reference; Results of Tasks 1, 2 & 3; Conclusions; Reference List and Appendices. Referencing and reference list in Harvard style. The Appendices should include the spread sheets, spread sheet formulae, fuel price list and port cost calculations.