Please help me solve this assignment in EXCEL FORMAT. If you could provide STEP$-$BY$-$STEP INSTRUCTIONS of how to input each piece of the problem into an excel file $(5$ worksheets for each answer for example$)$ that I could follow along to$,$ I$\text{'}$d very much appreciate that. If you can create a solved excel file that I could download that would also work as well, but most importantly, I need to see exactly how to do it on excel so I could do it myself. Very important! Thank you!!!!

Problem $1$:

A supplier needs to supply $10$ retailers $($indexed as $i=1,$dots,$10).$ In each day, each retailer i has

probability $p_i=0\mathrm{.}7$ to place an order $($to the supplier$),$ with order quantity $D_i$ following a discrete

uniform distribution $U\{1,$cdots,$10\}.$ Retailers' ordering decisions are independent of each other. The

supplier's unit production cost is $$1K$ per unit. In each day, the supplier first produces $x=50$ units of

the product at unit cost $$1K$; then it receives all the orders from the retailers and satisfies them as much

as possible. The wholesale price is $$10K$ per unit, and each unit of leftover costs the supplier $$1K$ to

dispose. Let $V(x)$ be the supplier's expected daily profit under production quantity $x.$ Assume sample

sizeN$=365.$

$1.$ What is the distribution $($histogram$)$ of the daily total order quantities received by the supplier?

Plot it$.$

$2.$ What is the $90\%$ confidence interval of the expected daily profit for the supplier?

$3.$ What is the probability that the supplier experiences shortage? What is the probability that the

supplier has leftover?

$4.$ What is the quantity $x^{*}$ that maximizes the supplier's expected profit? Graph $V(x)$ against $x$ to

support your conclusion.

$5.$ When the retailers consolidate their orders, they can get the discounted wholesale price $$7K.$

They coordinate their ordering process as follows: in each day, each supplier i first observes their

individual demand $D_{i}U\{1,$dots,$10\}.$ Then if the consolidated demand ${\displaystyle \underset{i=1}{\overset{10}{}}}{D}_{i}35,$ all orders

will be placed; otherwise, no order will be placed. The supplier's operation and other parameters

remain the same. In this case, what is the profit$-$maximizing production $x^{*}$ for the supplier?

Please help me solve this assignment in EXCEL FORMAT. If you could provide STEP$-$BY$-$STEP INSTRUCTIONS of how to input each piece of the problem into an excel file $(5$ worksheets for each answer for example$)$ that I could follow along to$,$ I$\text{'}$d very much appreciate that. If you can create a solved excel file that I could download that would also work as well, but most importantly, I need to see exactly how to do it on excel so I could do it myself. Very important! Thank you!!!!