Please solve the below details. Be sure to show steps in the work

7-13. The weekly demand for milk for the last 50 weeks at the AllWaysOpen convenient market is shown in the following table. (a) Assign the proper probability distribution to demands so that the probability of a particular demand in the simulation is equal to the relative frequency of that demand over the last 50 weeks. (b) The store orders 42 cases every week. What are the true expected shortage and the expected excess inventory values? (c) What are the simulated average shortage and average excess inventory for 1,000 simulated weeks? (Note: Simulate 100 weeks if using Excel alone.) Sales {cases} W 40 4 41 10 42 12 43 9 44 8 45 1 Total 50