Question: ** solve it using excel with steps ** Find the the monthly forecast sales for year 2022 given the sales data for the past four


** solve it using excel with steps **
Find the the monthly forecast sales for year 2022 given the sales data for the past four years Note that the total sales for 2022 is expected to be 10% more than the total sales for 2021 DEMAND 2018 2019 2020 2021 80,000 88,000 90,000 100,000 85,000 93,500 95,000 99,000 86,000 94,600 96,000 100,000 90,000 99,000 102,000 105,000 92,000 101,200 105,000 110,000 100,000 110,000 120,000 130,000 120,000 132,000 140,000 145,000 90,000 99,000 85,000 85,000 86,000 94,600 100,000 105,000 85,000 93,500 95,000 95,000 84,000 92,400 95,000 97,000 75,000 78,000 80,000 82,000
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
