Rate this paper
  • Currently rating
  • 1
  • 2
  • 3
  • 4
  • 5
3.50 / 2
Paper Topic:

MERRIWELL BAG CO. CASE STUDY

p After calculating Index No . for each month Average Index No . is calculated by formula

Average Index No Sum of Index Nos . of five years / 5

In following table index numbers for each month and average index numbers are calculated

2003 2004 2005 2006 2007 Av . Index No Jan 0 .3077 0 .4045 0 .2449 0 .5218 0 .5310 0 .4020

Feb 0 .4615 0 .5393 0 .6122 0 .4174 0 .2124 0 .4486

Mar 0 .4615 0 .4045 0 .6122 0 .4174 0 .3186 0 .4428

Apr 0 .4615 0

.6741 0 .3673 0 .2087 0 .2124 0 .3848

May 0 .6154 0 .6741 0 .4898 0 .5218 0 .7433 0 .6089

Jun 0 .9231 1 .0786 0 .7347 0 .7305 0 .6371 0 .8208

Jul 1 .0769 0 .4045 0 .8571 1 .0435 0 .8495 0 .8463

Aug 0 .9231 1 .0786 1 .2244 1 .4609 1 .0619 1 .1498

Sep 1 .5385 1 .6179 1 .8367 1 .6696 2 .1238 1 .7573

Oct 1 .8462 1 .6179 1 .8367 1 .6696 2 .1238 1 .8188

Nov 2 .1538 2 .1572 2 .2040 2 .0870 2 .3362 2 .1877

Dec 1 .2308 1 .3483 0 .9796 1 .2522 0 .8495 1 .1321

By calculating average index number of each month we can get the picture of annual seasonal variation of sales which is shown in following chart

Now as we examine the five year record of annual sales of the Merriwell Bag Company we come to know that in first four years the sales continuously raised but last year it dropped by 2 ,000 . The possible reason for sales ' drop may be the saturation of market of the competitor 's penetration . In following graph this trend of growth and decline is obvious

Now if Ed Merriwell could keep the...

Not the Essay You're looking for? Get a custom essay (only for $12.99)