Please provide with excel formula, Thank you.

2. A baker is trying to figure out how many dozens of bagels to bake each day. The probability distribution of the number of baget customers is as follows: Number of Customers/Day Probability 10 12 0.35 0.30 0.25 14 0.10 Customers order 1, 2, 3, or 4 dozen bagels according to the following probability distribution. Number of Dozen Ordered/Customer1 2. 3 4 Probability 0.4 0.3 0.2 0.1 Bagels sell for $8.40 per dozen. They cost $5.80 per dozen to make. All bagels not sold at the end of the day are sold at half-price to a local grocery store. Based on 5 days of simulation, how many dozen (to the nearest 5 dozen) bagels should be baked each day? Explain your justification for the answer in the conclusion part