; Product Launch Templates - Excel
Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out
Your Federal Quarterly Tax Payments are due April 15th Get Help Now >>

Product Launch Templates - Excel

VIEWS: 104 PAGES: 28

Product Launch Templates document sample

More Info
  • pg 1
									        7/11/2011                                                e9598fe7-ade3-4c7c-a333-6c32d6f50f63.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
                                          1994
            Advertising                   Totals           Jan            Feb            Mar            Apr          May            Jun        Jul             Aug

Media
Publication 1                              $259,776        $18,040        $18,040        $18,040        $18,040      $18,040        $18,040    $18,040         $18,040
Publication 2                              $273,600        $28,500        $28,500        $28,500        $28,500      $28,500        $28,500    $28,500         $28,500
Publication 3                                     $0       $27,000              $0             $0              $0          $0             $0          $0             $0
Publication 4                                     $0             $0             $0        $9,300               $0          $0             $0          $0             $0
Publication 5                                     $0             $0             $0             $0              $0          $0             $0          $0             $0
Publication 6                                     $0             $0             $0             $0              $0          $0             $0          $0             $0
Publication 7                                     $0             $0             $0             $0              $0          $0             $0          $0             $0
Publication 8                                     $0             $0             $0             $0              $0          $0             $0          $0             $0
Publication 9                                     $0             $0             $0             $0              $0          $0       $11,500           $0             $0
Publication 10                                    $0             $0             $0             $0              $0          $0             $0          $0             $0
Publication 11                                    $0             $0             $0             $0              $0          $0             $0          $0             $0
Publication 12                                    $0             $0             $0             $0              $0          $0             $0          $0             $0

                                                                                                                                                           Page 1
      7/11/2011                                    e9598fe7-ade3-4c7c-a333-6c32d6f50f63.xls                               Confidential

Publication 13                           $0        $0           $0            $0              $0       $0        $0        $0               $0
Publication 14                       $62,000       $0           $0            $0              $0   $31,000       $0        $0               $0


                      Total Media   $595,376   $73,540     $46,540       $55,840      $46,540      $77,540   $58,040   $46,540       $46,540


Artwork & Production
Design (12 Ads)                      $21,000       $0      $10,500            $0      $12,500          $0        $0        $0               $0
Layout/DTP                            $2,800     $250         $250         $250          $250        $250      $250      $250             $250
Copywriting                           $1,250       $0           $0            $0              $0       $0        $0        $0               $0
Mechanical Artwork                     $500        $0           $0            $0              $0       $0        $0        $0               $0
Typography                             $500        $0           $0            $0              $0       $0        $0        $0               $0
Lino                                   $700      $100         $100         $100          $100        $100      $100      $100             $100
Separations (12 ads)                 $12,000       $0       $5,000            $0       $5,000          $0        $0        $0               $0
Photography                           $4,800       $0           $0        $2,500              $0       $0     $2,500       $0               $0
Miscellaneous                        $10,000    $1,000      $1,000        $1,000       $1,000       $1,000    $1,000    $1,000        $1,000


    Total Artwork & Production       $53,550    $1,350     $16,850        $3,850      $18,850       $1,350    $3,850    $1,350        $1,350


Total Advertising                   $648,926   $74,890     $63,390       $59,690      $65,390      $78,890   $61,890   $47,890       $47,890
Percentage of Sales                             14.8%        12.3%        11.6%         14.6%       16.9%     10.1%      8.0%             7.4%




                                                                                                                                 Page 2
      7/11/2011                          e9598fe7-ade3-4c7c-a333-6c32d6f50f63.xls                                          Confidential

                                                                                                    Catalog Budget
                      1994
            Catalog   Total        Jan           Feb          Mar           Apr          May           Jun           Jul             Aug
Catalog 1               $4,574           $0       $2,292            $0              $0         $0            $0             $0             $0
Catalog 2              $20,480      $7,470             $0       $6,000              $0         $0            $0       $6,700               $0
Catalog 3                     $0         $0            $0       $4,000              $0    $3,000             $0       $3,000               $0
Catalog 4              $74,528     $12,996        $6,243       $12,996       $6,243       $6,243        $6,243              $0        $6,243
Catalog 5               $3,500      $1,851             $0       $3,000              $0    $3,000             $0       $3,000               $0


