-graph the data. is there seasonality?

-complete a forecast analysis including monthly forecasts expected for the new location.

-determine the total 2020 sales revenue based on forecast

(Please include the formulas you used for each column)

2018 - 2019 SALES FOR CURRENT LOCATION Average Pizza Price: $25.00 CASE NOTES: MONTH January February March April May June July August Sept Oct Nov Dec TOTAL YR 2018 SALES DOLLARS (000) 5 22 28 71 90 81 25 30 71 31 22 83 559 2019 SALES DOLLARS (000) 8 26 30 79 92 86 28 34 84 34 28 87 616 The spreadsheet contains the sales data for two years from Isabella's current location. For the analysis complete the following: Graph the data to determine which forecasting method would be best. Mint: Do you see seasonality? Complete a forecast analysis including determining the monthly forecasts expected for the new location. Remember: She expects the sales to be 20% higher due to the larger store & prominent location -Determine the total 2020 sales revenue based on the forecast