Apply Your Knowledge

profileoyabq76
ayk11_data.xlsx

AYK 11

Apply Your Knowledge
Project 11 - Scanner System
Input boxes in tan
Output boxes in yellow
Given data in blue
Answers in red

Scanner System

SplashEm
Average Ticket Price $35.00
Average Number Tickets Sold Annually 2,400,000
Online Ticket Expense as % of Sales 6%
Revenue Benefit Analysis Year 1 Year 2 Year 3 Totals
Anticipated Increase in Tickets Sold 0% 4% 4%
Number of Ticket Sales
Ticket Sales Adjustment
Booth Sales
% of Total Sales 90% 80% 70%
Number Tickets Sold at Booth
Revenue Generated
Online Sales
% of Total Sales 10% 20% 30%
Number Tickets Sold Online
Revenue Generated
Online Ticket Expense
Revenue Generated With Online Sales
Revenue Generated Without Online Sales
Net Benefit