Total Catalogs        $103,082     $22,317        $8,535       $25,996       $6,243      $12,243        $6,243       $12,700          $6,243
Percentage of Sales                  4.4%           1.7%          5.0%         1.4%        2.6%           1.0%         2.1%               1.0%




                                                                                                                                 Page 3
      7/11/2011                                     e9598fe7-ade3-4c7c-a333-6c32d6f50f63.xls                                                  Confidential

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




Installed Consumer Base
Product Line Upsell                 $84,000         $0             $0             $0             $0             $0               $0            $0               $0
New Product Upsell                 $156,890         $0             $0             $0             $0             $0          $97,750            $0               $0
Newsletter                          $65,450         $0             $0             $0             $0             $0              $0             $0          $81,250
Upgrade Re-Mail                                 $41,939            $0             $0             $0             $0              $0             $0               $0
        Installed Customer Total   $306,340     $41,939            $0             $0             $0             $0          $97,750            $0          $81,250



Outside List
Source 1 Post Card                                  $0             $0      $16,250               $0             $0              $0             $0               $0
Source 2 Post Card                                  $0             $0             $0             $0             $0          $13,000            $0               $0
Source 3 Post Card                                  $0             $0             $0             $0             $0              $0             $0               $0


              Outside List Total        $0          $0             $0      $16,250               $0             $0          $13,000            $0               $0


Mailing List Management

Registration Card Data Entry         $5,000       $650           $650           $650           $650           $650            $650          $1,000          $1,000
MIS Time - Reports                   $1,000         $0             $0             $0             $0           $800              $0             $0               $0
Mailing List Rental Fees                            $0             $0             $0             $0             $0              $0           $450             $450
Miscellaneous                                       $0             $0             $0             $0             $0              $0             $0               $0
        Mailing List Mgmt. Total     $6,000       $650           $650           $650           $650          $1,450           $650          $1,450          $1,450


Mailing List Income
Rental to [Company]                  $5,000       $700           $700           $700           $700           $700            $700           $700             $700
Rental to [Company]                               $500           $500           $500           $500           $500            $500           $500             $500
      Mailing List Income Total     $11,000      $1,200         $1,200         $1,200         $1,200         $1,200          $1,200         $1,200          $1,200
                                                                                                                                                     Page 4
       7/11/2011                                               e9598fe7-ade3-4c7c-a333-6c32d6f50f63.xls                               Confidential


[ ] Total Direct Mail = (Installed Customer Base + Outside List + Mailing List Management) - Mailing List Income
Total Direct Mail                         $301,340        $41,389          ($550)       $15,700          ($550)    $250   $110,200   $250       $81,500
Percentage of Sales                                           8.2%          -0.1%          3.0%          -0.1%     0.1%     17.9%    0.0%            12.6%




                                                                                                                                            Page 5
      7/11/2011                                      e9598fe7-ade3-4c7c-a333-6c32d6f50f63.xls                                        Confidential

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


Collateral
Corporate Brochure-Printing          $25,500         $0            $0           $0              $0         $0           $0            $0             $0
Mini Catalog-Printing                $32,450         $0            $0           $0              $0         $0      $36,220            $0             $0
Product Brochures-Printing           $89,520         $0            $0           $0              $0         $0            $0           $0       $97,560
Photography                          $12,485         $0            $0           $0              $0         $0       $5,415            $0        $5,415
Copywriter                            $2,400         $0            $0           $0              $0         $0            $0           $0             $0
Design & Mechanicals                  $5,600         $0            $0           $0              $0         $0       $3,500            $0        $3,500
Separations                           $4,800         $0            $0           $0              $0         $0       $2,400            $0        $2,400
                 Collateral Total   $172,755         $0            $0           $0              $0         $0      $47,535            $0      $108,875



