Scenario Summary 500 Attend
Changing Cells: No. Attending Meal Cost/Person Ticket Price/Person Ballroom Rental Result Cells: Total Revenue Total Expenses Balance
Student Name
400 Attend
300 Attend
200 Attend
$ $
500 15.95 $ 75.00 $ 12,500
400 17.95 $ 85.00 $ 12,500
300 19.95 $ 90.00 $ 11,995
200 22.95 95.00 11,995
$ $ $
46,000 $ 44,883 $ 1,118 $
42,500 $ 42,890 $ (390) $
35,500 $ 39,993 $ (4,493) $
27,500 37,400 (9,900)
Sheet Name code
File Name code
Microsoft Excel 14.0 Answer Report Worksheet: [e06c1dance_LastnameFirstname.xlsx]Budget Report Created: 2/22/2012 9:35:30 PM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: GRG Nonlinear Solution Time: 0.047 Seconds. Iterations: 3 Subproblems: 0 Solver Options Max Time 100 sec, Iterations 100, Precision 0.000001 Convergence 0.0001, Population Size 100, Random Seed 0, Derivatives Forward, Require Bounds Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 5% Objective Cell () Cell $C$34
Balance
Original Value $ -
Variable Cells Cell $B$4 $B$9
Name No. of Attendees Ticket Price per Person
Original Value 400 $ 88.98 $
Name Valet Parking No. of Attendees Ticket Price per Person Ticket Price per Person
Cell Value 4,788 480 $ 100.00 $ 100.00
Constraints Cell $B$26 $B$4 $B$9 $B$9 $B$4=Integer
Student Name
Name
$
Final Value 9,776
Final Value
Integer 480 Integer 100.00 Contin
Formula $B$26