Get documents about "fortress
Shared by: loka2011
-
Stats
- views:
- 0
- posted:
- 6/21/2012
- language:
- pages:
- 86
Document Sample
Since 1996, JaxWorks has offered a suite of Free Excel workbooks and spreadsheets, and associated MS Word, PDF and HTML
documents, that cover a number of financial, accounting and sales functions. These are invaluable small business tools.
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 other applications in the Of fice
suite this site is invaluable.
© Copyright, 2010, Jaxworks, All Rights Reserved.
Fortress ™ Budget Analysis System
The art or practice of strengthening or creating defenses is to create a fortress. This same principle applies to a business. The fort is the business
surrounding defensive walls is the budget. Fortress™ is designed to financially manage a business through 12 months of performance by using budgeting
primary tool - not an afterthought. Major goals are attained by setting and attaining small goals. This system helps you do that.
What is a Budget?
Although you might not know it, you prepare a budget each time you estimate how much cash you will have left at the end of the month after paying your
budget is a forecast of all cash sources and cash expenditures. It is organized in the same format as a financial statement, and most commonly covers a
the end of the year, the anticipated income and expenses developed in the budget are compared to the actual performance of the business as recorded
financial statement.
Why Create a Budget?
A budget can greatly enhance your chances of success by helping you estimate future needs and plan profits, spending and overall cash flow. A budget
you to perceive problems before they occur and alter your plans to prevent those problems. Fortress™ covers the basic concept of budgeting and takes
through the step-by-step process of constructing a budget.
How do I use a Budget?
In business, budgets help you determine how much money you have and how you will use it, and help you decide whether you have enough money to
your financial goals. As part of a business plan, a budget can help convince a loan officer that you know your business and have anticipated its needs.
What will a Budget Indicate?
1) The cash required for necessary labor and/or materials.
2) Total start-up costs in a new business or new product line.
3) Day-to-day maintenance costs.
4) Revenues needed to support business operations.
5) Expected profit.
© Copyright, 2010, Jaxworks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
business and the
budgeting as a
your bills. A
covers a year. At
recorded in the
budget allows
and takes you
money to achieve
needs.
Next
© Copyright, 2010, JaxWorks, All Rights Reserved.
Fortress™ is straightforward and easy to operate. Here are the steps:
1) Be sure to activate the Solver add-in.
2) Go to the Data Entry worksheet. Clear the Data Entry worksheet. (a button is provided).
3) Enter a start month.
4) Post your internal or accountant's financial numbers in the appropriate cells with blue numbers.
5) Establish budgetary limits in the cells provided in the appropriate cells with blue numbers.
6) Each line item has a hyperlink to individual chart analysis sheets with a return button to Data Entry.
7) With the included sample data, experiment with using the Solver and Scenario Manager. Instructions for their use is included in the Fortress
folder. Open Whatif.xls for step-by-step lessons.
8) All analysis sheets have been preset for printing.
9) Fortress™ was produced with 100% open architecture. You may alter it to suit your needs.
10) Accessed from the Data Entry sheet, is the Budget Analysis Worksheet. This worksheet is a consolidation of monthly actuals vs. budget
displayed in calendar quarters.
11) Lastly, Fortress™ automatically forecasts an annual budget trend with as little as 3 months data input. The Forecast Budget Analyzer
forecasts the necessary sales and budgets for the year.
Back
© Copyright, 2010, Jaxworks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
Next
© Copyright, 2010, JaxWorks, All Rights Reserved.
Clear Worksheet Add Sample Data 12 Mos Add Sample Data 3 Mos Budget Forecast Analyzer Budget Analysis
Period Starting: Jan Feb Mar Apr May Jun Jul Aug Sep
Sales 1 2 3 4 5 6 7 8 9
Product 1 $5,600 $6,350 $5,100 $6,850 $8,600 $8,850 $12,100 $13,850 $16,600
Budget $4,790 $5,678 $4,754 $6,501 $7,744 $8,645 $10,976 $11,232 $14,323
Over / (Under Budget) $810 $672 $346 $349 $856 $205 $1,124 $2,618 $2,277
Product 2 $3,600 $4,350 $16,400 $16,830 $17,260 $17,690 $15,600 $17,350 $8,600
Budget $5,595 $5,678 $9,754 $9,168 $18,748 $14,327 $14,907 $15,486 $9,066
Over / (Under Budget) ($1,995) ($1,328) $6,646 $7,662 ($1,488) $3,363 $694 $1,864 ($466)
Product 3 $14,600 $25,350 $25,100 $26,850 $32,100 $35,750 $39,400 $43,050 $46,700
Budget $5,895 $3,678 $5,754 $7,501 $9,431 $11,320 $13,209 $15,099 $16,988
Over / (Under Budget) $8,705 $21,672 $19,346 $19,349 $22,670 $24,430 $26,191 $27,951 $29,712
Product 4 $16,850 $17,690 $18,830 $19,260 $20,690 $21,439 $22,364 $23,289 $24,214
Budget $8,895 $14,678 $7,754 $6,501 $9,431 $11,320 $13,209 $15,099 $16,988
Over / (Under Budget) $7,955 $3,012 $11,076 $12,759 $11,260 $10,119 $9,155 $8,190 $7,226
Product 5 $78,600 $88,750 $89,002 $86,850 $96,400 $106,830 $127,260 $137,690 $167,274
Budget $68,595 $78,595 $78,754 $86,501 $77,744 $99,845 $115,976 $126,232 $174,323
Over / (Under Budget) $10,005 $10,155 $10,248 $349 $18,656 $6,985 $11,284 $11,458 ($7,050)
Product 6 $36,000 $43,350 $45,100 $46,850 $56,400 $66,830 $68,593 $74,166 $79,739
Budget $15,754 $16,501 $15,744 $14,987 $14,982 $14,676 $14,370 $15,419 $14,323
Over / (Under Budget) $20,246 $26,849 $29,356 $31,863 $41,418 $52,154 $54,223 $58,747 $65,416
Total Sales 155,250 185,840 199,532 203,490 231,450 257,389 285,317 309,395 343,127
Total Sales Budget 109,524 124,808 122,514 131,159 138,079 160,133 182,648 198,566 246,011
Total Over / (Under Budget) $45,726 $61,032 $77,018 $72,331 $93,372 $97,256 $102,670 $110,829 $97,116
© Copyright, 2010, JaxWorks, All Rights Reserved.
Less Cost of Goods Sold
Materials $3,168 $3,748 $4,327 $4,907 $5,486 $10,350 $12,100 $13,850 $15,600
Budget $1,595 $1,678 $4,754 $6,501 $8,081 $9,845 $10,976 $11,232 $14,323
Over / (Under Budget) $1,573 $2,070 ($427) ($1,595) ($2,595) $505 $1,124 $2,618 $1,277
Labor $16,400 $16,830 $17,260 $17,690 $15,600 $10,350 $12,100 $13,850 $15,600
Budget $4,754 $6,501 $8,081 $9,845 $10,976 $9,845 $10,976 $11,232 $14,323
Over / (Under Budget) $11,646 $10,329 $9,180 $7,845 $4,624 $505 $1,124 $2,618 $1,277
Overhead $11,320 $13,209 $15,099 $16,988 $18,878 $10,350 $12,100 $13,850 $15,600
Budget $2,754 $3,168 $3,748 $4,327 $4,907 $9,845 $10,976 $11,232 $14,323
Over / (Under Budget) $8,566 $10,041 $11,351 $12,661 $13,971 $505 $1,124 $2,618 $1,277
Other $9,845 $10,976 $11,232 $14,323 $15,434 $10,350 $12,100 $13,850 $15,600
Budget $4,327 $4,907 $9,845 $10,976 $11,232 $9,845 $10,976 $11,232 $14,323
Over / (Under Budget) $5,518 $6,070 $1,387 $3,347 $4,202 $505 $1,124 $2,618 $1,277
Total Cost of Goods Sold $40,733 $44,763 $47,918 $53,908 $55,398 $41,400 $48,400 $55,400 $62,400
Total COG Budget $13,430 $16,254 $26,427 $31,649 $35,195 $39,380 $43,904 $44,928 $57,292
Total Over / (Under Budget) $27,303 $28,509 $21,491 $22,259 $20,203 $2,020 $4,496 $10,472 $5,108
Gross Profit $114,517 $141,077 $151,614 $149,582 $176,053 $215,989 $236,917 $253,995 $280,727
Gross Profit Budget $90,567 $95,987 $123,456 $141,587 $158,032 $176,085 $194,138 $212,191 $230,244
GP Budget Total Over / (Under Budget) $23,950 $45,090 $28,158 $7,995 $18,021 $39,904 $42,779 $41,804 $50,483
Operating Expenses
G&A Expenses
Operating Expenses $5,600 $5,850 $5,900 $6,850 $8,600 $10,350 $12,100 $13,850 $15,600
Budget $6,012 $6,045 $6,356 $6,501 $7,744 $9,845 $10,976 $11,232 $14,323
Over / (Under Budget) ($412) ($195) ($456) $349 $856 $505 $1,124 $2,618 $1,277
Payroll Salaries $10,350 $12,100 $13,850 $15,600 $17,350 $19,100 $20,850 $22,600 $24,350
Budget $7,744 $9,845 $10,976 $11,232 $14,323 $15,188 $16,642 $18,097 $19,551
Over / (Under Budget) $2,606 $2,255 $2,874 $4,368 $3,027 $3,913 $4,208 $4,504 $4,799
Total G&A Expenses $15,950 $17,950 $19,750 $22,450 $25,950 $29,450 $32,950 $36,450 $39,950
Total G&A Budget $13,756 $15,890 $17,332 $17,733 $22,067 $25,033 $27,618 $29,329 $33,874
Total Over / (Under Budget) $2,194 $2,060 $2,418 $4,717 $3,883 $4,418 $5,332 $7,122 $6,076
Sales Expenses
Operating Expenses $5,500 $5,650 $6,900 $7,750 $8,450 $9,250 $10,050 $10,850 $11,650
Budget $6,012 $6,045 $6,356 $6,501 $7,744 $9,845 $10,976 $11,232 $14,323
Over / (Under Budget) ($512) ($395) $544 $1,249 $706 ($595) ($926) ($382) ($2,673)
Payroll Salaries $5,500 $5,650 $6,900 $7,750 $8,450 $9,250 $12,050 $11,993 $13,007
Budget $7,744 $8,845 $9,276 $10,232 $10,998 $11,788 $12,577 $13,367 $14,156
Over / (Under Budget) ($2,244) ($3,195) ($2,376) ($2,482) ($2,548) ($2,538) ($527) ($1,374) ($1,149)
Total Sales Expenses $11,000 $11,300 $13,800 $15,500 $16,900 $18,500 $22,100 $22,843 $24,657
Total Sales Expense Budget $13,756 $14,890 $15,632 $16,733 $18,742 $21,633 $23,553 $24,599 $28,479
Total Over / (Under Budget) ($2,756) ($3,590) ($1,832) ($1,233) ($1,842) ($3,133) ($1,453) ($1,756) ($3,822)
© Copyright, 2010, JaxWorks, All Rights Reserved.
Marketing Expenses
Operating Expenses $5,500 $5,650 $6,900 $7,750 $8,450 $9,250 $10,050 $10,850 $11,650
Budget $6,012 $6,045 $6,356 $6,501 $7,744 $9,845 $10,976 $11,232 $14,323
Over / (Under Budget) ($512) ($395) $544 $1,249 $706 ($595) ($926) ($382) ($2,673)
Payroll Salaries $5,600 $6,650 $6,900 $7,550 $8,550 $9,150 $12,050 $11,993 $13,007
Budget $7,744 $8,845 $9,276 $10,232 $10,998 $11,788 $12,577 $13,367 $14,156
Over / (Under Budget) ($2,144) ($2,195) ($2,376) ($2,682) ($2,448) ($2,638) ($527) ($1,374) ($1,149)
Total Marketing Expenses $11,100 $12,300 $13,800 $15,300 $17,000 $18,400 $22,100 $22,843 $24,657
Total Marketing Expense Budget $13,756 $14,890 $15,632 $16,733 $18,742 $21,633 $23,553 $24,599 $28,479
Total Over / (Under Budget) ($2,656) ($2,590) ($1,832) ($1,433) ($1,742) ($3,233) ($1,453) ($1,756) ($3,822)
Research & Development Expenses
Operating Expenses $21,500 $23,735 $24,908 $26,965 $29,740 $33,420 $36,130 $37,965 $42,635
Budget $19,595 $21,678 $23,754 $25,501 $27,581 $29,560 $31,539 $33,519 $35,498
Over / (Under Budget) $1,905 $2,057 $1,154 $1,464 $2,160 $3,860 $4,591 $4,446 $7,137
Payroll Salaries $35,256 $38,625 $40,540 $43,698 $48,482 $55,053 $59,683 $62,564 $71,114
Budget $19,595 $21,678 $23,754 $25,501 $27,581 $29,560 $31,539 $33,519 $35,498
Over / (Under Budget) $15,661 $16,947 $16,786 $18,197 $20,902 $25,493 $28,144 $29,045 $35,616
Total Research & Development Expenses $56,756 $62,360 $65,448 $70,663 $78,222 $88,473 $95,813 $100,529 $113,749
Total R&D Expenses Budget $39,190 $43,356 $47,508 $51,002 $55,161 $59,120 $63,079 $67,037 $70,996
Total Over / (Under Budget) $17,566 $19,004 $17,940 $19,661 $23,061 $29,353 $32,734 $33,491 $42,753
Total Operating Expenses $94,806 $103,910 $112,798 $123,913 $138,072 $154,823 $172,963 $182,664 $203,013
Total Payroll Salaries $56,706 $63,025 $68,190 $74,598 $82,832 $92,553 $104,633 $109,149 $121,478
Total All Operating Expenses
All Operating Expenses $151,512 $166,935 $180,988 $198,511 $220,904 $247,375 $277,596 $291,813 $324,492
All Operating Expenses Budget $80,458 $89,026 $96,104 $102,201 $114,712 $127,417 $137,803 $145,563 $161,828
OP Budget Total Over / (Under Budget) $71,054 $77,909 $84,884 $96,310 $106,192 $119,958 $139,793 $146,251 $162,663
Earnings Before Income Tax $3,738 $18,905 $18,544 $4,979 $10,546 $10,014 $7,721 $17,582 $18,635
Budget $1,744 $17,845 $17,276 $5,232 $10,998 $11,788 $12,577 $13,367 $14,156
Over / (Under Budget) $1,994 $1,060 $1,268 ($253) ($452) ($1,774) ($4,856) $4,215 $4,479
Interest income (expense) $10,000 $10,300 $10,609 $10,912 $11,217 $11,521 $11,826 $12,130 $12,435
Other income (expense) $20,000 $20,600 $21,218 $21,824 $22,433 $23,042 $23,651 $24,260 $24,869
Total Non-operating Income (expense) $30,000 $30,900 $31,827 $32,736 $33,650 $34,563 $35,477 $36,390 $37,304
Income (Loss) Before Taxes $33,738 $49,805 $50,371 $37,715 $44,196 $44,577 $43,198 $53,972 $55,938
Income Taxes $19,121 $24,212 $24,659 $21,135 $23,354 $23,742 $23,602 $27,109 $27,973
Net Income (Loss) $14,617 $25,594 $25,712 $16,580 $20,842 $20,835 $19,596 $26,863 $27,966
Budget $41,744 $67,845 $77,276 $55,232 $60,998 $66,388 $70,977 $85,567 $90,156
Over / (Under Budget) ($27,127) ($42,252) ($51,564) ($38,652) ($40,156) ($45,553) ($51,381) ($58,703) ($62,190)
Cumulative Net Income (Loss) $14,617 $40,210 $65,922 $82,501 $103,343 $124,178 $143,774 $170,637 $198,603
© Copyright, 2010, Jaxworks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
Budget Analysis Forecast Budget Analysis
Oct Nov Dec Totals
10 11 12
$19,100 $21,600 $24,100 $148,700
$15,434 $16,543 $17,896 $124,516
$3,666 $5,057 $6,204 ($24,184)
$9,350 $10,100 $10,850 $147,980
$10,645 $8,225 $12,804 $134,401
($1,295) $1,876 ($1,954) $13,579
$50,350 $54,000 $57,650 $450,900
$18,878 $20,767 $22,656 $151,175
$31,473 $33,233 $34,994 $299,725
$25,139 $26,064 $26,989 $262,818
$18,878 $20,767 $22,656 $166,175
$6,262 $5,297 $4,333 $96,643
$165,240 $193,207 $191,174 $1,528,277
$155,434 $196,543 $197,896 $1,456,438
$9,806 ($3,336) ($6,722) $71,839
$85,312 $90,885 $96,458 $789,683
$15,434 $16,543 $17,896 $186,629
$69,878 $74,342 $78,562 $603,054
354,491 395,856 407,221 3,328,358
234,702 279,387 291,805 2,219,335
$119,789 $116,469 $115,416 $1,109,023
© Copyright, 2010, JaxWorks, All Rights Reserved.
$17,350 $19,100 $20,850 $130,835
$15,434 $16,543 $17,896 $118,858
$1,916 $2,557 $2,954 $11,978
$17,350 $19,100 $20,850 $192,980
$15,434 $16,543 $17,896 $136,406
$1,916 $2,557 $2,954 $56,575
$17,350 $19,100 $20,850 $184,694
$15,434 $16,543 $17,896 $115,152
$1,916 $2,557 $2,954 $69,542
$17,350 $19,100 $20,850 $171,010
$15,434 $16,543 $17,896 $137,536
$1,916 $2,557 $2,954 $33,475
$69,400 $76,400 $83,400 $679,519
$61,736 $66,172 $71,584 $507,951
$7,664 $10,228 $11,816 $171,568
$285,091 $319,456 $323,821 $2,648,839
$248,297 $266,350 $284,403 $2,221,337
$36,794 $53,106 $39,418 $427,502
$17,350 $19,100 $20,850 $142,000
$15,434 $16,543 $17,896 $128,907
$1,916 $2,557 $2,954 $270,907
$26,100 $27,850 $29,600 $239,700
$21,006 $22,460 $23,915 $190,977
$5,095 $5,390 $5,686 $430,677
$43,450 $46,950 $50,450 $381,700
$36,440 $39,003 $41,811 $319,884
$7,011 $7,947 $8,640 $61,816
$12,450 $13,250 $14,050 $115,800
$15,434 $16,543 $17,896 $128,907
($2,984) ($3,293) ($3,846) $244,707
$14,021 $15,036 $16,050 $125,657
$14,946 $15,735 $16,525 $146,187
($924) ($699) ($475) $271,844
$26,471 $28,286 $30,100 $241,457
$30,380 $32,278 $34,421 $275,094
($3,908) ($3,992) ($4,321) ($33,637)
© Copyright, 2010, JaxWorks, All Rights Reserved.
$12,450 $13,250 $14,050 $115,800
$15,434 $16,543 $17,896 $128,907
($2,984) ($3,293) ($3,846) $244,707
$14,021 $15,036 $16,050 $126,557
$14,946 $15,735 $16,525 $146,187
($924) ($699) ($475) $272,744
$26,471 $28,286 $30,100 $242,357
$30,380 $32,278 $34,421 $275,094
($3,908) ($3,992) ($4,321) ($32,737)
$45,325 $48,013 $50,945 $421,281
$37,478 $39,457 $41,436 $366,595
$7,848 $8,556 $9,509 $787,876
$75,705 $80,291 $85,366 $696,375
$37,478 $39,457 $41,436 $366,595
$38,227 $40,834 $43,929 $1,062,970
$121,030 $128,304 $136,311 $1,117,656
$74,955 $78,914 $82,873 $733,190
$46,075 $49,390 $53,438 $384,466
$217,422 $231,825 $246,961 $1,983,170
$129,847 $138,212 $147,066 $1,188,289
$347,270 $370,038 $394,026 $3,171,460
$172,154 $182,473 $193,524 $1,603,262
$175,116 $187,565 $200,502 $1,568,197
$7,222 $25,818 $13,195 $156,898
$14,946 $15,735 $16,525 $152,187
($7,724) $10,083 ($3,330) $309,085
$12,739 $13,044 $13,348 $140,079
$25,478 $26,087 $26,696 $280,158
$38,217 $39,131 $40,044 $420,237
$45,439 $64,949 $53,239 $577,135
$25,097 $31,224 $27,985 $299,212
$20,342 $33,725 $25,254 $277,924
$64,746 $99,335 $63,925 $844,187
($44,404) ($65,610) ($38,671) $1,122,111
$218,945 $252,670 $277,924 $555,847
© Copyright, 2010, JaxWorks, All Rights Reserved.
Budget Forecast Analyzer
Period Starting: Jan Feb Mar Apr May Jun Jul Aug Sep
Sales 1 2 3 4 5 6 7 8 9
Product 1 $5,600 $6,350 $5,100 $5,183 $4,933 $4,683 $4,433 $4,183 $3,933
Budget $4,790 $5,678 $4,754 $5,038 $5,020 $5,002 $4,984 $4,966 $4,948
Over / (Under Budget) $810 $672 $346 $145 ($87) ($319) ($551) ($783) ($1,015)
Product 2 $3,600 $4,350 $16,400 $20,917 $27,317 $33,717 $40,117 $46,517 $52,917
Budget $5,595 $5,678 $9,754 $11,168 $13,248 $15,327 $17,407 $19,486 $21,566
Over / (Under Budget) ($1,995) ($1,328) $6,646 $9,749 $14,069 $18,390 $22,710 $27,031 $31,351
Product 3 $14,600 $25,350 $25,100 $32,183 $37,433 $42,683 $47,933 $53,183 $58,433
Budget $5,895 $3,678 $5,754 $4,968 $4,898 $4,827 $4,757 $4,686 $4,616
Over / (Under Budget) $8,705 $21,672 $19,346 $27,215 $32,536 $37,856 $43,177 $48,497 $53,818
Product 4 $16,850 $17,690 $18,830 $19,770 $20,760 $21,750 $22,740 $23,730 $24,720
Budget $8,895 $14,678 $7,754 $9,301 $8,731 $8,160 $7,590 $7,019 $6,449
Over / (Under Budget) $7,955 $3,012 $11,076 $10,469 $12,029 $13,590 $15,150 $16,711 $18,271
Product 5 $78,600 $88,750 $89,002 $95,853 $101,054 $106,255 $111,456 $116,657 $121,858
Budget $68,595 $78,595 $78,754 $85,474 $90,553 $95,633 $100,712 $105,792 $110,871
Over / (Under Budget) $10,005 $10,155 $10,248 $10,379 $10,501 $10,622 $10,744 $10,865 $10,987
Product 6 $36,000 $43,350 $45,100 $50,583 $55,133 $59,683 $64,233 $68,783 $73,333
Budget $15,754 $16,501 $15,744 $15,990 $15,985 $15,980 $15,975 $15,970 $15,965
Over / (Under Budget) $20,246 $26,849 $29,356 $34,594 $39,149 $43,704 $48,259 $52,814 $57,369
Total Sales $155,250 $185,840 $199,532 $224,489 $246,630 $268,771 $290,912 $313,053 $335,194
Total Sales Budget 109,524 124,808 122,514 $131,939 $138,434 $144,929 $151,424 $157,919 $164,414
Total Over / (Under Budget) $45,726 $61,032 $77,018 $92,551 $108,197 $123,843 $139,489 $155,135 $170,781
© Copyright, 2010, JaxWorks, All Rights Reserved.
Less Cost of Goods Sold
Materials $3,168 $3,748 $4,327 $4,907 $5,486 $6,066 $6,645 $7,225 $7,804
Budget $1,595 $1,678 $4,754 $5,835 $7,414 $8,994 $10,573 $12,153 $13,732
Over / (Under Budget) $1,573 $2,070 ($427) ($928) ($1,928) ($2,928) ($3,928) ($4,928) ($5,928)
Labor $16,400 $16,830 $17,260 $17,690 $18,120 $18,550 $18,980 $19,410 $19,840
Budget $4,754 $6,501 $8,081 $9,772 $11,435 $13,098 $14,761 $16,425 $18,088
Over / (Under Budget) $11,646 $10,329 $9,180 $7,918 $6,685 $5,452 $4,219 $2,985 $1,752
Overhead $11,320 $13,209 $15,099 $16,988 $18,878 $20,767 $22,656 $24,546 $26,435
Budget $2,754 $3,168 $3,748 $4,217 $4,713 $5,210 $5,707 $6,204 $6,700
Over / (Under Budget) $8,566 $10,041 $11,351 $12,771 $14,164 $15,557 $16,949 $18,342 $19,735
Other $9,845 $10,976 $11,232 $12,071 $12,765 $13,458 $14,152 $14,845 $15,539
Budget $4,327 $4,907 $9,845 $11,878 $14,637 $17,396 $20,155 $22,914 $25,673
Over / (Under Budget) $5,518 $6,070 $1,387 $194 ($1,872) ($3,937) ($6,003) ($8,068) ($10,134)
Total Cost of Goods Sold $40,733 $44,763 $47,918 $51,656 $55,248 $58,841 $62,433 $66,026 $69,618
Total COG Budget $13,430 $16,254 $26,427 $31,701 $38,199 $44,698 $51,196 $57,695 $64,193
Total Over / (Under Budget) $27,303 $28,509 $21,491 $19,955 $17,049 $14,143 $11,237 $8,331 $5,425
Gross Profit $114,517 $141,077 $151,614 $172,833 $191,382 $209,931 $228,479 $247,028 $265,576
Gross Profit Budget $90,567 $95,987 $123,456 $136,226 $152,670 $169,115 $185,559 $202,004 $218,448
GP Budget Total Over / (Under Budget) $23,950 $45,090 $28,158 $36,608 $38,712 $40,816 $42,920 $45,024 $47,128
Operating Expenses
G&A Expenses
Operating Expenses $5,600 $5,850 $5,900 $6,083 $6,233 $6,383 $6,533 $6,683 $6,833
Budget $6,012 $6,045 $6,356 $6,482 $6,654 $6,826 $6,998 $7,170 $7,342
Over / (Under Budget) ($412) ($195) ($456) ($398) ($420) ($442) ($464) ($486) ($508)
Payroll Salaries $10,350 $12,100 $13,850 $15,600 $17,350 $19,100 $20,850 $22,600 $24,350
Budget $7,744 $9,845 $10,976 $12,754 $14,370 $15,986 $17,602 $19,218 $20,834
Over / (Under Budget) $2,606 $2,255 $2,874 $2,846 $2,980 $3,114 $3,248 $3,382 $3,516
Total G&A Expenses 15,950 17,950 19,750 $21,683 $23,583 $25,483 $27,383 $29,283 $31,183
Total G&A Budget $13,756 $15,890 $17,332 $19,235 $21,023 $22,811 $24,599 $26,387 $28,175
Total Over / (Under Budget) $2,194 $2,060 $2,418 $2,448 $2,560 $2,672 $2,784 $2,896 $3,008
Sales Expenses
Operating Expenses $5,500 $5,650 $6,900 $7,417 $8,117 $8,817 $9,517 $10,217 $10,917
Budget $6,012 $6,045 $6,356 $6,482 $6,654 $6,826 $6,998 $7,170 $7,342
Over / (Under Budget) ($512) ($395) $544 $935 $1,463 $1,991 $2,519 $3,047 $3,575
Payroll Salaries $5,500 $5,650 $6,900 $7,417 $8,117 $8,817 $9,517 $10,217 $10,917
Budget $7,744 $8,845 $9,276 $10,154 $10,920 $11,686 $12,452 $13,218 $13,984
Over / (Under Budget) ($2,244) ($3,195) ($2,376) ($2,737) ($2,803) ($2,869) ($2,935) ($3,001) ($3,067)
Total Sales Expenses $11,000 $11,300 $13,800 $14,833 $16,233 $17,633 $19,033 $20,433 $21,833
Total Sales Expense Budget $13,756 $14,890 $15,632 $16,635 $17,573 $18,511 $19,449 $20,387 $21,325
Total Over / (Under Budget) ($2,756) ($3,590) ($1,832) ($1,802) ($1,340) ($878) ($416) $46 $508
© Copyright, 2010, JaxWorks, All Rights Reserved.
Marketing Expenses
Operating Expenses $5,500 $5,650 $6,900 $7,417 $8,117 $8,817 $9,517 $10,217 $10,917
Budget $6,012 $6,045 $6,356 $6,482 $6,654 $6,826 $6,998 $7,170 $7,342
Over / (Under Budget) ($512) ($395) $544 $935 $1,463 $1,991 $2,519 $3,047 $3,575
Payroll Salaries $5,600 $6,650 $6,900 $7,683 $8,333 $8,983 $9,633 $10,283 $10,933
Budget $7,744 $8,845 $9,276 $10,154 $10,920 $11,686 $12,452 $13,218 $13,984
Over / (Under Budget) ($2,144) ($2,195) ($2,376) ($2,470) ($2,586) ($2,702) ($2,818) ($2,934) ($3,050)
Total Marketing Expenses $11,100 $12,300 $13,800 $15,100 $16,450 $17,800 $19,150 $20,500 $21,850
Total Marketing Expense Budget $13,756 $14,890 $15,632 $16,635 $17,573 $18,511 $19,449 $20,387 $21,325
Total Over / (Under Budget) ($2,656) ($2,590) ($1,832) ($1,535) ($1,123) ($711) ($299) $113 $525
Research & Development Expenses
Operating Expenses $21,500 $23,735 $24,908 $26,789 $28,493 $30,197 $31,901 $33,605 $35,309
Budget $19,595 $21,678 $23,754 $25,835 $27,914 $29,994 $32,073 $34,153 $36,232
Over / (Under Budget) $1,905 $2,057 $1,154 $954 $579 $203 ($172) ($548) ($923)
Payroll Salaries $35,256 $38,625 $40,540 $43,424 $46,066 $48,708 $51,350 $53,992 $56,634
Budget $19,595 $21,678 $23,754 $25,835 $27,914 $29,994 $32,073 $34,153 $36,232
Over / (Under Budget) $15,661 $16,947 $16,786 $17,590 $18,152 $18,715 $19,277 $19,840 $20,402
Total Research & Development Expenses $56,756 $62,360 $65,448 $70,213 $74,559 $78,905 $83,251 $87,597 $91,943
Total R&D Expenses Budget $39,190 $43,356 $47,508 $51,669 $55,828 $59,987 $64,146 $68,305 $72,464
Total Over / (Under Budget) $17,566 $19,004 $17,940 $18,544 $18,731 $18,918 $19,105 $19,292 $19,479
Total Operating Expenses $94,806 $103,910 $112,798 $121,830 $130,826 $139,822 $148,818 $157,814 $166,810
Total Payroll Salaries $56,706 $63,025 $68,190 $74,124 $79,866 $85,608 $91,350 $97,092 $102,834
Total All Operating Expenses
All Operating Expenses $151,512 $166,935 $180,988 $195,954 $210,692 $225,430 $240,168 $254,906 $269,644
All Operating Expenses Budget $80,458 $89,026 $96,104 $104,175 $111,998 $119,821 $127,644 $135,467 $143,290
OP Budget Total Over / (Under Budget) $71,054 $77,909 $84,884 $91,779 $98,694 $105,609 $112,524 $119,439 $126,354
Earnings Before Income Tax $3,738 $18,905 $18,544 $28,535 $35,938 $43,341 $50,744 $58,147 $65,550
Budget $1,744 $17,845 $17,276 $27,820 $35,586 $43,352 $51,118 $58,884 $66,650
Over / (Under Budget) $1,994 $1,060 $1,268 $715 $352 ($11) ($374) ($737) ($1,100)
Interest income (expense) $10,000 $10,300 $10,609 $10,912 $11,217 $11,521 $11,826 $12,130 $12,435
Other income (expense) $20,000 $20,600 $21,218 $21,824 $22,433 $23,042 $23,651 $24,260 $24,869
Total Non-operating Income (expense) $30,000 $30,900 $31,827 $32,736 $33,650 $34,563 $35,477 $36,390 $37,304
Income (Loss) Before Taxes $33,738 $49,805 $50,371 $61,271 $69,588 $77,904 $86,221 $94,537 $102,854
Income Taxes $19,121 $24,212 $24,659 $28,202 $30,971 $33,740 $36,509 $39,278 $42,047
Net Income (Loss) $14,617 $25,594 $25,712 $33,069 $38,616 $44,164 $49,711 $55,259 $60,806
Budget $41,744 $67,845 $77,276 $97,820 $115,586 $133,352 $151,118 $168,884 $186,650
Over / (Under Budget) ($27,127) ($42,252) ($51,564) ($64,751) ($76,970) ($89,188) ($101,407) ($113,625) ($125,844)
Cumulative Net Income (Loss) $14,617 $40,210 $65,922 $91,555 $117,207 $142,860 $168,512 $194,165 $219,817
© Copyright, 2010, Jaxworks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
Oct Nov Dec Totals
10 11 12
$3,683 $3,433 $3,183 $54,700
$4,930 $4,912 $4,894 $59,916
($1,247) ($1,479) ($1,711) $5,216
$59,317 $65,717 $72,117 $443,000
$23,645 $25,725 $27,804 $196,401
$35,672 $39,992 $44,313 $246,599
$63,683 $68,933 $74,183 $543,700
$4,545 $4,475 $4,404 $57,501
$59,138 $64,459 $69,779 $486,199
$25,710 $26,700 $27,690 $266,940
$5,878 $5,308 $4,737 $94,501
$19,832 $21,392 $22,953 $172,439
$127,059 $132,260 $137,461 $1,306,262
$115,951 $121,030 $126,110 $1,178,069
$11,108 $11,230 $11,351 $128,193
$77,883 $82,433 $86,983 $743,500
$15,960 $15,955 $15,950 $191,726
$61,924 $66,479 $71,034 $551,774
$357,335 $379,476 $401,617 3,358,102
$170,909 $177,404 $183,899 1,778,114
$186,427 $202,073 $217,719 $1,579,988
© Copyright, 2010, JaxWorks, All Rights Reserved.
$8,384 $8,963 $9,543 $76,263
$15,312 $16,891 $18,471 $117,401
($6,928) ($7,928) ($8,928) ($41,138)
$20,270 $20,700 $21,130 $225,180
$19,751 $21,414 $23,078 $167,158
$519 ($714) ($1,948) $58,023
$28,325 $30,214 $32,103 $260,539
$7,197 $7,694 $8,191 $65,503
$21,127 $22,520 $23,913 $195,037
$16,232 $16,926 $17,619 $165,661
$28,432 $31,191 $33,950 $225,300
($12,199) ($14,265) ($16,330) ($59,639)
$73,210 $76,803 $80,395 $727,643
$70,692 $77,190 $83,689 $575,361
$2,519 ($387) ($3,293) $152,282
$284,125 $302,674 $321,222 $2,630,459
$234,893 $251,337 $267,782 $2,128,043
$49,232 $51,336 $53,441 $502,416
$6,983 $7,133 $7,283 $77,500
$7,514 $7,686 $7,858 $82,940
($530) ($552) ($574) $160,440
$26,100 $27,850 $29,600 $239,700
$22,450 $24,066 $25,682 $201,524
$3,650 $3,784 $3,918 $441,224
$33,083 $34,983 $36,883 $317,200
$29,963 $31,751 $33,539 $284,464
$3,120 $3,232 $3,344 $32,736
$11,617 $12,317 $13,017 $110,000
$7,514 $7,686 $7,858 $82,940
$4,103 $4,631 $5,159 $192,940
$11,617 $12,317 $13,017 $110,000
$14,750 $15,516 $16,282 $144,824
($3,133) ($3,199) ($3,265) $254,824
$23,233 $24,633 $26,033 $220,000
$22,263 $23,201 $24,139 $227,764
$970 $1,432 $1,894 ($7,764)
© Copyright, 2010, JaxWorks, All Rights Reserved.
$11,617 $12,317 $13,017 $110,000
$7,514 $7,686 $7,858 $82,940
$4,103 $4,631 $5,159 $192,940
$11,583 $12,233 $12,883 $111,700
$14,750 $15,516 $16,282 $144,824
($3,166) ($3,282) ($3,398) $256,524
$23,200 $24,550 $25,900 $221,700
$22,263 $23,201 $24,139 $227,764
$937 $1,349 $1,761 ($6,064)
$37,013 $38,717 $40,421 $372,588
$38,312 $40,391 $42,471 $372,401
($1,299) ($1,674) ($2,050) $744,989
$59,276 $61,918 $64,560 $600,352
$38,312 $40,391 $42,471 $372,401
$20,965 $21,527 $22,090 $972,753
$96,289 $100,635 $104,981 $972,940
$76,623 $80,782 $84,941 $744,802
$19,666 $19,853 $20,040 $228,138
$175,806 $184,802 $193,798 $1,731,840
$108,576 $114,318 $120,060 $1,061,752
$284,382 $299,120 $313,858 $2,793,592
$151,113 $158,936 $166,759 $1,484,794
$133,269 $140,184 $147,099 $1,308,798
$72,953 $80,356 $87,759 $564,510
$74,416 $82,182 $89,948 $566,824
($1,463) ($1,826) ($2,189) $1,131,334
$12,739 $13,044 $13,348 $140,079
$25,478 $26,087 $26,696 $280,158
$38,217 $39,131 $40,044 $420,237
$111,170 $119,487 $127,803 $984,747
$44,816 $47,585 $50,354 $421,495
$66,354 $71,901 $77,449 $563,252
$204,416 $222,182 $239,948 $1,706,824
($138,062) ($150,281) ($162,499) $2,270,076
$245,470 $271,122 $296,775 $860,027
© Copyright, 2010, JaxWorks, All Rights Reserved.
Annual Budget Analysis
Average
Quarter 1 Quarter 2 Quarter 3 Quarter 4 Totals Budget
$ % $ % $ % $ % Over/Under
Sales
Total Sales $540,622 100.00% $692,329 100.00% $937,839 100.00% $1,157,568 100.00% $3,328,358
Total Sales Budget $356,846 66.01% $429,371 62.02% $627,224 66.88% $805,894 69.62% $2,219,335
Total Over / (Under Budget) $183,776 33.99% $262,959 37.98% $310,615 33.12% $351,674 30.38% $1,109,023 Over
Less Cost of Goods Sold
Materials $11,243 2.08% $20,743 3.00% $41,550 4.43% $57,300 4.95% $130,835
Budget $8,027 1.48% $24,427 3.53% $36,531 3.90% $49,873 4.31% $118,858
Over / (Under Budget) $3,216 28.60% ($3,684) -17.76% $5,019 12.08% $7,427 12.96% $11,978 Under
Labor $50,490 9.34% $43,640 6.30% $41,550 4.43% $57,300 4.95% $192,980
Budget $19,336 3.58% $30,666 4.43% $36,531 3.90% $49,873 4.31% $136,406
Over / (Under Budget) $31,155 61.70% $12,974 29.73% $5,019 12.08% $7,427 12.96% $56,575 Over
Overhead $39,628 7.33% $46,216 6.68% $41,550 4.43% $57,300 4.95% $184,694
Budget $9,670 1.79% $19,079 2.76% $36,531 3.90% $49,873 4.31% $115,152
Over / (Under Budget) $29,958 75.60% $27,137 58.72% $5,019 12.08% $7,427 12.96% $69,542 Over
Other $32,053 5.93% $40,107 5.79% $41,550 4.43% $57,300 4.95% $171,010
Budget $19,079 3.53% $32,053 4.63% $36,531 3.90% $49,873 4.31% $137,536
Over / (Under Budget) $12,975 40.48% $8,054 20.08% $5,019 12.08% $7,427 12.96% $33,475 Over
Total Cost of Goods Sold $133,413 24.68% $150,705 21.77% $166,200 17.72% $229,200 19.80% $679,519
Total COG Budget $56,111 10.38% $106,224 15.34% $146,124 15.58% $199,492 17.23% $507,951
Total Over / (Under Budget) $77,303 57.94% $44,481 29.52% $20,076 12.08% $29,708 12.96% $171,568 Over
Gross Profit $407,209 75.32% $541,624 78.23% $771,639 82.28% $928,368 80.20% $2,648,839
Gross Profit Budget $310,010 57.34% $475,704 68.71% $636,573 67.88% $799,050 69.03% $2,221,337
Total Over / (Under Budget) $97,199 23.87% $65,920 12.17% $135,066 17.50% $129,318 13.93% $427,502 Over
© Copyright, 2010, JaxWorks, All Rights Reserved.
Annual Budget Analysis
Operating Expenses
G&A Expenses
Operating Expenses $17,350 3.21% $25,800 3.73% $41,550 4.43% $57,300 4.95% $142,000
Budget $18,413 3.41% $24,090 3.48% $36,531 3.90% $49,873 4.31% $128,907
Over / (Under Budget) ($1,063) -6.13% $1,710 6.63% $5,019 12.08% $7,427 12.96% $13,093 Under
Payroll Salaries $36,300 6.71% $52,050 7.52% $67,800 7.23% $83,550 7.22% $239,700
Budget $28,565 5.28% $40,743 5.88% $54,290 5.79% $67,380 5.82% $190,977
Over / (Under Budget) $7,735 21.31% $11,308 21.72% $13,511 19.93% $16,170 19.35% $48,723 Over
Total G&A Expenses $53,650 9.92% $77,850 11.24% $109,350 11.66% $140,850 12.17% $381,700
Total G&A Budget $46,978 8.69% $64,833 9.36% $90,821 9.68% $117,253 10.13% $319,884
Total Over / (Under Budget) $6,672 12.44% $13,018 16.72% $18,530 16.95% $23,597 16.75% $61,816 Over
Sales Expenses
Operating Expenses $18,050 3.34% $25,450 3.68% $32,550 3.47% $39,750 3.43% $115,800
Budget $18,413 3.41% $24,090 3.48% $36,531 3.90% $49,873 4.31% $128,907
Over / (Under Budget) ($363) -2.01% $1,360 5.34% ($3,981) -12.23% ($10,123) -25.47% ($13,107) Under
Payroll Salaries $18,050 3.34% $25,450 3.68% $37,050 3.95% $45,107 3.90% $125,657
Budget $25,865 4.78% $33,018 4.77% $40,100 4.28% $47,205 4.08% $146,187
Over / (Under Budget) ($7,815) -43.30% ($7,568) -29.73% ($3,050) -8.23% ($2,098) -4.65% ($20,530) Under
Total Sales Expenses $36,100 6.68% $50,900 7.35% $69,600 7.42% $84,857 7.33% $241,457
Total Sales Expense Budget $44,278 8.19% $57,108 8.25% $76,631 8.17% $97,078 8.39% $275,094
Total Over / (Under Budget) ($8,178) -22.65% ($6,208) -12.20% ($7,031) -10.10% ($12,221) -14.40% ($33,637) Under
© Copyright, 2010, JaxWorks, All Rights Reserved.
Annual Budget Analysis
Marketing Expenses
Operating Expenses $18,050 3.34% $25,450 3.68% $32,550 3.47% $39,750 3.43% $115,800
Budget $18,413 3.41% $24,090 3.48% $36,531 3.90% $49,873 4.31% $128,907
Over / (Under Budget) ($363) -2.01% $1,360 5.34% ($3,981) -12.23% ($10,123) -25.47% ($13,107) Under
Payroll Salaries $19,150 3.54% $25,250 3.65% $37,050 3.95% $45,107 3.90% $126,557
Budget $25,865 4.78% $33,018 4.77% $40,100 4.28% $47,205 4.08% $146,187
Over / (Under Budget) ($6,715) -35.07% ($7,768) -30.76% ($3,050) -8.23% ($2,098) -4.65% ($19,630) Under
Total Marketing Expenses $37,200 6.88% $50,700 7.32% $69,600 7.42% $84,857 7.33% $242,357
Total Marketing Expense Budget $44,278 8.19% $57,108 8.25% $76,631 8.17% $97,078 8.39% $275,094
Total Over / (Under Budget) ($7,078) -19.03% ($6,408) -12.64% ($7,031) -10.10% ($12,221) -14.40% ($32,737) Under
Research & Development Expenses
Operating Expenses $70,143 12.97% $90,125 13.02% $116,730 12.45% $144,283 12.46% $421,281
Budget $65,027 12.03% $82,641 11.94% $100,556 10.72% $118,371 10.23% $366,595
Over / (Under Budget) $5,116 7.29% $7,484 8.30% $16,174 13.86% $25,912 17.96% $54,686 Over
Payroll Salaries $114,421 21.16% $147,233 21.27% $193,361 20.62% $241,361 20.85% $696,375
Budget $65,027 12.03% $82,641 11.94% $100,556 10.72% $118,371 10.23% $366,595
Over / (Under Budget) $49,394 43.17% $64,591 43.87% $92,804 48.00% $122,990 50.96% $329,780 Over
Total Research & Development Expenses $184,564 34.14% $237,358 34.28% $310,091 33.06% $385,644 33.32% $1,117,656
Total R&D Expenses Budget $130,054 24.06% $165,283 23.87% $201,112 21.44% $236,741 20.45% $733,190
Total Over / (Under Budget) $54,510 29.53% $72,075 30.37% $108,978 35.14% $148,903 38.61% $384,466 Over
Total Operating Expenses $311,514 57.62% $416,808 60.20% $558,641 59.57% $696,208 60.14% $1,983,170
Total Payroll Salaries $187,921 34.76% $249,983 36.11% $335,261 35.75% $415,125 35.86% $1,188,289
© Copyright, 2010, JaxWorks, All Rights Reserved.
Annual Budget Analysis
Total All Operating Expenses
All Operating Expenses $499,435 92.38% $666,790 96.31% $893,901 95.31% $1,111,334 96.01% $3,171,460
All Operating Expenses Budget $265,588 49.13% $344,330 49.74% $445,194 47.47% $548,150 47.35% $1,603,262
Total Over / (Under Budget) $233,847 46.82% $322,460 48.36% $448,707 50.20% $563,183 50.68% $1,568,197 Over
Earnings Before Income Tax $41,187 7.62% $25,539 3.69% $43,938 4.69% $46,234 3.99% $156,898
Budget $36,865 6.82% $28,018 4.05% $40,100 4.28% $47,205 4.08% $152,187
Over / (Under Budget) $4,322 10.49% ($2,479) -9.70% $3,839 8.74% ($971) -2.10% $4,711 Under
Interest income (expense) $30,909 5.72% $33,650 4.86% $36,390 3.88% $39,131 3.38% $140,079
Other income (expense) $61,818 11.43% $67,299 9.72% $72,780 7.76% $78,261 6.76% $280,158
Total Non-operating Income (expense) $92,727 17.15% $100,949 14.58% $109,170 11.64% $117,392 10.14% $420,237
Income (Loss) Before Taxes $133,914 24.77% $126,488 18.27% $153,108 16.33% $163,626 14.14% $577,135
Income Taxes $67,992 12.58% $68,231 9.86% $78,683 8.39% $84,305 7.28% $299,212
Net Income (Loss) $65,922 12.19% $58,257 8.41% $74,425 7.94% $79,321 6.85% $277,924
Budget $186,865 34.56% $182,618 26.38% $246,700 26.31% $228,005 19.70% $844,187
Over / (Under Budget) ($120,943) -183.47% ($124,361) -213.47% ($172,275) -231.48% ($148,684) -187.45% ($566,263) Under
© Copyright, 2010, Jaxworks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
Forecast Budget Analysis
Average
Quarter 1 Quarter 2 Quarter 3 Quarter 4 Totals Budget
$ % $ % $ % $ % Over/Under
Sales
Total Sales $540,622 100.00% $739,891 100.00% $939,160 100.00% $1,138,429 100.00% $3,358,102
Total Sales Budget $356,846 66.01% $415,301 56.13% $473,756 50.44% $532,211 46.75% $1,778,114
Total Over / (Under Budget) $183,776 33.99% $324,590 43.87% $465,404 49.56% $606,218 53.25% $1,579,988 Over
Less Cost of Goods Sold
Materials $11,243 2.08% $16,458 2.22% $21,674 2.31% $26,889 2.36% $76,263
Budget $8,027 1.48% $22,243 3.01% $36,458 3.88% $50,674 4.45% $117,401
Over / (Under Budget) $3,216 28.60% ($5,785) -35.15% ($14,785) -68.21% ($23,785) -88.45% ($41,138) Under
Labor $50,490 9.34% $54,360 7.35% $58,230 6.20% $62,100 5.45% $225,180
Budget $19,336 3.58% $34,305 4.64% $49,274 5.25% $64,243 5.64% $167,158
Over / (Under Budget) $31,155 61.70% $20,055 36.89% $8,956 15.38% ($2,143) -3.45% $58,023 Over
Overhead $39,628 7.33% $56,633 7.65% $73,637 7.84% $90,642 7.96% $260,539
Budget $9,670 1.79% $14,140 1.91% $18,611 1.98% $23,082 2.03% $65,503
Over / (Under Budget) $29,958 75.60% $42,492 75.03% $55,026 74.73% $67,560 74.54% $195,037 Over
Other $32,053 5.93% $38,295 5.18% $44,536 4.74% $50,778 4.46% $165,661
Budget $19,079 3.53% $43,910 5.93% $68,741 7.32% $93,572 8.22% $225,300
Over / (Under Budget) $12,975 40.48% ($5,615) -14.66% ($24,205) -54.35% ($42,794) -84.28% ($59,639) Under
Total Cost of Goods Sold $133,413 24.68% $165,745 22.40% $198,077 21.09% $230,408 20.24% $727,643
Total COG Budget $56,111 10.38% $114,597 15.49% $173,084 18.43% $231,570 20.34% $575,361
Total Over / (Under Budget) $77,303 57.94% $51,148 30.86% $24,993 12.62% ($1,162) -0.50% $152,282 Over
Gross Profit $407,209 75.32% $574,146 77.60% $741,083 78.91% $908,021 79.76% $2,630,459
Gross Profit Budget $310,010 57.34% $458,011 61.90% $606,011 64.53% $754,012 66.23% $2,128,043
Total Over / (Under Budget) $97,199 23.87% $116,136 20.23% $135,072 18.23% $154,009 16.96% $502,416 Over
© Copyright, 2010, JaxWorks, All Rights Reserved.
Forecast Budget Analysis
Operating Expenses
G&A Expenses
Operating Expenses $17,350 3.21% $18,700 2.53% $20,050 2.13% $21,400 1.88% $77,500
Budget $18,413 3.41% $19,961 2.70% $21,509 2.29% $23,057 2.03% $82,940
Over / (Under Budget) ($1,063) -6.13% ($1,261) -6.74% ($1,459) -7.28% ($1,657) -7.74% ($5,440) Under
Payroll Salaries $36,300 6.71% $52,050 7.03% $67,800 7.22% $83,550 7.34% $239,700
Budget $28,565 5.28% $43,109 5.83% $57,653 6.14% $72,197 6.34% $201,524
Over / (Under Budget) $7,735 21.31% $8,941 17.18% $10,147 14.97% $11,353 13.59% $38,176 Over
Total G&A Expenses $53,650 9.92% $70,750 9.56% $87,850 9.35% $104,950 9.22% $317,200
Total G&A Budget $46,978 8.69% $63,070 8.52% $79,162 8.43% $95,254 8.37% $284,464
Total Over / (Under Budget) $6,672 12.44% $7,680 10.86% $8,688 9.89% $9,696 9.24% $32,736 Over
Sales Expenses
Operating Expenses $18,050 3.34% $24,350 3.29% $30,650 3.26% $36,950 3.25% $110,000
Budget $18,413 3.41% $19,961 2.70% $21,509 2.29% $23,057 2.03% $82,940
Over / (Under Budget) ($363) -2.01% $4,389 18.02% $9,141 29.82% $13,893 37.60% $27,060 Over
Payroll Salaries $18,050 3.34% $24,350 3.29% $30,650 3.26% $36,950 3.25% $110,000
Budget $25,865 4.78% $32,759 4.43% $39,653 4.22% $46,547 4.09% $144,824
Over / (Under Budget) ($7,815) -43.30% ($8,409) -34.53% ($9,003) -29.37% ($9,597) -25.97% ($34,824) Under
Total Sales Expenses $36,100 6.68% $48,700 6.58% $61,300 6.53% $73,900 6.49% $220,000
Total Sales Expense Budget $44,278 8.19% $52,720 7.13% $61,162 6.51% $69,604 6.11% $227,764
Total Over / (Under Budget) ($8,178) -22.65% ($4,020) -8.25% $138 0.23% $4,296 5.81% ($7,764) Under
© Copyright, 2010, JaxWorks, All Rights Reserved.
Forecast Budget Analysis
Marketing Expenses
Operating Expenses $18,050 3.34% $24,350 3.29% $30,650 3.26% $36,950 3.25% $110,000
Budget $18,413 3.41% $19,961 2.70% $21,509 2.29% $23,057 2.03% $82,940
Over / (Under Budget) ($363) -2.01% $4,389 18.02% $9,141 29.82% $13,893 37.60% $27,060 Over
Payroll Salaries $19,150 3.54% $25,000 3.38% $30,850 3.28% $36,700 3.22% $111,700
Budget $25,865 4.78% $32,759 4.43% $39,653 4.22% $46,547 4.09% $144,824
Over / (Under Budget) ($6,715) -35.07% ($7,759) -31.04% ($8,803) -28.53% ($9,847) -26.83% ($33,124) Under
Total Marketing Expenses $37,200 6.88% $49,350 6.67% $61,500 6.55% $73,650 6.47% $221,700
Total Marketing Expense Budget $44,278 8.19% $52,720 7.13% $61,162 6.51% $69,604 6.11% $227,764
Total Over / (Under Budget) ($7,078) -19.03% ($3,370) -6.83% $338 0.55% $4,046 5.49% ($6,064) Under
Research & Development Expenses
Operating Expenses $70,143 12.97% $85,479 11.55% $100,815 10.73% $116,151 10.20% $372,588
Budget $65,027 12.03% $83,743 11.32% $102,458 10.91% $121,174 10.64% $372,401
Over / (Under Budget) $5,116 7.29% $1,737 2.03% ($1,643) -1.63% ($5,023) -4.32% $187 Under
Payroll Salaries $114,421 21.16% $138,199 18.68% $161,977 17.25% $185,755 16.32% $600,352
Budget $65,027 12.03% $83,743 11.32% $102,458 10.91% $121,174 10.64% $372,401
Over / (Under Budget) $49,394 43.17% $54,457 39.40% $59,519 36.75% $64,582 34.77% $227,951 Over
Total Research & Development Expenses $184,564 34.14% $223,678 30.23% $262,792 27.98% $301,906 26.52% $972,940
Total R&D Expenses Budget $130,054 24.06% $167,485 22.64% $204,916 21.82% $242,347 21.29% $744,802
Total Over / (Under Budget) $54,510 29.53% $56,193 25.12% $57,876 22.02% $59,559 19.73% $228,138 Over
Total Operating Expenses $311,514 57.62% $392,478 53.05% $473,442 50.41% $554,406 48.70% $1,731,840
Total Payroll Salaries $187,921 34.76% $239,599 32.38% $291,277 31.01% $342,955 30.13% $1,061,752
© Copyright, 2010, JaxWorks, All Rights Reserved.
Forecast Budget Analysis
Total All Operating Expenses
All Operating Expenses $499,435 92.38% $632,077 85.43% $764,719 81.43% $897,361 78.82% $2,793,592
All Operating Expenses Budget $265,588 49.13% $335,995 45.41% $406,402 43.27% $476,809 41.88% $1,484,794
Total Over / (Under Budget) $233,847 46.82% $296,082 46.84% $358,317 46.86% $420,552 46.87% $1,308,798 Over
Earnings Before Income Tax $41,187 7.62% $107,814 14.57% $174,441 18.57% $241,068 21.18% $564,510
Budget $36,865 6.82% $106,759 14.43% $176,653 18.81% $246,547 21.66% $566,824
Over / (Under Budget) $4,322 10.49% $1,055 0.98% ($2,212) -1.27% ($5,479) -2.27% ($2,314) Under
Interest income (expense) $30,909 5.72% $33,650 4.55% $36,390 3.87% $39,131 3.44% $140,079
Other income (expense) $61,818 11.43% $67,299 9.10% $72,780 7.75% $78,261 6.87% $280,158
Total Non-operating Income (expense) $92,727 17.15% $100,949 13.64% $109,170 11.62% $117,392 10.31% $420,237
Income (Loss) Before Taxes $133,914 24.77% $208,763 28.22% $283,611 30.20% $358,460 31.49% $984,747
Income Taxes $67,992 12.58% $92,913 12.56% $117,834 12.55% $142,755 12.54% $421,495
Net Income (Loss) $65,922 12.19% $115,849 15.66% $165,777 17.65% $215,704 18.95% $563,252
Budget $186,865 34.56% $346,759 46.87% $506,653 53.95% $666,547 58.55% $1,706,824
Over / (Under Budget) ($120,943) -183.47% ($230,910) -199.32% ($340,876) -205.62% ($450,843) -209.01% ($1,143,572) Under
© Copyright, 2010, Jaxworks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
Product 1
Annual Sales vs. Budget Report
Sales
Month Sales Budget Over/Under
Jan $5,600 $4,790 $810
Feb $6,350 $5,678 $672
Mar $5,100 $4,754 $346
Jan Feb
Apr $6,850 $6,501 $349 Mar Apr
May $8,600 $7,744 $856 Dec
Jun $8,850 $8,645 $205 May
Jul $12,100 $10,976 $1,124
Nov Jun
Aug $13,850 $11,232 $2,618
Sep $16,600 $14,323 $2,277 Jul
Oct $19,100 $15,434 $3,666 Oct Aug
Sep
Nov $21,600 $16,543 $5,057
Dec $24,100 $17,896 $6,204
Totals $148,700 $124,516 $24,184
Sales
$30,000
$25,000
$20,000
$15,000
$10,000
$5,000
$0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
© Copyright, 2010, Jaxworks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
Apr
May
Dec
© Copyright, 2010, JaxWorks, All Rights Reserved.
Product 2
Annual Sales vs. Budget Report
Sales
Month Sales Budget Over/Under
Jan $3,600 $5,595 ($1,995)
Feb $4,350 $5,678 ($1,328)
Mar $16,400 $9,754 $6,646
Jan Feb
Apr $16,830 $9,168 $7,662
May $17,260 $18,748 ($1,488) Dec
Jun $17,690 $14,327 $3,363 Nov Mar
Oct
Jul $15,600 $14,907 $694 Apr
Sep
Aug $17,350 $15,486 $1,864
Sep $8,600 $9,066 ($466) Aug May
Oct $9,350 $10,645 ($1,295) Jul Jun
Nov $10,100 $8,225 $1,876
Dec $10,850 $12,804 ($1,954)
Totals $147,980 $134,401 $13,579
Sales
$20,000
$15,000
$10,000
$5,000
$0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
© Copyright, 2010, Jaxworks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
Dec
© Copyright, 2010, JaxWorks, All Rights Reserved.
Product 3
Annual Sales vs. Budget Report
Sales
Month Sales Budget Over/Under
Jan $14,600 $5,895 $8,705
Feb $25,350 $3,678 $21,672
Mar $25,100 $5,754 $19,346
Jan Feb
Apr $26,850 $7,501 $19,349
Mar
May $32,100 $9,431 $22,670 Dec Apr
Jun $35,750 $11,320 $24,430
Jul $39,400 $13,209 $26,191 Nov
May
Aug $43,050 $15,099 $27,951
Sep $46,700 $16,988 $29,712 Oct Jun
Oct $50,350 $18,878 $31,473 Sep Jul
Aug
Nov $54,000 $20,767 $33,233
Dec $57,650 $22,656 $34,994
Totals $450,900 $151,175 $299,725
Sales
$70,000
$60,000
$50,000
$40,000
$30,000
$20,000
$10,000
$0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
© Copyright, 2010, Jaxworks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
Apr
Dec
© Copyright, 2010, JaxWorks, All Rights Reserved.
Product 4
Annual Sales vs. Budget Report
Sales
Month Sales Budget Over/Under
Jan $16,850 $8,895 $7,955
Feb $17,690 $14,678 $3,012
Mar $18,830 $7,754 $11,076
Apr $19,260 $6,501 $12,759
May $20,690 $9,431 $11,260 Dec Jan
Feb
Jun $21,439 $11,320 $10,119 Nov Mar
Jul $22,364 $13,209 $9,155
Oct Apr
Aug $23,289 $15,099 $8,190
Sep $24,214 $16,988 $7,226 May
Sep
Oct $25,139 $18,878 $6,262 Aug Jun
Jul
Nov $26,064 $20,767 $5,297
Dec $26,989 $22,656 $4,333
Totals $262,818 $166,175 $96,643
Sales
$30,000
$25,000
$20,000
$15,000
$10,000
$5,000
$0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
© Copyright, 2010, Jaxworks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
Dec
© Copyright, 2010, JaxWorks, All Rights Reserved.
Product 5
Annual Sales vs. Budget Report
Sales
Month Sales Budget Over/Under
Jan $78,600 $68,595 $10,005
Feb $88,750 $78,595 $10,155
Mar $89,002 $78,754 $10,248
Apr $86,850 $86,501 $349 Feb
May $96,400 $77,744 $18,656 Jan Mar
Dec
Jun $106,830 $99,845 $6,985 Apr
Jul $127,260 $115,976 $11,284 Nov
Aug $137,690 $126,232 $11,458 May
Sep $167,274 $174,323 ($7,050) Oct Jun
Oct $165,240 $155,434 $9,806 Sep Jul
Aug
Nov $193,207 $196,543 ($3,336)
Dec $191,174 $197,896 ($6,722)
Totals $1,528,277 $1,456,438 $71,839
Sales
$250,000
$200,000
$150,000
$100,000
$50,000
$0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
© Copyright, 2010, Jaxworks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
Apr
Dec
© Copyright, 2010, JaxWorks, All Rights Reserved.
Product 6
Annual Sales vs. Budget Report
Sales
Month Sales Budget Over/Under
Jan $36,000 $15,754 $20,246
Feb $43,350 $16,501 $26,849
Mar $45,100 $15,744 $29,356
Jan Feb
Apr $46,850 $14,987 $31,863
May $56,400 $14,982 $41,418 Mar
Dec
Jun $66,830 $14,676 $52,154 Apr
Nov
Jul $68,593 $14,370 $54,223
Aug $74,166 $15,419 $58,747 May
Oct
Sep $79,739 $14,323 $65,416 Jun
Oct $85,312 $15,434 $69,878 Sep Jul
Aug
Nov $90,885 $16,543 $74,342
Dec $96,458 $17,896 $78,562
Totals $789,683 $186,629 $603,054
Sales
$120,000
$100,000
$80,000
$60,000
$40,000
$20,000
$0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
© Copyright, 2010, Jaxworks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
Apr
Dec
© Copyright, 2010, JaxWorks, All Rights Reserved.
Summary Report: Annual Sales vs. Budget
Month Sales Budget Over/Under
Jan $155,250 $109,524 $45,726
Feb $185,840 $124,808 $61,032
Total Sales by Product
Mar $199,532 $122,514 $77,018
Apr $203,490 $131,159 $72,331
May $231,450 $138,079 $93,372 Feb
Jan Mar
Jun $257,389 $160,133 $97,256 Dec
Jul $285,317 $182,648 $102,670 Nov Apr
Aug $309,395 $198,566 $110,829
May
Sep $343,127 $246,011 $97,116 Oct
Oct $354,491 $234,702 $119,789 Jun
Sep Jul
Nov $395,856 $279,387 $116,469 Aug
Dec $407,221 $291,805 $115,416
Totals $3,328,358 $2,219,335 $1,109,023
Sales Budget
$450,000
$400,000
$350,000
$300,000
$250,000
$200,000
$150,000
$100,000
$50,000
$0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
© Copyright, 2010, Jaxworks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
Materials
Summary Materials Expense vs. Budget Report
Materials
Month Expense Budget Over/Under
Jan $3,168 $1,595 $1,573
Feb $3,748 $1,678 $2,070
Mar $4,327 $4,754 ($427) Mar
Jan Feb
Apr $4,907 $6,501 ($1,595)
Apr
May $5,486 $8,081 ($2,595) Dec May
Jun $10,350 $9,845 $505
Jul $12,100 $10,976 $1,124 Jun
Nov
Aug $13,850 $11,232 $2,618
Jul
Sep $15,600 $14,323 $1,277
Oct $17,350 $15,434 $1,916 Oct Aug
Sep
Nov $19,100 $16,543 $2,557
Dec $20,850 $17,896 $2,954
Totals $130,835 $118,858 $11,978
Expense Budget
$25,000
$20,000
$15,000
$10,000
$5,000
$0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
© Copyright, 2010, Jaxworks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
May
© Copyright, 2010, JaxWorks, All Rights Reserved.
Labor
Summary Labor Expense vs. Budget Report
Labor
Month Expense Budget Over/Under
Jan $16,400 $4,754 $11,646
Feb $16,830 $6,501 $10,329
Mar $17,260 $8,081 $9,180
Apr $17,690 $9,845 $7,845
May $15,600 $10,976 $4,624 Dec Jan
Jun $10,350 $9,845 $505 Feb
Nov
Jul $12,100 $10,976 $1,124 Mar
Aug $13,850 $11,232 $2,618 Oct
Sep $15,600 $14,323 $1,277 Apr
Sep
Oct $17,350 $15,434 $1,916 Aug May
Jul Jun
Nov $19,100 $16,543 $2,557
Dec $20,850 $17,896 $2,954
Totals $192,980 $136,406 $56,575
Expense Budget
$25,000
$20,000
$15,000
$10,000
$5,000
$0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
© Copyright, 2010, Jaxworks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
Overhead
Summary Overhead Expense vs. Budget Report
Overhead
Month Expense Budget Over/Under
Jan $16,400 $4,754 $11,646
Feb $16,830 $6,501 $10,329
Mar $17,260 $8,081 $9,180
Apr $17,690 $9,845 $7,845
May $15,600 $10,976 $4,624 Dec Jan
Jun $10,350 $9,845 $505 Feb
Nov
Jul $12,100 $10,976 $1,124 Mar
Aug $13,850 $11,232 $2,618 Oct
Sep $15,600 $14,323 $1,277 Apr
Sep
Oct $17,350 $15,434 $1,916 Aug May
Jul Jun
Nov $19,100 $16,543 $2,557
Dec $20,850 $17,896 $2,954
Totals $192,980 $136,406 $56,575
Expense Budget
$25,000
$20,000
$15,000
$10,000
$5,000
$0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
© Copyright, 2010, Jaxworks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
Other Direct Expenses
Summary Other Expense vs. Budget Report
Other Expenses
Month Expense Budget Over/Under
Jan $9,845 $4,327 $5,518
Feb $10,976 $4,907 $6,070
Mar $11,232 $9,845 $1,387
Apr $14,323 $10,976 $3,347
May $15,434 $11,232 $4,202 Dec Jan Feb Mar
Jun $10,350 $9,845 $505
Nov
Jul $12,100 $10,976 $1,124 Apr
Aug $13,850 $11,232 $2,618 Oct
Sep $15,600 $14,323 $1,277 May
Oct $17,350 $15,434 $1,916 Sep
Aug Jul
Nov $19,100 $16,543 $2,557
Dec $20,850 $17,896 $2,954
Jun
Totals $171,010 $137,536 $33,475
Expense Budget
$25,000
$20,000
$15,000
$10,000
$5,000
$0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
© Copyright, 2010, Jaxworks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
Total Cost of Goods Sold
Summary COG vs. Budget Report
COG
Month COG Budget Over/Under
Jan $40,733 $13,430 $27,303
Feb $44,763 $16,254 $28,509
Mar $47,918 $26,427 $21,491
Apr $53,908 $31,649 $22,259
May $55,398 $35,195 $20,203 Dec Jan Feb
Jun $41,400 $39,380 $2,020 Mar
Nov
Jul $48,400 $43,904 $4,496
Apr
Aug $55,400 $44,928 $10,472 Oct
Sep $62,400 $57,292 $5,108 May
Oct $69,400 $61,736 $7,664 Sep
Aug Jul
Nov $76,400 $66,172 $10,228
Dec $83,400 $71,584 $11,816
Jun
Totals $679,519 $507,951 $171,568
COG Budget
$90,000
$80,000
$70,000
$60,000
$50,000
$40,000
$30,000
$20,000
$10,000
$0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
© Copyright, 2010, Jaxworks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
Gross Profit
Summary Gross Profit
Gross Profit
Month Gross Profit Budget Over/Under
Jan $114,517 $90,567 $23,950
Feb $141,077 $95,987 $45,090
Mar $151,614 $123,456 $28,158
Jan Feb
Apr $149,582 $141,587 $7,995
Mar
May $176,053 $158,032 $18,021 Dec
Jun $215,989 $176,085 $39,904 Apr
Nov
Jul $236,917 $194,138 $42,779
Aug $253,995 $212,191 $41,804 May
Oct Jun
Sep $280,727 $230,244 $50,483
Oct $285,091 $248,297 $36,794 Sep Jul
Aug
Nov $319,456 $266,350 $53,106
Dec $323,821 $284,403 $39,418
Totals $2,648,839 $2,221,337 $427,502
Gross Profit Budget
$350,000
$300,000
$250,000
$200,000
$150,000
$100,000
$50,000
$0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
© Copyright, 2010, Jaxworks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
Apr
© Copyright, 2010, JaxWorks, All Rights Reserved.
G&A Expenses
Summary of Operating Expenses
Operating Expenses
Month Operating Expenses Budget Over/Under
Jan $5,600 $6,012 ($412)
Feb $5,850 $6,045 ($195)
Mar $5,900 $6,356 ($456)
Jan Feb
Apr $6,850 $6,501 $349 Mar
May $8,600 $7,744 $856 Apr
Dec
Jun $10,350 $9,845 $505 May
Jul $12,100 $10,976 $1,124 Nov
Aug $13,850 $11,232 $2,618 Jun
Sep $15,600 $14,323 $1,277 Oct Jul
Oct $17,350 $15,434 $1,916 Sep Aug
Nov $19,100 $16,543 $2,557
Dec $20,850 $17,896 $2,954
Totals $142,000 $128,907 $13,093
Operating Expenses Budget
$25,000
$20,000
$15,000
$10,000
$5,000
$0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
© Copyright, 2010, Jaxworks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
Apr
May
© Copyright, 2010, JaxWorks, All Rights Reserved.
G&A Expenses
Summary of Payroll Salaries
Payroll Salaries Expenses
Month Payroll Salaries Budget Over/Under
Jan $10,350 $7,744 $2,606
Feb $12,100 $9,845 $2,255
Mar $13,850 $10,976 $2,874
Jan Feb
Apr $15,600 $11,232 $4,368
May $17,350 $14,323 $3,027 Mar
Dec
Jun $19,100 $15,188 $3,913
Nov Apr
Jul $20,850 $16,642 $4,208
Aug $22,600 $18,097 $4,504 May
Oct
Sep $24,350 $19,551 $4,799 Jun
Oct $26,100 $21,006 $5,095 Sep Jul
Aug
Nov $27,850 $22,460 $5,390
Dec $29,600 $23,915 $5,686
Totals $239,700 $190,977 $48,723
Payroll Salaries Budget
$35,000
$30,000
$25,000
$20,000
$15,000
$10,000
$5,000
$0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
© Copyright, 2010, Jaxworks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
Total G&A Expenses
Summary of G&A Expenses
Total G&A Expenses
Month Total G&A Expenses Budget Over/Under
Jan $15,950 $13,756 $2,194
Feb $17,950 $15,890 $2,060
Mar $19,750 $17,332 $2,418
Jan Feb
Apr $22,450 $17,733 $4,717
Mar
May $25,950 $22,067 $3,883 Dec
Jun $29,450 $25,033 $4,418 Apr
Jul $32,950 $27,618 $5,332 Nov
May
Aug $36,450 $29,329 $7,122
Sep $39,950 $33,874 $6,076 Oct Jun
Oct $43,450 $36,440 $7,011 Sep Jul
Aug
Nov $46,950 $39,003 $7,947
Dec $50,450 $41,811 $8,640
Totals $381,700 $319,884 $61,816
Total G&A Expenses Budget
$60,000
$50,000
$40,000
$30,000
$20,000
$10,000
$0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
© Copyright, 2010, Jaxworks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
Apr
© Copyright, 2010, JaxWorks, All Rights Reserved.
Sales Expenses
Summary of Sales Operating Expenses
Sales Operating Expenses
Month Operating Expenses Budget Over/Under
Jan $5,500 $6,012 ($512)
Feb $5,650 $6,045 ($395)
Mar $6,900 $6,356 $544
Apr $7,750 $6,501 $1,249 Feb
May $8,450 $7,744 $706 Mar
Dec Jan
Jun $9,250 $9,845 ($595)
Nov Apr
Jul $10,050 $10,976 ($926)
Aug $10,850 $11,232 ($382) May
Oct
Sep $11,650 $14,323 ($2,673) Jun
Oct $12,450 $15,434 ($2,984) Sep Jul
Aug
Nov $13,250 $16,543 ($3,293)
Dec $14,050 $17,896 ($3,846)
Totals $115,800 $128,907 ($13,107)
Operating Expenses Budget
$20,000
$15,000
$10,000
$5,000
$0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
© Copyright, 2010, Jaxworks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
Sales Expenses
Summary of Sales Payroll Salaries Expenses
Sales Payroll Salaries Expenses
Month Payroll Salaries Budget Over/Under
Jan $5,500 $7,744 ($2,244)
Feb $5,650 $8,845 ($3,195)
Mar $6,900 $9,276 ($2,376)
Jan Feb
Apr $7,750 $10,232 ($2,482)
Mar
May $8,450 $10,998 ($2,548) Dec Apr
Jun $9,250 $11,788 ($2,538)
Jul $12,050 $12,577 ($527) Nov
May
Aug $11,993 $13,367 ($1,374)
Sep $13,007 $14,156 ($1,149) Oct Jun
Oct $14,021 $14,946 ($924) Sep Jul
Aug
Nov $15,036 $15,735 ($699)
Dec $16,050 $16,525 ($475)
Totals $125,657 $146,187 ($20,530)
Payroll Salaries Budget
$18,000
$16,000
$14,000
$12,000
$10,000
$8,000
$6,000
$4,000
$2,000
$0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
© Copyright, 2010, Jaxworks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
Apr
© Copyright, 2010, JaxWorks, All Rights Reserved.
Total Sales Expenses
Summary of Sales Expenses
Total Sales Expenses
Month Total Sales Expenses Budget Over/Under
Jan $11,000 $13,756 ($2,756)
Feb $11,300 $14,890 ($3,590)
Mar $13,800 $15,632 ($1,832)
Jan Feb
Apr $15,500 $16,733 ($1,233)
Mar
May $16,900 $18,742 ($1,842) Dec
Jun $18,500 $21,633 ($3,133)
Nov Apr
Jul $22,100 $23,553 ($1,453)
Aug $22,843 $24,599 ($1,756) May
Oct
Sep $24,657 $28,479 ($3,822) Jun
Oct $26,471 $30,380 ($3,908) Sep Jul
Aug
Nov $28,286 $32,278 ($3,992)
Dec $30,100 $34,421 ($4,321)
Totals $241,457 $275,094 ($33,637)
Total Sales Expenses Budget
$40,000
$35,000
$30,000
$25,000
$20,000
$15,000
$10,000
$5,000
$0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
© Copyright, 2010, Jaxworks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
Marketing Expenses
Summary of Marketing Operating Expenses
Marketing Operating Expenses
Month Operating Expenses Budget Over/Under
Jan $5,500 $6,012 ($512)
Feb $5,650 $6,045 ($395)
Mar $6,900 $6,356 $544
Apr $7,750 $6,501 $1,249 Feb
May $8,450 $7,744 $706 Mar
Dec Jan
Jun $9,250 $9,845 ($595)
Nov Apr
Jul $10,050 $10,976 ($926)
Aug $10,850 $11,232 ($382) May
Oct
Sep $11,650 $14,323 ($2,673) Jun
Oct $12,450 $15,434 ($2,984) Sep Jul
Aug
Nov $13,250 $16,543 ($3,293)
Dec $14,050 $17,896 ($3,846)
Totals $115,800 $128,907 ($13,107)
Operating Expenses Budget
$20,000
$15,000
$10,000
$5,000
$0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
© Copyright, 2010, Jaxworks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
Marketing Expenses
Summary of Marketing Payroll Salaries Expenses
Marketing Payroll Salaries Expenses
Month Payroll Salaries Budget Over/Under
Jan $5,500 $7,744 ($2,244)
Feb $5,650 $8,845 ($3,195)
Mar $6,900 $9,276 ($2,376)
Jan Feb
Apr $7,750 $10,232 ($2,482)
Mar
May $8,450 $10,998 ($2,548) Dec Apr
Jun $9,250 $11,788 ($2,538)
Jul $12,050 $12,577 ($527) Nov
May
Aug $11,993 $13,367 ($1,374)
Sep $13,007 $14,156 ($1,149) Oct Jun
Oct $14,021 $14,946 ($924) Sep Jul
Aug
Nov $15,036 $15,735 ($699)
Dec $16,050 $16,525 ($475)
Totals $125,657 $146,187 ($20,530)
Payroll Salaries Budget
$18,000
$16,000
$14,000
$12,000
$10,000
$8,000
$6,000
$4,000
$2,000
$0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
© Copyright, 2010, Jaxworks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
Salaries Expenses
Apr
© Copyright, 2010, JaxWorks, All Rights Reserved.
Total Marketing Expenses
Summary of Marketing Expenses
Total Marketing Expenses
Month Marketing Expenses Budget Over/Under
Jan $11,100 $13,756 ($2,656)
Feb $12,300 $14,890 ($2,590)
Mar $13,800 $15,632 ($1,832)
Apr $15,300 $16,733 ($1,433) Feb
May $17,000 $18,742 ($1,742) Mar
Dec Jan
Jun $18,400 $21,633 ($3,233)
Nov Apr
Jul $22,100 $23,553 ($1,453)
Aug $22,843 $24,599 ($1,756) May
Oct
Sep $24,657 $28,479 ($3,822) Jun
Oct $26,471 $30,380 ($3,908) Sep Jul
Aug
Nov $28,286 $32,278 ($3,992)
Dec $30,100 $34,421 ($4,321)
Totals $242,357 $275,094 ($32,737)
Marketing Expenses Budget
$40,000
$35,000
$30,000
$25,000
$20,000
$15,000
$10,000
$5,000
$0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
© Copyright, 2010, Jaxworks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
Research & Development Expenses
Summary of R&D Operating Expenses
R&D Operating Expenses
Month Operating Expenses Budget Over/Under
Jan $21,500 $19,595 $1,905
Feb $23,735 $21,678 $2,057
Mar $24,908 $23,754 $1,154
Apr $26,965 $25,501 $1,464 Feb
May $29,740 $27,581 $2,160 Dec Jan Mar
Jun $33,420 $29,560 $3,860
Nov Apr
Jul $36,130 $31,539 $4,591
Aug $37,965 $33,519 $4,446 May
Oct
Sep $42,635 $35,498 $7,137 Jun
Oct $45,325 $37,478 $7,848 Sep Jul
Aug
Nov $48,013 $39,457 $8,556
Dec $50,945 $41,436 $9,509
Totals $421,281 $366,595 $54,686
Operating Expenses Budget
$60,000
$50,000
$40,000
$30,000
$20,000
$10,000
$0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
© Copyright, 2010, Jaxworks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
Research & Development Expenses
Summary of R&D Payroll Salaries Expenses
Marketing Payroll Salaries Expenses
Month Payroll Salaries Budget Over/Under
Jan $35,256 $19,595 $15,661
Feb $38,625 $21,678 $16,947
Mar $40,540 $23,754 $16,786
Apr $43,698 $25,501 $18,197 Feb
May $48,482 $27,581 $20,902 Dec Jan Mar
Jun $55,053 $29,560 $25,493
Nov Apr
Jul $59,683 $31,539 $28,144
Aug $62,564 $33,519 $29,045 May
Oct
Sep $71,114 $35,498 $35,616 Jun
Oct $75,705 $37,478 $38,227 Sep Jul
Aug
Nov $80,291 $39,457 $40,834
Dec $85,366 $41,436 $43,929
Totals $696,375 $366,595 $329,780
Payroll Salaries Budget
$90,000
$80,000
$70,000
$60,000
$50,000
$40,000
$30,000
$20,000
$10,000
$0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
© Copyright, 2010, Jaxworks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
Salaries Expenses
© Copyright, 2010, JaxWorks, All Rights Reserved.
Total Research & Development Expenses
Summary of R&D Expenses
Total Marketing Expenses
Month Marketing Expenses Budget Over/Under
Jan $56,756 $39,190 $17,566
Feb $62,360 $43,356 $19,004
Mar $65,448 $47,508 $17,940
Apr $70,663 $51,002 $19,661 Feb
May $78,222 $55,161 $23,061 Dec Jan Mar
Jun $88,473 $59,120 $29,353
Nov Apr
Jul $95,813 $63,079 $32,734
Aug $100,529 $67,037 $33,491 May
Oct
Sep $113,749 $70,996 $42,753 Jun
Oct $121,030 $74,955 $46,075 Sep Jul
Aug
Nov $128,304 $78,914 $49,390
Dec $136,311 $82,873 $53,438
Totals $1,117,656 $733,190 $384,466
Marketing Expenses Budget
$160,000
$140,000
$120,000
$100,000
$80,000
$60,000
$40,000
$20,000
$0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
© Copyright, 2010, Jaxworks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
Total All Operating Expenses
Summary of All Operating Expenses
Total All Operating Expenses
Month All Operating Expenses Budget Over/Under
Jan $151,512 $80,458 $71,054
Feb $166,935 $89,026 $77,909
Mar $180,988 $96,104 $84,884
Apr $198,511 $102,201 $96,310 Feb
May $220,904 $114,712 $106,192 Jan Mar
Dec
Jun $247,375 $127,417 $119,958
Nov Apr
Jul $277,596 $137,803 $139,793
Aug $291,813 $145,563 $146,251 May
Oct
Sep $324,492 $161,828 $162,663 Jun
Oct $347,270 $172,154 $175,116 Sep Jul
Aug
Nov $370,038 $182,473 $187,565
Dec $394,026 $193,524 $200,502
Totals $3,171,460 $1,603,262 $1,568,197
All Operating Expenses Budget
$450,000
$400,000
$350,000
$300,000
$250,000
$200,000
$150,000
$100,000
$50,000
$0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
© Copyright, 2010, Jaxworks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
Earnings Before Income Tax
Summary of Earnings Before Income Tax
Earnings Before Income Tax
Month EBIT Budget Over/Under
Jan $3,738 $1,744 $1,994
Feb $18,905 $17,845 $1,060
Mar $18,544 $17,276 $1,268
Jan
Apr $4,979 $5,232 ($253)
May $10,546 $10,998 ($452) Dec Feb
Jun $10,014 $11,788 ($1,774) Nov
Jul $7,721 $12,577 ($4,856) Mar
Aug $17,582 $13,367 $4,215 Oct
Sep $18,635 $14,156 $4,479 Sep May
Oct $7,222 $14,946 ($7,724) Jun Apr
Aug Jul
Nov $25,818 $15,735 $10,083
Dec $13,195 $16,525 ($3,330)
Totals $156,898 $152,187 $4,711
EBIT Budget
$30,000
$25,000
$20,000
$15,000
$10,000
$5,000
$0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
© Copyright, 2010, Jaxworks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
Apr
© Copyright, 2010, JaxWorks, All Rights Reserved.
Net Income (Loss)
Summary of Net Income (Loss)
Net Income (Loss)
Month Net Income Budget Over/Under
Jan $14,617 $41,744 ($27,127)
Feb $25,594 $67,845 ($42,252)
Mar $25,712 $77,276 ($51,564)
Apr $16,580 $55,232 ($38,652)
May $20,842 $60,998 ($40,156) Dec Jan Feb
Jun $20,835 $66,388 ($45,553) Nov
Jul $19,596 $70,977 ($51,381) Mar
Aug $26,863 $85,567 ($58,703) Oct Apr
Sep $27,966 $90,156 ($62,190) Sep May
Oct $20,342 $64,746 ($44,404) Aug Jul Jun
Nov $33,725 $99,335 ($65,610)
Dec $25,254 $63,925 ($38,671)
Totals $277,924 $844,187 ($566,263)
Net Income Budget
$120,000
$100,000
$80,000
$60,000
$40,000
$20,000
$0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
© Copyright, 2010, Jaxworks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
© Copyright, 2010, JaxWorks, All Rights Reserved.
Copyright Notice
© 2010, JaxWorks
All rights reserved.
Specifications are subject to change without notice.
Fortress™ Budget System is a registered trademark of Jaxworks. All other brands or products are trademarks or registered
trademarks of their respective holders and should be treated as such.
This program is protected by copyright law and international treaties.Unauthorized reproduction or distribution of this program, or any
portion of it may result in severe civil and criminal penalties, and will be prosecuted to the maximum extent possible under law.
NOTICES REGARDING SOFTWARE, DOCUMENTS AND SERVICES.
IN NO EVENT SHALL JAXWORKS BE LIABLE FOR ANY SPECIAL, INDIRECT OR CONSEQUENTIAL DAMAGES OR ANY
DAMAGES WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT,
NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF OR IN CONNECTION WITH THE USE OR PERFORMANCE
OF SOFTWARE, DOCUMENTS, PROVISION OF OR FAILURE TO PROVIDE SERVICES, OR INFORMATION AVAILABLE FROM
THIS PROGRAM.
© Copyright, 2007, Jaxworks, All Rights Reserved.
