Questions from Business Analytics

Q: A bakery stall at a local supermarket bakes 100 loaves of banana

A bakery stall at a local supermarket bakes 100 loaves of banana bread every morning for sale. The cost of baking a loaf of banana bread is $3 and it sells for $5. The average expected sales at the st...

Q: Develop and analyze a simulation model for Vision Clinic with the following

Develop and analyze a simulation model for Vision Clinic with the following assumptions. Assume that the demand is uniform between 110 and 160 per week and that anywhere between 10% and 20% of prospec...

Q: The following table shows the number and frequency of books bought per

The following table shows the number and frequency of books bought per customer, on an hourly basis, at a bookstore from 10am to 9pm on a specific day. Use VLOOKUP to generate 20 random variates from...

Q: DemiGod Shipping Company forecasts a 10% increase in its sales over

DemiGod Shipping Company forecasts a 10% increase in its sales over the year 2019. Its assets and liabilities, at the end of 2018, amount to $20 billion and $7 billion respectively. Sales for this pe...

Q: In Jennifer Bellin’s leadership conference project, suppose that the activity times

In Jennifer Bellin’s leadership conference project, suppose that the activity times are uncertain. Estimated ranges for these times are shown in the table below. Develop a spreadshee...

Q: A front office receptionist of a given company answers the incoming calls

A front office receptionist of a given company answers the incoming calls on multi-line telephones. The number of calls successfully attended by the receptionist within each 5-minute period is recorde...

Q: E-Globex is a moneychanger headquartered in Kuala Lumpur, Malaysia

E-Globex is a moneychanger headquartered in Kuala Lumpur, Malaysia. It quotes the current US Dollar to Malaysian Ringgit exchange rate to be RM4.1740 for every 1 US Dollar. The daily price changes ove...

Q: The Miller-Orr model in finance addresses a firm’s problem of

The Miller-Orr model in finance addresses a firm’s problem of managing its cash position by purchasing or selling securities at a transaction cost in order to lower or raise its cash position. That is...

Q: For the car wash simulation model, use data tables to find

For the car wash simulation model, use data tables to find the distributions for the maximum number in the queue, maximum waiting time, average waiting time per customer, and total idle time. Use 100...

Q: In many queueing situations, the time between arrivals and service times

In many queueing situations, the time between arrivals and service times are assumed to have exponential distributions. Modify the car wash model to simulate a queueing system with an exponential arri...