Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Year Actual Employees 1988 540595 23078 1989 698843 37743 1990 759775 35583 1991 884612 37070 1992 793838 37296 1993 836066 37913 1994 884295 38386 1995
Year Actual Employees 1988 540595 23078 1989 698843 37743 1990 759775 35583 1991 884612 37070 1992 793838 37296 1993 836066 37913 1994 884295 38386 1995 914407 38663 1996 968789 40511 1997 933579 40739 1998 1045283 40199 1999 1123216 41980 2000 1300682 50248 2001 1404762 53773 2002 1465761 59965 2003 1417377 53609 2004 1457627 53938 2005 1493703 53317 2006 1474452 54605 2007 1627071 56224 2008 1689947 58000 2009 1448248 56377 2010 52,498
Year | Actual | Employees |
1988 | 540595 | 23078 |
1989 | 698843 | 37743 |
1990 | 759775 | 35583 |
1991 | 884612 | 37070 |
1992 | 793838 | 37296 |
1993 | 836066 | 37913 |
1994 | 884295 | 38386 |
1995 | 914407 | 38663 |
1996 | 968789 | 40511 |
1997 | 933579 | 40739 |
1998 | 1045283 | 40199 |
1999 | 1123216 | 41980 |
2000 | 1300682 | 50248 |
2001 | 1404762 | 53773 |
2002 | 1465761 | 59965 |
2003 | 1417377 | 53609 |
2004 | 1457627 | 53938 |
2005 | 1493703 | 53317 |
2006 | 1474452 | 54605 |
2007 | 1627071 | 56224 |
2008 | 1689947 | 58000 |
2009 | 1448248 | 56377 |
2010 | 52,498 |
Shown above is the data for actual amounts (in dollars) contributed by employees at a company from the years 1988-2009. How would you forecast what the amount will be in 2010? What is the final forecast for 2010? Please show your work (in Excel, preferably). Thanks!
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started