Our Advantage

  • 100 % Original
  • Any Urgency
  • Over 500 Writers
  • 15% Discount
  • No Hidden Charges
  • 24/7 Live Support
  • Secured Payments
  • High Quality Paper
  • Privacy Guaranteed
  • Any Citation Style

Josiane_exploring_e06_grader_Capstone21.xlsx

Budget

Valentine's Day BallOne-Variable Data Table: Attendees
Input Section
No. of Attendees400
% Attendees Using Valet50%
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 Attendees500
Maximum Parking Stalls240
Minimum Ticket Price$ 50.00
Maximum Ticket Price$ 100.00
Income
Student Club Contributions$ 8,500
Ticket Revenue30,000
Total Income$ 38,500Two-Variable Data Table: Attendees and Price Per Ticket
Expenses
Advertising$ 3,345
Ballroom Rental12,500
Chairs/Table Setup800
Valet Parking3,990
Decorations4,575
DJ Cost3,000
Cleanup Costs2,500
Meal Cost8,380
Contingency5,000
Total Expenses$ 44,090
Balance$ (5,590)
You can leave a response, or trackback from your own site.

Leave a Reply

Powered by WordPress | Designed by: Premium WordPress Themes | Thanks to Themes Gallery, Bromoney and Wordpress Themes