the Grand Circus wants to record how many customers go back because of the large waiting line

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

The Grand Circus wants to know most effective placement of staff in their Circus. Customers arrive according to exponential distribution with the mean of 2 minutes. Customers enter the Circus if ticket line is not greater that double value of Max waiting line size (which is currently 3). The Grand Circus wants to record how many customers go back because of the large waiting line. Ticket purchase time is triangular(1, 1.5, 3.5) minutes. After customers buy tickets they enter the lobby and 80% of them feel hungry and want to buy refreshment. There are two refreshment stands, main and satellite. The hungry patrons first look at the main refreshment stand, and if its queue is not larger than Max waiting line size (5) join the queue to buy refreshment. If the line is too long, they go to satellite stand. If its line is again not larger than Max waiting line size (5), they join to buy refreshment. If not, they skip buying refreshment and go directly to movie room, as other (non-hungry) patrons. Refreshment purchase time is triangular(4,5,9) in minutes for both, main and satellite stands. The company wants to estimate its revenue and lost opportunity, knowing that ticket price is $1.50, and customers buy refreshments for the amount of, on average, $2.00. nMake a model of this problem in Excel to simulate this operation and answer the following two questions. Run the simulation for 8 hours and replicate it 10 times. 1. How much is the estimated revenue? 2. How much is the lost opportunity (i.e., potential revenue that was not realized) because of the large waiting lines? Submit model in Excel file containing all calculations. In your excel file, highlight the cells that correspond to the answers to the above questions.

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme