12

The forecast function uses a process to take existing data and make predictions based on existing patterns within the data. On the Forecast worksheet, click cell C16, and then type=B16. In cell C17 forecast the sales revenue for the years 2020-2021 based on the historical data from 2019. Copy cell C17 to C18:C40.

B C D E G H K M N O Turquoise Oasis Spa Forecast Based on Historical Time Series Date Sales Forecast Jan 2019 $15,662.00 Feb 2019 $14,012.00 Mar 2019 $20,048.00 Apr 2019 $11,852.00 May 2019 $19,566.00 Jun 2019 $14,928.00 Jul 2019 $17,768.00 Aug 2019 $18,155.00 Sep 2019 $13,557.00 Oct 2019 $16,696.00 Nov 2019 $15,885.00 Dec 2019 $12,187.00 Jan 2020 Feb 2020 Mar 2020 Apr 2020 May 2020 Jun 2020 Jul 2020 Aug 2020 Sep 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 Jun 2021 Jul 2021 Aug 2021 Sep 2021 Oct 2021 Nov 2021 Dec 2021 OnlineOrder SpaTreatments RaffleAnalysis Sales Trend CorrelationMatrix Regression Forecast