Please use Excel Formulas

8. In planning for next year the buyer noted that because of a strike he ran out of a popular style of basic trousers on August 10 and did not receive more in stock until the beginning of September. He estimated that he could have sold an additional 15 of them in August at an average retail of $60.00. Revise the percentage sales curve below to reflect these lost sales. (10 Points) Month $ Sales August $ 600 September $1,200 October $1,320 November $1,440 December $1,380 January $1,140 I Units 10 -20 22 24 23 19 % Sales Curve 8.5% 17.0% 18.6% 20.3% 19.5% 16.1%