Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Sales Growth (2003 to 2004) = k units (Sales forecast 2004 - Sales 2003 --> from 'yearly data' tab) Float % = State your assumptions
Sales Growth (2003 to 2004) = | k units | (Sales forecast 2004 - Sales 2003 --> from 'yearly data' tab) | |
Float % = | State your assumptions based on data from case on how you determined Float % | ||
Float Growth (2003 to 2004) = | k units | ||
Replacement % = | State your assumptions based on data from case on how you determined Replacement % | ||
Replacement for 2004 = | k units | ||
Total Float for 2004 = | k units | ||
Total Bottles to Order = | k units |
Year | Sales |
1995 | 1845 |
1996 | 2088 |
1997 | 2345 |
1998 | 2876 |
1999 | 2465 |
2000 | 3266 |
2001 | 3325 |
2002 | 3972 |
2003 | 4078 |
2004 | 4554 |
Year | Sales | A | T | Forecast | Error | Sm MAD |
1995 | 1845 | 1845 | 279.125 | |||
1996 | 2088 | 1722.51 | 158.64125 | 2124.13 | 36.13 | 422.11 |
1997 | 2345 | 1798.21 | 133.75809 | 1881.15 | 463.85 | 423.52 |
1998 | 2876 | 2027.92 | 162.54257 | 1931.97 | 944.03 | 481.70 |
1999 | 2465 | 2045.26 | 118.9834 | 2190.46 | 274.54 | 466.45 |
2000 | 3266 | 2328.19 | 168.16832 | 2164.24 | 1101.76 | 543.92 |
2001 | 3325 | 2509.52 | 172.11495 | 2496.36 | 828.64 | 583.04 |
2002 | 3972 | 2827.78 | 215.95966 | 2681.63 | 1290.37 | 666.26 |
2003 | 4078 | 3051.68 | 218.33981 | 3043.74 | 1034.26 | 713.07 |
2004 | ||||||
MAD | Sm MAD | |||||
746.70 | 713.07 |
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