Product Packaging
Boxes                                $48,575         $0            $0      $13,965              $0         $0      $13,965            $0             $0
Stickers                              $3,750         $0            $0       $1,000              $0         $0       $1,000            $0             $0
Photography                          $18,520         $0      $20,000            $0              $0         $0            $0           $0             $0
Copywriter                            $2,400         $0            $0        $950               $0         $0         $950            $0             $0
Design & Mechanicals                  $6,000         $0       $3,000            $0              $0    $3,000             $0           $0        $3,000
Separations                           $6,000         $0            $0       $1,800              $0         $0       $1,800            $0             $0
         Product Packaging Total     $85,245         $0      $23,000       $17,715              $0    $3,000       $17,715            $0        $3,000


Merchandising
Flyers                               $16,515         $0            $0       $4,200              $0         $0       $4,200            $0             $0
Coupons                              $11,545         $0            $0       $3,000              $0         $0       $3,000            $0             $0
Copywriter                            $2,400         $0            $0       $1,000              $0         $0       $1,000            $0             $0
Design & Mechanicals                  $4,000         $0            $0       $1,500              $0         $0       $1,500            $0             $0
           Merchandising Total       $34,460         $0            $0       $9,700              $0         $0       $9,700            $0             $0


Miscellaneous
                                                                                                                                           Page 6
      7/11/2011                               e9598fe7-ade3-4c7c-a333-6c32d6f50f63.xls                           Confidential

Ad & Editorial Reprints             $8,000    $0           $0        $2,000              $0      $0     $2,000    $0               $0
Registration Cards                  $1,750    $0           $0         $500               $0      $0      $500     $0               $0
Business Cards                      $2,000    $0           $0         $600               $0      $0      $600     $0               $0
Training Materials                  $2,400    $0           $0         $850               $0      $0      $850     $0               $0
Christmas Cards                      $500     $0           $0            $0              $0      $0        $0     $0               $0


            Miscellaneous Total    $14,650    $0           $0        $3,950              $0      $0     $3,950    $0               $0


Total Literature                  $307,110    $0      $23,000       $31,365              $0   $3,000   $78,900    $0       $111,875
Percentage of Sales                          0.0%        4.5%          6.1%         0.0%       0.6%     12.8%    0.0%            17.3%




                                                                                                                        Page 7
       7/11/2011                                    e9598fe7-ade3-4c7c-a333-6c32d6f50f63.xls                                       Confidential

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


Public Relations
Press Review Kits                   $25,500         $0            $0           $0              $0   $25,000             $0          $0             $0
          Public Relations Total    $25,500         $0            $0           $0              $0   $25,000             $0          $0             $0



Sales Collateral
Copy & Design                        $2,000         $0            $0           $0              $0         $0            $0    $2,000               $0
Photoshoot & Supply of Film          $1,000         $0            $0           $0              $0         $0            $0    $1,000               $0
Product Pkg. Design & Film          $10,000         $0            $0           $0              $0         $0            $0   $10,000               $0
Product Brochure                    $10,000         $0            $0           $0              $0         $0            $0   $10,000               $0
Direct Mail Reg. Card piece          $5,000         $0            $0           $0              $0         $0            $0    $5,000               $0
Mini Catalog                        $18,000         $0            $0           $0              $0         $0            $0   $18,000               $0
Ad/Editorial Reprints                $2,500         $0            $0           $0              $0         $0            $0    $2,500               $0
Merchandising                        $5,000         $0            $0           $0              $0         $0            $0    $5,000               $0
           Sales Collateral Total   $53,500         $0            $0           $0              $0         $0            $0   $53,500               $0


Trade Shows
Targeted Industry Shows             $15,000         $0            $0           $0              $0    $5,000        $5,000     $5,000               $0
Other Shows                          $5,000         $0            $0           $0              $0         $0       $5,000           $0             $0
            Merchandising Total     $20,000         $0            $0           $0              $0    $5,000       $10,000     $5,000               $0


Advertising
Targeting Publications              $60,000         $0      $10,000       $10,000      $10,000      $10,000       $10,000    $10,000               $0


                Advertising Total   $60,000         $0      $10,000       $10,000      $10,000      $10,000       $10,000    $10,000               $0


