Docstoc

Marketing Budget Template - Excel

Document Sample
Marketing Budget Template - Excel Powered By Docstoc
					8/11/2008

eed6bf56-ede5-4cca-b57d-259f05090eeb.xls

Confidential

Marketing Budget
[ ] The Marketing Budget worksheet consists of separate budgets for: Advertising, Catalogs, Direct Mail, Literature, Product Launches, Public Relations, Resellers and Trade Shows. Each of these budgets can be used separately or in conjunction with the Advertising & Promotions Summary which tracks total annual marketing expenditures. [ ] If you choose to use one of the separate budgets, it is recommended that you first enter your monthly sales forecast totals on Row 293. Each budget calculates the monthly and annual expenses as a percent of sales, as well as comparing 1994's expenses to 1995's totals. [ ] The month names and years are calculated based on the values you enter in rows 19-20. [ ] Enter your data into the unprotected cells in blue. Totals and percentages are calculated automatically. [ ] The Advertising Budget begins on Row 18, the Catalog Budget on Row 56, the Direct Mail Budget on Row 68, the Literature Budget on Row 106, the Product Launch Budget on Row 150, Public Relations Budget on Row 200, the Reseller Budget on Row 217, and the Trade Show Budget on Row 263.

Advertising Budget Advertising Media Publication 1 Publication 2 Publication 3 Publication 4 Publication 5 Publication 6 Publication 7 Publication 8 Publication 9 Publication 10 Publication 11 Publication 12 1994 Totals Jan Feb Mar Apr May Jun Jul Aug

$259,776 $273,600 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

$18,040 $28,500 $27,000 $0 $0 $0 $0 $0 $0 $0 $0 $0

$18,040 $28,500 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

$18,040 $28,500 $0 $9,300 $0 $0 $0 $0 $0 $0 $0 $0

$18,040 $28,500 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

$18,040 $28,500 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

$18,040 $28,500 $0 $0 $0 $0 $0 $0 $11,500 $0 $0 $0

$18,040 $28,500 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

$18,040 $28,500 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Page 1

8/11/2008

eed6bf56-ede5-4cca-b57d-259f05090eeb.xls $0 $62,000 $0 $0 $73,540 $0 $0 $46,540 $0 $0 $55,840 $0 $0 $46,540 $0 $31,000 $77,540 $0 $0 $58,040

Confidential $0 $0 $46,540 $0 $0 $46,540

Publication 13 Publication 14 Total Media Artwork & Production Design (12 Ads) Layout/DTP Copywriting Mechanical Artwork Typography Lino Separations (12 ads) Photography Miscellaneous Total Artwork & Production Total Advertising Percentage of Sales

$595,376

$21,000 $2,800 $1,250 $500 $500 $700 $12,000 $4,800 $10,000 $53,550 $648,926

$0 $250 $0 $0 $0 $100 $0 $0 $1,000 $1,350 $74,890 14.8%

$10,500 $250 $0 $0 $0 $100 $5,000 $0 $1,000 $16,850 $63,390 12.3%

$0 $250 $0 $0 $0 $100 $0 $2,500 $1,000 $3,850 $59,690 11.6%

$12,500 $250 $0 $0 $0 $100 $5,000 $0 $1,000 $18,850 $65,390 14.6%

$0 $250 $0 $0 $0 $100 $0 $0 $1,000 $1,350 $78,890 16.9%

$0 $250 $0 $0 $0 $100 $0 $2,500 $1,000 $3,850 $61,890 10.1%

$0 $250 $0 $0 $0 $100 $0 $0 $1,000 $1,350 $47,890 8.0%

$0 $250 $0 $0 $0 $100 $0 $0 $1,000 $1,350 $47,890 7.4%

Page 2

8/11/2008

eed6bf56-ede5-4cca-b57d-259f05090eeb.xls

Confidential

Catalog Budget Catalog Catalog 1 Catalog 2 Catalog 3 Catalog 4 Catalog 5 Total Catalogs Percentage of Sales 1994 Total
$4,574 $20,480 $0 $74,528 $3,500 $103,082

