Any submission after 330 pm. Will be regarded as late and will be penalized. Your group assignment can be submitted as an excel spread sheet or in MSWord. It must be clear, easy to follow and be very logical when applying the data provided. Your company manufactures a CPG item. Sold all across Canada. Sales and marketing has established 3 regions for your company. West with 20% of sales, Central with 70% of sales and the remainder to the East region. Your final forecast will be a) for total company and b) for each region. TASK: Create a MONTHLY demand forecast. sing historical data combined with business intelligences. 2019 Data-sales Feb - 8000 Mar - 8500 Jan - 5000 5670 Apr May - 8900 9000 Jun - 7000 Jly - 8700 Aug- Oct-9000 Nov-8900 Dec- Sep - 5600 11000 2019 Data-returns Jan - 0 Feb - 800 Mar-0 Apr - 0 May - Jun-200 Jly - 700 Aug - 90 Sep-0 Oct - 90 Nov- Dec- 2020 Business strategy is to grow the business by 5.5% across the board, That is regardless of what the SKU is. Your customer base consist of three customer that represents 100% of your business. Acme Retail has submitted their yearly promotional plans. Jan - 0 Feb - 2300 Mar-0 Apr-0 May-0 Jun-0 Jly - 7000 Aug - 25000 Sep-0 Oct-0 Nov- Dec - 4000 Acme will also be opening 2 new stores in August of 2020, and will require 1500 for each stores, this is incremental to the forecast Vladiss Retail has submitted their yearly promotional plans. Jan - 0 Feb-0 Mar-0 Apr - 0 May-0 Jun Aug Acme Retail has submitted their yearly promotional plans. Jan - 0 Feb - 2300 Mar-0 Apr - 0 May-0 Jun-0 Jly - 7000 Aug - 25000 Sep-0 Oct-0 Nov Dec-4000 Acme will also be opening 2 new stores in August of 2020, and will require 1500 for each stores, this is incremental to the forecast. Vladiss Retail has submitted their yearly promotional plans. Jan - 0 Feb-0 Mar-0 Apr - 0 Jun- May-0 15000 Jly- Aug- Sep-0 Oct-0 Nov- Dec- This is in recognition as Vladiss 25 year in business, and is having an Anniversary Sale M & Q has submitted their yearly promotional plans. Jan - 0 Feb - 6000 Mar-0 Apr-9000 Jun-0 May - 3000 2000 Jly - 0 Aug- Sep-0 Oct - 2000 Novo Dec-8000 M & Q has acquired an old retail outlets and is doing promotional sales for the first time. Other information. Vladiss will be closing one store in the East Region, this store sells 580 units per month. Closing takes effect in Sept. 2020. M&Q plans to open 3 new stores in June 2021. These stores will be requiring 950 units for the opening, and 500 units per month after the opening Acme Retail plans one store expansion, which is expected to be completed in July 2020, and will require an additional 1800 selling units. Assuming that today is Dec. 27th 2019. Produce a forecast for the next 12 months. You must also justify the data that you are using. Use the grid pages supplied to capture the data as you will be utilizing to produce this forecast. Discuss with your group as you proceed. Any submission after 330 pm. Will be regarded as late and will be penalized. Your group assignment can be submitted as an excel spread sheet or in MSWord. It must be clear, easy to follow and be very logical when applying the data provided. Your company manufactures a CPG item. Sold all across Canada. Sales and marketing has established 3 regions for your company. West with 20% of sales, Central with 70% of sales and the remainder to the East region. Your final forecast will be a) for total company and b) for each region. TASK: Create a MONTHLY demand forecast. sing historical data combined with business intelligences. 2019 Data-sales Feb - 8000 Mar - 8500 Jan - 5000 5670 Apr May - 8900 9000 Jun - 7000 Jly - 8700 Aug- Oct-9000 Nov-8900 Dec- Sep - 5600 11000 2019 Data-returns Jan - 0 Feb - 800 Mar-0 Apr - 0 May - Jun-200 Jly - 700 Aug - 90 Sep-0 Oct - 90 Nov- Dec- 2020 Business strategy is to grow the business by 5.5% across the board, That is regardless of what the SKU is. Your customer base consist of three customer that represents 100% of your business. Acme Retail has submitted their yearly promotional plans. Jan - 0 Feb - 2300 Mar-0 Apr-0 May-0 Jun-0 Jly - 7000 Aug - 25000 Sep-0 Oct-0 Nov- Dec - 4000 Acme will also be opening 2 new stores in August of 2020, and will require 1500 for each stores, this is incremental to the forecast Vladiss Retail has submitted their yearly promotional plans. Jan - 0 Feb-0 Mar-0 Apr - 0 May-0 Jun Aug Acme Retail has submitted their yearly promotional plans. Jan - 0 Feb - 2300 Mar-0 Apr - 0 May-0 Jun-0 Jly - 7000 Aug - 25000 Sep-0 Oct-0 Nov Dec-4000 Acme will also be opening 2 new stores in August of 2020, and will require 1500 for each stores, this is incremental to the forecast. Vladiss Retail has submitted their yearly promotional plans. Jan - 0 Feb-0 Mar-0 Apr - 0 Jun- May-0 15000 Jly- Aug- Sep-0 Oct-0 Nov- Dec- This is in recognition as Vladiss 25 year in business, and is having an Anniversary Sale M & Q has submitted their yearly promotional plans. Jan - 0 Feb - 6000 Mar-0 Apr-9000 Jun-0 May - 3000 2000 Jly - 0 Aug- Sep-0 Oct - 2000 Novo Dec-8000 M & Q has acquired an old retail outlets and is doing promotional sales for the first time. Other information. Vladiss will be closing one store in the East Region, this store sells 580 units per month. Closing takes effect in Sept. 2020. M&Q plans to open 3 new stores in June 2021. These stores will be requiring 950 units for the opening, and 500 units per month after the opening Acme Retail plans one store expansion, which is expected to be completed in July 2020, and will require an additional 1800 selling units. Assuming that today is Dec. 27th 2019. Produce a forecast for the next 12 months. You must also justify the data that you are using. Use the grid pages supplied to capture the data as you will be utilizing to produce this forecast. Discuss with your group as you proceed