Course:- Supply chain case study

Your answer must be in Excel sheet and show your Excel formular

Scenario Pipeline Report Catalogue Vehicles Terms \& info Student Answer Ready th? Accessibility: Unavailable B23 :fx 3 On 14th May 2019 at 12pm Cyclone Fiona made landfall onto the South Lakes region of B.C, Canada. 4 You are part of the Logistics team that was deployed on 15th May to manage the influx of Emergency items 5 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 6 You also have a page of the Emergency Items Catalogue giving the specifications of the common relief items 7 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. 8 All items are currently arriving into Vancouver Port 9 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 10 It will take one day for any vehicle to travel from the port to your warehouse 11 The carrier has advised that there is a surplus of trucks so you can order as many of each type as you need. 13 TASK: Calculate the number of each type of truck(s)requiredtocollecttheseafreightshipmentsarrivingintoVancouverPorton16thMayandtheassociatedcost 14 (There is no need to create a packing list or manifest for any of the trucks) 15 16 YOUR ANSWER WILL BE A UNIQUE SPREADSHEET TABLE WHICH IS DIFFERENT FROM YOUR PEERS, (not color, not width, etc) INCLUDING ALL FORMULAS 17 Remember to show your answer, all calculations and assumptions you have made in the "Student Answer" sheet tab 18 Please note that plagiarism in this test will not be tolerated and could result in consequences. 19 Answer: 50\%, Calculation\&Asummption and Formula: 40\%, Spreadsheet table: 10\%, Scenario Pipeline Report Catalogue Vehicles Terms \& info Student Answer Ready th? Accessibility: Unavailable B23 :fx 3 On 14th May 2019 at 12pm Cyclone Fiona made landfall onto the South Lakes region of B.C, Canada. 4 You are part of the Logistics team that was deployed on 15th May to manage the influx of Emergency items 5 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 6 You also have a page of the Emergency Items Catalogue giving the specifications of the common relief items 7 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. 8 All items are currently arriving into Vancouver Port 9 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 10 It will take one day for any vehicle to travel from the port to your warehouse 11 The carrier has advised that there is a surplus of trucks so you can order as many of each type as you need. 13 TASK: Calculate the number of each type of truck(s)requiredtocollecttheseafreightshipmentsarrivingintoVancouverPorton16thMayandtheassociatedcost 14 (There is no need to create a packing list or manifest for any of the trucks) 15 16 YOUR ANSWER WILL BE A UNIQUE SPREADSHEET TABLE WHICH IS DIFFERENT FROM YOUR PEERS, (not color, not width, etc) INCLUDING ALL FORMULAS 17 Remember to show your answer, all calculations and assumptions you have made in the "Student Answer" sheet tab 18 Please note that plagiarism in this test will not be tolerated and could result in consequences. 19 Answer: 50\%, Calculation\&Asummption and Formula: 40\%, Spreadsheet table: 10\%