Scenario Summary

Feb 22, 2012 - No. of Attendees. 480 $B$4
230KB taille 52 téléchargements 102 vues
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