Jan
$0 $7,470 $0 $12,996 $1,851 $22,317 4.4%

Feb
$2,292 $0 $0 $6,243 $0 $8,535 1.7%

Mar
$0 $6,000 $4,000 $12,996 $3,000 $25,996 5.0%

Apr
$0 $0 $0 $6,243 $0 $6,243 1.4%

May
$0 $0 $3,000 $6,243 $3,000 $12,243 2.6%

Jun
$0 $0 $0 $6,243 $0 $6,243 1.0%

Jul
$0 $6,700 $3,000 $0 $3,000 $12,700 2.1%

Aug
$0 $0 $0 $6,243 $0 $6,243 1.0%

Page 3

8/11/2008

eed6bf56-ede5-4cca-b57d-259f05090eeb.xls

Confidential

Direct Mail Budget Direct Mail 1994 Total Jan Feb Mar Apr May Jun Jul Aug

Installed Consumer Base Product Line Upsell New Product Upsell Newsletter Upgrade Re-Mail Installed Customer Total

$84,000 $156,890 $65,450 $306,340

$0 $0 $0 $41,939 $41,939

$0 $0 $0 $0 $0

$0 $0 $0 $0 $0

$0 $0 $0 $0 $0

$0 $0 $0 $0 $0

$0 $97,750 $0 $0 $97,750

$0 $0 $0 $0 $0

$0 $0 $81,250 $0 $81,250

Outside List Source 1 Post Card Source 2 Post Card Source 3 Post Card Outside List Total Mailing List Management Registration Card Data Entry MIS Time - Reports Mailing List Rental Fees Miscellaneous Mailing List Mgmt. Total Mailing List Income Rental to [Company] Rental to [Company] Mailing List Income Total
$5,000 $1,000 $0

$0 $0 $0 $0

$0 $0 $0 $0

$16,250 $0 $0 $16,250

$0 $0 $0 $0

$0 $0 $0 $0

$0 $13,000 $0 $13,000

$0 $0 $0 $0

$0 $0 $0 $0

$650 $0 $0 $0

$650 $0 $0 $0 $650

$650 $0 $0 $0 $650

$650 $0 $0 $0 $650

$650 $800 $0 $0 $1,450

$650 $0 $0 $0 $650

$1,000 $0 $450 $0 $1,450

$1,000 $0 $450 $0 $1,450

$6,000

$650

$5,000 $11,000

$700 $500 $1,200

$700 $500 $1,200

$700 $500 $1,200

$700 $500 $1,200

$700 $500 $1,200

$700 $500 $1,200

$700 $500 $1,200

$700 $500 $1,200 Page 4

8/11/2008

eed6bf56-ede5-4cca-b57d-259f05090eeb.xls

Confidential

[ ] Total Direct Mail = (Installed Customer Base + Outside List + Mailing List Management) - Mailing List Income

Total Direct Mail Percentage of Sales

$301,340

$41,389 8.2%

($550) -0.1%

$15,700 3.0%

($550) -0.1%

$250 0.1%

$110,200 17.9%

$250 0.0%

$81,500 12.6%

Page 5

8/11/2008

eed6bf56-ede5-4cca-b57d-259f05090eeb.xls

Confidential

Literature Budget Literature 1994 Total Jan Feb Mar Apr May Jun Jul Aug

Collateral Corporate Brochure-Printing Mini Catalog-Printing Product Brochures-Printing Photography Copywriter Design & Mechanicals Separations Collateral Total

$25,500 $32,450 $89,520 $12,485 $2,400 $5,600 $4,800 $172,755

$0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0

$0 $36,220 $0 $5,415 $0 $3,500 $2,400 $47,535

$0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $97,560 $5,415 $0 $3,500 $2,400 $108,875

Product Packaging Boxes Stickers Photography Copywriter Design & Mechanicals Separations Product Packaging Total Merchandising Flyers Coupons Copywriter Design & Mechanicals Merchandising Total Miscellaneous

