Question: this has to be done in excel. please show formulas used. thanks 7. Spot Automotive manufactures the SG electric cars. The company operates two manufacturing

this has to be done in excel. please show formulas used. thanks

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? Dealership Surrey, BC Calgary, AB Regina, SK Winnipeg, MB Ottawa, ON Moncton, NB Demand 1,500 1,200 1,000 1,400 3,000 1,000

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

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...

This question is need to be done on Excel. please please write fromulas don't just copy paste a single answer again and agian. don't do that that's blurry image. 7. 10 Spot Automotive manufactures...

MUST BE IN OWN WORDS FOR POINTS Analyze the Current Situation Identify the Strategic Managers "Case 30 Tesla Motors, as the first U.S. Car Company IPO Since 1956 Alan N. Hoffman Bentley University...

Please write it from the case i send it until 2013 The fall case in the photos Written Strategic Audit for (Tesla) I. Current Situation A. Current Performance B. Strategic Posture II. Strategic...

Unit 2: Designing the Operations Designing the operations of an organization or your department - precedes operational management. For .ll _ . example, suppose a wallet manufacture's mission is to '...

You have been hired as a consultant to help Ford Motor Company return to its glory days, when either Henry Ford or Alan Mulally ran the company. In doing so, you must produce a short report to Jim...

Need help on this group project. In this analysis, you will discuss the financial health of two companies (ZCL and Linamar) with the ultimate goal of recommending one of the companies to an investor....

In this analysis, you will discuss the financial health of two companies (ZCL and Linamar) with the ultimate goal of recommending one of the companies to an investor. Your paper should consist of the...

ITM 309: Business Information Technology and Systems Spring 2016 Watson and the new era of cognitive systems Jerry Haan IBM Cloud Ecosystem Development January 27, 2016 2013 International Business...

Please read the 10 pages of the article and answer the question: What should be BYD's objectives for the next years? What are the priority actions to achieve those objectives? IVEy | Publishing CEIBS...

Find Vo in the network infigure. 103 -j10+ Vx 4/0 At 10 2Vx V. j1a

Q1. Consider the transcendental equation: x + 1 + sech(x/ Seeking real solutions, explain why with no loss of generality. After sketching the two functions in this equation on the same graph, explain...

Which of the following is the first step of an activity-based costing (ABC) system? a. Assign activity costs to cost objects. b. Calculate primary activity rates. c. Identify, define, and classify...

Please answer in C language(not C++/cpp nor C#). This program is quicksort. n = no. of array, the output will print out each step of sort. For the code in void my_qsort(char**a, int left, int right,...