professional documents
home
Upload
docsters
Upload
1/30/2008 $ASQMarketingBudget[2].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 Media Publication 1 $259,776 $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 Publication 3 $0 $27,000 $0 $0 $0 $0 Publication 4 $0 $0 $0 $9,300 $0 $0 Publication 5 $0 $0 $0 $0 $0 $0 Publication 6 $0 $0 $0 $0 $0 $0 Publication 7 $0 $0 $0 $0 $0 $0 Publication 8 $0 $0 $0 $0 $0 $0 Publication 9 $0 $0 $0 $0 $0 $0 $11,500 Publication 10 $0 $0 $0 $0 $0 $0 Publication 11 $0 $0 $0 $0 $0 $0 Page 11/30/2008 $ASQMarketingBudget[2].xls Confidential Publication 12 $0 $0 $0 $0 $0 $0 Publication 13 $0 $0 $0 $0 $0 $0 Publication 14 $62,000 $0 $0 $0 $0 $31,000 Total Media $595,376 $73,540 $46,540 $55,840 $46,540 $77,540 $58,040 Artwork & Production Design (12 Ads) $21,000 $0 $10,500 $0 $12,500 $0 Layout/DTP $2,800 $250 $250 $250 $250 $250 Copywriting $1,250 $0 $0 $0 $0 $0 Mechanical Artwork $500 $0 $0 $0 $0 $0 Typography $500 $0 $0 $0 $0 $0 Lino $700 $100 $100 $100 $100 $100 Separations (12 ads) $12,000 $0 $5,000 $0 $5,000 $0 Photography $4,800 $0 $0 $2,500 $0 $0 $2,500 Miscellaneous $10,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 Total Advertising $648,926 $74,890 $63,390 $59,690 $65,390 $78,890 $61,890 Percentage of Sales 14.8% 12.3% 11.6% 14.6% 16.9% Page 21/30/2008 $ASQMarketingBudget[2].xls Confidential Catalog Budget 1994 Catalog Total Jan Feb Mar Apr May Jun Catalog 1 $4,574 $0 $2,292 $0 $0 $0 Catalog 2 $20,480 $7,470 $0 $6,000 $0 $0 Catalog 3 $0 $0 $0 $4,000 $0 $3,000 Catalog 4 $74,528 $12,996 $6,243 $12,996 $6,243 $6,243 $6,243 Catalog 5 $3,500 $1,851 $0 $3,000 $0 $3,000 Total Catalogs $103,082 $22,317 $8,535 $25,996 $6,243 $12,243 $6,243 Percentage of Sales 4.4% 1.7% 5.0% 1.4% 2.6% Page 31/30/2008 $ASQMarketingBudget[2].xls Confidential Direct Mail Budget 1994 Direct Mail Total Jan Feb Mar Apr May Jun Installed Consumer Base Product Line Upsell $84,000 $0 $0 $0 $0 $0 New Product Upsell $156,890 $0 $0 $0 $0 $0 $97,750 Newsletter $65,450 $0 $0 $0 $0 $0 Upgrade Re-Mail $41,939 $0 $0 $0 $0 Installed Customer Total $306,340 $41,939 $0 $0 $0 $0 $97,750 Outside List Source 1 Post Card $0 $0 $16,250 $0 $0 Source 2 Post Card $0 $0 $0 $0 $0 $13,000 Source 3 Post Card $0 $0 $0 $0 $0 Outside List Total $0 $0 $0 $16,250 $0 $0 $13,000 Mailing List Management Registration Card Data Entry $5,000 $650 $650 $650 $650 $650 MIS Time -Reports $1,000 $0 $0 $0 $0 $800 Mailing List Rental Fees $0 $0 $0 $0 $0 Miscellaneous $0 $0 $0 $0 $0 Mailing List Mgmt. Total $6,000 $650 $650 $650 $650 $1,450 Mailing List Income Rental to [Company] $5,000 $700 $700 $700 $700 $700 Rental to [Company] $500 $500 $500 $500 $500 Page 41/30/2008 $ASQMarketingBudget[2].xls Confidential Mailing List Income Total $11,000 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 [ ] 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 Percentage of Sales 8.2% -0.1% 3.0% -0.1% 0.1% Page 51/30/2008 $ASQMarketingBudget[2].xls Confidential Literature Budget 1994 Literature Total Jan Feb Mar Apr May Jun Collateral Corporate Brochure-Printing $25,500 $0 $0 $0 $0 $0 Mini Catalog-Printing $32,450 $0 $0 $0 $0 $0 $36,220 Product Brochures-Printing $89,520 $0 $0 $0 $0 $0 Photography $12,485 $0 $0 $0 $0 $0 $5,415 Copywriter $2,400 $0 $0 $0 $0 $0 Design & Mechanicals $5,600 $0 $0 $0 $0 $0 $3,500 Separations $4,800 $0 $0 $0 $0 $0 $2,400 Collateral Total $172,755 $0 $0 $0 $0 $0 $47,535 Product Packaging Boxes $48,575 $0 $0 $13,965 $0 $0 $13,965 Stickers $3,750 $0 $0 $1,000 $0 $0 $1,000 Photography $18,520 $0 $20,000 $0 $0 $0 Copywriter $2,400 $0 $0 $950 $0 $0 Design & Mechanicals $6,000 $0 $3,000 $0 $0 $3,000 Separations $6,000 $0 $0 $1,800 $0 $0 $1,800 Product Packaging Total $85,245 $0 $23,000 $17,715 $0 $3,000 $17,715 Merchandising Flyers $16,515 $0 $0 $4,200 $0 $0 $4,200 Coupons $11,545 $0 $0 $3,000 $0 $0 Copywriter $2,400 $0 $0 $1,000 $0 $0 $1,000 Design & Mechanicals $4,000 $0 $0 $1,500 $0 $0 $1,500 Merchandising Total $34,460 $0 $0 $9,700 $0 $0 $9,700 Page 61/30/2008 $ASQMarketingBudget[2].xls Confidential Miscellaneous Ad & Editorial Reprints $8,000 $0 $0 $2,000 $0 $0 $2,000 Registration Cards $1,750 $0 $0 $500 $0 $0 Business Cards $2,000 $0 $0 $600 $0 $0 Training Materials $2,400 $0 $0 $850 $0 $0 Christmas Cards $500 $0 $0 $0 $0 $0 Miscellaneous Total $14,650 $0 $0 $3,950 $0 $0 $3,950 Total Literature $307,110 $0 $23,000 $31,365 $0 $3,000 $78,900 Percentage of Sales 0.0% 4.5% 6.1% 0.0% 0.6% Page 71/30/2008 $ASQMarketingBudget[2].xls Confidential Product Launch Budget 1994 Product Launch Total Jan Feb Mar Apr May Jun Public Relations Press Review Kits $25,500 $0 $0 $0 $0 $25,000 Public Relations Total $25,500 $0 $0 $0 $0 $25,000 Sales Collateral Copy & Design $2,000 $0 $0 $0 $0 $0 Photoshoot & Supply of Film $1,000 $0 $0 $0 $0 $0 Product Pkg. Design & Film $10,000 $0 $0 $0 $0 $0 Product Brochure $10,000 $0 $0 $0 $0 $0 Direct Mail Reg. Card piece $5,000 $0 $0 $0 $0 $0 Mini Catalog $18,000 $0 $0 $0 $0 $0 Ad/Editorial Reprints $2,500 $0 $0 $0 $0 $0 Merchandising $5,000 $0 $0 $0 $0 $0 Sales Collateral Total $53,500 $0 $0 $0 $0 $0 Trade Shows Targeted Industry Shows $15,000 $0 $0 $0 $0 $5,000 $5,000 Other Shows $5,000 $0 $0 $0 $0 $0 $5,000 Merchandising Total $20,000 $0 $0 $0 $0 $5,000 $10,000 Advertising Targeting Publications $60,000 $0 $10,000 $10,000 $10,000 $10,000 $10,000 Advertising Total $60,000 $0 $10,000 $10,000 $10,000 $10,000 $10,000 Direct Mail Page 81/30/2008 $ASQMarketingBudget[2].xls Confidential Design, printing, postage $75,000 $0 $0 $0 $0 $0 Direct Mail Total $75,000 $0 $0 $0 $0 $0 Mail Order Catalogs Catalog 1 $25,000 $0 $0 $0 $0 $0 Direct Mail Total $25,000 $0 $0 $0 $0 $0 Reseller Promotions ROP Ads $45,000 $0 $0 $0 $0 $0 End Caps $35,000 $0 $0 $0 $0 $0 Direct Mail Total $80,000 $0 $0 $0 $0 $0 Total Product Launch $339,000 $0 $10,000 $10,000 $10,000 $40,000 $20,000 Percentage of Sales 0.0% 1.9% 1.9% 2.2% 8.5% Page 91/30/2008 $ASQMarketingBudget[2].xls Confidential Public Relations Budget 1994 Public Relations Total Jan Feb Mar Apr May Jun Free Shipping $5,600 $1,500 $250 $250 $250 $1,500 $1,500 Bacon,s Clipping Service $2,000 $200 $200 $200 $200 $200 Consultant's Fees $35,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 Consultant's Expenses $5,000 $500 $500 $0 $1,500 $500 Evaluation Units $10,000 $500 $500 $500 $500 $1,000 P.R. Production $3,500 $250 $250 $250 $250 $250 Product Photos $4,500 $2,500 $75 $75 $500 $75 Miscellaneous $2,500 $100 $100 $100 $100 $100 Total Public Relations $68,100 $9,550 $5,875 $5,375 $7,300 $7,625 $7,050 Percentage of Sales 1.9% 1.1% 1.0% 1.6% 1.6% Page 101/30/2008 $ASQMarketingBudget[2].xls Confidential Resellers Budget 1994 Resellers Total Jan Feb Mar Apr May Jun Merchandising Collateral (includes production costs) Replenishment Reports $450 $45 $45 $45 $45 $45 Flyers $595 $0 $0 $218 $0 $0 Special Materials $3,800 $0 $0 $873 $0 $0 Collateral Total $4,845 $45 $45 $1,136 $45 $45 $1,136 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 Chain Store 2 $9,072 $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 Chain Store 4 $63,900 $5,680 $5,680 $5,680 $5,680 $5,680 $5,680 Chain Store 5 $2,520 $240 $240 $240 $240 $240 Services Total $133,092 $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 Distributor 1 $21,754 $4,993 $4,993 $4,993 $1,993 $1,993 $1,993 Distributor 2 $1,756 $231 $231 $231 $231 $231 Distributor 3 $1,200 $117 $117 $117 $117 $117 Distributor 4 $4,633 $267 $267 $267 $267 $267 $3,267 Distributor 5 $4,000 $100 $100 $100 $100 $100 Distributors Total $33,343 $5,708 $5,708 $5,708 $2,708 $2,708 $5,708 1994 Page 111/30/2008 $ASQMarketingBudget[2].xls Confidential Retailers Total Jan Feb Mar Apr May Jun Retailer 1 $10,000 $117 $8,117 $117 $117 $117 Retailer 2 $97,350 $2,287 $2,287 $41,287 $2,287 $2,287 $12,287 Retailer 3 $38,042 $1,510 $1,510 $1,510 $21,510 $1,510 $1,510 Retailer 4 $29,915 $1,042 $1,042 $1,042 $1,042 $11,042 $4,042 Retailer 5 $41,469 $13,047 $2,047 $2,047 $2,047 $2,047 $2,047 Retailers Total $216,776 $18,003 $15,003 $46,003 $27,003 $17,003 $20,003 1994 Total Jan Feb Mar Apr May Jun Total Resellers $388,056 $35,804 $32,804 $64,895 $41,804 $31,804 $38,895 Percentage of Sales 7.1% 6.4% 12.6% 9.3% 6.8% Page 121/30/2008 $ASQMarketingBudget[2].xls Confidential Trade Show Budget 1994 Trade Shows Total Jan Feb Mar Apr May Jun Air Fare $5,400 $2,000 $0 $0 $2,000 $0 Badges $150 $50 $0 $0 $50 $0 Booth Space $47,000 $10,000 $0 $0 $10,000 $0 Candy $0 $200 $0 $0 $200 $0 Carpeting & Padding $1,050 $350 $0 $0 $350 $0 Cleaning & Repair Services $425 $125 $0 $0 $125 $0 Faxing & Copying $95 $45 $0 $0 $45 $0 Film $45 $15 $0 $0 $15 $0 Furniture $575 $200 $0 $0 $200 $0 Giveaways $4,800 $1,200 $0 $0 $1,200 $0 Hotel $4,875 $2,400 $0 $0 $2,400 $0 Lead Forms $98 $35 $0 $0 $35 $0 Meals $1,375 $540 $0 $0 $540 $0 Post Card Invitations $2,250 $850 $0 $0 $850 $0 Press Kits $3,125 $1,100 $0 $0 $1,100 $0 Shipping $4,895 $1,800 $0 $0 $1,800 $0 Signage $1,765 $600 $0 $0 $600 $0 Transportation $198 $75 $0 $0 $75 $0 Uniforms $425 $0 $0 $0 $0 $0 Utilities $1,275 $460 $0 $0 $460 $0 $0 $0 $0 $0 $0 Total Trade Shows $79,821 $22,045 $0 $0 $22,045 $0 Percentage of Sales 4.4% 0.0% 0.0% 4.9% 0.0% Page 131/30/2008 $ASQMarketingBudget[2].xls Confidential Advertising & Promotions Budget Summary Sales Forecast $506,000 $516,000 $515,000 $449,000 $468,000 $615,000 $600,000 Category Jan Feb Mar Apr May Jun Jul Advertising $74,890 $63,390 $59,690 $65,390 $78,890 $61,890 $47,890 Catalogs $22,317 $8,535 $25,996 $6,243 $12,243 $6,243 $12,700 Direct Mail $41,389 ($550) $15,700 ($550) $250 $110,200 Literature $0 $23,000 $31,365 $0 $3,000 $78,900 Product Launch $0 $10,000 $10,000 $10,000 $40,000 $20,000 $68,500 Public Relations $9,550 $5,875 $5,375 $7,300 $7,625 $7,050 $7,625 Resellers $35,804 $32,804 $64,895 $41,804 $31,804 $38,895 $23,804 Trade Shows $22,045 $0 $0 $22,045 $0 $0 Grand Total A & P $205,995 $143,054 $213,021 $152,232 $173,812 $323,178 $160,769 % of Sales 41% 28% 41% 34% 37% 53% Page 141/30/2008 $ASQMarketingBudget[2].xls Confidential 1995 Variance Aug Sep Oct Nov Dec Total 1994/1995 $18,040 $18,040 $18,040 $18,040 $18,040 $216,480 -16.7% $28,500 $28,500 $28,500 $28,500 $28,500 $342,000 25.0% $0 $0 $0 $0 $0 $27,000 $0 $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 $0 $0 $0 $0 $0 $11,500 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Page 151/30/2008 $ASQMarketingBudget[2].xls Confidential $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $31,000 -50.0% $0 $46,540 $46,540 $46,540 $46,540 $46,540 $637,280 7.0% $0 $0 $0 $0 $0 $23,000 9.5% $250 $250 $250 $250 $250 $3,000 7.1% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $100 $100 $100 $100 $100 $1,200 71.4% $0 $0 $0 $0 $0 $10,000 -16.7% $0 $0 $0 $0 $0 $5,000 4.2% $1,000 $1,000 $1,000 $1,000 $1,000 $12,000 20.0% $0 $1,350 $1,350 $1,350 $1,350 $1,350 $54,200 1.2% $47,890 $47,890 $47,890 $47,890 $47,890 $691,480 6.6% 7.4% 6.5% 7.1% 6.8% 7.7% 9.8% Page 161/30/2008 $ASQMarketingBudget[2].xls Confidential 1995 Variance Aug Sep Oct Nov Dec Total 1994/1995 $0 $0 $0 $0 $0 $2,292 -49.9% $0 $6,700 $0 $0 $0 $26,870 31.2% $0 $3,000 $0 $3,000 $0 $16,000 $6,243 $6,243 $12,996 $12,996 $6,243 $95,685 28.4% $0 $3,000 $0 $3,000 $0 $16,851 381.5% $0 $6,243 $18,943 $12,996 $18,996 $6,243 $157,698 53.0% 1.0% 2.6% 1.9% 2.7% 1.0% 2.2% Page 171/30/2008 $ASQMarketingBudget[2].xls Confidential 1995 Variance Aug Sep Oct Nov Dec Total 1994/1995 $0 $106,250 $0 $0 $0 $106,250 26.5% $0 $0 $0 $0 $0 $97,750 -37.7% $81,250 $0 $0 $0 $0 $81,250 24.1% $0 $0 $0 $0 $0 $41,939 $81,250 $106,250 $0 $0 $0 $327,189 6.8% $0 $0 $0 $0 $0 $16,250 $0 $0 $0 $0 $0 $13,000 $0 $32,500 $0 $0 $0 $32,500 $0 $0 $32,500 $0 $0 $0 $61,750 $1,000 $1,000 $1,000 $1,000 $1,000 $9,900 98.0% $0 $0 $0 $0 $1,400 $2,200 120.0% $450 $450 $450 $450 $450 $2,700 $0 $0 $0 $0 $0 $0 $1,450 $1,450 $1,450 $1,450 $2,850 $14,800 146.7% $700 $700 $700 $700 $700 $8,400 68.0% $500 $500 $500 $500 $500 $6,000 Page 181/30/2008 $ASQMarketingBudget[2].xls Confidential $1,200 $1,200 $1,200 $1,200 $1,200 $14,400 30.9% $81,500 $139,000 $250 $250 $1,650 $389,339 29.2% 12.6% 18.7% 0.0% 0.0% 0.3% 5.5% Page 191/30/2008 $ASQMarketingBudget[2].xls Confidential 1995 Variance Aug Sep Oct Nov Dec Total 1994/1995 $0 $31,250 $0 $0 $0 $31,250 22.5% $0 $0 $0 $0 $0 $36,220 11.6% $97,560 $0 $0 $0 $0 $97,560 9.0% $5,415 $5,415 $0 $0 $0 $16,245 30.1% $0 $3,200 $0 $0 $0 $3,200 33.3% $3,500 $3,750 $0 $0 $0 $10,750 92.0% $2,400 $2,650 $0 $0 $0 $7,450 55.2% $108,875 $46,265 $0 $0 $0 $202,675 17.3% $0 $13,965 $0 $0 $13,965 $55,860 15.0% $0 $1,000 $0 $0 $1,000 $4,000 6.7% $0 $0 $0 $0 $0 $20,000 8.0% $0 $950 $0 $0 $950 $3,800 58.3% $3,000 $32,500 $0 $3,000 $0 $44,500 641.7% $0 $1,800 $0 $0 $1,800 $7,200 20.0% $3,000 $50,215 $0 $3,000 $17,715 $135,360 58.8% $0 $4,200 $0 $0 $4,200 $16,800 1.7% $0 $3,000 $0 $0 $3,000 $12,000 3.9% $0 $1,000 $0 $0 $1,000 $4,000 66.7% $0 $1,500 $0 $0 $1,500 $6,000 50.0% $0 $9,700 $0 $0 $9,700 $38,800 12.6% Page 201/30/2008 $ASQMarketingBudget[2].xls Confidential $0 $2,000 $0 $0 $2,000 $8,000 0.0% $0 $500 $0 $0 $500 $2,000 14.3% $0 $600 $0 $0 $600 $2,400 20.0% $0 $850 $0 $0 $850 $3,400 41.7% $0 $0 $650 $0 $0 $650 30.0% $0 $0 $3,950 $650 $0 $3,950 $16,450 12.3% $111,875 $110,130 $650 $3,000 $31,365 $393,285 28.1% 17.3% 14.8% 0.1% 0.4% 5.1% 5.6% Page 211/30/2008 $ASQMarketingBudget[2].xls Confidential 1995 Variance Aug Sep Oct Nov Dec Total 1994/1995 $0 $0 $0 $0 $0 $25,000 -2.0% $0 $0 $0 $0 $0 $25,000 -2.0% $0 $0 $0 $0 $0 $2,000 0.0% $0 $0 $0 $0 $0 $1,000 0.0% $0 $0 $0 $0 $0 $10,000 0.0% $0 $0 $0 $0 $0 $10,000 0.0% $0 $0 $0 $0 $0 $5,000 0.0% $0 $0 $0 $0 $0 $18,000 0.0% $0 $0 $0 $0 $0 $2,500 0.0% $0 $0 $0 $0 $0 $5,000 0.0% $0 $0 $0 $0 $0 $53,500 0.0% $0 $0 $0 $0 $0 $15,000 0.0% $0 $0 $0 $0 $0 $5,000 0.0% $0 $0 $0 $0 $0 $20,000 0.0% $0 $0 $0 $0 $0 $60,000 0.0% $0 $0 $0 $0 $0 $0 $60,000 0.0% Page 221/30/2008 $ASQMarketingBudget[2].xls Confidential $0 $25,000 $25,000 $25,000 $0 $75,000 0.0% $0 $0 $25,000 $25,000 $25,000 $0 $75,000 0.0% $0 $0 $0 $25,000 $0 $25,000 0.0% $0 $0 $0 $0 $25,000 $0 $25,000 0.0% $0 $0 $0 $25,000 $20,000 $45,000 0.0% $0 $0 $0 $25,000 $10,000 $35,000 0.0% $0 $0 $0 $50,000 $30,000 $80,000 0.0% $0 $25,000 $25,000 $100,000 $30,000 $338,500 -0.1% 0.0% 3.4% 3.7% 14.2% 4.9% 4.8% Page 231/30/2008 $ASQMarketingBudget[2].xls Confidential 1995 Variance Aug Sep Oct Nov Dec Total 1994/1995 $250 $1,500 $1,500 $250 $250 $10,500 87.5% $200 $200 $200 $200 $200 $2,400 20.0% $4,000 $4,000 $4,000 $4,000 $4,000 $48,000 37.1% $1,500 $500 $0 $500 $0 $6,000 20.0% $500 $1,000 $500 $500 $500 $7,000 -30.0% $250 $750 $250 $250 $250 $4,000 14.3% $500 $75 $75 $75 $75 $4,600 2.2% $100 $100 $100 $100 $100 $1,200 -52.0% $7,300 $8,125 $6,625 $5,875 $5,375 $83,700 22.9% 1.1% 1.1% 1.0% 0.8% 0.9% 1.2% Page 241/30/2008 $ASQMarketingBudget[2].xls Confidential 1995 Variance Aug Sep Oct Nov Dec Total 1994/1995 $45 $45 $45 $45 $45 $540 20.0% $0 $218 $0 $0 $218 $872 46.6% $0 $873 $0 $0 $873 $3,492 -8.1% $45 $1,136 $45 $45 $1,136 $4,904 1.2% $1,280 $1,280 $1,280 $1,280 $1,280 $15,360 6.7% $1,008 $1,008 $1,008 $1,008 $1,008 $12,096 33.3% $3,840 $3,840 $3,840 $3,840 $3,840 $46,080 6.7% $5,680 $5,680 $5,680 $5,680 $5,680 $68,160 6.7% $240 $240 $240 $240 $240 $2,880 14.3% $12,048 $12,048 $12,048 $12,048 $12,048 $144,576 8.6% fee is generally less than 5%. the appropriate months. 1995 Variance Aug Sep Oct Nov Dec Total 1994/1995 $1,993 $1,993 $1,993 $3,493 $1,993 $34,416 58.2% $231 $231 $231 $231 $231 $2,772 57.9% $117 $117 $117 $117 $117 $1,404 17.0% $267 $3,267 $267 $267 $267 $9,204 98.7% $100 $100 $100 $100 $100 $1,200 -70.0% $2,708 $5,708 $2,708 $4,208 $2,708 $48,996 46.9% 1995 Variance Page 251/30/2008 $ASQMarketingBudget[2].xls Confidential Aug Sep Oct Nov Dec Total 1994/1995 $117 $117 $117 $117 $117 $11,404 14.0% $2,287 $2,287 $17,287 $2,287 $2,287 $91,444 -6.1% $1,510 $1,510 $1,510 $1,510 $1,510 $38,120 0.2% $1,042 $11,042 $1,042 $1,042 $1,042 $35,504 18.7% $10,047 $2,047 $2,047 $2,047 $2,047 $43,564 5.1% $15,003 $17,003 $22,003 $7,003 $7,003 $220,036 1.5% 1995 Variance Aug Sep Oct Nov Dec Total 1994/1995 $29,804 $35,895 $36,804 $23,304 $22,895 $418,512 7.8% 4.6% 4.8% 5.5% 3.3% 3.7% 5.9% Page 261/30/2008 $ASQMarketingBudget[2].xls Confidential 1995 Variance Aug Sep Oct Nov Dec Total 1994/1995 $0 $0 $0 $2,000 $0 $6,000 11.1% $0 $0 $0 $50 $0 $150 0.0% $0 $0 $0 $10,000 $0 $30,000 -36.2% $0 $0 $0 $200 $0 $600 $0 $0 $0 $350 $0 $1,050 0.0% $0 $0 $0 $125 $0 $375 -11.8% $0 $0 $0 $45 $0 $135 42.1% $0 $0 $0 $15 $0 $45 0.0% $0 $0 $0 $200 $0 $600 4.3% $0 $0 $0 $1,200 $0 $3,600 -25.0% $0 $0 $0 $2,400 $0 $7,200 47.7% $0 $0 $0 $35 $0 $105 7.1% $0 $0 $0 $540 $0 $1,620 17.8% $0 $0 $0 $850 $0 $2,550 13.3% $0 $0 $0 $1,100 $0 $3,300 5.6% $0 $0 $0 $1,800 $0 $5,400 10.3% $0 $0 $0 $600 $0 $1,800 2.0% $0 $0 $0 $75 $0 $225 13.6% $0 $0 $0 $0 $0 $0 $0 $0 $0 $460 $0 $1,380 8.2% $0 $0 $0 $0 $0 $0 $0 $0 $22,045 $0 $66,135 -17.1% 0.0% 0.0% 0.0% 3.1% 0.0% 0.9% Page 271/30/2008 $ASQMarketingBudget[2].xls Confidential $742,000 $670,000 $705,000 $618,000 $7,050,000 1995 Sep Oct Nov Dec Total $47,890 $47,890 $47,890 $47,890 $691,480 $18,943 $12,996 $18,996 $6,243 $157,698 $139,000 $250 $250 $1,650 $389,339 $110,130 $650 $3,000 $31,365 $393,285 $25,000 $25,000 $100,000 $30,000 $338,500 $8,125 $6,625 $5,875 $5,375 $83,700 $35,895 $36,804 $23,304 $22,895 $418,512 $0 $0 $22,045 $0 $66,135 $384,983 $130,215 $221,360 $145,418 $2,538,649 52% 19% 31% 24% 36% Page 28
flag this doc
33
2
not rated
0
1/21/2008
English
Preview