$48,575 $3,750 $18,520 $2,400 $6,000 $6,000 $85,245

$0 $0 $0 $0 $0 $0 $0

$0 $0 $20,000 $0 $3,000 $0 $23,000

$13,965 $1,000 $0 $950 $0 $1,800 $17,715

$0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $3,000 $0 $3,000

$13,965 $1,000 $0 $950 $0 $1,800 $17,715

$0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $3,000 $0 $3,000

$16,515 $11,545 $2,400 $4,000 $34,460

$0 $0 $0 $0 $0

$0 $0 $0 $0 $0

$4,200 $3,000 $1,000 $1,500 $9,700

$0 $0 $0 $0 $0

$0 $0 $0 $0 $0

$4,200 $3,000 $1,000 $1,500 $9,700

$0 $0 $0 $0 $0

$0 $0 $0 $0 $0

Page 6

8/11/2008

eed6bf56-ede5-4cca-b57d-259f05090eeb.xls $8,000 $1,750 $2,000 $2,400 $500 $14,650 $307,110 $0 $0 $0 $0 $0 $0 $0 0.0% $0 $0 $0 $0 $0 $0 $23,000 4.5% $2,000 $500 $600 $850 $0 $3,950 $31,365 6.1% $0 $0 $0 $0 $0 $0 $0 0.0% $0 $0 $0 $0 $0 $0 $3,000 0.6% $2,000 $500 $600 $850 $0 $3,950 $78,900 12.8%

Confidential $0 $0 $0 $0 $0 $0 $0 0.0% $0 $0 $0 $0 $0 $0 $111,875 17.3%

Ad & Editorial Reprints Registration Cards Business Cards Training Materials Christmas Cards Miscellaneous Total Total Literature Percentage of Sales

Page 7

8/11/2008

eed6bf56-ede5-4cca-b57d-259f05090eeb.xls

Confidential

Product Launch Budget Product Launch 1994 Total Jan Feb Mar Apr May Jun Jul Aug

Public Relations Press Review Kits Public Relations Total

$25,500 $25,500

$0 $0

$0 $0

$0 $0

$0 $0

$25,000 $25,000

$0 $0

$0 $0

$0 $0

Sales Collateral Copy & Design Photoshoot & Supply of Film Product Pkg. Design & Film Product Brochure Direct Mail Reg. Card piece Mini Catalog Ad/Editorial Reprints Merchandising Sales Collateral Total Trade Shows Targeted Industry Shows Other Shows Merchandising Total Advertising Targeting Publications Advertising Total Direct Mail Design, printing, postage

$2,000 $1,000 $10,000 $10,000 $5,000 $18,000 $2,500 $5,000 $53,500

$0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0 $0

$2,000 $1,000 $10,000 $10,000 $5,000 $18,000 $2,500 $5,000 $53,500

$0 $0 $0 $0 $0 $0 $0 $0 $0

$15,000 $5,000 $20,000

$0 $0 $0

$0 $0 $0

$0 $0 $0

$0 $0 $0

$5,000 $0 $5,000

$5,000 $5,000 $10,000

$5,000 $0 $5,000

$0 $0 $0

$60,000 $60,000

$0 $0

$10,000 $10,000

$10,000 $10,000

$10,000 $10,000

$10,000 $10,000

$10,000 $10,000

$10,000 $10,000

$0 $0

$75,000

$0

$0

$0

$0

$0

$0

$0 Page 8

$0

8/11/2008

eed6bf56-ede5-4cca-b57d-259f05090eeb.xls

Confidential

Direct Mail Total Mail Order Catalogs Catalog 1 Direct Mail Total Reseller Promotions ROP Ads End Caps Direct Mail Total

$75,000

$0

$0

$0

$0

$0

$0

$0

$0

$25,000 $25,000

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$45,000 $35,000 $80,000

$0 $0 $0

$0 $0 $0

