Josiane_exploring_e06_grader_Capstone21.xlsx

Budget

Valentine's Day Ball One-Variable Data Table: Attendees
Input Section
No. of Attendees 400
% Attendees Using Valet 50%
Cost per Chair Setup $ 2.00
Valet Parking per Car $ 19.95
Caterer's Meal Cost per Person $ 20.95
Ticket Price per Person $ 75.00
Limitations
Maximum Attendees 500
Maximum Parking Stalls 240
Minimum Ticket Price $ 50.00
Maximum Ticket Price $ 100.00
Income
Student Club Contributions $ 8,500
Ticket Revenue 30,000
Total Income $ 38,500 Two-Variable Data Table: Attendees and Price Per Ticket
Expenses
Advertising $ 3,345
Ballroom Rental 12,500
Chairs/Table Setup 800
Valet Parking 3,990
Decorations 4,575
DJ Cost 3,000
Cleanup Costs 2,500
Meal Cost 8,380
Contingency 5,000
Total Expenses $ 44,090
Balance $ (5,590)