Need assistance creating a study aide. A problem I want to add to the study aid requires a forecast calculation or there is a function in excel. It is critical to include the steps or formulas used so I can add it to the document with those details.

It looks like there are two forecasts required (please include steps/Calculations):

1. A forecast of how the defects would have trended if the program was never implemented
2. A forecast of how defects will trend in the future based on the trend of defects after the program was implemented

Problem to solve for Study Aide:Elizabeth noted that the program appeared to reverse an increasing trend in defects; she would like to(#1) predict what might have happened had the supplier initiative not been implementedAND(#2)how the number of defects might further be reduced in the near future.

Case: Performance Lawn Equipment In reviewing the PLE data, Elizabeth Burke noticed that defects received from suppliers have decreased (worksheet Defects After Delivery). Upon investigation, she learned that in 2010, PLE experienced some quality problems due to an increasing number of defects in materials received from suppliers. The company instituted an initiative in August 2011 to work with suppliers to reduce these defects, to more closely coordinate deliveries, and to improve materials quality through reengineering supplier production policies. Elizabeth noted that the program appeared to reverse an increasing trend in defects; she would like to predict what might have happened had the supplier initiative not been implemented and how the number of defects might further be reduced in the near future.

Year Month Defects

2010 Jan 812

2010 Feb 810

2010 Mar 813

2010 Apr 823

2010 May 832

2010 Jun 848

2010 Jul 837

2010 Aug 831

2010 Sep 827

2010 Oct 838

2010 Nov 826

2010 Dec 819

2011 Jan 828

2011 Feb 832

2011 Mar 847

2011 Apr 839

2011 May 832

2011 Jun 840

2011 Jul 849

2011 Aug 857

2011 Sep 839

2011 Oct 842

2011 Nov 828

2011 Dec 816

2012 Jan 824

2012 Feb 836

2012 Mar 818

2012 Apr 825

2012 May 804

2012 Jun 812

2012 Jul 806

2012 Aug 798

2012 Sep 804

2012 Oct 713

2012 Nov 705

2012 Dec 686

2013 Jan 682

2013 Feb 695

2013 Mar 692

2013 Apr 686

2013 May 673

2013 Jun 681

2013 Jul 696

2013 Aug 688

2013 Sep 671

2013 Oct 645

2013 Nov 617

2013 Dec 603

2014 Jan 571

2014 Feb 575

2014 Mar 547

2014 Apr 542

2014 May 532

2014 Jun 496

2014 Jul 472

2014 Aug 460

2014 Sep 441

2014 Oct 445

2014 Nov 438

2014 Dec 436