$0 $0 $0

$0 $0 $0

$0 $0 $0

$0 $0 $0

$0 $0 $0

$0 $0 $0

Total Product Launch Percentage of Sales

$339,000

$0 0.0%

$10,000 1.9%

$10,000 1.9%

$10,000 2.2%

$40,000 8.5%

$20,000 3.3%

$68,500 11.4%

$0 0.0%

Page 9

8/11/2008

eed6bf56-ede5-4cca-b57d-259f05090eeb.xls

Confidential

Public Relations Budget Public Relations 1994 Total Jan Feb Mar Apr May Jun Jul Aug

Free Shipping Bacon,s Clipping Service Consultant's Fees Consultant's Expenses Evaluation Units P.R. Production Product Photos Miscellaneous Total Public Relations Percentage of Sales

$5,600 $2,000 $35,000 $5,000 $10,000 $3,500 $4,500 $2,500 $68,100

$1,500 $200 $4,000 $500 $500 $250 $2,500 $100 $9,550 1.9%

$250 $200 $4,000 $500 $500 $250 $75 $100 $5,875 1.1%

$250 $200 $4,000 $0 $500 $250 $75 $100 $5,375 1.0%

$250 $200 $4,000 $1,500 $500 $250 $500 $100 $7,300 1.6%

$1,500 $200 $4,000 $500 $1,000 $250 $75 $100 $7,625 1.6%

$1,500 $200 $4,000 $0 $500 $250 $500 $100 $7,050 1.1%

$1,500 $200 $4,000 $500 $500 $750 $75 $100 $7,625 1.3%

$250 $200 $4,000 $1,500 $500 $250 $500 $100 $7,300 1.1%

Page 10

8/11/2008

eed6bf56-ede5-4cca-b57d-259f05090eeb.xls

Confidential

Resellers Budget Resellers 1994 Total Jan Feb Mar Apr May Jun Jul Aug

Merchandising Collateral (includes production costs) Replenishment Reports $450 $45 Flyers $595 $0 Special Materials $3,800 $0 Collateral Total $4,845 $45

$45 $0 $0 $45

$45 $218 $873 $1,136

$45 $0 $0 $45

$45 $0 $0 $45

$45 $218 $873 $1,136

$45 $0 $0 $45

$45 $0 $0 $45

Merchandising Services (based on 1 visit per store, per month) Chain Store 1 $14,400 $1,280 $1,280 Chain Store 2 $9,072 $1,008 $1,008 Chain Store 3 $43,200 $3,840 $3,840 Chain Store 4 $63,900 $5,680 $5,680 Chain Store 5 $2,520 $240 $240 Services Total $133,092 $12,048 $12,048

$1,280 $1,008 $3,840 $5,680 $240 $12,048

$1,280 $1,008 $3,840 $5,680 $240 $12,048

$1,280 $1,008 $3,840 $5,680 $240 $12,048

$1,280 $1,008 $3,840 $5,680 $240 $12,048

$1,280 $1,008 $3,840 $5,680 $240 $12,048

$1,280 $1,008 $3,840 $5,680 $240 $12,048

[ ] Most distributors and retailers insist on an "Advertising Co-Op" or "MDF" percentage of your total annual sales in their stores. This fee is generally less than 5%. In addition to this fee, distributors and retailers will coordinate special advertising deals -- end-caps, full page spreads -- and charge accordingly. Estimate your total "Advertising Co-Op" fee and divide by 12. Ad this value to your "special promotions" fees and enter your totals in the appropriate months.

Distributors Distributor 1 Distributor 2 Distributor 3 Distributor 4 Distributor 5 Distributors Total

1994 Total Jan
$21,754 $1,756 $1,200 $4,633 $4,000 $33,343 $4,993 $231 $117 $267 $100 $5,708

Feb
$4,993 $231 $117 $267 $100 $5,708

Mar
$4,993 $231 $117 $267 $100 $5,708

Apr
$1,993 $231 $117 $267 $100 $2,708

