Reliance Baking Soda - Case Exhibits.xlsx

Ex 1 RBS Income stmt

2005

2006

2007E

Gross Sales Variable Manufacturing Costs

$42,400 $20,258

$54,125 $25,354

$55,051 $25,325

Gross Margin

$22,142 52!

$28,771 53!

$29,72 54!

$2,82 $87 $7 $3,25

$4,453 $950 $238 $5,41

$3,815 $94 $248 $4,757

#()Me&ia #ro&uction Costs

$191

$297

$198

Consu*er #ro*otion

$424

$1,080

$551

"ra&e #ro*otion

$4,240

$5,938

$5,505

"otal Mar+eting -.enses

$8,480

$12,95

$11,011

#rofit before SG/%, 'erea&, an& ta-es

$13,2

$15,815

$18,715

32!

29!

34!

$183

$188

$213

$87

$88

$98

Advertising

"V #rint nternet "otal %&'ertising

Price per case Variable cost per case

Trusted by over 1 million members

Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.



Ex 2 - Qtrly Gross Sales

Gross Sales

2007 "

1

2

4

4

2005

$ 14,840

$ 8,480

$ 9,752

$ 9,328

200

$20,58

$7,578

$18,944

$7,03

$14,84

$12,111



Ex 4 - Factory shipments

Size

8 o6 oCases Si..e& ! ncrease ecrease 1 lb Cases Si..e& ! ncrease  ecrease 5 lb Cases Si..e& ! ncrease  ecrease "otal Cases

2005

2006

2007E

Cases

! of total

Cases

! of total

Cases

! of total

40

28!

793 24!

28!

714 :10!

28!

1,099

47!

1,32 24!

47!

122

47!

581

25!

720 24!

25!

48 :10!

25!

2,320

100!

2,875

100!

2,588

100!



Ex  !"r sellin# price $s costs Size

2005

2006

2007

Manufacturer;s #rice .er case 8 o6

$18

$37

$720

1 lb

$1033

$104

$1202

5 lb

$43

$4803

$5428

$302

$305

$338

Variable Manufacturing Cost .er case 8 o6 1 lb

$498

$503

$558

5 lb

$2212

$2234

$2480



Ex 1% &emplate 2005

200

2007

2008

Manufacturer’s Manufacturer’s Price per Case

8 o6

$ 18

$ 37

$

1 lb

$ 1033

$ 104

$ 1202

720

5 lb

$ 43

$ 4803

$ 5428

Factory Sip!ents "in 000’s of cases#

8 o6

40

793

714

1 lb

1,099

1,392

1,22

5 lb

581

720

48

$aria%&e Manufacturing Cost per Case

8 o6

$ 302

$ 305

$

338

1 lb

$ 498

$ 503

$

503

5 lb

$ 2212

$ 2234

$ 2480

200 Gross Sales

$ 42,400

$ 54,125

$ 55,051

Variable Manufacturing Costs

$ 20,258

$ 25,354

$ 25,325

$ $

: :

Gross Margin

$ 22,142

$ 28,771

$ 29,72

$

:

52!

53!

54!

!

Advertising

"V

$ 2,82

$ 4,453

$

3,815

#rint

$

87

$

950

$

94

nternet

$

7

$

238

"otal %&'ertising

$ 3,25

$ 5,41

$ 4,757

#( ) Me&ia #ro&uction Costs

$

191

$

297

$

198

Consu*er #ro*otion

$

424

$ 1,080

$

551

"ra&e #ro*otion

$ 4,240

$ 5,938

$ 5,550

"otal Mar+eting -.enses

$ 8,480

$12,95

#rofit before SG/%, 'erea& an& ta-es

$13,2

$15,815

$

248 $

:

$11,011

$

:

$18,715

$

:

Reliance Baking Soda - Case Exhibits.xlsx

Recommend Documents