1. Use Goal Seek to achieve a $0 balance by changing the Ticket Price per Person.

2. Beginning in cell E3, complete the series of substitution values ranging from 200 to 500 at increments of 20 students vertically down column E.

3. Enter cell references to the Total Income, Total Expenses, and Balance formulas (in that order) for a one-variable data table in cells F2, G2, and H2 respectively.

Transcribed Image Text:

File Get Data - A1 Home Insert From Text/CSV From Web From Table/Range Get & Transform Data 1 2 3 Input Section 4 No. of Attendees A % Attendees Using Valet Ready B Valentine's Day Ball 5 6 Cost per Chair Setup 7 Valet Parking per Car 8 Caterer's Meal Cost per Person 9 Ticket Price per Person 10 11 Limitations 12 Maximum Attendees 13 Maximum Parking Stalls Draw Page Layout Recent Sources Existing Connections 20 Total Income 21 14 Minimum Ticket Price 15 Maximum Ticket Price 16 17 Income 18 Student Club Contributions 19 Ticket Revenue Budget + fx Valentine's Day Ball с с $ $ $ $ Formulas $ Queries & Connections Properties All-Edit Links Refresh Queries & Connections 400 50% 2.00 19.95 20.95 75.00 500 240 $ 50.00 $ 100.00 Data Review View 8,500 30,000 $ 38,500 D AL 32 Sort E Tell me what you want to do Clear Reapply Advanced Filter Sort & Filter Text to Columns -0 Data Tools F G One-Variable Data Table: Attendees H What-If Forecast Analysis Sheet Forecast I Group - Q] Ungroup - ~ T Subtotal Outline J Two-Variable Data Table: Attendees and Price Per Ticket ?, Solver Analyze K E L M + Share NA +100% File Get Data - A1 Home Insert From Text/CSV From Web From Table/Range Get & Transform Data 1 2 3 Input Section 4 No. of Attendees A % Attendees Using Valet Ready B Valentine's Day Ball 5 6 Cost per Chair Setup 7 Valet Parking per Car 8 Caterer's Meal Cost per Person 9 Ticket Price per Person 10 11 Limitations 12 Maximum Attendees 13 Maximum Parking Stalls Draw Page Layout Recent Sources Existing Connections 20 Total Income 21 14 Minimum Ticket Price 15 Maximum Ticket Price 16 17 Income 18 Student Club Contributions 19 Ticket Revenue Budget + fx Valentine's Day Ball с с $ $ $ $ Formulas $ Queries & Connections Properties All-Edit Links Refresh Queries & Connections 400 50% 2.00 19.95 20.95 75.00 500 240 $ 50.00 $ 100.00 Data Review View 8,500 30,000 $ 38,500 D AL 32 Sort E Tell me what you want to do Clear Reapply Advanced Filter Sort & Filter Text to Columns -0 Data Tools F G One-Variable Data Table: Attendees H What-If Forecast Analysis Sheet Forecast I Group - Q] Ungroup - ~ T Subtotal Outline J Two-Variable Data Table: Attendees and Price Per Ticket ?, Solver Analyze K E L M + Share NA +100%