Excel Assignment
The Year 1 "Number of Tickets Sales" (cell c12) is the same as the initial "Average Number Tickets Sold Annually" (cell c6).
In Years 2 and 3, the value for "Number of Tickets Sales" will increase by the "Anticipated Increase in Tickets Sold" percent value for that year.
The Totals for that row is the sum of the values in the row. In the Booth Sales section, the values in the row labeled "Number Tickets Sold at Booth" will be the value for the "% of Total Sales" for each year multiplied by the "Number of Tickets Sales" for that year.
In Year 1, it is C12*C16, and in Year 2, it is D12*C16, and so on. In each year, the "Revenue Generated" will be the "Average Ticket Price" (cell C5) times the "Number Tickets Sold at Booth" for that year.
For Online Sales, an assumption is that "% of Total Sales" will increase from 10% to 20% to 30% in the 3 years shown.
So the "Number Tickets Sold Online" for each year will be that percentage times "Number of Ticket Sales" for that year. And the Revenue Generated for a year will be the "Number Tickets Sold Online" for that year times the "Average Ticket Price".
The Online Ticket Expense for a year will be the "Online Ticket Expense as % of Sales" times the "Revenue Generated" for that year.
Revenue Generated With Online Sales for a year will be the "Revenue Generated for Booth Sales" plus the "Revenue Generated for Online Sales" less the "Online Ticket Expense" in each year. Revenue Generated Without Online Sales for a year will be the value of "Average Ticket Price" times "Average Number Tickets Sold Annually" for each year. This means that it will be the constant for each year and assumes that there are NO online sales. However, the Net Benefit for each year will be the "Revenue Generated With Online Sales" less the "Revenue Generated Without Online Sales" for each year.
Attachment:- Ayk11_data.xlsx