Direct Mail
Design, printing, postage           $75,000         $0            $0           $0              $0         $0            $0          $0             $0
                                                                                                                                         Page 8
      7/11/2011                               e9598fe7-ade3-4c7c-a333-6c32d6f50f63.xls                               Confidential


              Direct Mail Total    $75,000    $0           $0            $0              $0       $0        $0        $0              $0


Mail Order Catalogs
Catalog 1                          $25,000    $0           $0            $0              $0       $0        $0        $0              $0


              Direct Mail Total    $25,000    $0           $0            $0              $0       $0        $0        $0              $0


Reseller Promotions
ROP Ads                            $45,000    $0           $0            $0              $0       $0        $0        $0              $0
End Caps                           $35,000    $0           $0            $0              $0       $0        $0        $0              $0
              Direct Mail Total    $80,000    $0           $0            $0              $0       $0        $0        $0              $0



Total Product Launch              $339,000    $0      $10,000       $10,000      $10,000      $40,000   $20,000   $68,500             $0
Percentage of Sales                          0.0%        1.9%          1.9%         2.2%        8.5%      3.3%     11.4%             0.0%




                                                                                                                            Page 9
      7/11/2011                            e9598fe7-ade3-4c7c-a333-6c32d6f50f63.xls                                     Confidential

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


Free Shipping               $5,600   $1,500           $250         $250          $250    $1,500        $1,500      $1,500              $250
Bacon,s Clipping Service    $2,000     $200           $200         $200          $200     $200          $200        $200               $200
Consultant's Fees          $35,000   $4,000         $4,000        $4,000       $4,000    $4,000        $4,000      $4,000          $4,000
Consultant's Expenses       $5,000     $500           $500            $0       $1,500     $500             $0       $500           $1,500
Evaluation Units           $10,000     $500           $500         $500          $500    $1,000         $500        $500               $500
P.R. Production             $3,500     $250           $250         $250          $250     $250          $250        $750               $250
Product Photos              $4,500   $2,500              $75         $75         $500      $75          $500            $75            $500
Miscellaneous               $2,500     $100           $100         $100          $100     $100          $100        $100               $100


Total Public Relations     $68,100   $9,550         $5,875        $5,375       $7,300    $7,625        $7,050      $7,625          $7,300
Percentage of Sales                    1.9%           1.1%          1.0%         1.6%     1.6%          1.1%        1.3%               1.1%




                                                                                                                           Page 10
        7/11/2011                                                  e9598fe7-ade3-4c7c-a333-6c32d6f50f63.xls                                                          Confidential

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

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


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


                                              1994
Distributors                                Total  Jan                 Feb               Mar            Apr             May            Jun               Jul               Aug
Distributor 1                                $21,754          $4,993         $4,993            $4,993          $1,993         $1,993          $1,993            $1,993            $1,993
Distributor 2                                  $1,756           $231           $231             $231            $231           $231            $231              $231               $231
Distributor 3                                  $1,200           $117           $117             $117            $117           $117            $117              $117               $117
Distributor 4                                  $4,633           $267           $267             $267            $267           $267           $3,267             $267               $267
Distributor 5                                  $4,000           $100           $100             $100            $100           $100            $100              $100               $100
                 Distributors Total          $33,343          $5,708         $5,708            $5,708          $2,708         $2,708          $5,708            $2,708            $2,708


                                              1994
Retailers                                   Total  Jan                 Feb               Mar            Apr             May            Jun               Jul               Aug
                                                                                                                                                                        Page 11
       7/11/2011                                      e9598fe7-ade3-4c7c-a333-6c32d6f50f63.xls                                                     Confidential

