Problem 2 Solver TC 10,750 Decision Variables Objective Function Solution Values ICA 20 70 XCU 30 30 XGA 35 80 XGU 50 XRA 40 XRU 20 70 XAM 15 150 XAL 40 XUM 25 0 XUL 20 100 0 0 0 XCU XGA XGU XRA XRU XAM XAL XUM XUL XCA 1 LHS 100 80 70 RHS 100 80 70 Slack 0 0 1 > 0 150 100 e 0 Adjustable Cells Cell Name $B$5 Solution Values xCA $C$5 Solution Values XCU $D$5 Solution Values GA $E$5 Solution Values xGU $F$5 Solution Values RA $G$5 Solution Values XRU $H$5 Solution Values XAM $I$5 Solution Values XAL $J$5 Solution Values XUM $K$5 Solution Values XUL Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 70 0 20 15 5 30 0 30 5 20 80 0 35 5 15 0 5 50 1E+30 5 0 30 40 1E+30 30 70 0 20 25 1E+30 150 0 15 20 50 0 10 40 1E+30 10 0 20 25 1E+30 20 100 0 20 10 65 Constraints Shadow Price Final Value 100 80 -15 0 -25 70 Cell Name $L$8 Charlotte Cap LHS $L$9 Greenville Cap LHS $L$10 Rock Hill Cap LHS $L$11 Anderson Warehouse LHS $L$12 Union Warehouse LHS $L$13 Monroe Require LHS $L$14 Lexington Require LHS Constraint Allowable Allowable R.H. Side Increase Decrease 100 80 0 80 1E+30 0 70 30 0 0 0 80 0 0 30 150 0 80 100 0 30 0 0 35 45 50 65 150 100 Problem 2: See problem 2 printouts on following page. This is an example of a standard Transshipment Problem. Acme Appliances manufactures washers at three different facilities located at Charlotte, Greenville, and Rock Hill and ships them to warehouses at Anderson and Union. These warehouses then ship the washers to Acme's two retail stores located at Monroe and Lexington. The cost to ship one washer between facilities, along with the monthly capacities and requirements are shown in the tables below. Plant Charlotte Greenville Rock Hill Requirements Anderson 20 35 40 0 Union 30 50 20 0 Capacity 100 80 70 Warehouse Anderson Union Requirements Monroe 15 25 150 Lexington 40 20 100 Capacity 0 0 (a) (b) Set up the primal problem and use Solver to determine the optimal shipping flows. What is the value to Acme if it were to ship 1 one less unit from the Charlotte plant. Explain. What is it worth to Acme if it could ship 20 less units from the Greenville plant. What if it shipped 40 less units? Why is no product being shipped from Rock Hill to Anderson? Explain using the dual problem results. At what price would product be shipped from Rock Hill to Anderson? Explain. (d) (e) Problem 2 Solver on next page