Questions from Analytics

Q: SPD Tax Service is a regional tax preparation firm that

SPD Tax Service is a regional tax preparation firm that competes with such national chains as H&R Block. The company is considering expanding and needs a financial model to analyze the decision to ope...

Q: Sturgill Manufacturing, Inc. needs to predict the numbers of machines

Sturgill Manufacturing, Inc. needs to predict the numbers of machines and employees required to produce its planned production for the coming year. The plant runs three shifts continuously during the...

Q: O’Brien Chemicals makes three types of products: industrial cleaning, chemical

O’Brien Chemicals makes three types of products: industrial cleaning, chemical treatment, and some miscellaneous products. Each is sold in 55-gallon drums. The selling price and unit...

Q: Use the Newsvendor Model spreadsheet to set up and run

Use the Newsvendor Model spreadsheet to set up and run a Monte Carlo simulation assuming that demand is Poisson with a mean of 45 but a minimum value of 40 (use the lower cutoff parameter in the distr...

Q: Determine if there is evidence to conclude that the mean

Determine if there is evidence to conclude that the mean GPA of males who plan to attend graduate school is larger than that of females who plan to attend graduate school using the data in the Excel f...

Q: The manager of the extended-stay hotel in Problem 27 of

The manager of the extended-stay hotel in Problem 27 of Chapter 11 believes that the number of rooms rented during any given week has a triangular distribution with minimum 32, most likely 38, and max...

Q: In the Sales Transactions database, find the proportion of customers

In the Sales Transactions database, find the proportion of customers who used PayPal and the proportion of customers who used credit cards. Also, find the proportion that purchased a book and the prop...

Q: Develop a Monte Carlo simulation model for the garage-band in

Develop a Monte Carlo simulation model for the garage-band in Problem 7 in Chapter 11 with the following assumptions. The expected crowd is normally distributed with mean of 3,000 and standard deviati...

Q: A plant manager is considering investing in a new $30,000

A plant manager is considering investing in a new $30,000 machine. Use of the new machine is expected to generate a cash flow of about $8,000 per year for each of the next 5 years. However, the cash f...

Q: The Kelly Theater produces plays and musicals for a regional

The Kelly Theater produces plays and musicals for a regional audience. For a typical performance, the theater sells at least 250 tickets and occasionally reaches its capacity of 600 seats. Most often,...