Retailer 1                            $10,000       $117           $8,117          $117            $117           $117            $117           $2,117           $117
Retailer 2                            $97,350      $2,287          $2,287     $41,287             $2,287         $2,287         $12,287          $2,287          $2,287
Retailer 3                            $38,042      $1,510          $1,510         $1,510         $21,510         $1,510          $1,510          $1,510          $1,510
Retailer 4                            $29,915      $1,042          $1,042         $1,042          $1,042     $11,042             $4,042          $1,042          $1,042
Retailer 5                            $41,469     $13,047          $2,047         $2,047          $2,047         $2,047          $2,047          $2,047         $10,047
                   Retailers Total   $216,776     $18,003         $15,003     $46,003            $27,003     $17,003            $20,003          $9,003         $15,003



                                       1994
                                     Total  Jan             Feb             Mar            Apr             May            Jun             Jul             Aug
Total Resellers                      $388,056     $35,804         $32,804     $64,895            $41,804     $31,804            $38,895         $23,804         $29,804
Percentage of Sales                                 7.1%            6.4%          12.6%            9.3%           6.8%            6.3%            4.0%            4.6%




                                                                                                                                                      Page 12
      7/11/2011                               e9598fe7-ade3-4c7c-a333-6c32d6f50f63.xls                                         Confidential

                                                                                                           Trade Show Budget
                               1994
         Trade Shows         Total  Jan             Feb          Mar          Apr             May          Jun          Jul          Aug

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




                                                                                                                                  Page 13
      7/11/2011                            e9598fe7-ade3-4c7c-a333-6c32d6f50f63.xls                                      Confidential


                                                                            Advertising & Promotions Budget Summary
        Sales Forecast   $506,000    $516,000     $515,000     $449,000       $468,000     $615,000   $600,000     $646,000      $742,000


            Category      Jan        Feb           Mar          Apr            May         Jun         Jul         Aug             Sep
Advertising               $74,890     $63,390      $59,690       $65,390       $78,890      $61,890    $47,890      $47,890        $47,890
Catalogs                  $22,317      $8,535      $25,996        $6,243       $12,243       $6,243    $12,700       $6,243        $18,943
Direct Mail               $41,389       ($550)     $15,700         ($550)         $250     $110,200      $250       $81,500      $139,000
Literature                      $0    $23,000      $31,365            $0        $3,000      $78,900           $0   $111,875      $110,130
Product Launch                  $0    $10,000      $10,000       $10,000       $40,000      $20,000    $68,500            $0       $25,000
Public Relations           $9,550      $5,875       $5,375        $7,300        $7,625       $7,050     $7,625       $7,300         $8,125
Resellers                 $35,804     $32,804      $64,895       $41,804       $31,804      $38,895    $23,804      $29,804        $35,895
Trade Shows               $22,045          $0            $0      $22,045              $0         $0           $0          $0             $0


Grand Total A & P        $205,995    $143,054     $213,021     $152,232       $173,812     $323,178   $160,769     $284,612      $384,983
         % of Sales          41%         28%           41%          34%           37%          53%           27%       44%              52%




                                                                                                                            Page 14
  7/11/2011                                    e9598fe7-ade3-4c7c-a333-6c32d6f50f63.xls   Confidential




                                               1995         Variance
Sep           Oct        Nov        Dec        Total        1994/1995


$18,040       $18,040    $18,040    $18,040    $216,480         -16.7%
$28,500       $28,500    $28,500    $28,500    $342,000          25.0%
      $0            $0         $0         $0    $27,000
      $0            $0         $0         $0     $9,300
      $0            $0         $0         $0           $0
      $0            $0         $0         $0           $0
      $0            $0         $0         $0           $0
      $0            $0         $0         $0           $0
      $0            $0         $0         $0    $11,500
      $0            $0         $0         $0           $0
      $0            $0         $0         $0           $0
      $0            $0         $0         $0           $0

                                                                                             Page 15
  7/11/2011                                 e9598fe7-ade3-4c7c-a333-6c32d6f50f63.xls   Confidential

    $0            $0        $0        $0         $0
    $0            $0        $0        $0     $31,000         -50.0%
                                                 $0
