Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need this within 30 to 45 minutes using excel formulas Year Sales 1995 1845 1996 2088 1997 2345 1998 2876 1999 2465 2000 3266

I need this within 30 to 45 minutes using excel formulas

Year Sales
1995 1845
1996 2088
1997 2345
1998 2876
1999 2465
2000 3266
2001 3325
2002 3972
2003 4078
2004 4554

image text in transcribed

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 % (This is how fast bottle cycles through the whole system) Float Growth (2003 to 2004) = k units Replacement % = State your assumptions based on data from case on how you determined Replacement % (This is how often bottles are replaced) Replacement for 2004 = k units Total Float for 2004 = k units This represents amount needed to support new Sales Growth and Replacements Total Bottles to Order = k units Hint: don't forget to take existing inventory into account 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 % (This is how fast bottle cycles through the whole system) Float Growth (2003 to 2004) = k units Replacement % = State your assumptions based on data from case on how you determined Replacement % (This is how often bottles are replaced) Replacement for 2004 = k units Total Float for 2004 = k units This represents amount needed to support new Sales Growth and Replacements Total Bottles to Order = k units Hint: don't forget to take existing inventory into account

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

Cost Of Capital Applications And Examples

Authors: Shannon P. Pratt, Roger J. Grabowski, Richard A. Brealey

5th Edition

1118555805, 9781118555804

More Books

Students also viewed these Finance questions

Question

please dont use chat gpt AI 9 9 0 .

Answered: 1 week ago