Calculate all the assumptions including ticket sold at booth

Assignment Help Business Management
Reference no: EM131384689

Assignment: Apply Your Knowledge

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 (on the attachment) 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:

• Tickets sold at the booth.
• Tickets sold by the scanner.
• Revenues generated by booth sales.
• Revenues generated by scanner sales.
• Scanner ticket expense.
• Revenue with and without scanner sales.
• Three year row totals
• (***Your task is, for each yellow cell, 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.)***

Attachment:- Data.xlsx

Reference no: EM131384689

Questions Cloud

Demonstrate the process of creating an outline prior : Demonstrate the process of creating an outline prior to creating a draft of an academic paper. Synthesis of the previous research on good decisions that results in a general definition of good decision making.
Write algorithm to calculate total expences : Write algorithm to calculate total expences
Construct an individuals and a moving range chart : Construct an individuals and a moving-range chart on the data before process improvement changes are made and comment on process stability.
Construct an appropriate control chart : The time from product inception and design to marketing and sales is important for application software in mobile devices.- Construct an appropriate control chart and comment on the organization's responsiveness to market needs.
Calculate all the assumptions including ticket sold at booth : 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 Tickets sold at the booth.
Find the modified control limits for the process mean : It is desirable for the process nonconformance to be within 1.5%. If the acceptable level of type I error is 0.05, find the modified control limits for the process mean.
Find the modified control limits for the process mean : Refer to given Example and the data for the nitrogen content in a certain fertilizer mix. Ifit is desired that the proportion nonconforming be within 0.5% and the level of type I error be limited to 0.025, find the modified control limits for the ..
Briefly explain vaughan theory : In your response, briefly explain Vaughan's theory. Explain how this type of communication within one of the organizations (Ford Motor Company, NASA, B.F. Goodrich, and Volkswagen) altered the behavior of the employees
Find the modified control limits for the process mean : It is desirable for the process nonconformance to be within 1.5%. If the acceptable level of type I error is 0.05, find the modified control limits for the process mean.

Reviews

Write a Review

Business Management Questions & Answers

  Question based on financial management

Considering that airlines compete based on routes, flight times, and price; will the Investment Lufstansa is making in its airport lounges, will the Return on that Investment be positive, negative, or neutral?

  Focuses on the influence of decision support systems

This topic focuses on the influence of decision support systems and personal characteristics on decision-making process

  Role of the compensable factors in the rating

Describe with examples how the knowledge or skill needs of a job drive the evaluation rating and also describe with example the role of the other compensable factors in the rating.

  Management theories developed by fayol

Describe the key similarities and differences between the management theories developed by Fayol, Mintzberg and Katz

  Human resource management

In the early writings on HRM (Human Resource Management), it was claimed HRM differed from PM (Personnel Management) by virtue of the integration of HR policies with the strategic business needs of the firm. Which of the following findings have..

  Community efforts and managing public relations

Community Efforts and Managing Public Relations

  What timing strategy is used here

Poga International, a multinational beverage corporation identifies that one of its competitors is launching an apple flavored drink. The company decides to launch an apple flavor brand along with its competitor. What timing strategy is used here?

  Which one of the following is not a fundamental part of a

which one of the following is not a fundamental part of a companys culture?the behaviors that define how we do things

  Supervisor harassment causes economic

The employer is automatically liable if a supervisor's harassment causes economic harm to an employee, even if the employer was never previously informed about the harassment.

  Developing a search marketing strategy

What options do marketers have when it comes to developing a search marketing strategy?

  Health care issue with controversial ethical

Choose a health care issue with controversial ethical and legal implications that was at the center of a high visibility case in the public domain. Some examples of issues include but are not limited to the following:

  Temperature have a cause and effect relationship with sales

Project what the forecast number would have been for 2012 and determine the accuracy of that forecast (BIAS, Absolute, Absolute %, Standard Error) Does the Temperature have a cause and effect relationship with Sales?

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