May
$1,993 $231 $117 $267 $100 $2,708

Jun
$1,993 $231 $117 $3,267 $100 $5,708

Jul
$1,993 $231 $117 $267 $100 $2,708

Aug
$1,993 $231 $117 $267 $100 $2,708

Retailers

1994 Total Jan

Feb

Mar

Apr

May

Jun

Jul

Aug
Page 11

8/11/2008

eed6bf56-ede5-4cca-b57d-259f05090eeb.xls $10,000 $97,350 $38,042 $29,915 $41,469 $117 $2,287 $1,510 $1,042 $13,047 $18,003 $8,117 $2,287 $1,510 $1,042 $2,047 $15,003 $117 $41,287 $1,510 $1,042 $2,047 $46,003 $117 $2,287 $21,510 $1,042 $2,047 $27,003 $117 $2,287 $1,510 $11,042 $2,047 $17,003 $117 $12,287 $1,510 $4,042 $2,047 $20,003

Confidential $2,117 $2,287 $1,510 $1,042 $2,047 $9,003 $117 $2,287 $1,510 $1,042 $10,047 $15,003

Retailer 1 Retailer 2 Retailer 3 Retailer 4 Retailer 5 Retailers Total

$216,776

1994 Total Jan Total Resellers Percentage of Sales
$388,056 $35,804 7.1%

Feb
$32,804 6.4%

Mar
$64,895 12.6%

Apr
$41,804 9.3%

May
$31,804 6.8%

Jun
$38,895 6.3%

Jul
$23,804 4.0%

Aug
$29,804 4.6%

Page 12

8/11/2008

eed6bf56-ede5-4cca-b57d-259f05090eeb.xls

Confidential

Trade Show Budget Trade Shows Air Fare Badges Booth Space Candy Carpeting & Padding Cleaning & Repair Services Faxing & Copying Film Furniture Giveaways Hotel Lead Forms Meals Post Card Invitations Press Kits Shipping Signage Transportation Uniforms Utilities Total Trade Shows Percentage of Sales 1994 Total Jan
$5,400 $150 $47,000 $0 $1,050 $425 $95 $45 $575 $4,800 $4,875 $98 $1,375 $2,250 $3,125 $4,895 $1,765 $198 $425 $1,275 $79,821 $2,000 $50 $10,000 $200 $350 $125 $45 $15 $200 $1,200 $2,400 $35 $540 $850 $1,100 $1,800 $600 $75 $0 $460 $0 $22,045 4.4%

Feb
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 0.0%

Mar
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 0.0%

Apr
$2,000 $50 $10,000 $200 $350 $125 $45 $15 $200 $1,200 $2,400 $35 $540 $850 $1,100 $1,800 $600 $75 $0 $460 $0 $22,045 4.9%

May
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 0.0%

Jun
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 0.0%

Jul
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 0.0%

Aug
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 0.0%

Page 13

8/11/2008

eed6bf56-ede5-4cca-b57d-259f05090eeb.xls

Confidential

Advertising & Promotions Budget Summary Sales Forecast Category Advertising Catalogs Direct Mail Literature Product Launch Public Relations Resellers Trade Shows Grand Total A & P % of Sales
$506,000 $516,000 $515,000 $449,000 $468,000 $615,000 $600,000 $646,000 $742,000

Jan
$74,890 $22,317 $41,389 $0 $0 $9,550 $35,804 $22,045 $205,995 41%

Feb
$63,390 $8,535 ($550) $23,000 $10,000 $5,875 $32,804 $0 $143,054 28%

Mar
$59,690 $25,996 $15,700 $31,365 $10,000 $5,375 $64,895 $0 $213,021 41%

Apr
$65,390 $6,243 ($550) $0 $10,000 $7,300 $41,804 $22,045 $152,232 34%

May
$78,890 $12,243 $250 $3,000 $40,000 $7,625 $31,804 $0 $173,812 37%

Jun
$61,890 $6,243 $110,200 $78,900 $20,000 $7,050 $38,895 $0 $323,178 53%

