Part C: [Use excel]

Show your work completely and in an orderly fashion in excel. Remember to provide all column titles and calculations, including excel formulas in the excel sheet relevant for all problems even though they may not be necessary for final results, so I can understand and follow your work, and use all decimal places (do not round-off) for all your calculations in excel unless instructed otherwise.

Q3. A neighborhood grocery store orders a weekly number of Alaskan Pink Salmon. Demand varies each week, but historical records show the following distribution:

Number of Salmons	Probability
21	1/10
22	2/10
23	3/10
24	2/10
25	2/10

Each Salmon costs $2.32 and sells for $4.75. Any Salmons remaining at the end of the week are sold to a local Humane Society shelter for Cats and Dogs for 0.55 each. Develop a simulation model in excel and determine the best order quantity (number of Salmons) for inventory, so the average profit is maximum. Also, provide average profits for each inventory level. Simulate for 15 weeks using excel and draw your conclusions. Use only the random numbers provided in the attached excel file (do not change data format) to generate demand. Highlight your answers in the excel sheet

DON alternatives available: Inventory 8 Evaluation Demand Prob Cum Prob Random Stock Stock Stock Sales Sales Profit Profit Scrapped Units Scrapped Units Scrapped Units R# Demand Trials Profit Sales == 1 4 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 Neeks/Trial 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 9 0 7 9 4 NG 5 6 Average Average Average Average CINTA