Create a spreadsheet model in standard MIP format. Use Solver to select the set of

activities for your trip that maximizes your total enjoyment score. Of course, you should

not exceed the budgeted cost or duration. Label your tab as Q$1$A$.$

B$.$ After telling your daughters the optimal plan, your youngest daughter replies, $$Two

museums! In one day! Are you kidding?$$ Enhance your spreadsheet to limit the number

of museums visited to be no more than one. Re$-$run Solver. Label your tab as Q$1$B$.$

C$.$ After reviewing the Q$1$B solution, you observe that the optimal solution includes visiting

the planetarium, which is far from all other activities selected. $($Note: if this is not the