An important part of planning manufacturing capacity is having a good forecast of sales. Elizabeth Burke is interested in forecasting future increases in production costs.Develop forecasting models for these data and prepare a report of your results with appropriate charts and output from Excel.

Unit Production Costs

Month Tractor Mower

Jan-14 $1,750 $50

Feb-14 $1,755 $50

Mar-14 $1,763 $51

Apr-14 $1,770 $51

May-14 $1,778 $51

Jun-14 $1,785 $51

Jul-14 $1,792 $51

Aug-14 $1,795 $51

Sep-14 $1,801 $52

Oct-14 $1,804 $52

Nov-14 $1,810 $52

Dec-14 $1,813 $52

Jan-15 $1,835 $55

Feb-15 $1,841 $55

Mar-15 $1,848 $55

Apr-15 $1,854 $55

May-15 $1,860 $56

Jun-15 $1,866 $56

Jul-15 $1,872 $56

Aug-15 $1,878 $56

Sep-15 $1,885 $56

Oct-15 $1,892 $57

Nov-15 $1,897 $57

Dec-15 $1,903 $57

Jan-16 $1,925 $59

Feb-16 $1,931 $59

Mar-16 $1,938 $59

Apr-16 $1,944 $59

May-16 $1,950 $59

Jun-16 $1,956 $60

Jul-16 $1,963 $60

Aug-16 $1,969 $60

Sep-16 $1,976 $60

Oct-16 $1,983 $60

Nov-16 $1,990 $61

Dec-16 $1,996 $61

Jan-17 $2,011 $59

Feb-17 $2,001 $59

Mar-17 $2,024 $59

Apr-17 $2,030 $59

May-17 $2,039 $60

Jun-17 $2,026 $60

Jul-17 $2,034 $60

Aug-17 $2,033 $60

Sep-17 $2,056 $60

Oct-17 $2,065 $60

Nov-17 $2,068 $61

Dec-17 $2,069 $61

Jan-18 $2,073 $63

Feb-18 $2,077 $63

Mar-18 $2,081 $63

Apr-18 $2,086 $63

May-18 $2,092 $63

Jun-18 $2,098 $63

Jul-18 $2,104 $64

Aug-18 $2,110 $64

Sep-18 $2,116 $64

Oct-18 $2,122 $64

Nov-18 $2,129 $64

Dec-18 $2,135 $64