Question: Make a Splash T-Shirts is planning to print and sell specially designed tee shirts for the upcoming World Series. The shirts will cost $12 each
Make a Splash T-Shirts is planning to print and sell specially designed tee shirts for the upcoming World Series. The shirts will cost $12 each to produce and can be sold for 30 each until the World Series. After the World Series, the price will be reduced to $20 per shirt. The demand at the $30 price is expected to be normally distributed, with a mean
of 12,000 shirts and a standard deviation of 2,500 shirts. The demand for the $20 price is expected to be normally distributed, with a mean of 5,000 shirts and a standard deviation of 1,000 shirts. Any shirts left over will be discarded. Because of the high setup costs, Make a Splash T-Shirts is planning on producing one run of 17,000 shirts. In your model use integers for all demands.
(a) Simulate N setups to calculate the average profit for this quantity of shirts.
(b) Make a Splash T-Shirts would like to evaluate producing 16,000,17,000,18,000,19,000, and 20,000 shirts. Which would you recommend? Why?
Step by Step Solution
3.48 Rating (165 Votes )
There are 3 Steps involved in it
tr msoheightsourceauto col msowidthsourceauto br msodataplacementsamecell style0 msonumberformatGeneral textaligngeneral verticalalignbottom whitespacenowrap msorotate0 msobackgroundsourceauto msopatt... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
718-M-S-L-P (1285).xlsx
300 KBs Excel File