Jul
$47,890 $12,700 $250 $0 $68,500 $7,625 $23,804 $0 $160,769 27%

Aug
$47,890 $6,243 $81,500 $111,875 $0 $7,300 $29,804 $0 $284,612 44%

Sep
$47,890 $18,943 $139,000 $110,130 $25,000 $8,125 $35,895 $0 $384,983 52%

Page 14

8/11/2008

eed6bf56-ede5-4cca-b57d-259f05090eeb.xls

Confidential

Sep

Oct

Nov

Dec

1995 Total

Variance 1994/1995

$18,040 $28,500 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

$18,040 $28,500 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

$18,040 $28,500 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

$18,040 $28,500 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

$216,480 $342,000 $27,000 $9,300 $0 $0 $0 $0 $11,500 $0 $0 $0

-16.7% 25.0%

Page 15

8/11/2008 $0 $0 $46,540 $0 $0 $46,540 $0 $0 $46,540 $0 $0 $46,540

eed6bf56-ede5-4cca-b57d-259f05090eeb.xls $0 $31,000 $0 $637,280 7.0% -50.0%

Confidential

$0 $250 $0 $0 $0 $100 $0 $0 $1,000 $1,350 $47,890 6.5%

$0 $250 $0 $0 $0 $100 $0 $0 $1,000 $1,350 $47,890 7.1%

$0 $250 $0 $0 $0 $100 $0 $0 $1,000 $1,350 $47,890 6.8%

$0 $250 $0 $0 $0 $100 $0 $0 $1,000 $1,350 $47,890 7.7%

$23,000 $3,000 $0 $0 $0 $1,200 $10,000 $5,000 $12,000 $0 $54,200 $691,480 9.8%

9.5% 7.1%

71.4% -16.7% 4.2% 20.0% 1.2% 6.6%

Page 16

8/11/2008

eed6bf56-ede5-4cca-b57d-259f05090eeb.xls

Confidential

Sep
$0 $6,700 $3,000 $6,243 $3,000 $18,943 2.6%

Oct
$0 $0 $0 $12,996 $0 $12,996 1.9%

Nov
$0 $0 $3,000 $12,996 $3,000 $18,996 2.7%

Dec
$0 $0 $0 $6,243 $0 $6,243 1.0%

1995 Total
$2,292 $26,870 $16,000 $95,685 $16,851 $0 $157,698 2.2%

Variance 1994/1995
-49.9% 31.2% 28.4% 381.5% 53.0%

Page 17

8/11/2008

eed6bf56-ede5-4cca-b57d-259f05090eeb.xls

Confidential

Sep

Oct

Nov

Dec

1995 Variance Total 1994/1995

$106,250 $0 $0 $0 $106,250

$0 $0 $0 $0 $0

$0 $0 $0 $0 $0

$0 $0 $0 $0 $0

$106,250 $97,750 $81,250 $41,939 $327,189

26.5% -37.7% 24.1% 6.8%

$0 $0 $32,500 $32,500

$0 $0 $0 $0

$0 $0 $0 $0

$0 $0 $0 $0

$16,250 $13,000 $32,500 $0 $61,750

$1,000 $0 $450 $0 $1,450

$1,000 $0 $450 $0 $1,450

$1,000 $0 $450 $0 $1,450

$1,000 $1,400 $450 $0 $2,850

$9,900 $2,200 $2,700 $0 $14,800

98.0% 120.0%

146.7%

$700 $500 $1,200

$700 $500 $1,200

$700 $500 $1,200

$700 $500 $1,200

$8,400 $6,000 $14,400

68.0% 30.9% Page 18

8/11/2008

eed6bf56-ede5-4cca-b57d-259f05090eeb.xls

Confidential

$139,000 18.7%

$250 0.0%

$250 0.0%

$1,650 0.3%

$389,339 5.5%

29.2%

Page 19

8/11/2008

