Excel assignment task 4
G33 Valentine's Day Ball One-Variable Data Table: Attendees $ 38,500.00 44,090.00 (5,590.00) s 200.00 23,500.00 $37,505.00 (14,005.00) $ 220.00 25,000.00 38,163.50 (13,163.50) S 240.00$ 26,500.00 $38,822.00$ (12,322.00) 260.00 28,000.00 39,480.50 (11,480.50) S 280.00$ 29,500.00$ 40,139.00$ (10,639.00) 300.00 31,000.00 40,797.50 (9,797.50) 320.0032,500.00 41,456.00 $ (8,956.00) 340.00 $ 34,000.00 42,114.50$(8,114.50) 360.00 $ 35,500.00 42,773.00 (7,273.00) S 380.00$ 37,000.00 $43,431.50$(6,431.50 400.00 38,500.00 44,090.00 (5,590.00) 420.0040,000.00$ 44,748.50$(4,748.50 440.0041,500.00 45,407.00(3,907.00) S 460.00$ 43,000.00$ 46,065.50 $(3,065.50) S 480.00 $ 44,500.00$ 46,724.00(2,224.00) 500.00 46,000.00 47,382.50 (1,382.50) 2 Input Section 4 No. of Attendees 5 % Attendees using Valet 6 Cost per Chair Setup 7 Valet Parking per Car 8 Caterer's Meal Cost per Person 9 Ticket Price per Person 2.00 19.95 20.95 75.00 Limitations 12 Maximum Attendees 13 Maximum Parking Stalls 14 Minimum Ticket Price 15 Maximum Ticket Price 16 17 18 Student Club Contributions 19 Ticket Revenue 20 Total Income 21 240 50.00 $100.00 Income 8,500 30,000 $38,500 Two-Variable Data Table: Attendees and Price Per Ticket 23 Advertising 24 Ballroom Rental 25 Chairs/Table Setup 26 Valet Parking 27 Decorations 28 DJ Cost 29 Cleanup Costs 30 Meal Cost 31 Contingency 32 Total Expenses 3,990 4,575 3,000 8,380 5,000 $44,090 Balance 5,590) 35 37 G33 Valentine's Day Ball One-Variable Data Table: Attendees $ 38,500.00 44,090.00 (5,590.00) s 200.00 23,500.00 $37,505.00 (14,005.00) $ 220.00 25,000.00 38,163.50 (13,163.50) S 240.00$ 26,500.00 $38,822.00$ (12,322.00) 260.00 28,000.00 39,480.50 (11,480.50) S 280.00$ 29,500.00$ 40,139.00$ (10,639.00) 300.00 31,000.00 40,797.50 (9,797.50) 320.0032,500.00 41,456.00 $ (8,956.00) 340.00 $ 34,000.00 42,114.50$(8,114.50) 360.00 $ 35,500.00 42,773.00 (7,273.00) S 380.00$ 37,000.00 $43,431.50$(6,431.50 400.00 38,500.00 44,090.00 (5,590.00) 420.0040,000.00$ 44,748.50$(4,748.50 440.0041,500.00 45,407.00(3,907.00) S 460.00$ 43,000.00$ 46,065.50 $(3,065.50) S 480.00 $ 44,500.00$ 46,724.00(2,224.00) 500.00 46,000.00 47,382.50 (1,382.50) 2 Input Section 4 No. of Attendees 5 % Attendees using Valet 6 Cost per Chair Setup 7 Valet Parking per Car 8 Caterer's Meal Cost per Person 9 Ticket Price per Person 2.00 19.95 20.95 75.00 Limitations 12 Maximum Attendees 13 Maximum Parking Stalls 14 Minimum Ticket Price 15 Maximum Ticket Price 16 17 18 Student Club Contributions 19 Ticket Revenue 20 Total Income 21 240 50.00 $100.00 Income 8,500 30,000 $38,500 Two-Variable Data Table: Attendees and Price Per Ticket 23 Advertising 24 Ballroom Rental 25 Chairs/Table Setup 26 Valet Parking 27 Decorations 28 DJ Cost 29 Cleanup Costs 30 Meal Cost 31 Contingency 32 Total Expenses 3,990 4,575 3,000 8,380 5,000 $44,090 Balance 5,590) 35 37
