Urgent!! Need Help Solving In Excels Thanks so much

Problem 4: (40 points) Lake grove Confectionaries (LGC) produces and sells chocolates for holiday season in four decentralized facilities. The demand forecast for chocolate boxes at each facility is completed before the start of the season. The demand forecast for chocolate boxes at each facility is independent (i.e., p=0) and normally distributed with a mean of 20,000 and a standard deviation of 8,000. Each box costs $10 and is sold for $20. Any unsold boxes at the end of the season are discounted at $7, and they sell out at this price. a) How many boxes of Chocolate should LGC produce at each facility? (15 points) b) LGC is considering centralizing all its operations at a single facility. This will add $2 to the cost of product because of increased transportation cost. How many boxes of Chocolate should LGC produce at a centralized facility? (25 points)