Building a scenario/Menu model

It's not too hard with Solver.

See attached for an implementation of that.

I've set it up so that you input your desired values in the TARGET, and then run a Macro bound to the button to the right of the table. Make sure Solver is loaded or else it will throw an error like "Sub is not defined" when you click the button.

(The weight of the two variables might not be what you want; I just averaged them instead of summing them, which isn't really how Least Squares is supposed to work. You might want to change D24 from =AVERAGE(B24:C24) to =SUM(B24:C24) or maybe =(B24 *10 + C24) or something like that.

Maybe you have security settings that aren't allowing macro-enabled workbooks or something?

File > Options > Trust Center: [Trust Center Settings] > Macro Settings: Macro Settings
The second button [Disable all macros with notification] should be clicked & choose to enable macros when you load the file.

File > Options > Trust Center: [Trust Center Settings] > File Block Settings
See if the second checkbox [Excel 2007 and later MAcro-Enabled Workbooks and Templates] has the "Open" box checked

Well, if you're on a work computer, that might be circumventing your company IT policies though.



Either way, it's not that important.



You can just set Solver manually; Launch Solver and set objective D24 to Min, by changing cells D15:D21, with constraint D22 = D23; then click Solve.

See attached.