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 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
