Some analysts complain that spreadsheet models are difficult to resize. We’ll let you be the judge of this. Suppose the current product mix problem is changed so that there is an extra resource,...

Some analysts complain that spreadsheet models are difficult to resize. We’ll let you be the judge of this. Suppose the current product mix problem is changed so that there is an extra resource, plastic, and two additional frame types, 5 and 6. What additional data are required? What modifications are necessary in the spreadsheet model (including range name changes)? Make up values for any extra required data and incorporate these into a modified spreadsheet model. (You might want to try inserting new columns in the middle of your range, rather than inserting them at the end. See if you can discover why the former is more efficient.) Then optimize with Solver. Do you conclude that it’s easy to resize a spreadsheet model? (By the way, algebraic models are typically much easier to resize.)