Each week, a grocery store purchases eggs from a local ranch for $1.99 for each 12-egg carton and sells it for $3.89. Any cartons not sold within a week will be on “manager’s special” sales or sold to a low-cost outlet for $1.25. If the eggs sell out before the end of the week, an estimated opportunity cost of not meeting demand is $1.75 per carton. The demand distribution is normally distributed with a mean of 75 cartons and a standard deviation of 12.5 cartons. Use Analysis ToolPak or R, both with a seed of 1, to develop a Monte Carlo simulation for 500 weeks to answer parts a and b.

a. If the store has been ordering exactly 75 cartons per week from the rancher, what are the likelihood and opportunity cost of not meeting the weekly demand? 

b. If the store increases the weekly order to 85 cartons, what is the estimated cost of having too many eggs in store?