# Some analysts complain that spreadsheet models are difficult to resize. Well let you be the judge..

Some analysts complain that spreadsheet models are difficult

to resize. Well 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. Well 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 its easy to resize a spreadsheet model? (By the way, algebraic

models are typically much easier to resize.)

»