In contrast to the spreadsheet model for the Wyndor Glass Co. product-mix problem shown in Fig. 21.6, the spreadsheet given next is an example of a poorly formulated spreadsheet model for this same problem. Identify each of the guidelines in Sec. 21.3 that is violated by this poor model. In each case, explain how it violates the guideline and why the model in Fig. 21.6 does a much better job of following the guideline.

Transcribed Image Text:

1 Wyndor Glass Co. (Poor Formulation Batches of Windows Produced Hours Used (Plant 1 Hours Used (Plant 2 Hours Used (Plant 3 Total Profit 12 $36,000 Solver Parameters Set Objective Cell: CS To: Max By Changing Variable Cells: 5 Hours Used (Plant 1) 1 C3+0 C4 6 Hours Used (Plant 2) 0 C3+2 C4 C3:C4 Subject to the Constraints: 8 Total Profit 3000 C3+5000 C4 C6-2-12 C7 18 Solver Options: Make Variables Nonnegative Solving Method: Simplex LP