On 14th May 2019 at 12pm Cyclone Fiona made landfall onto the South Lakes region of B.C, Canada.

You are part of the Logistics team that was deployed on 15th May to manage the influx of Emergency items

Your team leader has provided you with the latest copy of the initial Pipeline showing the goods that are expected to arrive in the coming days and weeks

You also have a page of the Emergency Items Catalogue giving the specifications of the common relief items

Your company has a contract carrier company and has given you a copy of the pricing list. The price is a daily hire rate and includes fuel, the driver, insurance etc.

All items are currently arriving into Vancouver Port

There is one road from Vancover Port to your warehouse which is good and all vehicles provided by the carrier are suitable for this road

It will take one day for any vehicle to travel from the port to your warehouse

The carrier has advised that there is a surplus of trucks so you can order as many of each type as you need.

TASK: Calculate the number of each type of truck(s) required to collect the sea freight shipments arriving into Vancouver Port on 16th May and the associated cost

(There is no need to create a packing list or manifest for any of the trucks)

YOUR ANSWER WILL BE A UNIQUE SPREADSHEET TABLE WHICH IS DIFFERENT FROM YOUR PEERS, (not color, not width, etc) INCLUDING ALL FORMULAS

Remember to show your answer, all calculations and assumptions you have made in the "Student Answer" sheet tab

Answer: 50%, Calculation&Asummption and Formula: 40%, Spreadsheet table: 10% ,