Please help solve the problem using excel, and please show the step by step solution.

Thank you very much

1. John started a small fruit juice shop in Wichita. His strawberry smoothie is the best-selling drink in the shop. To make one cup of the smoothie, a one tiny special box of strawberry is required. The demand of the smoothie is random, but using historical data, he has a probability distribution of the daily demand. He got the strawberry from his uncle who is a farmer. His uncle gave him strawberry without any margin. John paid #1,000 for a box. (It means it cost #1,000 to produce a box of strawberry) However, his uncle cannot provide strawberries anymore because he got hospitalized due to illness. John found another farmer, but this farmer charges him 1,500 for a box. The smoothie costs additional 500 to make, for other ingredients and other costs.John's strawberry smoothie sells at $5,500 for a cup. Strawberry cannot be used next day. All the leftover needs to be disposed. 1. When John bought Strawberry from his uncle, how many boxes did he buy everyday? Remember Johnmajored Management Science, he knows how to optimize. 2. With the new farmer, how many boxesJohnwould buy for a day? 3. Now the new farmer suggests a revenue sharing contract. According to the contract, the farmer will sell strawberry at #500, butJohn needs to share/give 30% of his revenue to the farmer. Note that 400+30% of 45,500=$2,150. Now how many boxes wouldJohn buy for a day