eed6bf56-ede5-4cca-b57d-259f05090eeb.xls

Confidential

Sep

Oct

Nov

Dec

1995 Total

Variance 1994/1995

$31,250 $0 $0 $5,415 $3,200 $3,750 $2,650 $46,265

$0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0

$31,250 $36,220 $97,560 $16,245 $3,200 $10,750 $7,450 $202,675

22.5% 11.6% 9.0% 30.1% 33.3% 92.0% 55.2% 17.3%

$13,965 $1,000 $0 $950 $32,500 $1,800 $50,215

$0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $3,000 $0 $3,000

$13,965 $1,000 $0 $950 $0 $1,800 $17,715

$55,860 $4,000 $20,000 $3,800 $44,500 $7,200 $135,360

15.0% 6.7% 8.0% 58.3% 641.7% 20.0% 58.8%

$4,200 $3,000 $1,000 $1,500 $9,700

$0 $0 $0 $0 $0

$0 $0 $0 $0 $0

$4,200 $3,000 $1,000 $1,500 $9,700

$16,800 $12,000 $4,000 $6,000 $38,800

1.7% 3.9% 66.7% 50.0% 12.6%

Page 20

8/11/2008 $2,000 $500 $600 $850 $0 $3,950 $110,130 14.8% $0 $0 $0 $0 $650 $650 $650 0.1% $0 $0 $0 $0 $0 $0 $3,000 0.4% $2,000 $500 $600 $850 $0 $3,950 $31,365 5.1%

eed6bf56-ede5-4cca-b57d-259f05090eeb.xls $8,000 $2,000 $2,400 $3,400 $650 $0 $16,450 $393,285 5.6% 12.3% 28.1% 0.0% 14.3% 20.0% 41.7% 30.0%

Confidential

Page 21

8/11/2008

eed6bf56-ede5-4cca-b57d-259f05090eeb.xls

Confidential

Sep

Oct

Nov

Dec

1995 Total

Variance 1994/1995

$0 $0

$0 $0

$0 $0

$0 $0

$25,000 $25,000

-2.0% -2.0%

$0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0 $0

$2,000 $1,000 $10,000 $10,000 $5,000 $18,000 $2,500 $5,000 $53,500

0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0%

$0 $0 $0

$0 $0 $0

$0 $0 $0

$0 $0 $0

$15,000 $5,000 $20,000

0.0% 0.0% 0.0%

$0 $0

$0 $0

$0 $0

$0 $0

$60,000 $0 $60,000

0.0% 0.0%

$25,000

$25,000

$25,000

$0

$75,000

0.0% Page 22

8/11/2008

eed6bf56-ede5-4cca-b57d-259f05090eeb.xls $0

Confidential

$25,000

$25,000

$25,000

$0

$75,000

0.0%

$0 $0

$0 $0

$25,000 $25,000

$0 $0

$25,000 $0 $25,000

0.0% 0.0%

$0 $0 $0

$0 $0 $0

$25,000 $25,000 $50,000

$20,000 $10,000 $30,000

$45,000 $35,000 $80,000

0.0% 0.0% 0.0%

$25,000 3.4%

$25,000 3.7%

$100,000 14.2%

$30,000 4.9%

$338,500 4.8%

-0.1%

Page 23

8/11/2008

eed6bf56-ede5-4cca-b57d-259f05090eeb.xls

Confidential

Sep

Oct

Nov

Dec

1995 Total

Variance 1994/1995

$1,500 $200 $4,000 $500 $1,000 $750 $75 $100 $8,125 1.1%

$1,500 $200 $4,000 $0 $500 $250 $75 $100 $6,625 1.0%

$250 $200 $4,000 $500 $500 $250 $75 $100 $5,875 0.8%

$250 $200 $4,000 $0 $500 $250 $75 $100 $5,375 0.9%

$10,500 $2,400 $48,000 $6,000 $7,000 $4,000 $4,600 $1,200 $83,700 1.2%