$46,540       $46,540   $46,540   $46,540   $637,280           7.0%



    $0            $0        $0        $0     $23,000           9.5%
  $250          $250      $250      $250      $3,000           7.1%
    $0            $0        $0        $0         $0
    $0            $0        $0        $0         $0
    $0            $0        $0        $0         $0
  $100          $100      $100      $100      $1,200          71.4%
    $0            $0        $0        $0     $10,000         -16.7%
    $0            $0        $0        $0      $5,000           4.2%
 $1,000        $1,000    $1,000    $1,000    $12,000          20.0%
                                                 $0
 $1,350        $1,350    $1,350    $1,350    $54,200           1.2%


$47,890       $47,890   $47,890   $47,890   $691,480           6.6%
  6.5%          7.1%      6.8%      7.7%       9.8%




                                                                                          Page 16
  7/11/2011                                    e9598fe7-ade3-4c7c-a333-6c32d6f50f63.xls   Confidential


                                               1995         Variance
Sep           Oct        Nov        Dec        Total        1994/1995
      $0            $0         $0         $0     $2,292         -49.9%
 $6,700             $0         $0         $0    $26,870          31.2%
 $3,000             $0    $3,000          $0    $16,000
 $6,243       $12,996    $12,996    $6,243      $95,685          28.4%
 $3,000             $0    $3,000          $0    $16,851         381.5%
                                                       $0
$18,943       $12,996    $18,996    $6,243     $157,698          53.0%
  2.6%          1.9%       2.7%       1.0%        2.2%




                                                                                             Page 17
        7/11/2011                                            e9598fe7-ade3-4c7c-a333-6c32d6f50f63.xls   Confidential


                                                               1995   Variance
Sep             Oct            Nov            Dec            Total  1994/1995




  $106,250               $0             $0             $0    $106,250          26.5%
        $0               $0             $0             $0     $97,750         -37.7%
          $0             $0             $0             $0     $81,250          24.1%
          $0             $0             $0             $0     $41,939
  $106,250               $0             $0             $0    $327,189           6.8%




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




       $1,000         $1,000         $1,000         $1,000     $9,900          98.0%
          $0             $0             $0          $1,400     $2,200        120.0%
        $450           $450           $450           $450      $2,700
          $0             $0             $0             $0         $0
       $1,450         $1,450         $1,450         $2,850    $14,800        146.7%



        $700           $700           $700           $700      $8,400          68.0%
        $500           $500           $500           $500      $6,000
       $1,200         $1,200         $1,200         $1,200    $14,400          30.9%
                                                                                                           Page 18
   7/11/2011                          e9598fe7-ade3-4c7c-a333-6c32d6f50f63.xls   Confidential




$139,000       $250   $250   $1,650   $389,339          29.2%
  18.7%        0.0%   0.0%    0.3%       5.5%




                                                                                    Page 19
  7/11/2011                                    e9598fe7-ade3-4c7c-a333-6c32d6f50f63.xls   Confidential


                                               1995       Variance
Sep           Oct        Nov        Dec        Total      1994/1995




$31,250             $0         $0         $0    $31,250          22.5%
     $0             $0         $0         $0    $36,220          11.6%
      $0            $0         $0         $0    $97,560           9.0%
 $5,415             $0         $0         $0    $16,245          30.1%
 $3,200             $0         $0         $0     $3,200          33.3%
 $3,750             $0         $0         $0    $10,750          92.0%
 $2,650             $0         $0         $0     $7,450          55.2%
$46,265             $0         $0         $0   $202,675          17.3%




$13,965             $0         $0   $13,965     $55,860          15.0%
 $1,000             $0         $0    $1,000      $4,000           6.7%
      $0            $0         $0         $0    $20,000           8.0%
  $950              $0         $0     $950       $3,800          58.3%
$32,500             $0   $3,000           $0    $44,500        641.7%
 $1,800             $0         $0    $1,800      $7,200          20.0%
