Reference no: EM131310047
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
|
Understanding the role of the project manager
: Discuss reasons for understanding the role of the project manager, project leadership, and the project team (LO7). Discuss two types of conflict that might arise during a project. Describe a situation in which you have experienced these types of c..
|
|
A company issued preferred shares two years
: A company issued preferred shares two years ago, paying a $3.85 dividend, which offered investors an original yield of 9%. Currently, the required return on companies with preferred shares of comparable risk yield 9%. Given this information, what sho..
|
|
Write about terrorism and how terrorism affects americans
: Write a 1,050- to 1,400-word essay in which you consider why the topic should be included in your list, how this topic affects Americans and the wider global community, what remedies and policies have been implemented on this topic/issue, and viab..
|
|
The dangerous morality of managing earnings
: Discussion of management's ability to manage earnings in the long term given the operational manipulations discussed in the case.
|
|
Revenue generated with online sales for a 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.
|
|
Advertising public relations personal selling
: Part A what are the advantages and disadvantages of advertising public relations personal selling and sales promotions from the perspective of a small independent retailer?
|
|
What is the implied growth rate for company
: A business paid a dividend last year of $2.4, and its stock is currently trading at $51 a share. If investors require a rate of return of 12.2, what is the implied growth rate for this company?
|
|
Discuss about the women empowerment
: For women generally, this means advancing sexual and reproductive health and rights, an area where Africa has some of the worst indicators. Sexual and reproductive rights simply means granting everyone the freedom and the means to make informed de..
|
|
How can the user force the computer to shut down
: Suppose a user has physical access to computer hardware (specifically, the box containing the CPU and a hard drive). The user does not have an account on the computer. How can the user force the computer to shut down? To reboot?
|