Print for upcoming NCAA Basketball Tournament game

Assignment Help Operation Management

Reference no: EM132277359

Solve the following Monte-Carlo simulation problem both with Excel data tables and @Risk. Include all your answers directly in your Excel file using text boxes or comment boxes.

NCAA Sweatshirt Problem

An enterprising OU student is trying to decide how many sweatshirts to print for an upcoming NCAA Basketball Tournament game. The final four teams have emerged from the quarterfinal round, and there is a week left until the semi-finals, which are then followed by the finals a few days later. Each sweatshirt costs $10 to produce and sells for $25. However, in 3 weeks, any leftover sweatshirts will be put on sale for half price, $12.50. The student assumes that the demand for her sweatshirts during the next three weeks has the distribution shown in the file NCAASweatshirts-shell.xlsx in F5:G10. The residual demand, after the sweatshirts have been put on sale, has the distribution also shown in the same file in J5:K10. The student, being a profit maximizer, realizes that every sweatshirt sold, even at the sale price, makes a profit. However, she also realizes that any sweatshirts printed and still unsold (even at the sale price) must be given away, resulting in a loss of $10 per discarded shirt. Your job is:

1) Build an Excel based Monte-Carlo simulation model that will produce a probability distribution of profit for a given number of sweatshirts printed. Your simulation model should do 1000 replications.

For your base model,

2) Set the number of sweatshirts printed in your model to 10000. Run your model and find the mean and standard deviation of profit as well as the 5th and 95th percentiles of profit.

3) Construct a 95% confidence interval on the mean profit.

4) Now use your model to explore different numbers of printing quantities and find the:

a. Quantity that maximizes mean profit

b. Quantity that maximizes 5th percentile of profit

c. Quantity that maximizes 95th percentile of profit

d. Do these quantities differ?

Reference no: EM132277359

Questions Cloud

Strategic human resource planning-forecasting labour demand : There are quantitative techniques to forecasting the amount and type of employees needed for an organization in the future.

Different kinds of investors in the private equity market : Identify three different kinds of investors in the private equity market. Do the goals of these investors differ? How?

Differences of formal and informal work group : What are the similarities and differences of a formal and an informal work group?

Venture capitalists seek to maximize economic returns : Venture capitalists seek to maximize economic returns. How do venture capital firms balance their portfolios to minimize risks?

Print for upcoming NCAA Basketball Tournament game : An enterprising OU student is trying to decide how many sweatshirts to print for an upcoming NCAA Basketball Tournament game.

Key differences between good and poor managers : What do you believe are the key differences between good and poor managers?

About globalization explaining advantages or disadvantages : Write an introductory post on your views about globalization explaining the advantages or disadvantages.

The plaintiff damages be proven to reasonable certainty : Why, in a breach of contract case, must the amount of the plaintiff's damages be proven to a reasonable certainty?

Employee training and development : Describe how trainers can create a learning orientation among trainees in contrast ta a performance orientation.

User Account

All Pages