2- Social Work

Show you work in Word document for this homework assignment must contain
all of your work including all working and final tables and charts and also Word (and Excel files)
# 4. Solve Problem 21 at the end of Chapter 12 by using simulation.
#10 A hypermarket sells a specific brand of mobile phones and earns a profit of AED100 per mobile.It incurs a holding cost of AED40 per mobile per month if a stocked mobile is not sold. Holding cost is a portion of rent, insurance, and other expenses. If there is a shortage, the hypermarket assigns a goodwill cost of AED75 per mobile. The store has a stocking policy of 210 mobiles a month. The demand for mobile is normally distributed with a mean of 200 and standard deviation of 30. Simulate the operation for 12 months and determine the mean expected net profit, standard deviation of the net profit, and the service level.