no handwriting, finish problem in Excel!
1. Problem 9-13 (pg 343) - Write the equations for the problem from the chart (see example in attached spreadsheet); develop a spreadsheet for a Linear Programming solution to this problem; and use SOLVER to find the solution. \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline \multicolumn{3}{|c|}{ SOLVED PROBLEM EXAMPLES Pg 343} & \multicolumn{3}{|c|}{ TRANSPORTATION PROBLEM } & & & & & & & \\ \hline From/To & Project A & Project 8 & Project C & Plan Capacity & & & & & & & & \\ \hline Plant 1 & 10 & 4 & 11 & to & & fsec table in & in the problem & & & & & \\ \hline Plan 2 & 12 & 5 & 8 & 50 & & & & & & & & \\ \hline Mant 3 & 9 & 7 & 6 & 30 & & & & & & & & \\ \hline Froject Requirements & 40 & 50 & 60 & & & & & & & & & \\ \hline & & & & & & & & & & & & \\ \hline & & & & & & & & & & & & \\ \hline & & & & & & & & & & & & \\ \hline Variables & x11 & x12 & X13 & & x22 & x23 & Xil & xiz & x33 & & & \\ \hline Uhil & 20 & 30 & 0 & 0 & 0 & 90 & 20 & 0 & 10 & Total & & \\ \hline Opjective Functisen & 10 & 4 & 11 & 12 & 5 & s. & 9 & 7 & 6 & 1040 & & \\ \hline & & & & & & & & & & & & \\ \hline Consirainis & & & & & & & & & & Lis & Sign & Rus \\ \hline Project A requirsments & 1 & & & 1 & & & 1 & & & 40 & = & 40 \\ \hline Project II requircments & & 1 & & & 1 & & & 1 & & 50 & = & 50 \\ \hline Project C requircments & & & 1 & & & 1 & & & 1 & 60 & = & 60 \\ \hline Plant 1 capacity & 1 & 1 & 1 & & & & & & & 20 & 0% & No \\ \hline Flant 2 capacity & & & & 1 & 1 & 1 & & & & 50 & & 50 \\ \hline Plant 3 sapocity & & & & & & & I & 1 & 1 & 30 & & 10 \\ \hline \end{tabular} [QX]=913 Finnish Furniture manufactures tables in facilities located in three cities-Reno, Denver, and Pittsburgh. The tables are then shipped to three retail stores located in Phoenix, Cleveland, and Chicago. Management wishes to develop a distribution schedule that will meet the stores' demands at the lowest possible cost. The shipping cost per unit from each of the sources to each of the destinations is shown in the following table: The available supplies are 120 units from Reno, 200 from Denver, and 160 from Pittsburgh. Phoenix has a demand of 140 units, Gleveland has a demand of 160 units, and Chicago has a demand of 180 units. How many units should be shipped from each manufacturing faclily to each of the retail stores if cost is to be minimized? What is the total cost? 1. Problem 9-13 (pg 343) - Write the equations for the problem from the chart (see example in attached spreadsheet); develop a spreadsheet for a Linear Programming solution to this problem; and use SOLVER to find the solution. \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline \multicolumn{3}{|c|}{ SOLVED PROBLEM EXAMPLES Pg 343} & \multicolumn{3}{|c|}{ TRANSPORTATION PROBLEM } & & & & & & & \\ \hline From/To & Project A & Project 8 & Project C & Plan Capacity & & & & & & & & \\ \hline Plant 1 & 10 & 4 & 11 & to & & fsec table in & in the problem & & & & & \\ \hline Plan 2 & 12 & 5 & 8 & 50 & & & & & & & & \\ \hline Mant 3 & 9 & 7 & 6 & 30 & & & & & & & & \\ \hline Froject Requirements & 40 & 50 & 60 & & & & & & & & & \\ \hline & & & & & & & & & & & & \\ \hline & & & & & & & & & & & & \\ \hline & & & & & & & & & & & & \\ \hline Variables & x11 & x12 & X13 & & x22 & x23 & Xil & xiz & x33 & & & \\ \hline Uhil & 20 & 30 & 0 & 0 & 0 & 90 & 20 & 0 & 10 & Total & & \\ \hline Opjective Functisen & 10 & 4 & 11 & 12 & 5 & s. & 9 & 7 & 6 & 1040 & & \\ \hline & & & & & & & & & & & & \\ \hline Consirainis & & & & & & & & & & Lis & Sign & Rus \\ \hline Project A requirsments & 1 & & & 1 & & & 1 & & & 40 & = & 40 \\ \hline Project II requircments & & 1 & & & 1 & & & 1 & & 50 & = & 50 \\ \hline Project C requircments & & & 1 & & & 1 & & & 1 & 60 & = & 60 \\ \hline Plant 1 capacity & 1 & 1 & 1 & & & & & & & 20 & 0% & No \\ \hline Flant 2 capacity & & & & 1 & 1 & 1 & & & & 50 & & 50 \\ \hline Plant 3 sapocity & & & & & & & I & 1 & 1 & 30 & & 10 \\ \hline \end{tabular} [QX]=913 Finnish Furniture manufactures tables in facilities located in three cities-Reno, Denver, and Pittsburgh. The tables are then shipped to three retail stores located in Phoenix, Cleveland, and Chicago. Management wishes to develop a distribution schedule that will meet the stores' demands at the lowest possible cost. The shipping cost per unit from each of the sources to each of the destinations is shown in the following table: The available supplies are 120 units from Reno, 200 from Denver, and 160 from Pittsburgh. Phoenix has a demand of 140 units, Gleveland has a demand of 160 units, and Chicago has a demand of 180 units. How many units should be shipped from each manufacturing faclily to each of the retail stores if cost is to be minimized? What is the total cost