$50,215             $0   $3,000     $17,715    $135,360          58.8%



 $4,200             $0         $0    $4,200     $16,800           1.7%
 $3,000             $0         $0    $3,000     $12,000           3.9%
 $1,000             $0         $0    $1,000      $4,000          66.7%
 $1,500             $0         $0    $1,500      $6,000          50.0%
 $9,700             $0         $0    $9,700     $38,800          12.6%




                                                                                             Page 20
   7/11/2011                             e9598fe7-ade3-4c7c-a333-6c32d6f50f63.xls   Confidential

  $2,000        $0       $0     $2,000     $8,000           0.0%
   $500         $0       $0      $500      $2,000          14.3%
   $600         $0       $0      $600      $2,400          20.0%
   $850         $0       $0      $850      $3,400          41.7%
     $0        $650      $0        $0       $650           30.0%
                                              $0
  $3,950       $650      $0     $3,950    $16,450          12.3%


$110,130       $650   $3,000   $31,365   $393,285          28.1%
  14.8%        0.1%    0.4%      5.1%       5.6%




                                                                                       Page 21
  7/11/2011                                    e9598fe7-ade3-4c7c-a333-6c32d6f50f63.xls   Confidential


                                               1995         Variance
Sep           Oct        Nov        Dec        Total        1994/1995




      $0            $0         $0         $0   $25,000           -2.0%
      $0            $0         $0         $0   $25,000           -2.0%




      $0            $0         $0         $0    $2,000            0.0%
      $0            $0         $0         $0    $1,000            0.0%
      $0            $0         $0         $0   $10,000            0.0%
      $0            $0         $0         $0   $10,000            0.0%
      $0            $0         $0         $0    $5,000            0.0%
      $0            $0         $0         $0   $18,000            0.0%
      $0            $0         $0         $0    $2,500            0.0%
      $0            $0         $0         $0    $5,000            0.0%
      $0            $0         $0         $0   $53,500            0.0%



      $0            $0         $0         $0   $15,000            0.0%
      $0            $0         $0         $0    $5,000            0.0%
      $0            $0         $0         $0   $20,000            0.0%



      $0            $0         $0         $0   $60,000            0.0%
                                                       $0
      $0            $0         $0         $0   $60,000            0.0%



$25,000       $25,000    $25,000          $0   $75,000            0.0%
                                                                                             Page 22
  7/11/2011                                  e9598fe7-ade3-4c7c-a333-6c32d6f50f63.xls   Confidential

                                                  $0
$25,000       $25,000    $25,000       $0     $75,000           0.0%



    $0            $0     $25,000       $0     $25,000           0.0%
                                                  $0
    $0            $0     $25,000       $0     $25,000           0.0%



    $0            $0     $25,000   $20,000    $45,000           0.0%
    $0            $0     $25,000   $10,000    $35,000           0.0%
    $0            $0     $50,000   $30,000    $80,000           0.0%



$25,000       $25,000   $100,000   $30,000   $338,500          -0.1%
  3.4%          3.7%      14.2%      4.9%       4.8%




                                                                                           Page 23
  7/11/2011                                    e9598fe7-ade3-4c7c-a333-6c32d6f50f63.xls   Confidential


                                               1995       Variance
Sep           Oct         Nov      Dec         Total      1994/1995


$1,500        $1,500        $250     $250      $10,500           87.5%
  $200          $200        $200     $200       $2,400           20.0%
$4,000        $4,000      $4,000   $4,000      $48,000           37.1%
  $500              $0      $500         $0     $6,000           20.0%
$1,000          $500        $500     $500       $7,000          -30.0%
  $750          $250        $250     $250       $4,000           14.3%
      $75           $75     $75          $75    $4,600            2.2%
  $100          $100        $100     $100       $1,200          -52.0%


$8,125        $6,625      $5,875   $5,375      $83,700           22.9%
  1.1%          1.0%        0.8%     0.9%         1.2%




                                                                                             Page 24
        7/11/2011                                                     e9598fe7-ade3-4c7c-a333-6c32d6f50f63.xls   Confidential


                                                                      1995       Variance
      Sep               Oct           Nov                 Dec         Total      1994/1995


            $45               $45            $45                $45      $540           20.0%
        $218                  $0              $0            $218         $872           46.6%
        $873                  $0              $0            $873        $3,492          -8.1%
       $1,136                 $45            $45           $1,136       $4,904           1.2%



       $1,280            $1,280            $1,280          $1,280      $15,360           6.7%
       $1,008            $1,008            $1,008          $1,008      $12,096          33.3%
       $3,840            $3,840            $3,840          $3,840      $46,080           6.7%
       $5,680            $5,680            $5,680          $5,680      $68,160           6.7%
        $240              $240              $240            $240        $2,880          14.3%
      $12,048           $12,048           $12,048         $12,048     $144,576           8.6%




                                                                        1995   Variance
