M4 Valentine's Day Ball One-Variable Data Table: Attendees $38,500 44,090 $ (5,590) 14005 13163.5 12322 11480.5 10639 9797.5 23500 4 5 6 7 8 9 Input Section No.of Attendees % Attendees using Valet Cost per Chair Setup Valet Parking per Car Caterer's Meal Cost per Person Ticket Price per Person 37505 38163.5 38822 39480.5 40139 40797.5 41456 42114.5 42773 43431.5 240 260 2.00 19.95 20.95 75.00 26500 28000 29500 31000 32500 320 8114.5 7273 6431.5 5590 4748.5 35500 37000 12 Maximum Attendees 13 Maximum Parking Stalls 14 Minimum Ticket Price 15 Maximum Ticket Price 240 50.00 100.00 420 41500 43000 44500 44748.5 45407 46065.5 46724 47382.5 3065.5 2224 1382.5 17 18 Student Club Contributions 19 Ticket Revenue 8,500 30,000 S38,500 20 Total Income 21 Two-Variable Data Table: Attendees and Price Per Ticket 23 Advertising 24 Ballroom Rental 25 Chairs/Table Setup 26 Valet Parking 3,345 3,990 4,575 3,000 28 DJ Cost 29 Cleanup Costs 30 Meal Cost 31 Contingency 32 Total Expenses 8,380 5,000 $44,090 Balance (5,590) 37 Budget Q&A Ready