Question

2. Use the data provided to answer the following questions. Data for Last Week: Values LY POS Sales TY POS Sales LY POS Qty TY POS Qty LY Next Week Sales LY Next Week QTY LY Next 13 QTY $60,000 $56,250 11,625 10,901 $58,824 11,400 140,500 a. What is the average price for last year (LY), this year (TY)? b. What are the percent changes year-over-year (YOY) in sales and quantity? C. What would you suggest should be an expected forecast for next week? d. What would the forecast be for the next 13 weeks? Now what if you plan on having a in store promotion (just a display so the price isn't changing) in the next 13 weeks, note you had previously calculated and promotion give an expected 7% lift. e. Are these forecasts reliable? Would you rather trust these responses or those in question 1 and Why?

Answer 1

PAGE X 100 (a) Quantity Present year Auan itu - last year Quantity Last year Quantity Spor yayan Jetesid- = 10,901 - 11,625 1x100 = 1-6 2279 | 11,625 ) -ve I to sign past in shows year. both decrease or to sales & quantity relative. ulti LY+ Decrease ext weer increase in sales sales = You $58,824. – 6.25%. Hence for al present year sales = $58,824 l - 6.25) 100) forecast sale for next week, Ty=1$ 55, 147.5 Qty to Noge LY next week Decrease increase = Qty W, 400 ton – 6.2279 in = Hence for present year Quantity = 11,400 - 6.2279) Bubni on and fore casted fty 2700 com for next week, Ty = limi -10, 690 since it. Take I is the you rate change of change same as part B hence constant throughout year.

DATE PAGE = 140,soo (d) rand Ly Next 13 ile ? - so similar to Effet Sty US! part c we - consider 06.; you change = -6.2279%. forecasted of Sty 21 no Next 13 weeks = 140,5oo o n = 1131.750 7000 - 6.2279 7 - 100 Now with in store promotion, it gives 7% lift - I Hence new 8ty forecasted Woo of Next 13 weeks 131,750 It:7 - Approximate forecasted sty of next 13 weeks = 1140, 973 foner - No , these I sudden similarly ör social = forecasts aren't reliable as change in sales in Question many changes like political change is lanz in deviate results suggested by a d. Now, industrial, from forecast. Informations not enough for part End of ste.

Average Price = Total amount Total Quantity of sales yold hence, Average price of LY = LY LY POS POS Sales sty $ 5.16 $ 60,000 11,625 Average price of TY = TY POS sales - $ 56, 250 - $ 5.16 16 percent Changes year - over - year (you) (1) sales a present year sale x 10 year sale previous - year Previous sale $67000/- $ 86,250 17 $60,000 7 x100/ 7 = $60,000 x100 $56, 250 - $60,000 x 100 = -6.25% -3,750 60,000