Sep               Oct               Nov             Dec               Total  1994/1995
       $1,993            $1,993            $3,493          $1,993      $34,416          58.2%
        $231              $231              $231            $231        $2,772          57.9%
        $117              $117              $117            $117        $1,404          17.0%
       $3,267             $267              $267            $267        $9,204          98.7%
        $100              $100              $100            $100        $1,200         -70.0%
       $5,708            $2,708            $4,208          $2,708      $48,996          46.9%


                                                                        1995   Variance
Sep               Oct               Nov             Dec               Total  1994/1995
                                                                                                                    Page 25
        7/11/2011                                               e9598fe7-ade3-4c7c-a333-6c32d6f50f63.xls   Confidential

        $117            $117            $117            $117     $11,404          14.0%
       $2,287         $17,287          $2,287          $2,287    $91,444          -6.1%
       $1,510          $1,510          $1,510          $1,510    $38,120           0.2%
      $11,042          $1,042          $1,042          $1,042    $35,504          18.7%
       $2,047          $2,047          $2,047          $2,047    $43,564           5.1%
      $17,003         $22,003          $7,003          $7,003   $220,036           1.5%



                                                                  1995   Variance
Sep             Oct             Nov             Dec             Total  1994/1995
      $35,895         $36,804         $23,304         $22,895   $418,512           7.8%
        4.8%            5.5%            3.3%            3.7%       5.9%




                                                                                                              Page 26
      7/11/2011                                        e9598fe7-ade3-4c7c-a333-6c32d6f50f63.xls   Confidential


                                                         1995   Variance
Sep          Oct          Nov             Dec          Total  1994/1995

        $0          $0           $2,000          $0     $6,000           11.1%
        $0          $0             $50           $0       $150            0.0%
        $0          $0          $10,000          $0    $30,000          -36.2%
        $0          $0            $200           $0       $600
        $0          $0            $350           $0     $1,050            0.0%
        $0          $0            $125           $0       $375          -11.8%
        $0          $0             $45           $0       $135           42.1%
        $0          $0             $15           $0        $45            0.0%
        $0          $0            $200           $0       $600            4.3%
        $0          $0           $1,200          $0     $3,600          -25.0%
        $0          $0           $2,400          $0     $7,200           47.7%
        $0          $0             $35           $0       $105            7.1%
        $0          $0            $540           $0     $1,620           17.8%
        $0          $0            $850           $0     $2,550           13.3%
        $0          $0           $1,100          $0     $3,300            5.6%
        $0          $0           $1,800          $0     $5,400           10.3%
        $0          $0            $600           $0     $1,800            2.0%
        $0          $0             $75           $0       $225           13.6%
        $0          $0              $0           $0         $0
        $0          $0            $460           $0     $1,380            8.2%
        $0          $0              $0           $0
        $0          $0          $22,045          $0    $66,135          -17.1%
      0.0%         0.0%           3.1%          0.0%      0.9%




                                                                                                     Page 27
   7/11/2011                                      e9598fe7-ade3-4c7c-a333-6c32d6f50f63.xls   Confidential




$670,000       $705,000   $618,000   $7,050,000
                                      1995
 Oct           Nov        Dec         Total
 $47,890        $47,890    $47,890    $691,480
 $12,996        $18,996     $6,243    $157,698
   $250           $250      $1,650    $389,339
   $650          $3,000    $31,365    $393,285
 $25,000       $100,000    $30,000    $338,500
  $6,625         $5,875     $5,375     $83,700
 $36,804        $23,304    $22,895    $418,512
       $0       $22,045         $0     $66,135


$130,215       $221,360   $145,418   $2,538,649
    19%            31%        24%          36%




                                                                                                Page 28

								
To top