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