Project_Templates[2]

balazon 1/8/2008 | 778 | 114 | 0 | creative
Preview

Financial History and Ratios1[2]

lizzybee27925 1/21/2008 | 41 | 0 | 0 | financial
Preview

MarketingBudget

vinutha 1/8/2008 | 142 | 5 | 0 | business
Preview

Free Business Templates - Personal Financial Statement

anonymous 12/7/2007 | 2938 | 95 | 0 | business
Preview

Business Plan Templates

PastorGallo 9/11/2008 | 250 | 15 | 0 | business
Preview

CompetitorPricingHistory[2]

lizzybee27925 1/21/2008 | 27 | 1 | 0 | financial
Preview

FinancialStatement[2]

lizzybee27925 1/21/2008 | 39 | 3 | 0 | financial
Preview

YearEndTaxPlan[2]

lizzybee27925 1/21/2008 | 44 | 2 | 0 | financial
Preview

SalesofCompetitors[2]

lizzybee27925 1/21/2008 | 22 | 1 | 0 | financial
Preview

Balanced_Scorecard_Templates

balazon 1/8/2008 | 500 | 97 | 0 | financial
Preview

Start-up Expenses1[2]

lizzybee27925 1/21/2008 | 23 | 0 | 0 | financial
Preview

401K Reallocation Planner[2]

