ANNUAL BUDGET FORECAST - 5 PROFIT CENTERS
Site Site 1 Salaries Supplies Equipment Lease Pmts Advertising Other Operating Exp Month 1 $31,175 10000 3000 4575 9600 2500 1500 Month 2 $30,675 10000 2500 4575 9600 2500 1500 Month 3 $31,175 10000 3000 4575 9600 2500 1500 Q1 $93,025 30000 8500 13725 28800 7500 4500 Month 4 $31,175 10000 2500 4575 9600 2500 2000 Month 5 $32,075 10000 3000 4575 9600 2500 2400 Month 6 $34,375 13000 2500 4575 9600 2500 2200 Q2 $97,625 33000 8000 13725 28800 7500 6600 S1 $190,650 63000 16500 27450 57600 15000 11100 Month 7 $34,175 12000 3300 4575 9600 2500 2200 Month 8 $34,150 12000 2800 4575 9600 2500 2675 Month 9 $34,775 12000 3300 4575 9600 2500 2800 Q3 $103,100 36000 9400 13725 28800 7500 7675 Month 10 $34,675 12000 2800 4575 9600 2500 3200 Month 11 $35,575 12000 3300 4575 9600 2500 3600 Month 12 $35,575 12000 2800 4575 9600 2500 4100 Q4 $105,825 36000 8900 13725 28800 7500 10900 S2 $208,925 72000 18300 27450 57600 15000 18575 Year $399,575 135000 34800 54900 115200 30000 29675
Site 2 Salaries Supplies Equipment Lease Pmts Advertising Other
$29,700 7500 2000 8000 8200 2500 1500
$29,700 7500 2000 8000 8200 2500 1500
$29,700 7500 2000 8000 8200 2500 1500
$89,100 22500 6000 24000 24600 7500 4500
$30,200 7500 2000 8000 8200 2500 2000
$25,800 7500 2000 2700 8200 3000 2400
$28,100 10000 2000 2700 8200 3000 2200
$84,100 25000 6000 13400 24600 8500 6600
$173,200 47500 12000 37400 49200 16000 11100
$25,100 7500 2000 2700 8200 2500 2200
$25,575 7500 2000 2700 8200 2500 2675
$25,700 7500 2000 2700 8200 2500 2800
$76,375 22500 6000 8100 24600 7500 7675
$26,100 7500 2000 2700 8200 2500 3200
$27,000 7500 2500 2700 8200 2500 3600
$27,500 7500 2500 2700 8200 2500 4100
$80,600 22500 7000 8100 24600 7500 10900
$156,975 45000 13000 16200 49200 15000 18575
$330,175 92500 25000 53600 98400 31000 29675
Site 3 Salaries Supplies Equipment Lease Pmts Advertising Other
$56,000 20000 5000 9500 17000 3000 1500
$56,000 20000 5000 9500 17000 3000 1500
$56,000 20000 5000 9500 17000 3000 1500
$168,000 60000 15000 28500 51000 9000 4500
$60,000 22000 5000 11000 17000 3000 2000
$60,900 22000 5000 11000 17000 3500 2400
$65,700 27000 5000 11000 17000 3500 2200
$186,600 71000 15000 33000 51000 10000 6600
$354,600 131000 30000 61500 102000 19000 11100
$60,700 22000 5000 11000 17000 3500 2200
$61,175 22000 5000 11000 17000 3500 2675
$61,300 22000 5000 11000 17000 3500 2800
$183,175 66000 15000 33000 51000 10500 7675
$61,700 22000 5000 11000 17000 3500 3200
$62,100 22000 5000 11000 17000 3500 3600
$62,600 22000 5000 11000 17000 3500 4100
$186,400 66000 15000 33000 51000 10500 10900
$369,575 132000 30000 66000 102000 21000 18575
$724,175 263000 60000 127500 204000 40000 29675
Site 4 Salaries Supplies Equipment Lease Pmts Advertising Other
$28,500 7700 2100 6500 8500 2200 1500
$28,750 7700 2350 6500 8500 2200 1500
$28,750 7700 2350 6500 8500 2200 1500
$86,000 23100 6800 19500 25500 6600 4500
$29,250 7700 2350 6500 8500 2200 2000
$29,650 7700 2350 6500 8500 2200 2400
$30,100 8350 2350 6500 8500 2200 2200
$89,000 23750 7050 19500 25500 6600 6600
$175,000 46850 13850 39000 51000 13200 11100
$29,450 7700 2350 6500 8500 2200 2200
$29,925 7700 2350 6500 8500 2200 2675
$30,050 7700 2350 6500 8500 2200 2800
$89,425 23100 7050 19500 25500 6600 7675
$30,450 7700 2350 6500 8500 2200 3200
$30,850 7700 2350 6500 8500 2200 3600
$31,350 7700 2350 6500 8500 2200 4100
$92,650 23100 7050 19500 25500 6600 10900
$182,075 46200 14100 39000 51000 13200 18575
$357,075 93050 27950 78000 102000 26400 29675
Site 5 Salaries Supplies Equipment Lease Pmts Advertising Other
$74,450 31500 7450 8000 23550 2450 1500
$74,450 31500 7450 8000 23550 2450 1500
$74,450 31500 7450 8000 23550 2450 1500
$223,350 94500 22350 24000 70650 7350 4500
$76,500 33000 7450 8000 23550 2500 2000
$76,900 33000 7450 8000 23550 2500 2400
$80,700 37000 7450 8000 23550 2500 2200
$234,100 103000 22350 24000 70650 7500 6600
$457,450 197500 44700 48000 141300 14850 11100
$77,625 33000 8200 8100 23550 2575 2200
$80,200 35100 8200 8100 23550 2575 2675
$80,325 35100 8200 8100 23550 2575 2800
$238,150 103200 24600 24300 70650 7725 7675
$80,800 35100 8200 8100 23550 2650 3200
$81,200 35100 8200 8100 23550 2650 3600
$81,700 35100 8200 8100 23550 2650 4100
$243,700 105300 24600 24300 70650 7950 10900
$481,850 208500 49200 48600 141300 15675 18575
$939,300 406000 93900 96600 282600 30525 29675
TOTAL EXPENDITURES Salaries Supplies Equipment Lease Pmts Advertising Other
$219,825 76700 19550 36575 66850 12650 7500
$219,575 76700 19300 36575 66850 12650 7500
$220,075 76700 19800 36575 66850 12650 7500
$659,475 230100 58650 109725 200550 37950 22500
$227,125 80200 19300 38075 66850 12700 10000
$225,325 80200 19800 32775 66850 13700 12000
$238,975 95350 19300 32775 66850 13700 11000
$691,425 255750 58400 103625 200550 40100 33000
$1,350,900 485850 117050 213350 401100 78050 55500
$227,050 82200 20850 32875 66850 13275 11000
$231,025 84300 20350 32875 66850 13275 13375
$232,150 84300 20850 32875 66850 13275 14000
$690,225 250800 62050 98625 200550 39825 38375
$233,725 84300 20350 32875 66850 13350 16000
$236,725 84300 21350 32875 66850 13350 18000
$238,725 84300 20850 32875 66850 13350 20500
$709,175 252900 62550 98625 200550 40050 54500
$1,399,400 503700 124600 197250 401100 79875 92875
$2,750,300 989550 241650 410600 802200 157925 148375
© Copyright, 2006, JaxWorks, All Rights Reserved.
Since 1996, JaxWorks has offered a suite of Free Excel workbooks and spreadsheets, and ass documents, that cover a number of financial, accounting and sales functions. These are invalua Also included Free are: - business plan tools, including spreadsheets and excellent instructions - Excel functions glossary and guide; - free training courses for most Microsoft Office applications. These guides are in PDF format and rival commercial books! - comprehensive list of acronyms, ratios and formulas in customer financial analysis, and financial terms; - suite of online calculators, including, breakeven analysis, productivity analysis, business evaluation; - Altman Z-Score (covering publicly and privately held firms, and small businesses); - and payroll analysis. If you are involved in financial analysis at any level, or want to learn more about MS Excel and suite this site is invaluable.
JaxWorks Small Business Spreadsheet Factory
spreadsheets, and associated MS Word, PDF and HTML ons. These are invaluable small business tools.
uides are in
y analysis,
about MS Excel and other applications in the Office
sheet Factory