Revenue generated with online sales for a year

Assignment Help Basic Computer Science
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

Reference no: EM131310047

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 c

Which do you think is more psychologically acceptable

Consider the two interpretations of a time field that specifies "1 A.M." One interpretation says that this means exactly 1:00 A.M. and no other time. The other says that thi

Does the set form a lattice under that relation

Consider a set with elements that are totally ordered by a relation. Does the set form a lattice under that relation? If so, show that it does. If not, give a counterexample

Why are the extra digits necessary

The Web server on the DMZ Web server system renames temporary files used to record transactions. The name has the form trns followed by the integer representation of the dat

Would he be able to access the data in some other way

Assume that the user is not allowed to mount media such as the floppy disk. Thus, he would not be able to access the data on the disk as though it were a file system. Would

How important would secrecy of the nis records be then

The NIS client accepts the first response to its query that it receives from any NIS server. Why is physical control of the development network critical to the decision not

Should this antivirus software be installed on mail server

What other actions should the Drib take to limit incoming computer worms and viruses in attachments? Specifically, what attributes should cause the Drib to flag attachments

Are the semantics unambiguous now

The little languages presented in Section have ambiguous semantics. For example, in the location language, does "not host1 or host2" mean "not at host1 and not at h


Write a Review

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd