Problem 1 (15 points) PLEASE HELP WITH THIS I AM HAVING A HARD TIME. IF YOU COULD EXPLAIN SIMPLY HOW TO CALCULATE ANSWER THAT WOULD BE AWSOME. ALSO REFER TO PICTURE POSTED.\ Simulate the following scenario, using excel.\ A baker is trying to determine how many dozens of bagels to bake each day. The probability distribution of the number of customers coming to buy bagels each day is the\ following\ Number of customers per day buying\ bagels\ Customers order 1,2,3,or 4 dozen bagels according to the following probability\ Number of dozen bagels ordered per\ customer\ Probability\ Bagels sell for

$4.75

dozen. They cost

$1.61

per dozen to make. Any remaining bagels at the end of the day are sold for

$1.80

dozen. Based on 30 days simulation, how\ many bagels(dozens) should be baked each day?

Problem 1 (15 points) Simulate the following scenario, using excel. A baker is trying to determine how many dozens of bagels to bake each day. The probability distribution of the number of customers coming to buy bagels each day is the following Customers order 1,2,3,or 4 dozen bagels according to the following probability Bagels sell for $4.75/ dozen. They cost $1.61 per dozen to make. Any remaining bagels at the end of the day are sold for $1.80/ dozen. Based on 30 days simulation, how many bagels(dozens) should be baked each day