BUS 204-Business Analytics

(i) PROTECTED VIEW This file has been verified by Microsoft Defender Advanced Thre 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 shippirg an automobile from each plant to each region are listed in the middle of the table. Grand Prik wants to find the lowest-cast shipping plan for meeting the demands of the four resions without exceeding the capacities of the plants. Objective: To develop a spreadsheet optimization model that finds the least-cost way of shipping the automobles from plants to regions, staing within plant capacties 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 valves necessary D) Use excel functions and formulas to compute the value in the objective cell. E) Use range name provided. f) FINAL. IHE OPTIMAL soumow (if it exists.) There must be parameters in the solver. (i) PROTECTED VIEW This file has been verified by Microsoft Defender Advanced Thre 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 shippirg an automobile from each plant to each region are listed in the middle of the table. Grand Prik wants to find the lowest-cast shipping plan for meeting the demands of the four resions without exceeding the capacities of the plants. Objective: To develop a spreadsheet optimization model that finds the least-cost way of shipping the automobles from plants to regions, staing within plant capacties 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 valves necessary D) Use excel functions and formulas to compute the value in the objective cell. E) Use range name provided. f) FINAL. IHE OPTIMAL soumow (if it exists.) There must be parameters in the solver