lizzybee27925 1/21/2008 | 90 | 0 | 0 | financial
Preview

amortization table[2]

lizzybee27925 1/21/2008 | 135 | 8 | 0 | financial
Preview

equipment-tracking[2]

lizzybee27925 1/21/2008 | 86 | 5 | 0 | financial
Preview

Finance Examples[2]

lizzybee27925 1/21/2008 | 102 | 2 | 0 | financial
Preview

YearEndTaxPlan[2]

lizzybee27925 1/21/2008 | 44 | 2 | 0 | financial
Preview

workbreakdown

lizzybee27925 1/21/2008 | 445 | 96 | 1 | financial
Preview

What-If Analysis Template[1]

lizzybee27925 1/21/2008 | 271 | 79 | 1 | financial
Preview

what if model

lizzybee27925 1/21/2008 | 225 | 37 | 0 | financial
Preview

weighted avg cost

lizzybee27925 1/21/2008 | 183 | 14 | 0 | financial
Preview

weighted average cost

lizzybee27925 1/21/2008 | 218 | 14 | 0 | financial
Preview

vertical analysis

lizzybee27925 1/21/2008 | 227 | 19 | 0 | financial
Preview

valuation model

lizzybee27925 1/21/2008 | 337 | 19 | 0 | financial
Preview

transport management

lizzybee27925 1/21/2008 | 260 | 8 | 1 | financial
Preview

timesheet-template[1]

lizzybee27925 1/21/2008 | 385 | 24 | 0 | financial
 
review this doc