this question is need to be done on Excel. please write proper formulas.

7. Spot Automotive manufactures the SG electric cars. The company operates two manufacturing plants, one in Abbotsford, BC and another in Toronto, ON. The Abbotsford plant can manufacture 5,500 cars each week and Toronto 4,000. Every week, the company ships enough cars to exactly meet the demand of six dealerships. However, a plant cannot ship cars to a dealership within the same province. For example, the Abbotsford plant cannot ship cars to the Surrey dealership. The cost of shipping a car over 10 km is $1.25. What is the most cost-effective method to ship each dealership their demand? Demand Dealership Surrey, BC Calgary, AB Regina, SK Winnipeg, MB Ottawa, ON Moncton, NB 1,500 1,200 1,000 1,400 3,000 1,000