A super market sells mobiles. It divides the selling season into Regular and Sale. Regular selling period starts form the first day of a month to the penultimate day of the month. The store forecasts that the demand for mobile during the regular period is normally distributed with a mean of 400 and a standard deviation of 60. During this period, mobiles are sold at a fixed price $350 per mobile. The last day of the month is called Sale period. If there are leftovers at the end of the regular period, all the leftovers are disposed during the Sale period at a discounted bargain price which varies (continuous) uniformly between 175 and 275 both inclusive. The store has enough demand to absorb all the leftovers during the Sale period. In contrast, if there is a shortage of demand, the supermarket offers a coupon worth $30 to every unit of unmet demand. The store has an existing stocking policy of 380 mobiles a month. A wholesaler who supplies the phones to the super market charges $90 per mobile.

a. Simulate the operation for 16 months (Sheet1 of excel, Pressing F9 should simulate values)

b. Determine the mean expected monthly revenue during regular selling season

c. Determine the mean expected monthly revenue during Sale season

d. Determine the mean expected monthly profit

e. Determine the service level based on the average values of simulated months

f. Use the following random numbers and answer the questions b through f

(F9 is locked, use sheet2 of excel, RD rows are the random numbers for the regular demand and SP random numbers are for the Sale price)

RD	0.14	0.79	0.36	0.54	0.47	0.23	0.27	0.98	0.56	0.11	0.36	0.99	0.54	0.44	0.22	0.94
SP	0.89	0.77	0.98	0.92	0.95	0.75	0.44	0.59	0.92	0.49	0.73	0.38	0.97	0.31	0.69	0.60

g. As a simulation analyst, what is your observation of the system and what are your recommendations to improve the profit