Some analysts complain that spreadsheet models are difficult to resize. We’ll let you be the judge..

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
»

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.)

»