nd Prix transportation model t shipping costs m To Region 1 Region 2 Region 3 Region 4 Plant 1 Plant 2 $ 120.00 $ 210.00 $270.00 $ 115.00 $ 245.00 $ 116.00 $ 300.00 $ 350.00 Plant 3 $ 160.00 $ 130.00 $ 125.00 $ 170.00 oping plan, and constraints on supply and demand m ective to minimize: al cost To Region 1 Plant 1 200 Region 2 140 Region 3 Region 4 Total Shipped 147 132 619 Plant 2 100 50 240 111 501 Plant 3 200 100 50 70 420 Total Received 500 290 437 313 >= >= >= >= Demand 500 300 400 300 312570 Work Weight Score Comments Range Names Used: Part (A) 5 Part (B) 5 Capacity Part (C) 5 Demand Part (D) 5 Shipping Plan Total_Received Total_Shipped Total_Cost Part (E) Part (F) 5 5 30 0 The Grand Prix Automobile Company manufactures automobiles in three plants and then ships them to four regions of the country. The plants can supply the amounts listed in the right column of Table 5. The customer demands by region are listed in the bottom of the table, and the unit cost of shipping an automobile from each plant to each region are listed in the middle of the table. Grand Prix wants to find the lowest-cost shipping plan for meeting the demands of the four regions without exceeding the capacities of the plants. Table 5 Input Data for Grand Prix Example Capacity 470 630 520 Region 1 Region 2 Plant 1 120 210 Region 3 270 Region 4 115 Capacity 470 Plant 2 245 116 300 350 630 Plant 3 160 130 125 170 520 Demand 500 300 400 300 Objective: To develop a spreadsheet optimization model that finds the least-cost way of shipping the automobiles from plants to regions, staying within plant capacities and meeting regional demands. A) Enter all input value B) Enter arbitrary values of the decision variables C) Use excel functions and formulas to compute the calculated values necessary D) Use excel functions and formulas to compute the value in the objective cell. E) Use range name provided. F) FINAL THE OPTIMAL SOLUTION (if it exists.) There must be parameters in the solver.