Consider the Greenberg Motors example from section 3.8. Retrieve file Figure 3.14.xlsx, Sheet: Figure 3.14 from the Companion Website. Rerun the model (seen in Figure 3.14) by making all decision variables integer. The solution will take a while to run, and you may need to answer “Continue” if you reach an iteration limit. How much worse is the new cost? Did the new decision variable values round as you would have expected?

Figure 3.14

Transcribed Image Text:

All entries in column R are computed using the SUMPRODUCT function. K P 1 Greenberg Motors Per GM3A GM3A GM3A GM3A GM3A GM3A GM3A GM3A GM3B GM38 GM38 GM38 GM38 GM3B GM38 GM3B Jan prod 1276.92 476.92. 1,138.46 915.38 842.31 757.89 792 31 450.00 1,000.00 0.00 1,200.00 0 00 1.400.00. 0.00 1,700.00 300.00 PAt las PA2 la2 PAS las PAM Ist Pe2 lez Pes les Pe4 3 Feb Feb Mar prod Apr prod Feb Feb Mar prod Jan Jan Mar Apr Jan Mar Apr Apr inv 14 prod inv prod inv inv inv inv prod inv inv prod S Number of Units 6 Cost 7 Constraints: 8 GM3A Jan balance 9 GM3B Jan balance 10 GM3A Feb balance 11 GM3B Feb balance 12 GM3A Mar balance 13 GM3B Mar balance 14 GM3A Apr balance 15 GM3B Apr balance $10.00 $0.18 $10.00 S0.18 $11.00 $0.18 $11.00 s0.18 $6.00 $0.13 $6.00 $0.13 $6.60 $0.13 $8.60 $0.13 S76.301.62 800 1000 700 1200 1000 1400 1100 1400 450 300 476.92 3300 3300 3300 750.00 ce 3300 2560 2560 2560 2560 2560.00 2240 2240 2355.00 2240 2240 Sign RHS -1 800.00 1000 00 1 -1 -1 700.00 1200.00 1000 00 -1 -1 -1 1400.00 1. -1 1100.00 -1 1400.00 16 GM3A Apr inventory 17 GM3B Apr Inventory 18 Jan storage cap 19 Feb storage cap 20 Mar storage cap 21 Apr storage cap 22 Jan labor max 23 Feb labor max 24 Mar labor max 25 Apr labor max 26 Jan labor min 27 Feb labor min 28 Mar labor min 29 Apr labor min 30 450.00 300.00 1. 915.38 1. 757 69 1. 1.3 0.9 2560.00 13 0.9 2560.00 1.3 0.9 2355.00 13 0.9 2560.00 1.3 0.9 13 0.9 2560.00 1.3 0.9 1.3 0.9 2560.00 LHS Solver Parameters Set Objective: SR$6 To: G MO Cyalue Of Solver includes three entries: One for each type of constraints s, 2, and -. Ey Changing Variable Cels: Subject to the Constrants: SRS18: SRS25 <= $STS18: STS25 SRS26: SR$29 >- $T$26:ST$29 SR$3: SR$17 - STS8:ST$17