Note 1: For each pattern of shipments, include two relevant Excels Solver calculations/printouts (Sheet and Answer Report) as exhibits at the end of your report (you may use PrintScreen). Save everything as one and only one file in the pdf format.

Note 2: A report with no Excels Solver calculations/printouts included will receive zero (0) points.

I need the whole answer.

Dalton Pharmaceuticals enjoys a dominant position in most of Canada with over 800 discount retail outlets. These stores are served by twice-weekly deliveries from Dalton's 13 warehouses, which are in turn supplied daily by seven factories. It is clear to Marilyn Helms, VP operations, that an additional warehouse is desperately needed to handle growth and backlogs. Three cities, Montreal, Toronto, and Winnipeg, are under final consideration. The table below illustrates the current and proposed factory/warehouse capacities/demands and shipping costs per average carton of supplies. Unit Transportation Costs ($) Warehouse Yorkton SK Calgary Miramichi AB NB Quebec City QC Gatineau ac Charlotte town PE Wellington PE Bonavista NL Kingston ON Windsor ON Thunder Bay ON Bedeque PE Tignish PE Montreal QC Toronto ON Winnipeg Capacity MB (cartons/ day) 3 5 5 4 3 4 6 8 8 9 10 8 8 8 11 4 6 2 350 4 6 6 5 5 6 7 6 7 2 3 2 6 7 7 5 2 5 5 250 1 1 4 3 3 2 2 2 2 6 6 7 7 8 8 7 7 9 9 6 8 9 3 5 2 350 3 3 5 2 6 6 5 5 6 2 2 2 3 3 5 5 6 3 3 5 5 250 Factory: Saskatoon SK Ottawa ON Regina SK Hamilton ON Moncton NB Fredericton NB Summerside PEI Demand (cartons/day) 4 1 1 4 3 3 8 9 10 7 7 13 9 9 8 8 8 2 6 3 3 550 3 3 3 3 1 1 2 2 6 6 5 5 6 6 8 7 7 7 8 8 3 3 6 2 450 4 8 8 7 7 7 2 2 2 6 8 5 5 1 2 8 8 7 8 550 250 200 150 50 100 150 150 250 275 250 250 200 175 300 300 300 1. Find the best pattern of shipments (optimal solution that minimizes the total transportation cost) separately for each of the three alternatives for a location for the new warehouse no. 14: a) in Montreal b) in Toronto c) in Winnipeg 2. Which of these three patterns of shipments is the lowest transportation cost solution? What would be your final recommendation? Fully justify your