Case Study:
Scanner System
FunTown is a popular amusement park filled with roller coasters, games, and water features. Boasting 24 roller coasters, 10 of which exceed 200 feet and 70 miles per hour, and five water parks, the park's attendance remains steady throughout the season. Due to the park's popularity, it is not uncommon for entrance lines to exceed one hour on busy days. FunTown would like your help to find a solution to decrease park entrance lines.
FunTown would like to implement a handheld scanner system that can allow employees to walk around the front gates and accept credit card purchases and print tickets on the spot. The park anticipates an overall increase in sales of 4 percent per year with online ticketing, with an expense of 6 percent of total sales for the scanning equipment.
Please use the data file that FunTown has provided, that compares scanning sales and traditional sales. You will need to create the necessary formulas to calculate all the assumptions including:
1. Tickets sold at the booth.
2. Tickets sold by the scanner.
3. Revenues generated by booth sales.
4. Revenues generated by scanner sales.
5. Scanner ticket expense.
6. Revenue with and without scanner sales.
7. Three year row totals.
The AYK is strictly arithmetic. That is, no fancy Excel tools required. Your task is, to figure out which factors from the given data need to be combined arithmetically (could be multiplication, could be addition, could be only one factor is needed) and create the formula that executes that combination.
|
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
|
|
|
|
|