PLEASE SHOW WORK!!!! OR DO NOT BOTHER ANSWERING THE QUESTION AT ALL! PLEASE DO NOT USE EXCEL

Determine the forecast for Year 4 for both products.

• Monthly forecasts are needed for meeting demand.
• Annual forecast is more for inventory planning.
• The annual demand for inventory planning purposes for the products is an annual forecast for each product.
• Your first task would be to determine the annual demand values for the two products.
• You can assume you are at the end of Year 3 and you need to analyze the demand forecast/inventory policy decisions for upcoming year 4.

Product A JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC YEAR 1 850 884 2089 1650 1194 197 807 853 467 1384 552 697 YEAR 2 900 1000 2200 1500 1200 200 900 900 500 1400 500 700 YEAR 3 900 1200 1800 1500 1100 300 1000 800 400 1300 550 670 Product B JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC YEAR 1 3000 2800 2920 2100 2850 2800 2950 2800 2900 2900 2950 3200 YEAR 2 4000 2900 3000 3000 3000 3000 2700 2500 3200 3000 3000 2000 2000 YEAR 3 2500 3000 2700 3200 3000 2500 2600 2400 3300 3300 3500

Show transcribed image textProduct A JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC YEAR 1 850 884 2089 1650 1194 197 807 853 467 1384 552 697 YEAR 2 900 1000 2200 1500 1200 200 900 900 500 1400 500 700 YEAR 3 900 1200 1800 1500 1100 300 1000 800 400 1300 550 670 Product B JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC YEAR 1 3000 2800 2920 2100 2850 2800 2950 2800 2900 2900 2950 3200 YEAR 2 4000 2900 3000 3000 3000 3000 2700 2500 3200 3000 3000 2000 2000 YEAR 3 2500 3000 2700 3200 3000 2500 2600 2400 3300 3300 3500