Please USE EXCEL and write our formula and functions.

..F.10 DAY PAPERS RANDOM DEMAND REVENUE COST GOODWILL COST NET PROFIT ORDERED NUMBER Leonard Presby's newsstand uses naive forecasting to order tomorrow's papers. The number of newspapers ordered corresponds to the previous day's demands. Today's demand for papers was 22. Presby buys the newspapers for $.20 and sells them for $.50. Whenever there is unsatisfied demand, Presby estimates the lost goodwill cost at $.10. Complete the accompanying table, and answer the questions that follow. 1 22 37 2 19 3 52 4 8 DEMAND PROBABILITY 5 22 21 .25 6 61 22 .15 23 .10 24 .20 a. What is the demand on day 3? b. What is the total net profit at the end of the 6 days? c. What is the lost goodwill on day 6? d. What is the net profit on day 2? e. How many papers has Presby ordered for day 5? P 25 .30