\fDine In (1)/Take Out (2) Satisfaction with Service Satisfaction with Food 1 4 1 2 1 3 1 5 2 3 2 2 2 3 1 4 2 3 1 2 2 1 2 2 1 5 1 4 1 4 1 3 1 4 2 3 2 3 1 4 2 4 1 2 2 3 2 3 1 3 2 4 2 3 1 4 2 3 1 4 2 2 2 2 1 4 2 3 2 3 1 3 1 3 1 4 2 3 2 3 1 4 2 3 2 2 1 3 2 4 1 2 2 4 1 4 Overall Satisfaction 4 3 3 5 4 4 4 3 3 3 3 2 4 5 5 4 3 4 4 5 5 3 5 4 4 5 3 4 4 5 3 2 4 2 3 3 3 5 3 4 4 3 3 3 4 3 5 5 4 3 3 5 3 3 3 3 3 2 2 2 4 4 4 3 4 3 3 4 4 3 4 3 3 4 3 4 4 4 2 2 4 3 3 3 3 4 3 3 4 3 2 3 4 2 4 4 1 5 5 5 Driving Distance to Restaurant Total Bill 5 10 5 15 10 10 12 15 10 25 15 25 10 26 16 27 2 25 10 26 15 20 10 20 12 20 16 20 18 20 20 27 18 28 20 28 16 28 7 12 9 20 10 24 6 26 10 28 9 27 8 24 10 22 6 23 10 25 10 20 15 20 16 20 18 20 16 20 14 25 20 22 16 23 17 28 16 23 5 15 10 28 6 24 10 27 6 26 7 28 6 24 8 22 6 23 8 20 LP_min Enter Enter the the values values in in the the shaded shaded area. area. Then Then go go to to the the DATA DATATab Tab on on the the ribbon, ribbon, click click on on Solve Solve Analysis Group and then click SOLVE. Analysis Group and then click SOLVE. IfIf SOLVER SOLVER isis not not on on the the Data Data Tab Tab then then please please see see the the Help Help file file (Solver) (Solver) for for instructions. instructions. To To use use Integer Integer variables, variables, define define them them in in the the Solver Solver model model as as aa constraint. constraint. Linear, Integer and Mixed Integer Programming Signs < = > less than or equal to equals (You need to enter an apostrophe first.) greater than or equal to Data x1 Minimize 10 AM-1 PM 1:00 PM - 4:00 PM 4:00 PM- 7:00 PM 7:00 PM- 10:00 PM 10:00 PM- 1:00 AM Results Variables Objective x2 1 0 x3 1 x4 1 x5 1 1 sign > > > > > RHS 3 4 6 7 4 0 0 Page 1 LP_min e DATA DATATab Tab on on the the ribbon, ribbon, click click on on Solver Solver in in the the Data Data he he Help Help file file (Solver) (Solver) for for instructions. instructions. model model as as aa constraint. constraint. ter an apostrophe first.) Results LHS Slack/Surplus 0 0 0 0 0 0 3 4 6 7 4 Page 2