Question: Instructions: 1. To submit this assignment, attach one Word or PDF file with your descriptrve model, random variable descriptions, and answers to the questions, alone
Instructions: 1. To submit this assignment, attach one Word or PDF file with your descriptrve model, random variable descriptions, and answers to the questions, alone with the Excel spreadsheet. 2. Please use 10,000 replications in your simulation. Michelle Abrams rans a specialty clothing store that sells collegiate sports apparel. One of her pnmary business opporturuties involves selling custom screen printed sweatshirts for college football bowl games. She is trying to determmmne 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 negatrve 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. a. 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 subrrussion. b. List all random variables, their distributions, and parameters. c. Code the model in Excel and replicate it 10,000 times. Answer the following questions (attach the spreadsheet): i Determine the average profit that Michelle would earn if she orders 10,000 sweatshirts. ii Find the probability that Michelle's profit would be less than or equal to $100,000 if she orders 10,000 sweatshirts. ii. How many sweatshirts would you recommend Michelle order to maximize average profit
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Students Have Also Explored These Related Mathematics Questions!