87.5% 20.0% 37.1% 20.0% -30.0% 14.3% 2.2% -52.0% 22.9%

Page 24

8/11/2008

eed6bf56-ede5-4cca-b57d-259f05090eeb.xls

Confidential

Sep

Oct

Nov

Dec

1995 Total

Variance 1994/1995

$45 $218 $873 $1,136

$45 $0 $0 $45

$45 $0 $0 $45

$45 $218 $873 $1,136

$540 $872 $3,492 $4,904

20.0% 46.6% -8.1% 1.2%

$1,280 $1,008 $3,840 $5,680 $240 $12,048

$1,280 $1,008 $3,840 $5,680 $240 $12,048

$1,280 $1,008 $3,840 $5,680 $240 $12,048

$1,280 $1,008 $3,840 $5,680 $240 $12,048

$15,360 $12,096 $46,080 $68,160 $2,880 $144,576

6.7% 33.3% 6.7% 6.7% 14.3% 8.6%

Sep
$1,993 $231 $117 $3,267 $100 $5,708

Oct
$1,993 $231 $117 $267 $100 $2,708

Nov
$3,493 $231 $117 $267 $100 $4,208

Dec
$1,993 $231 $117 $267 $100 $2,708

1995 Variance Total 1994/1995
$34,416 $2,772 $1,404 $9,204 $1,200 $48,996 58.2% 57.9% 17.0% 98.7% -70.0% 46.9%

Sep

Oct

Nov

Dec

1995 Variance Total 1994/1995
Page 25

8/11/2008 $117 $2,287 $1,510 $11,042 $2,047 $17,003 $117 $17,287 $1,510 $1,042 $2,047 $22,003 $117 $2,287 $1,510 $1,042 $2,047 $7,003 $117 $2,287 $1,510 $1,042 $2,047 $7,003

eed6bf56-ede5-4cca-b57d-259f05090eeb.xls $11,404 $91,444 $38,120 $35,504 $43,564 $220,036 14.0% -6.1% 0.2% 18.7% 5.1% 1.5%

Confidential

Sep
$35,895 4.8%

Oct
$36,804 5.5%

Nov
$23,304 3.3%

Dec
$22,895 3.7%

1995 Variance Total 1994/1995
$418,512 5.9% 7.8%

Page 26

8/11/2008

eed6bf56-ede5-4cca-b57d-259f05090eeb.xls

Confidential

Sep
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 0.0%

Oct
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 0.0%

Nov
$2,000 $50 $10,000 $200 $350 $125 $45 $15 $200 $1,200 $2,400 $35 $540 $850 $1,100 $1,800 $600 $75 $0 $460 $0 $22,045 3.1%

Dec
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 0.0%

1995 Variance Total 1994/1995
$6,000 $150 $30,000 $600 $1,050 $375 $135 $45 $600 $3,600 $7,200 $105 $1,620 $2,550 $3,300 $5,400 $1,800 $225 $0 $1,380 $66,135 0.9% 8.2% -17.1% 0.0% -11.8% 42.1% 0.0% 4.3% -25.0% 47.7% 7.1% 17.8% 13.3% 5.6% 10.3% 2.0% 13.6% 11.1% 0.0% -36.2%

Page 27

8/11/2008

eed6bf56-ede5-4cca-b57d-259f05090eeb.xls

Confidential

$670,000

$705,000

$618,000

$7,050,000

Oct
$47,890 $12,996 $250 $650 $25,000 $6,625 $36,804 $0 $130,215 19%

Nov
$47,890 $18,996 $250 $3,000 $100,000 $5,875 $23,304 $22,045 $221,360 31%

Dec
$47,890 $6,243 $1,650 $31,365 $30,000 $5,375 $22,895 $0 $145,418 24%

1995 Total
$691,480 $157,698 $389,339 $393,285 $338,500 $83,700 $418,512 $66,135 $2,538,649 36%

Page 28


				
DOCUMENT INFO
Shared By:
Stats:
views:2052
posted:2/6/2008
language:English
pages:28