Question: Could someone tell me what I did wrong! ill attach screenshots of what I have. All of the red x are incorrect answers this is

Could someone tell me what I did wrong! ill attach screenshots of what I have. All of the red x are incorrect answers

Could someone tell me what I did wrong! ill

this is my workbook equations below

Could someone tell me what I did wrong! ill

here is the solver parameters I used

Could someone tell me what I did wrong! ill

Rent'R Cars is a multisite car rental company in the city. It is trying out a new "return the car to the location most convenient for you" policy to Improve customer service. But this means that the company has to constantly move cars around the city to maintain required levels of vehicle availability. The supply and demand for economy cars, and the total cost of moving these vehicles between sites, are shown below. From To D $11 Supply 60 $5 $7 $8 B 12 4 9 15 75 C 19 14 12 50 Demand 5e 45 40 50 185185 a. Find the solution that minimizes moving costs using Microsoft Excel. (Leave no cells blank - be certaln to enter "0" wherever required.) Answer is complete but not entirely correct. G Supply D E F From/To Candidate solution A 11 5 7 8 X 60 B 12 X 4 X 9 X 15 X 75 C 10 X 7 14 12 50 50 45 40 50 185 Total shipped Cost . 0 0 10 X 50 B 0 45 30 olo 50 0 0 0 Total costs IS 1,420 A B D E F 1 2 D E F G SUPPLY 3 A 11 5 7 8 60 12 4 9 15 75 4 B 5 C 10 7 14 12 50 6 DEMAND 50 45 40 50 7 8 D E A G 0 0 10 50 SUPPLY =SUM(B9:E9) =SUM(B10:E10) =SUM(B11:E11) 0 45 30 0 0 9 A 10 B 11 C 12 demand 13 14 TOTAL COST 15 -SUMPRODUCT(B3:E5,89:E11) 50 =SUM(B9:311) 0 =SUM(D9:011) 0 =SUM(E9:E11) =SUM(C9:011) Solver Parameters Set Objective: SA$15 KI To: Max Min O Value Of: 0 By Changing Variable Cells: $B$9:$E$11 Subject to the Constraints: $B$12:$E$12 = $B$6:$E$6 $F$9:$F$11 = $F$3:$F$5 Add Change Delete Reset All Load/Save Make Unconstrained variables Non-Negative Select a Solving Method: Simplex LP Options Solving Method Select the GRG Nonlinear engine for Solver Problems that are smooth nonlinear. Select the LP Simplex engine for linear Solver Problems, and select the Evolutionary engine for Solver problems that are non-smooth. Help Solve Close

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 General Management Questions!