Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Contemporary Logistics

Authors: Paul R. Murphy, Michael Knemeyer

11th edition

132953463, 2900132953466, 978-0132953467

More Books

Students also viewed these General Management questions

Question

Why are costs so difficult to assess in marketing internationally?

Answered: 1 week ago