Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Michelle Abrams runs a specialty clothing store that sells collegiate sports apparel. One of her primary business opportunities involves selling custom screen printed sweatshirts for

Michelle Abrams runs a specialty clothing store that sells collegiate sports apparel. One of her primary business opportunities involves selling custom screen printed sweatshirts for college football bowl games. She is trying to determine how many sweatshirts to produce for the upcoming Tangerine Bowl game. During the month before the game, Michelle plans to sell sweatshirts for $30 each. At this price, she believes the demand for sweatshirts will be normally distributed with mean 7,000 and standard deviation 1,500 (with no negative values). During the month after the game, Michelle plans to sell any remaining sweatshirts for $12 each. At this price, she believes the demand for sweatshirts will be discrete uniformly distributed with a minimum demand of 300, and a maximum demand of 1,000. Two months after the game, Michelle plans to sell any remaining sweatshirts to a surplus store that has agreed to buy up to 1,500 sweatshirts for a price of $3 per shirt. Michelle can order custom screen printed sweatshirts for $10 per sweatshirt in lot sizes of 1000.

  1. Develop a descriptive model of this scenario; identify and name random and non-random variables along the way. You may develop a flowchart for yourself to help you visualize, but do not attach it to the submission.
  2. List all random variables, their distributions, and parameters.
  3. Code the model in Excel and replicate it 10,000 times. Answer the following questions (do not attach the spreadsheet):
    1. Determine the average profit that Michelle would earn if she orders 10,000 sweatshirts.
    2. Find the probability that Michelle's profit would be less than or equal to $100,000 if she orders 10,000 sweatshirts.
    3. How many sweatshirts would you recommend Michelle order to maximize average profit?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business Research Methods

Authors: Emma Bell, Bill Harley, Alan Bryman

5th Edition

0198809875, 9780198809876

More Books

Students also viewed these General Management questions

Question

Pollution

Answered: 1 week ago

Question

The fear of making a fool of oneself

Answered: 1 week ago