Concert Production is planning an appearance of the top band Iggy Wiggy. They plan to buy custom desgined T-shirts to sell at the stadium where the concert will take place. The T-shirt will sell for $25 and the cost per shirt is $8. Previous experience at the Concert Productions suggests that after the concert is over, T-shirts can still be sold, but the selling price will only be $5 per shirt. Based on analysis of previous similar concerts, the company estimates sales of the T-shirt will be 6,000 units. However, the analysis also shows that the standard deviation in similar situations is 800 units.
How many Iggy Wiggy T-shirts should the company order?

Respuesta :

Answer:

Iggy Wiggy T-shirts should order 6,829 units of T-shirt

Explanation:

Cost per T-shirt = $8.00

Selling Price per T-shirt = $25

Marginal Profit = 25 - 8 = $17

Marginal Loss when t-shirt is sold for $5 = $8 - $5 = $3

Mean = 6000 units

Standard deviation = 800 units

Using the News Vendor Model

Q = MP / MP + ML

Q = 17 / (17+3)

Q = 17 / 20

Q = 0.85

Using NORMINV in Ms excel

= NORMINV (probability, mean, standard deviation)

= NORMINV(0.85,6000,800)

= 6829.14 units

Thus, Iggy Wiggy T-shirts should order 6829 units of T-shirt.