fortress excel budget analysis

Reviews

Tags

Stats

views:: 1514
rating:: not rated
reviews:: 0
posted:: 2/27/2008
language:: English
pages:: 0

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 and the surrounding defensive walls is the budget. Fortress™ is designed to financially manage a business through 12 months of performance by using budgeting as a 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 bills. A 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 year. At 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 in the 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 allows you to perceive problems before they occur and alter your plans to prevent those problems. Fortress™ covers the basic concept of budgeting and takes you 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 achieve 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. Next © Copyright, 2006, 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 Next © Copyright, 2006, JaxWorks, All Rights Reserved. Period Starting: Sales Product 1 Budget Over / (Under Budget) Product 2 Budget Over / (Under Budget) Product 3 Budget Over / (Under Budget) Product 4 Budget Over / (Under Budget) Product 5 Budget Over / (Under Budget) Product 6 Budget Over / (Under Budget) Total Sales Total Sales Budget Total Over / (Under Budget) Jan 1 $5,600 $4,790 $810 $3,600 $5,595 ($1,995) $14,600 $5,895 $8,705 $16,850 $8,895 $7,955 $78,600 $68,595 $10,005 $36,000 $15,754 $20,246 155,250 109,524 $45,726 Feb 2 $6,350 $5,678 $672 $4,350 $5,678 ($1,328) $25,350 $3,678 $21,672 $17,690 $14,678 $3,012 $88,750 $78,595 $10,155 $43,350 $16,501 $26,849 185,840 124,808 $61,032 Mar 3 $5,100 $4,754 $346 $16,400 $9,754 $6,646 $25,100 $5,754 $19,346 $18,830 $7,754 $11,076 $89,002 $78,754 $10,248 $45,100 $15,744 $29,356 199,532 122,514 $77,018 Apr 4 $6,850 $6,501 $349 $16,830 $9,168 $7,662 $26,850 $7,501 $19,349 $19,260 $6,501 $12,759 $86,850 $86,501 $349 $46,850 $14,987 $31,863 203,490 131,159 $72,331 May 5 $8,600 $7,744 $856 $17,260 $18,748 ($1,488) $32,100 $9,431 $22,670 $20,690 $9,431 $11,260 $96,400 $77,744 $18,656 $56,400 $14,982 $41,418 231,450 138,079 $93,372 Jun 6 $8,850 $8,645 $205 $17,690 $14,327 $3,363 $35,750 $11,320 $24,430 $21,439 $11,320 $10,119 $106,830 $99,845 $6,985 $66,830 $14,676 $52,154 257,389 160,133 $97,256 Jul 7 $12,100 $10,976 $1,124 $15,600 $14,907 $694 $39,400 $13,209 $26,191 $22,364 $13,209 $9,155 $127,260 $115,976 $11,284 $68,593 $14,370 $54,223 285,317 182,648 $102,670 Aug 8 $13,850 $11,232 $2,618 $17,350 $15,486 $1,864 $43,050 $15,099 $27,951 $23,289 $15,099 $8,190 $137,690 $126,232 $11,458 $74,166 $15,419 $58,747 309,395 198,566 $110,829 Sep 9 $16,600 $14,323 $2,277 $8,600 $9,066 ($466) $46,700 $16,988 $29,712 $24,214 $16,988 $7,226 $167,274 $174,323 ($7,050) $79,739 $14,323 $65,416 343,127 246,011 $97,116 Oct 10 $19,100 $15,434 $3,666 $9,350 $10,645 ($1,295) $50,350 $18,878 $31,473 $25,139 $18,878 $6,262 $165,240 $155,434 $9,806 $85,312 $15,434 $69,878 354,491 234,702 $119,789 Nov 11 $21,600 $16,543 $5,057 $10,100 $8,225 $1,876 $54,000 $20,767 $33,233 $26,064 $20,767 $5,297 $193,207 $196,543 ($3,336) $90,885 $16,543 $74,342 395,856 279,387 $116,469 Dec 12 $24,100 $17,896 $6,204 $10,850 $12,804 ($1,954) $57,650 $22,656 $34,994 $26,989 $22,656 $4,333 $191,174 $197,896 ($6,722) $96,458 $17,896 $78,562 407,221 291,805 $115,416 Totals $148,700 $124,516 ($24,184) $147,980 $134,401 $13,579 $450,900 $151,175 $299,725 $262,818 $166,175 $96,643 $1,528,277 $1,456,438 $71,839 $789,683 $186,629 $603,054 3,328,358 2,219,335 $1,109,023 © Copyright, 2006, JaxWorks, All Rights Reserved. Less Cost of Goods Sold Materials Budget Over / (Under Budget) Labor Budget Over / (Under Budget) Overhead Budget Over / (Under Budget) Other Budget Over / (Under Budget) Total Cost of Goods Sold Total COG Budget Total Over / (Under Budget) Gross Profit Gross Profit Budget GP Budget Total Over / (Under Budget) $3,168 $1,595 $1,573 $16,400 $4,754 $11,646 $11,320 $2,754 $8,566 $9,845 $4,327 $5,518 $40,733 $13,430 $27,303 $114,517 $96,094 $18,423 $3,748 $1,678 $2,070 $16,830 $6,501 $10,329 $13,209 $3,168 $10,041 $10,976 $4,907 $6,070 $44,763 $16,254 $28,509 $141,077 $108,555 $32,523 $4,327 $4,754 ($427) $17,260 $8,081 $9,180 $15,099 $3,748 $11,351 $11,232 $9,845 $1,387 $47,918 $26,427 $21,491 $151,614 $96,087 $55,527 $4,907 $6,501 ($1,595) $17,690 $9,845 $7,845 $16,988 $4,327 $12,661 $14,323 $10,976 $3,347 $53,908 $31,649 $22,259 $149,582 $99,510 $50,072 $5,486 $8,081 ($2,595) $15,600 $10,976 $4,624 $18,878 $4,907 $13,971 $15,434 $11,232 $4,202 $55,398 $35,195 $20,203 $176,053 $102,884 $73,169 $10,350 $9,845 $505 $10,350 $9,845 $505 $10,350 $9,845 $505 $10,350 $9,845 $505 $41,400 $39,380 $2,020 $215,989 $120,753 $95,236 $12,100 $10,976 $1,124 $12,100 $10,976 $1,124 $12,100 $10,976 $1,124 $12,100 $10,976 $1,124 $48,400 $43,904 $4,496 $236,917 $138,744 $98,174 $13,850 $11,232 $2,618 $13,850 $11,232 $2,618 $13,850 $11,232 $2,618 $13,850 $11,232 $2,618 $55,400 $44,928 $10,472 $253,995 $153,638 $100,357 $15,600 $14,323 $1,277 $15,600 $14,323 $1,277 $15,600 $14,323 $1,277 $15,600 $14,323 $1,277 $62,400 $57,292 $5,108 $280,727 $188,719 $92,008 $17,350 $15,434 $1,916 $17,350 $15,434 $1,916 $17,350 $15,434 $1,916 $17,350 $15,434 $1,916 $69,400 $61,736 $7,664 $285,091 $172,966 $112,125 $19,100 $16,543 $2,557 $19,100 $16,543 $2,557 $19,100 $16,543 $2,557 $19,100 $16,543 $2,557 $76,400 $66,172 $10,228 $319,456 $213,215 $106,241 $20,850 $17,896 $2,954 $20,850 $17,896 $2,954 $20,850 $17,896 $2,954 $20,850 $17,896 $2,954 $83,400 $71,584 $11,816 $323,821 $220,221 $103,600 $130,835 $118,858 $11,978 $192,980 $136,406 $56,575 $184,694 $115,152 $69,542 $171,010 $137,536 $33,475 $679,519 $507,951 $171,568 $2,648,839 $1,711,384 $937,455 Operating Expenses G&A Expenses Operating Expenses Budget Over / (Under Budget) Payroll Salaries Budget Over / (Under Budget) Total G&A Expenses Total G&A Budget Total Over / (Under Budget) $5,600 $6,012 ($412) $10,350 $7,744 $2,606 $15,950 $13,756 $2,194 $5,850 $6,045 ($195) $12,100 $9,845 $2,255 $17,950 $15,890 $2,060 $5,900 $6,356 ($456) $13,850 $10,976 $2,874 $19,750 $17,332 $2,418 $6,850 $6,501 $349 $15,600 $11,232 $4,368 $22,450 $17,733 $4,717 $8,600 $7,744 $856 $17,350 $14,323 $3,027 $25,950 $22,067 $3,883 $10,350 $9,845 $505 $19,100 $15,188 $3,913 $29,450 $25,033 $4,418 $12,100 $10,976 $1,124 $20,850 $16,642 $4,208 $32,950 $27,618 $5,332 $13,850 $11,232 $2,618 $22,600 $18,097 $4,504 $36,450 $29,329 $7,122 $15,600 $14,323 $1,277 $24,350 $19,551 $4,799 $39,950 $33,874 $6,076 $17,350 $15,434 $1,916 $26,100 $21,006 $5,095 $43,450 $36,440 $7,011 $19,100 $16,543 $2,557 $27,850 $22,460 $5,390 $46,950 $39,003 $7,947 $20,850 $17,896 $2,954 $29,600 $23,915 $5,686 $50,450 $41,811 $8,640 $142,000 $128,907 $270,907 $239,700 $190,977 $430,677 $381,700 $319,884 $61,816 Sales Expenses Operating Expenses Budget Over / (Under Budget) Payroll Salaries Budget Over / (Under Budget) Total Sales Expenses Total Sales Expense Budget Total Over / (Under Budget) $5,500 $6,012 ($512) $5,500 $7,744 ($2,244) $11,000 $13,756 ($2,756) $5,650 $6,045 ($395) $5,650 $8,845 ($3,195) $11,300 $14,890 ($3,590) $6,900 $6,356 $544 $6,900 $9,276 ($2,376) $13,800 $15,632 ($1,832) $7,750 $6,501 $1,249 $7,750 $10,232 ($2,482) $15,500 $16,733 ($1,233) $8,450 $7,744 $706 $8,450 $10,998 ($2,548) $16,900 $18,742 ($1,842) $9,250 $9,845 ($595) $9,250 $11,788 ($2,538) $18,500 $21,633 ($3,133) $10,050 $10,976 ($926) $12,050 $12,577 ($527) $22,100 $23,553 ($1,453) $10,850 $11,232 ($382) $11,993 $13,367 ($1,374) $22,843 $24,599 ($1,756) $11,650 $14,323 ($2,673) $13,007 $14,156 ($1,149) $24,657 $28,479 ($3,822) $12,450 $15,434 ($2,984) $14,021 $14,946 ($924) $26,471 $30,380 ($3,908) $13,250 $16,543 ($3,293) $15,036 $15,735 ($699) $28,286 $32,278 ($3,992) $14,050 $17,896 ($3,846) $16,050 $16,525 ($475) $30,100 $34,421 ($4,321) $115,800 $128,907 $244,707 $125,657 $146,187 $271,844 $241,457 $275,094 ($33,637) © Copyright, 2006, JaxWorks, All Rights Reserved. Marketing Expenses Operating Expenses Budget Over / (Under Budget) Payroll Salaries Budget Over / (Under Budget) Total Marketing Expenses Total Marketing Expense Budget Total Over / (Under Budget) $5,500 $6,012 ($512) $5,600 $7,744 ($2,144) $11,100 $13,756 ($2,656) $5,650 $6,045 ($395) $6,650 $8,845 ($2,195) $12,300 $14,890 ($2,590) $6,900 $6,356 $544 $6,900 $9,276 ($2,376) $13,800 $15,632 ($1,832) $7,750 $6,501 $1,249 $7,550 $10,232 ($2,682) $15,300 $16,733 ($1,433) $8,450 $7,744 $706 $8,550 $10,998 ($2,448) $17,000 $18,742 ($1,742) $9,250 $9,845 ($595) $9,150 $11,788 ($2,638) $18,400 $21,633 ($3,233) $10,050 $10,976 ($926) $12,050 $12,577 ($527) $22,100 $23,553 ($1,453) $10,850 $11,232 ($382) $11,993 $13,367 ($1,374) $22,843 $24,599 ($1,756) $11,650 $14,323 ($2,673) $13,007 $14,156 ($1,149) $24,657 $28,479 ($3,822) $12,450 $15,434 ($2,984) $14,021 $14,946 ($924) $26,471 $30,380 ($3,908) $13,250 $16,543 ($3,293) $15,036 $15,735 ($699) $28,286 $32,278 ($3,992) $14,050 $17,896 ($3,846) $16,050 $16,525 ($475) $30,100 $34,421 ($4,321) $115,800 $128,907 $244,707 $126,557 $146,187 $272,744 $242,357 $275,094 ($32,737) Research & Development Expenses Operating Expenses Budget Over / (Under Budget) Payroll Salaries Budget Over / (Under Budget) Total Research & Development Expenses Total R&D Expenses Budget Total Over / (Under Budget) Total Operating Expenses Total Payroll Salaries $21,500 $19,595 $1,905 $35,256 $19,595 $15,661 $56,756 $39,190 $17,566 $94,806 $56,706 $23,735 $21,678 $2,057 $38,625 $21,678 $16,947 $62,360 $43,356 $19,004 $103,910 $63,025 $24,908 $23,754 $1,154 $40,540 $23,754 $16,786 $65,448 $47,508 $17,940 $112,798 $68,190 $26,965 $25,501 $1,464 $43,698 $25,501 $18,197 $70,663 $51,002 $19,661 $123,913 $74,598 $29,740 $27,581 $2,160 $48,482 $27,581 $20,902 $78,222 $55,161 $23,061 $138,072 $82,832 $33,420 $29,560 $3,860 $55,053 $29,560 $25,493 $88,473 $59,120 $29,353 $154,823 $92,553 $36,130 $31,539 $4,591 $59,683 $31,539 $28,144 $95,813 $63,079 $32,734 $172,963 $104,633 $37,965 $33,519 $4,446 $62,564 $33,519 $29,045 $100,529 $67,037 $33,491 $182,664 $109,149 $42,635 $35,498 $7,137 $71,114 $35,498 $35,616 $113,749 $70,996 $42,753 $203,013 $121,478 $45,325 $37,478 $7,848 $75,705 $37,478 $38,227 $121,030 $74,955 $46,075 $217,422 $129,847 $48,013 $39,457 $8,556 $80,291 $39,457 $40,834 $128,304 $78,914 $49,390 $231,825 $138,212 $50,945 $41,436 $9,509 $85,366 $41,436 $43,929 $136,311 $82,873 $53,438 $246,961 $147,066 $421,281 $366,595 $787,876 $696,375 $366,595 $1,062,970 $1,117,656 $733,190 $384,466 $1,983,170 $1,188,289 Total All Operating Expenses All Operating Expenses All Operating Expenses Budget OP Budget Total Over / (Under Budget) $151,512 $123,285 $28,227 ($36,995) ($27,191) ($9,804) $10,000 $20,000 $30,000 ($6,995) $19,121 ($26,116) ($16,312) ($9,804) ($26,116) $166,935 $138,239 $28,696 ($25,858) ($29,685) $3,827 $10,300 $20,600 $30,900 $5,042 $24,212 ($19,169) ($22,996) $3,827 ($45,286) $180,988 $149,386 $31,602 ($29,374) ($53,299) $23,925 $10,609 $21,218 $31,827 $2,453 $24,659 ($22,206) ($46,131) $23,925 ($67,492) $198,511 $159,398 $39,113 ($48,929) ($59,888) $10,959 $10,912 $21,824 $32,736 ($16,193) $21,135 ($37,328) ($48,287) $10,959 ($104,820) $220,904 $178,612 $42,293 ($44,852) ($75,728) $30,877 $11,217 $22,433 $33,650 ($11,202) $23,354 ($34,556) ($65,432) $30,877 ($139,375) $247,375 $195,740 $51,635 ($31,386) ($74,987) $43,601 $11,521 $23,042 $34,563 $3,177 $23,742 ($20,565) ($64,166) $43,601 ($159,940) $277,596 $211,138 $66,458 ($40,679) ($72,394) $31,716 $11,826 $23,651 $35,477 ($5,202) $23,602 ($28,804) ($60,520) $31,716 ($188,745) $291,813 $223,911 $67,902 ($37,818) ($70,273) $32,455 $12,130 $24,260 $36,390 ($1,428) $27,109 ($28,537) ($60,992) $32,455 ($217,281) $324,492 $245,189 $79,302 ($43,765) ($56,471) $12,706 $12,435 $24,869 $37,304 ($6,462) $27,973 ($34,434) ($47,140) $12,706 ($251,715) $347,270 $260,528 $86,742 ($62,178) ($87,562) $25,383 $12,739 $25,478 $38,217 ($23,961) $25,097 ($49,058) ($74,441) $25,383 ($300,774) $370,038 $275,860 $94,178 ($50,582) ($62,644) $12,062 $13,044 $26,087 $39,131 ($11,451) $31,224 ($42,675) ($54,738) $12,062 ($343,449) $394,026 $291,924 $102,102 $3,171,460 $2,453,209 $718,251 Earnings Before Income Tax Budget Over / (Under Budget) Interest income (expense) Other income (expense) Total Non-operating Income (expense) ($70,205) ($522,620) ($71,703) ($741,824) $1,498 ($1,264,445) $13,348 $26,696 $40,044 ($30,161) $27,985 $140,079 $280,158 $420,237 ($102,383) $299,212 Income (Loss) Before Taxes Income Taxes Net Income (Loss) Budget Over / (Under Budget) ($58,146) ($401,595) ($59,644) ($620,799) $1,498 ($1,022,394) ($401,595) ($803,190) Cumulative Net Income (Loss) © Copyright, 2006, JaxWorks, All Rights Reserved. Period Starting: Sales Product 1 Budget Over / (Under Budget) Product 2 Budget Over / (Under Budget) Product 3 Budget Over / (Under Budget) Product 4 Budget Over / (Under Budget) Product 5 Budget Over / (Under Budget) Product 6 Budget Over / (Under Budget) Total Sales Total Sales Budget Total Over / (Under Budget) Jan 1 $5,600 $4,790 $810 $3,600 $5,595 ($1,995) $14,600 $5,895 $8,705 $16,850 $8,895 $7,955 $78,600 $68,595 $10,005 $36,000 $15,754 $20,246 $155,250 109,524 $45,726 Feb 2 $6,350 $5,678 $672 $4,350 $5,678 ($1,328) $25,350 $3,678 $21,672 $17,690 $14,678 $3,012 $88,750 $78,595 $10,155 $43,350 $16,501 $26,849 $185,840 124,808 $61,032 Mar 3 $5,100 $4,754 $346 $16,400 $9,754 $6,646 $25,100 $5,754 $19,346 $18,830 $7,754 $11,076 $89,002 $78,754 $10,248 $45,100 $15,744 $29,356 $199,532 122,514 $77,018 Apr 4 $5,183 $5,038 $145 $20,917 $11,168 $9,749 $32,183 $4,968 $27,215 $19,770 $9,301 $10,469 $95,853 $85,474 $10,379 $50,583 $15,990 $34,594 $224,489 $131,939 $92,551 May 5 $4,933 $5,020 ($87) $27,317 $13,248 $14,069 $37,433 $4,898 $32,536 $20,760 $8,731 $12,029 $101,054 $90,553 $10,501 $55,133 $15,985 $39,149 $246,630 $138,434 $108,197 Jun 6 $4,683 $5,002 ($319) $33,717 $15,327 $18,390 $42,683 $4,827 $37,856 $21,750 $8,160 $13,590 $106,255 $95,633 $10,622 $59,683 $15,980 $43,704 $268,771 $144,929 $123,843 Jul 7 $4,433 $4,984 ($551) $40,117 $17,407 $22,710 $47,933 $4,757 $43,177 $22,740 $7,590 $15,150 $111,456 $100,712 $10,744 $64,233 $15,975 $48,259 $290,912 $151,424 $139,489 Aug 8 $4,183 $4,966 ($783) $46,517 $19,486 $27,031 $53,183 $4,686 $48,497 $23,730 $7,019 $16,711 $116,657 $105,792 $10,865 $68,783 $15,970 $52,814 $313,053 $157,919 $155,135 Sep 9 $3,933 $4,948 ($1,015) $52,917 $21,566 $31,351 $58,433 $4,616 $53,818 $24,720 $6,449 $18,271 $121,858 $110,871 $10,987 $73,333 $15,965 $57,369 $335,194 $164,414 $170,781 Oct 10 $3,683 $4,930 ($1,247) $59,317 $23,645 $35,672 $63,683 $4,545 $59,138 $25,710 $5,878 $19,832 $127,059 $115,951 $11,108 $77,883 $15,960 $61,924 $357,335 $170,909 $186,427 Nov 11 $3,433 $4,912 ($1,479) $65,717 $25,725 $39,992 $68,933 $4,475 $64,459 $26,700 $5,308 $21,392 $132,260 $121,030 $11,230 $82,433 $15,955 $66,479 $379,476 $177,404 $202,073 Dec 12 $3,183 $4,894 ($1,711) $72,117 $27,804 $44,313 $74,183 $4,404 $69,779 $27,690 $4,737 $22,953 $137,461 $126,110 $11,351 $86,983 $15,950 $71,034 $401,617 $183,899 $217,719 Totals $54,700 $59,916 $5,216 $443,000 $196,401 $246,599 $543,700 $57,501 $486,199 $266,940 $94,501 $172,439 $1,306,262 $1,178,069 $128,193 $743,500 $191,726 $551,774 3,358,102 1,778,114 $1,579,988 © Copyright, 2006, JaxWorks, All Rights Reserved. Less Cost of Goods Sold Materials Budget Over / (Under Budget) Labor Budget Over / (Under Budget) Overhead Budget Over / (Under Budget) Other Budget Over / (Under Budget) Total Cost of Goods Sold Total COG Budget Total Over / (Under Budget) Gross Profit Gross Profit Budget GP Budget Total Over / (Under Budget) $3,168 $1,595 $1,573 $16,400 $4,754 $11,646 $11,320 $2,754 $8,566 $9,845 $4,327 $5,518 $40,733 $13,430 $27,303 $114,517 $96,094 $18,423 $3,748 $1,678 $2,070 $16,830 $6,501 $10,329 $13,209 $3,168 $10,041 $10,976 $4,907 $6,070 $44,763 $16,254 $28,509 $141,077 $108,555 $32,523 $4,327 $4,754 ($427) $17,260 $8,081 $9,180 $15,099 $3,748 $11,351 $11,232 $9,845 $1,387 $47,918 $26,427 $21,491 $151,614 $96,087 $55,527 $4,907 $5,835 ($928) $17,690 $9,772 $7,918 $16,988 $4,217 $12,771 $12,071 $11,878 $194 $51,656 $31,701 $19,955 $172,833 $100,238 $72,595 $5,486 $7,414 ($1,928) $18,120 $11,435 $6,685 $18,878 $4,713 $14,164 $12,765 $14,637 ($1,872) $55,248 $38,199 $17,049 $191,382 $100,235 $91,147 $6,066 $8,994 ($2,928) $18,550 $13,098 $5,452 $20,767 $5,210 $15,557 $13,458 $17,396 ($3,937) $58,841 $44,698 $14,143 $209,931 $100,231 $109,699 $6,645 $10,573 ($3,928) $18,980 $14,761 $4,219 $22,656 $5,707 $16,949 $14,152 $20,155 ($6,003) $62,433 $51,196 $11,237 $228,479 $100,228 $128,252 $7,225 $12,153 ($4,928) $19,410 $16,425 $2,985 $24,546 $6,204 $18,342 $14,845 $22,914 ($8,068) $66,026 $57,695 $8,331 $247,028 $100,224 $146,804 $7,804 $13,732 ($5,928) $19,840 $18,088 $1,752 $26,435 $6,700 $19,735 $15,539 $25,673 ($10,134) $69,618 $64,193 $5,425 $265,576 $100,221 $165,356 $8,384 $15,312 ($6,928) $20,270 $19,751 $519 $28,325 $7,197 $21,127 $16,232 $28,432 ($12,199) $73,210 $70,692 $2,519 $284,125 $100,217 $183,908 $8,963 $16,891 ($7,928) $20,700 $21,414 ($714) $30,214 $7,694 $22,520 $16,926 $31,191 ($14,265) $76,803 $77,190 ($387) $302,674 $100,214 $202,460 $9,543 $18,471 ($8,928) $21,130 $23,078 ($1,948) $32,103 $8,191 $23,913 $17,619 $33,950 ($16,330) $80,395 $83,689 ($3,293) $321,222 $100,210 $221,012 $76,263 $117,401 ($41,138) $225,180 $167,158 $58,023 $260,539 $65,503 $195,037 $165,661 $225,300 ($59,639) $727,643 $575,361 $152,282 $2,630,459 $1,202,753 $1,427,706 Operating Expenses G&A Expenses Operating Expenses Budget Over / (Under Budget) Payroll Salaries Budget Over / (Under Budget) Total G&A Expenses Total G&A Budget Total Over / (Under Budget) $5,600 $6,012 ($412) $10,350 $7,744 $2,606 15,950 $13,756 $2,194 $5,850 $6,045 ($195) $12,100 $9,845 $2,255 17,950 $15,890 $2,060 $5,900 $6,356 ($456) $13,850 $10,976 $2,874 19,750 $17,332 $2,418 $6,083 $6,482 ($398) $15,600 $12,754 $2,846 $21,683 $19,235 $2,448 $6,233 $6,654 ($420) $17,350 $14,370 $2,980 $23,583 $21,023 $2,560 $6,383 $6,826 ($442) $19,100 $15,986 $3,114 $25,483 $22,811 $2,672 $6,533 $6,998 ($464) $20,850 $17,602 $3,248 $27,383 $24,599 $2,784 $6,683 $7,170 ($486) $22,600 $19,218 $3,382 $29,283 $26,387 $2,896 $6,833 $7,342 ($508) $24,350 $20,834 $3,516 $31,183 $28,175 $3,008 $6,983 $7,514 ($530) $26,100 $22,450 $3,650 $33,083 $29,963 $3,120 $7,133 $7,686 ($552) $27,850 $24,066 $3,784 $34,983 $31,751 $3,232 $7,283 $7,858 ($574) $29,600 $25,682 $3,918 $36,883 $33,539 $3,344 $77,500 $82,940 $160,440 $239,700 $201,524 $441,224 $317,200 $284,464 $32,736 Sales Expenses Operating Expenses Budget Over / (Under Budget) Payroll Salaries Budget Over / (Under Budget) Total Sales Expenses Total Sales Expense Budget Total Over / (Under Budget) $5,500 $6,012 ($512) $5,500 $7,744 ($2,244) $11,000 $13,756 ($2,756) $5,650 $6,045 ($395) $5,650 $8,845 ($3,195) $11,300 $14,890 ($3,590) $6,900 $6,356 $544 $6,900 $9,276 ($2,376) $13,800 $15,632 ($1,832) $7,417 $6,482 $935 $7,417 $10,154 ($2,737) $14,833 $16,635 ($1,802) $8,117 $6,654 $1,463 $8,117 $10,920 ($2,803) $16,233 $17,573 ($1,340) $8,817 $6,826 $1,991 $8,817 $11,686 ($2,869) $17,633 $18,511 ($878) $9,517 $6,998 $2,519 $9,517 $12,452 ($2,935) $19,033 $19,449 ($416) $10,217 $7,170 $3,047 $10,217 $13,218 ($3,001) $20,433 $20,387 $46 $10,917 $7,342 $3,575 $10,917 $13,984 ($3,067) $21,833 $21,325 $508 $11,617 $7,514 $4,103 $11,617 $14,750 ($3,133) $23,233 $22,263 $970 $12,317 $7,686 $4,631 $12,317 $15,516 ($3,199) $24,633 $23,201 $1,432 $13,017 $7,858 $5,159 $13,017 $16,282 ($3,265) $26,033 $24,139 $1,894 $110,000 $82,940 $192,940 $110,000 $144,824 $254,824 $220,000 $227,764 ($7,764) © Copyright, 2006, JaxWorks, All Rights Reserved. Marketing Expenses Operating Expenses Budget Over / (Under Budget) Payroll Salaries Budget Over / (Under Budget) Total Marketing Expenses Total Marketing Expense Budget Total Over / (Under Budget) $5,500 $6,012 ($512) $5,600 $7,744 ($2,144) $11,100 $13,756 ($2,656) $5,650 $6,045 ($395) $6,650 $8,845 ($2,195) $12,300 $14,890 ($2,590) $6,900 $6,356 $544 $6,900 $9,276 ($2,376) $13,800 $15,632 ($1,832) $7,417 $6,482 $935 $7,683 $10,154 ($2,470) $15,100 $16,635 ($1,535) $8,117 $6,654 $1,463 $8,333 $10,920 ($2,586) $16,450 $17,573 ($1,123) $8,817 $6,826 $1,991 $8,983 $11,686 ($2,702) $17,800 $18,511 ($711) $9,517 $6,998 $2,519 $9,633 $12,452 ($2,818) $19,150 $19,449 ($299) $10,217 $7,170 $3,047 $10,283 $13,218 ($2,934) $20,500 $20,387 $113 $10,917 $7,342 $3,575 $10,933 $13,984 ($3,050) $21,850 $21,325 $525 $11,617 $7,514 $4,103 $11,583 $14,750 ($3,166) $23,200 $22,263 $937 $12,317 $7,686 $4,631 $12,233 $15,516 ($3,282) $24,550 $23,201 $1,349 $13,017 $7,858 $5,159 $12,883 $16,282 ($3,398) $25,900 $24,139 $1,761 $110,000 $82,940 $192,940 $111,700 $144,824 $256,524 $221,700 $227,764 ($6,064) Research & Development Expenses Operating Expenses Budget Over / (Under Budget) Payroll Salaries Budget Over / (Under Budget) Total Research & Development Expenses Total R&D Expenses Budget Total Over / (Under Budget) Total Operating Expenses Total Payroll Salaries $21,500 $19,595 $1,905 $35,256 $19,595 $15,661 $56,756 $39,190 $17,566 $94,806 $56,706 $23,735 $21,678 $2,057 $38,625 $21,678 $16,947 $62,360 $43,356 $19,004 $103,910 $63,025 $24,908 $23,754 $1,154 $40,540 $23,754 $16,786 $65,448 $47,508 $17,940 $112,798 $68,190 $26,789 $25,835 $954 $43,424 $25,835 $17,590 $70,213 $51,669 $18,544 $121,830 $74,124 $28,493 $27,914 $579 $46,066 $27,914 $18,152 $74,559 $55,828 $18,731 $130,826 $79,866 $30,197 $29,994 $203 $48,708 $29,994 $18,715 $78,905 $59,987 $18,918 $139,822 $85,608 $31,901 $32,073 ($172) $51,350 $32,073 $19,277 $83,251 $64,146 $19,105 $148,818 $91,350 $33,605 $34,153 ($548) $53,992 $34,153 $19,840 $87,597 $68,305 $19,292 $157,814 $97,092 $35,309 $36,232 ($923) $56,634 $36,232 $20,402 $91,943 $72,464 $19,479 $166,810 $102,834 $37,013 $38,312 ($1,299) $59,276 $38,312 $20,965 $96,289 $76,623 $19,666 $175,806 $108,576 $38,717 $40,391 ($1,674) $61,918 $40,391 $21,527 $100,635 $80,782 $19,853 $184,802 $114,318 $40,421 $42,471 ($2,050) $64,560 $42,471 $22,090 $104,981 $84,941 $20,040 $193,798 $120,060 $372,588 $372,401 $744,989 $600,352 $372,401 $972,753 $972,940 $744,802 $228,138 $1,731,840 $1,061,752 Total All Operating Expenses All Operating Expenses All Operating Expenses Budget OP Budget Total Over / (Under Budget) $151,512 $123,285 $28,227 ($36,995) ($27,191) ($9,804) $10,000 $20,000 $30,000 ($6,995) $19,121 ($26,116) ($16,312) ($9,804) ($26,116) $166,935 $138,239 $28,696 ($25,858) ($29,685) $3,827 $10,300 $20,600 $30,900 $5,042 $24,212 ($19,169) ($22,996) $3,827 ($45,286) $180,988 $149,386 $31,602 ($29,374) ($53,299) $23,925 $10,609 $21,218 $31,827 $2,453 $24,659 ($22,206) ($46,131) $23,925 ($67,492) $195,954 $163,071 $32,883 ($23,121) ($62,833) $39,712 $10,912 $21,824 $32,736 $9,615 $28,202 ($18,587) ($58,299) $39,712 ($87,673) $210,692 $176,122 $34,571 ($19,310) ($75,887) $56,577 $11,217 $22,433 $33,650 $14,339 $30,971 ($16,632) ($73,208) $56,577 ($108,361) $225,430 $189,172 $36,258 ($15,500) ($88,941) $73,441 $11,521 $23,042 $34,563 $19,063 $33,740 ($14,677) ($88,118) $73,441 ($129,049) $240,168 $202,223 $37,946 ($11,689) ($101,995) $90,306 $11,826 $23,651 $35,477 $23,787 $36,509 ($12,722) ($103,027) $90,306 ($149,736) $254,906 $215,273 $39,633 ($7,879) ($115,049) $107,170 $12,130 $24,260 $36,390 $28,511 $39,278 ($10,767) ($117,937) $107,170 ($170,424) $269,644 $228,324 $41,321 ($4,068) ($128,103) $124,035 $12,435 $24,869 $37,304 $33,236 $42,047 ($8,812) ($132,846) $124,035 ($191,112) $284,382 $241,374 $43,008 ($257) ($141,157) $140,900 $12,739 $25,478 $38,217 $37,960 $44,816 ($6,856) ($147,756) $140,900 ($211,799) $299,120 $254,425 $44,696 $3,553 ($154,211) $157,764 $13,044 $26,087 $39,131 $42,684 $47,585 ($4,901) ($162,665) $157,764 ($232,487) $313,858 $267,475 $46,383 $2,793,592 $2,348,367 $445,225 Earnings Before Income Tax Budget Over / (Under Budget) Interest income (expense) Other income (expense) Total Non-operating Income (expense) $7,364 ($163,133) ($167,265) ($1,145,614) $174,629 ($1,308,747) $13,348 $26,696 $40,044 $47,408 $50,354 $140,079 $280,158 $420,237 $257,104 $421,495 Income (Loss) Before Taxes Income Taxes Net Income (Loss) Budget Over / (Under Budget) ($2,946) ($164,391) ($177,575) ($1,146,872) $174,629 ($1,311,264) ($253,175) ($417,566) Cumulative Net Income (Loss) © Copyright, 2006, JaxWorks, All Rights Reserved. Annual Budget Analysis Quarter 1 $ % Sales Total Sales Total Sales Budget Total Over / (Under Budget) Less Cost of Goods Sold Materials Budget Over / (Under Budget) Labor Budget Over / (Under Budget) Overhead Budget Over / (Under Budget) Other Budget Over / (Under Budget) Total Cost of Goods Sold Total COG Budget Total Over / (Under Budget) Gross Profit Gross Profit Budget Total Over / (Under Budget) $540,622 $356,846 $183,776 100.00% 66.01% 33.99% Quarter 2 $ % $692,329 $429,371 $262,959 100.00% 62.02% 37.98% Quarter 3 $ % $937,839 $627,224 $310,615 Quarter 4 $ % Totals Average Budget Over/Under 100.00% $1,157,568 66.88% $805,894 33.12% $351,674 100.00% $3,328,358 69.62% $2,219,335 30.38% $1,109,023 Over $11,243 $8,027 $3,216 $50,490 $19,336 $31,155 $39,628 $9,670 $29,958 $32,053 $19,079 $12,975 $133,413 $56,111 $77,303 $407,209 $300,736 $106,473 2.08% 1.48% 28.60% 9.34% 3.58% 61.70% 7.33% 1.79% 75.60% 5.93% 3.53% 40.48% 24.68% 10.38% 57.94% 75.32% 55.63% 26.15% $20,743 $24,427 ($3,684) $43,640 $30,666 $12,974 $46,216 $19,079 $27,137 $40,107 $32,053 $8,054 $150,705 $106,224 $44,481 $541,624 $323,147 $218,477 3.00% 3.53% -17.76% 6.30% 4.43% 29.73% 6.68% 2.76% 58.72% 5.79% 4.63% 20.08% 21.77% 15.34% 29.52% 78.23% 46.68% 40.34% $41,550 $36,531 $5,019 $41,550 $36,531 $5,019 $41,550 $36,531 $5,019 $41,550 $36,531 $5,019 $166,200 $146,124 $20,076 $771,639 $481,100 $290,539 4.43% 3.90% 12.08% 4.43% 3.90% 12.08% 4.43% 3.90% 12.08% 4.43% 3.90% 12.08% 17.72% 15.58% 12.08% 82.28% 51.30% 37.65% $57,300 $49,873 $7,427 $57,300 $49,873 $7,427 $57,300 $49,873 $7,427 $57,300 $49,873 $7,427 $229,200 $199,492 $29,708 $928,368 $606,402 $321,966 4.95% 4.31% 12.96% 4.95% 4.31% 12.96% 4.95% 4.31% 12.96% 4.95% 4.31% 12.96% 19.80% 17.23% 12.96% $130,835 $118,858 $11,978 $192,980 $136,406 $56,575 $184,694 $115,152 $69,542 $171,010 $137,536 $33,475 $679,519 $507,951 $171,568 Under Over Over Over Over 80.20% $2,648,839 52.39% $1,711,384 34.68% $937,455 Over © Copyright, 2006, JaxWorks, All Rights Reserved. Annual Budget Analysis Operating Expenses G&A Expenses Operating Expenses Budget Over / (Under Budget) Payroll Salaries Budget Over / (Under Budget) Total G&A Expenses Total G&A Budget Total Over / (Under Budget) Sales Expenses Operating Expenses Budget Over / (Under Budget) Payroll Salaries Budget Over / (Under Budget) Total Sales Expenses Total Sales Expense Budget Total Over / (Under Budget) $17,350 $18,413 ($1,063) $36,300 $28,565 $7,735 $53,650 $46,978 $6,672 3.21% 3.41% -6.13% 6.71% 5.28% 21.31% 9.92% 8.69% 12.44% $25,800 $24,090 $1,710 $52,050 $40,743 $11,308 $77,850 $64,833 $13,018 3.73% 3.48% 6.63% 7.52% 5.88% 21.72% 11.24% 9.36% 16.72% $41,550 $36,531 $5,019 $67,800 $54,290 $13,511 $109,350 $90,821 $18,530 4.43% 3.90% 12.08% 7.23% 5.79% 19.93% 11.66% 9.68% 16.95% $57,300 $49,873 $7,427 $83,550 $67,380 $16,170 $140,850 $117,253 $23,597 4.95% 4.31% 12.96% 7.22% 5.82% 19.35% 12.17% 10.13% 16.75% $142,000 $128,907 $13,093 $239,700 $190,977 $48,723 $381,700 $319,884 $61,816 Under Over Over $18,050 $18,413 ($363) $18,050 $25,865 ($7,815) $36,100 $44,278 ($8,178) 3.34% 3.41% -2.01% 3.34% 4.78% -43.30% 6.68% 8.19% -22.65% $25,450 $24,090 $1,360 $25,450 $33,018 ($7,568) $50,900 $57,108 ($6,208) 3.68% 3.48% 5.34% 3.68% 4.77% -29.73% 7.35% 8.25% -12.20% $32,550 $36,531 ($3,981) $37,050 $40,100 ($3,050) $69,600 $76,631 ($7,031) 3.47% 3.90% -12.23% 3.95% 4.28% -8.23% 7.42% 8.17% -10.10% $39,750 $49,873 ($10,123) $45,107 $47,205 ($2,098) $84,857 $97,078 ($12,221) 3.43% 4.31% -25.47% 3.90% 4.08% -4.65% 7.33% 8.39% -14.40% $115,800 $128,907 ($13,107) $125,657 $146,187 ($20,530) $241,457 $275,094 ($33,637) Under Under Under © Copyright, 2006, JaxWorks, All Rights Reserved. Annual Budget Analysis Marketing Expenses Operating Expenses Budget Over / (Under Budget) Payroll Salaries Budget Over / (Under Budget) Total Marketing Expenses Total Marketing Expense Budget Total Over / (Under Budget) Research & Development Expenses Operating Expenses Budget Over / (Under Budget) Payroll Salaries Budget Over / (Under Budget) Total Research & Development Expenses Total R&D Expenses Budget Total Over / (Under Budget) Total Operating Expenses Total Payroll Salaries $18,050 $18,413 ($363) $19,150 $25,865 ($6,715) $37,200 $44,278 ($7,078) 3.34% 3.41% -2.01% 3.54% 4.78% -35.07% 6.88% 8.19% -19.03% $25,450 $24,090 $1,360 $25,250 $33,018 ($7,768) $50,700 $57,108 ($6,408) 3.68% 3.48% 5.34% 3.65% 4.77% -30.76% 7.32% 8.25% -12.64% $32,550 $36,531 ($3,981) $37,050 $40,100 ($3,050) $69,600 $76,631 ($7,031) 3.47% 3.90% -12.23% 3.95% 4.28% -8.23% 7.42% 8.17% -10.10% $39,750 $49,873 ($10,123) $45,107 $47,205 ($2,098) $84,857 $97,078 ($12,221) 3.43% 4.31% -25.47% 3.90% 4.08% -4.65% 7.33% 8.39% -14.40% $115,800 $128,907 ($13,107) $126,557 $146,187 ($19,630) $242,357 $275,094 ($32,737) Under Under Under $70,143 $65,027 $5,116 $114,421 $65,027 $49,394 $184,564 $130,054 $54,510 $311,514 $187,921 12.97% 12.03% 7.29% 21.16% 12.03% 43.17% 34.14% 24.06% 29.53% 57.62% 34.76% $90,125 $82,641 $7,484 $147,233 $82,641 $64,591 $237,358 $165,283 $72,075 $416,808 $249,983 13.02% 11.94% 8.30% 21.27% 11.94% 43.87% 34.28% 23.87% 30.37% 60.20% 36.11% $116,730 $100,556 $16,174 $193,361 $100,556 $92,804 $310,091 $201,112 $108,978 $558,641 $335,261 12.45% 10.72% 13.86% 20.62% 10.72% 48.00% 33.06% 21.44% 35.14% 59.57% 35.75% $144,283 $118,371 $25,912 $241,361 $118,371 $122,990 $385,644 $236,741 $148,903 $696,208 $415,125 12.46% 10.23% 17.96% 20.85% 10.23% 50.96% $421,281 $366,595 $54,686 $696,375 $366,595 $329,780 Over Over 33.32% $1,117,656 20.45% $733,190 38.61% $384,466 60.14% $1,983,170 35.86% $1,188,289 Over © Copyright, 2006, JaxWorks, All Rights Reserved. Annual Budget Analysis Total All Operating Expenses All Operating Expenses All Operating Expenses Budget Total Over / (Under Budget) Earnings Before Income Tax Budget Over / (Under Budget) Interest income (expense) Other income (expense) Total Non-operating Income (expense) Income (Loss) Before Taxes Income Taxes Net Income (Loss) Budget Over / (Under Budget) $499,435 $410,910 $88,525 ($92,226) ($110,175) $17,948 $30,909 $61,818 $92,727 $501 $67,992 ($67,492) ($85,440) $17,948 92.38% 76.01% 17.73% -17.06% -20.38% -19.46% 5.72% 11.43% 17.15% 0.09% 12.58% -12.48% -15.80% -26.59% $666,790 $533,749 $133,041 ($125,166) ($210,603) $85,437 $33,650 $67,299 $100,949 ($24,218) $68,231 ($92,448) ($177,885) $85,437 96.31% 77.09% 19.95% -18.08% -30.42% -68.26% 4.86% 9.72% 14.58% -3.50% 9.86% -13.35% -25.69% -92.42% $893,901 $680,238 $213,663 ($122,262) ($199,138) $76,876 $36,390 $72,780 $109,170 ($13,092) $78,683 ($91,775) ($168,651) $76,876 95.31% $1,111,334 72.53% $828,311 23.90% $283,022 -13.04% -21.23% -62.88% 3.88% 7.76% 11.64% -1.40% 8.39% -9.79% -17.98% -83.77% ($182,966) ($221,909) $38,943 $39,131 $78,261 $117,392 ($65,574) $84,305 ($149,879) ($188,823) $38,943 96.01% $3,171,460 71.56% $2,453,209 25.47% $718,251 -15.81% -19.17% -21.28% 3.38% 6.76% 10.14% -5.66% 7.28% -12.95% -16.31% -25.98% ($522,620) ($741,824) $219,204 $140,079 $280,158 $420,237 ($102,383) $299,212 ($401,595) ($620,799) $219,204 Over Under Under © Copyright, 2006, JaxWorks, All Rights Reserved. Forecast Budget Analysis Quarter 1 $ % Sales Total Sales Total Sales Budget Total Over / (Under Budget) Less Cost of Goods Sold Materials Budget Over / (Under Budget) Labor Budget Over / (Under Budget) Overhead Budget Over / (Under Budget) Other Budget Over / (Under Budget) Total Cost of Goods Sold Total COG Budget Total Over / (Under Budget) Gross Profit Gross Profit Budget Total Over / (Under Budget) $540,622 $356,846 $183,776 100.00% 66.01% 33.99% Quarter 2 $ % $739,891 $415,301 $324,590 100.00% 56.13% 43.87% Quarter 3 $ $939,160 $473,756 $465,404 % $ Quarter 4 % 100.00% $3,358,102 46.75% $1,778,114 53.25% $1,579,988 Totals Average Budget Over/Under 100.00% $1,138,429 50.44% $532,211 49.56% $606,218 Over $11,243 $8,027 $3,216 $50,490 $19,336 $31,155 $39,628 $9,670 $29,958 $32,053 $19,079 $12,975 $133,413 $56,111 $77,303 $407,209 $300,736 $106,473 2.08% 1.48% 28.60% 9.34% 3.58% 61.70% 7.33% 1.79% 75.60% 5.93% 3.53% 40.48% 24.68% 10.38% 57.94% 75.32% 55.63% 26.15% $16,458 $22,243 ($5,785) $54,360 $34,305 $20,055 $56,633 $14,140 $42,492 $38,295 $43,910 ($5,615) $165,745 $114,597 $51,148 $574,146 $300,704 $273,442 2.22% 3.01% -35.15% 7.35% 4.64% 36.89% 7.65% 1.91% 75.03% 5.18% 5.93% -14.66% 22.40% 15.49% 30.86% 77.60% 40.64% 47.63% $21,674 $36,458 ($14,785) $58,230 $49,274 $8,956 $73,637 $18,611 $55,026 $44,536 $68,741 ($24,205) $198,077 $173,084 $24,993 $741,083 $300,673 $440,411 2.31% 3.88% -68.21% 6.20% 5.25% 15.38% 7.84% 1.98% 74.73% 4.74% 7.32% -54.35% 21.09% 18.43% 12.62% 78.91% 32.02% 59.43% $26,889 $50,674 ($23,785) $62,100 $64,243 ($2,143) $90,642 $23,082 $67,560 $50,778 $93,572 ($42,794) $230,408 $231,570 ($1,162) $908,021 $300,641 $607,380 2.36% 4.45% -88.45% 5.45% 5.64% -3.45% 7.96% 2.03% 74.54% 4.46% 8.22% -84.28% 20.24% 20.34% -0.50% $76,263 $117,401 ($41,138) $225,180 $167,158 $58,023 $260,539 $65,503 $195,037 $165,661 $225,300 ($59,639) $727,643 $575,361 $152,282 Under Over Over Under Over 79.76% $2,630,459 26.41% $1,202,753 66.89% $1,427,706 Over © Copyright, 2006, JaxWorks, All Rights Reserved. Forecast Budget Analysis Operating Expenses G&A Expenses Operating Expenses Budget Over / (Under Budget) Payroll Salaries Budget Over / (Under Budget) Total G&A Expenses Total G&A Budget Total Over / (Under Budget) Sales Expenses Operating Expenses Budget Over / (Under Budget) Payroll Salaries Budget Over / (Under Budget) Total Sales Expenses Total Sales Expense Budget Total Over / (Under Budget) $17,350 $18,413 ($1,063) $36,300 $28,565 $7,735 $53,650 $46,978 $6,672 3.21% 3.41% -6.13% 6.71% 5.28% 21.31% 9.92% 8.69% 12.44% $18,700 $19,961 ($1,261) $52,050 $43,109 $8,941 $70,750 $63,070 $7,680 2.53% 2.70% -6.74% 7.03% 5.83% 17.18% 9.56% 8.52% 10.86% $20,050 $21,509 ($1,459) $67,800 $57,653 $10,147 $87,850 $79,162 $8,688 2.13% 2.29% -7.28% 7.22% 6.14% 14.97% 9.35% 8.43% 9.89% $21,400 $23,057 ($1,657) $83,550 $72,197 $11,353 $104,950 $95,254 $9,696 1.88% 2.03% -7.74% 7.34% 6.34% 13.59% 9.22% 8.37% 9.24% $77,500 $82,940 ($5,440) $239,700 $201,524 $38,176 $317,200 $284,464 $32,736 Under Over Over $18,050 $18,413 ($363) $18,050 $25,865 ($7,815) $36,100 $44,278 ($8,178) 3.34% 3.41% -2.01% 3.34% 4.78% -43.30% 6.68% 8.19% -22.65% $24,350 $19,961 $4,389 $24,350 $32,759 ($8,409) $48,700 $52,720 ($4,020) 3.29% 2.70% 18.02% 3.29% 4.43% -34.53% 6.58% 7.13% -8.25% $30,650 $21,509 $9,141 $30,650 $39,653 ($9,003) $61,300 $61,162 $138 3.26% 2.29% 29.82% 3.26% 4.22% -29.37% 6.53% 6.51% 0.23% $36,950 $23,057 $13,893 $36,950 $46,547 ($9,597) $73,900 $69,604 $4,296 3.25% 2.03% 37.60% 3.25% 4.09% -25.97% 6.49% 6.11% 5.81% $110,000 $82,940 $27,060 $110,000 $144,824 ($34,824) $220,000 $227,764 ($7,764) Over Under Under © Copyright, 2006, JaxWorks, All Rights Reserved. Forecast Budget Analysis Marketing Expenses Operating Expenses Budget Over / (Under Budget) Payroll Salaries Budget Over / (Under Budget) Total Marketing Expenses Total Marketing Expense Budget Total Over / (Under Budget) Research & Development Expenses Operating Expenses Budget Over / (Under Budget) Payroll Salaries Budget Over / (Under Budget) Total Research & Development Expenses Total R&D Expenses Budget Total Over / (Under Budget) Total Operating Expenses Total Payroll Salaries $18,050 $18,413 ($363) $19,150 $25,865 ($6,715) $37,200 $44,278 ($7,078) 3.34% 3.41% -2.01% 3.54% 4.78% -35.07% 6.88% 8.19% -19.03% $24,350 $19,961 $4,389 $25,000 $32,759 ($7,759) $49,350 $52,720 ($3,370) 3.29% 2.70% 18.02% 3.38% 4.43% -31.04% 6.67% 7.13% -6.83% $30,650 $21,509 $9,141 $30,850 $39,653 ($8,803) $61,500 $61,162 $338 3.26% 2.29% 29.82% 3.28% 4.22% -28.53% 6.55% 6.51% 0.55% $36,950 $23,057 $13,893 $36,700 $46,547 ($9,847) $73,650 $69,604 $4,046 3.25% 2.03% 37.60% 3.22% 4.09% -26.83% 6.47% 6.11% 5.49% $110,000 $82,940 $27,060 $111,700 $144,824 ($33,124) $221,700 $227,764 ($6,064) Over Under Under $70,143 $65,027 $5,116 $114,421 $65,027 $49,394 $184,564 $130,054 $54,510 $311,514 $187,921 12.97% 12.03% 7.29% 21.16% 12.03% 43.17% 34.14% 24.06% 29.53% 57.62% 34.76% $85,479 $83,743 $1,737 $138,199 $83,743 $54,457 $223,678 $167,485 $56,193 $392,478 $239,599 11.55% 11.32% 2.03% 18.68% 11.32% 39.40% 30.23% 22.64% 25.12% 53.05% 32.38% $100,815 $102,458 ($1,643) $161,977 $102,458 $59,519 $262,792 $204,916 $57,876 $473,442 $291,277 10.73% 10.91% -1.63% 17.25% 10.91% 36.75% 27.98% 21.82% 22.02% 50.41% 31.01% $116,151 $121,174 ($5,023) $185,755 $121,174 $64,582 $301,906 $242,347 $59,559 $554,406 $342,955 10.20% 10.64% -4.32% 16.32% 10.64% 34.77% 26.52% 21.29% 19.73% $372,588 $372,401 $187 $600,352 $372,401 $227,951 $972,940 $744,802 $228,138 Under Over Over 48.70% $1,731,840 30.13% $1,061,752 © Copyright, 2006, JaxWorks, All Rights Reserved. Forecast Budget Analysis Total All Operating Expenses All Operating Expenses All Operating Expenses Budget Total Over / (Under Budget) Earnings Before Income Tax Budget Over / (Under Budget) Interest income (expense) Other income (expense) Total Non-operating Income (expense) Income (Loss) Before Taxes Income Taxes Net Income (Loss) Budget Over / (Under Budget) $499,435 $410,910 $88,525 ($92,226) ($110,175) $17,948 $30,909 $61,818 $92,727 $501 $67,992 ($67,492) ($85,440) $17,948 92.38% 76.01% 17.73% -17.06% -20.38% -19.46% 5.72% 11.43% 17.15% 0.09% 12.58% -12.48% -15.80% -26.59% $632,077 $528,365 $103,713 85.43% 71.41% 16.41% $764,719 $645,819 $118,900 81.43% 68.77% 15.55% $897,361 $763,274 $134,088 78.82% $2,793,592 67.05% $2,348,367 14.94% $445,225 Over ($57,931) -7.83% ($227,661) -30.77% $169,730 -292.99% $33,650 $67,299 $100,949 $43,017 $92,913 4.55% 9.10% 13.64% 5.81% 12.56% ($23,636) -2.52% ($345,147) -36.75% $321,511 -1360.28% $36,390 $72,780 $109,170 $85,534 $117,834 ($32,300) ($353,811) $321,511 3.87% 7.75% 11.62% 9.11% 12.55% -3.44% -37.67% -995.39% $10,660 0.94% ($163,133) ($462,633) -40.64% ($1,145,614) $473,292 4439.97% $982,481 $39,131 $78,261 $117,392 $128,051 $142,755 3.44% 6.87% 10.31% 11.25% 12.54% $140,079 $280,158 $420,237 $257,104 $421,495 Over ($49,896) -6.74% ($219,625) -29.68% $169,730 -340.17% ($14,704) -1.29% ($164,391) ($487,996) -42.87% ($1,146,872) $473,292 -3218.80% $982,481 Under © Copyright, 2006, JaxWorks, All Rights Reserved. Product 1 Annual Sales vs. Budget Report Sales Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Totals Sales $5,600 $6,350 $5,100 $6,850 $8,600 $8,850 $12,100 $13,850 $16,600 $19,100 $21,600 $24,100 $148,700 Budget $4,790 $5,678 $4,754 $6,501 $7,744 $8,645 $10,976 $11,232 $14,323 $15,434 $16,543 $17,896 $124,516 Over/Under $810 $672 $346 $349 $856 $205 $1,124 $2,618 $2,277 $3,666 $5,057 $6,204 $24,184 Jan Dec Nov Oct Feb Mar Apr May Jun Jul Sep Aug 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, 2006, JaxWorks, All Rights Reserved. © Copyright, 2006, JaxWorks, All Rights Reserved. Product 2 Annual Sales vs. Budget Report Sales Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Totals Sales $3,600 $4,350 $16,400 $16,830 $17,260 $17,690 $15,600 $17,350 $8,600 $9,350 $10,100 $10,850 $147,980 Budget $5,595 $5,678 $9,754 $9,168 $18,748 $14,327 $14,907 $15,486 $9,066 $10,645 $8,225 $12,804 $134,401 Over/Under ($1,995) ($1,328) $6,646 $7,662 ($1,488) $3,363 $694 $1,864 ($466) ($1,295) $1,876 ($1,954) $13,579 Jan Feb Nov Oct Sep Aug Dec Mar Apr May Jul Jun Sales $20,000 $15,000 $10,000 $5,000 $0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec © Copyright, 2006, JaxWorks, All Rights Reserved. © Copyright, 2006, JaxWorks, All Rights Reserved. Product 3 Annual Sales vs. Budget Report Sales Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Totals Sales $14,600 $25,350 $25,100 $26,850 $32,100 $35,750 $39,400 $43,050 $46,700 $50,350 $54,000 $57,650 $450,900 Budget $5,895 $3,678 $5,754 $7,501 $9,431 $11,320 $13,209 $15,099 $16,988 $18,878 $20,767 $22,656 $151,175 Over/Under $8,705 $21,672 $19,346 $19,349 $22,670 $24,430 $26,191 $27,951 $29,712 $31,473 $33,233 $34,994 $299,725 Jan Dec Nov Feb Mar Apr May Oct Sep Aug Jun Jul 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, 2006, JaxWorks, All Rights Reserved. © Copyright, 2006, JaxWorks, All Rights Reserved. Product 4 Annual Sales vs. Budget Report Sales Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Totals Sales $16,850 $17,690 $18,830 $19,260 $20,690 $21,439 $22,364 $23,289 $24,214 $25,139 $26,064 $26,989 $262,818 Budget $8,895 $14,678 $7,754 $6,501 $9,431 $11,320 $13,209 $15,099 $16,988 $18,878 $20,767 $22,656 $166,175 Over/Under $7,955 $3,012 $11,076 $12,759 $11,260 $10,119 $9,155 $8,190 $7,226 $6,262 $5,297 $4,333 $96,643 Dec Nov Oct Sep Jan Feb Mar Apr May Aug Jul Jun 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, 2006, JaxWorks, All Rights Reserved. © Copyright, 2006, JaxWorks, All Rights Reserved. Product 5 Annual Sales vs. Budget Report Sales Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Totals Sales $78,600 $88,750 $89,002 $86,850 $96,400 $106,830 $127,260 $137,690 $167,274 $165,240 $193,207 $191,174 $1,528,277 Budget $68,595 $78,595 $78,754 $86,501 $77,744 $99,845 $115,976 $126,232 $174,323 $155,434 $196,543 $197,896 $1,456,438 Over/Under $10,005 $10,155 $10,248 $349 $18,656 $6,985 $11,284 $11,458 ($7,050) $9,806 ($3,336) ($6,722) $71,839 Feb Dec Nov Oct Sep Aug Jan Mar Apr May Jun Jul 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, 2006, JaxWorks, All Rights Reserved. © Copyright, 2006, JaxWorks, All Rights Reserved. Product 6 Annual Sales vs. Budget Report Sales Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Totals Sales $36,000 $43,350 $45,100 $46,850 $56,400 $66,830 $68,593 $74,166 $79,739 $85,312 $90,885 $96,458 $789,683 Budget $15,754 $16,501 $15,744 $14,987 $14,982 $14,676 $14,370 $15,419 $14,323 $15,434 $16,543 $17,896 $186,629 Over/Under $20,246 $26,849 $29,356 $31,863 $41,418 $52,154 $54,223 $58,747 $65,416 $69,878 $74,342 $78,562 $603,054 Jan Dec Feb Mar Apr May Nov Oct Sep Aug Jul Jun 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, 2006, JaxWorks, All Rights Reserved. © Copyright, 2006, JaxWorks, All Rights Reserved. Summary Report: Annual Sales vs. Budget Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Totals Sales $155,250 $185,840 $199,532 $203,490 $231,450 $257,389 $285,317 $309,395 $343,127 $354,491 $395,856 $407,221 $3,328,358 Budget $109,524 $124,808 $122,514 $131,159 $138,079 $160,133 $182,648 $198,566 $246,011 $234,702 $279,387 $291,805 $2,219,335 Over/Under $45,726 $61,032 $77,018 $72,331 $93,372 $97,256 $102,670 $110,829 $97,116 $119,789 $116,469 $115,416 $1,109,023 Total Sales by Product Feb Dec Nov Jan Mar Oct Sep Apr May Jun Aug Jul 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, 2006, JaxWorks, All Rights Reserved. © Copyright, 2006, JaxWorks, All Rights Reserved. Materials Summary Materials Expense vs. Budget Report Materials Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Totals Expense $3,168 $3,748 $4,327 $4,907 $5,486 $10,350 $12,100 $13,850 $15,600 $17,350 $19,100 $20,850 $130,835 Budget $1,595 $1,678 $4,754 $6,501 $8,081 $9,845 $10,976 $11,232 $14,323 $15,434 $16,543 $17,896 $118,858 Over/Under $1,573 $2,070 ($427) ($1,595) ($2,595) $505 $1,124 $2,618 $1,277 $1,916 $2,557 $2,954 $11,978 Jan Feb Dec Nov Oct Aug Mar Apr Jun May Jul Sep 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, 2006, JaxWorks, All Rights Reserved. © Copyright, 2006, JaxWorks, All Rights Reserved. Labor Summary Labor Expense vs. Budget Report Labor Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Totals Expense $16,400 $16,830 $17,260 $17,690 $15,600 $10,350 $12,100 $13,850 $15,600 $17,350 $19,100 $20,850 $192,980 Budget $4,754 $6,501 $8,081 $9,845 $10,976 $9,845 $10,976 $11,232 $14,323 $15,434 $16,543 $17,896 $136,406 Over/Under $11,646 $10,329 $9,180 $7,845 $4,624 $505 $1,124 $2,618 $1,277 $1,916 $2,557 $2,954 $56,575 Dec Jan Nov Oct Sep Aug Jul Jun Feb Mar Apr May 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, 2006, JaxWorks, All Rights Reserved. © Copyright, 2006, JaxWorks, All Rights Reserved. Overhead Summary Overhead Expense vs. Budget Report Overhead Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Totals Expense $16,400 $16,830 $17,260 $17,690 $15,600 $10,350 $12,100 $13,850 $15,600 $17,350 $19,100 $20,850 $192,980 Budget $4,754 $6,501 $8,081 $9,845 $10,976 $9,845 $10,976 $11,232 $14,323 $15,434 $16,543 $17,896 $136,406 Over/Under $11,646 $10,329 $9,180 $7,845 $4,624 $505 $1,124 $2,618 $1,277 $1,916 $2,557 $2,954 $56,575 Dec Jan Nov Oct Sep Aug Jul Jun Feb Mar Apr May 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, 2006, JaxWorks, All Rights Reserved. © Copyright, 2006, JaxWorks, All Rights Reserved. Other Direct Expenses Summary Other Expense vs. Budget Report Other Expenses Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Totals Expense $9,845 $10,976 $11,232 $14,323 $15,434 $10,350 $12,100 $13,850 $15,600 $17,350 $19,100 $20,850 $171,010 Budget $4,327 $4,907 $9,845 $10,976 $11,232 $9,845 $10,976 $11,232 $14,323 $15,434 $16,543 $17,896 $137,536 Over/Under $5,518 $6,070 $1,387 $3,347 $4,202 $505 $1,124 $2,618 $1,277 $1,916 $2,557 $2,954 $33,475 Dec Jan Feb Mar Apr Nov Oct Sep Aug Jul Jun May 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, 2006, JaxWorks, All Rights Reserved. © Copyright, 2006, JaxWorks, All Rights Reserved. Total Cost of Goods Sold Summary COG vs. Budget Report COG Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Totals COG $40,733 $44,763 $47,918 $53,908 $55,398 $41,400 $48,400 $55,400 $62,400 $69,400 $76,400 $83,400 $679,519 Budget $13,430 $16,254 $26,427 $31,649 $35,195 $39,380 $43,904 $44,928 $57,292 $61,736 $66,172 $71,584 $507,951 Over/Under $27,303 $28,509 $21,491 $22,259 $20,203 $2,020 $4,496 $10,472 $5,108 $7,664 $10,228 $11,816 $171,568 Dec Jan Feb Mar Apr May Nov Oct Sep Aug Jul Jun COG Budget $100,000 $80,000 $60,000 $40,000 $20,000 $0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec © Copyright, 2006, JaxWorks, All Rights Reserved. © Copyright, 2006, JaxWorks, All Rights Reserved. Gross Profit Summary Gross Profit Gross Profit Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Totals Gross Profit $114,517 $141,077 $151,614 $149,582 $176,053 $215,989 $236,917 $253,995 $280,727 $285,091 $319,456 $323,821 $2,648,839 Budget $96,094 $108,555 $96,087 $99,510 $102,884 $120,753 $138,744 $153,638 $188,719 $172,966 $213,215 $220,221 $1,711,384 Over/Under $18,423 $32,523 $55,527 $50,072 $73,169 $95,236 $98,174 $100,357 $92,008 $112,125 $106,241 $103,600 $937,455 Jan Dec Feb Mar Apr May Nov Oct Jun Sep Aug Jul 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, 2006, JaxWorks, All Rights Reserved. © Copyright, 2006, JaxWorks, All Rights Reserved. G&A Expenses Summary of Operating Expenses Operating Expenses Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Totals Operating Expenses $5,600 $5,850 $5,900 $6,850 $8,600 $10,350 $12,100 $13,850 $15,600 $17,350 $19,100 $20,850 $142,000 Budget $6,012 $6,045 $6,356 $6,501 $7,744 $9,845 $10,976 $11,232 $14,323 $15,434 $16,543 $17,896 $128,907 Over/Under ($412) ($195) ($456) $349 $856 $505 $1,124 $2,618 $1,277 $1,916 $2,557 $2,954 $13,093 Jan Feb Dec Mar Apr May Nov Jun Oct Sep Jul Aug 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, 2006, JaxWorks, All Rights Reserved. © Copyright, 2006, JaxWorks, All Rights Reserved. G&A Expenses Summary of Payroll Salaries Payroll Salaries Expenses Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Totals Payroll Salaries $10,350 $12,100 $13,850 $15,600 $17,350 $19,100 $20,850 $22,600 $24,350 $26,100 $27,850 $29,600 $239,700 Budget $7,744 $9,845 $10,976 $11,232 $14,323 $15,188 $16,642 $18,097 $19,551 $21,006 $22,460 $23,915 $190,977 Over/Under $2,606 $2,255 $2,874 $4,368 $3,027 $3,913 $4,208 $4,504 $4,799 $5,095 $5,390 $5,686 $48,723 Jan Dec Feb Mar Nov Oct Sep Aug Jul Apr May Jun 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, 2006, JaxWorks, All Rights Reserved. © Copyright, 2006, JaxWorks, All Rights Reserved. Total G&A Expenses Summary of G&A Expenses Total G&A Expenses Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Totals Total G&A Expenses $15,950 $17,950 $19,750 $22,450 $25,950 $29,450 $32,950 $36,450 $39,950 $43,450 $46,950 $50,450 $381,700 Budget $13,756 $15,890 $17,332 $17,733 $22,067 $25,033 $27,618 $29,329 $33,874 $36,440 $39,003 $41,811 $319,884 Over/Under $2,194 $2,060 $2,418 $4,717 $3,883 $4,418 $5,332 $7,122 $6,076 $7,011 $7,947 $8,640 $61,816 Jan Dec Nov Feb Mar Apr May Jun Sep Aug Jul Oct 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, 2006, JaxWorks, All Rights Reserved. © Copyright, 2006, JaxWorks, All Rights Reserved. Sales Expenses Summary of Sales Operating Expenses Sales Operating Expenses Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Totals Operating Expenses $5,500 $5,650 $6,900 $7,750 $8,450 $9,250 $10,050 $10,850 $11,650 $12,450 $13,250 $14,050 $115,800 Budget $6,012 $6,045 $6,356 $6,501 $7,744 $9,845 $10,976 $11,232 $14,323 $15,434 $16,543 $17,896 $128,907 Over/Under ($512) ($395) $544 $1,249 $706 ($595) ($926) ($382) ($2,673) ($2,984) ($3,293) ($3,846) ($13,107) Feb Dec Jan Mar Nov Oct Sep Aug Jul Apr May Jun 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, 2006, JaxWorks, All Rights Reserved. © Copyright, 2006, JaxWorks, All Rights Reserved. Sales Expenses Summary of Sales Payroll Salaries Expenses Sales Payroll Salaries Expenses Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Totals Payroll Salaries $5,500 $5,650 $6,900 $7,750 $8,450 $9,250 $12,050 $11,993 $13,007 $14,021 $15,036 $16,050 $125,657 Budget $7,744 $8,845 $9,276 $10,232 $10,998 $11,788 $12,577 $13,367 $14,156 $14,946 $15,735 $16,525 $146,187 Over/Under ($2,244) ($3,195) ($2,376) ($2,482) ($2,548) ($2,538) ($527) ($1,374) ($1,149) ($924) ($699) ($475) ($20,530) Jan Dec Nov Oct Sep Aug Feb Mar Apr May Jun Jul Payroll Salaries Budget $20,000 $15,000 $10,000 $5,000 $0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec © Copyright, 2006, JaxWorks, All Rights Reserved. © Copyright, 2006, JaxWorks, All Rights Reserved. Total Sales Expenses Summary of Sales Expenses Total Sales Expenses Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Totals Total Sales Expenses $11,000 $11,300 $13,800 $15,500 $16,900 $18,500 $22,100 $22,843 $24,657 $26,471 $28,286 $30,100 $241,457 Budget $13,756 $14,890 $15,632 $16,733 $18,742 $21,633 $23,553 $24,599 $28,479 $30,380 $32,278 $34,421 $275,094 Over/Under ($2,756) ($3,590) ($1,832) ($1,233) ($1,842) ($3,133) ($1,453) ($1,756) ($3,822) ($3,908) ($3,992) ($4,321) ($33,637) Jan Feb Dec Nov Oct Mar Apr May Jun Sep Aug Jul Total Sales Expenses Budget $40,000 $30,000 $20,000 $10,000 $0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec © Copyright, 2006, JaxWorks, All Rights Reserved. © Copyright, 2006, JaxWorks, All Rights Reserved. Marketing Expenses Summary of Marketing Operating Expenses Marketing Operating Expenses Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Totals Operating Expenses $5,500 $5,650 $6,900 $7,750 $8,450 $9,250 $10,050 $10,850 $11,650 $12,450 $13,250 $14,050 $115,800 Budget $6,012 $6,045 $6,356 $6,501 $7,744 $9,845 $10,976 $11,232 $14,323 $15,434 $16,543 $17,896 $128,907 Over/Under ($512) ($395) $544 $1,249 $706 ($595) ($926) ($382) ($2,673) ($2,984) ($3,293) ($3,846) ($13,107) Feb Dec Jan Mar Nov Oct Sep Aug Jul Apr May Jun 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, 2006, JaxWorks, All Rights Reserved. © Copyright, 2006, JaxWorks, All Rights Reserved. Marketing Expenses Summary of Marketing Payroll Salaries Expenses Marketing Payroll Salaries Expenses Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Totals Payroll Salaries $5,500 $5,650 $6,900 $7,750 $8,450 $9,250 $12,050 $11,993 $13,007 $14,021 $15,036 $16,050 $125,657 Budget $7,744 $8,845 $9,276 $10,232 $10,998 $11,788 $12,577 $13,367 $14,156 $14,946 $15,735 $16,525 $146,187 Over/Under ($2,244) ($3,195) ($2,376) ($2,482) ($2,548) ($2,538) ($527) ($1,374) ($1,149) ($924) ($699) ($475) ($20,530) Jan Dec Nov Oct Sep Aug Feb Mar Apr May Jun Jul Payroll Salaries Budget $20,000 $15,000 $10,000 $5,000 $0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec © Copyright, 2006, JaxWorks, All Rights Reserved. © Copyright, 2006, JaxWorks, All Rights Reserved. Total Marketing Expenses Summary of Marketing Expenses Total Marketing Expenses Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Totals Marketing Expenses $11,100 $12,300 $13,800 $15,300 $17,000 $18,400 $22,100 $22,843 $24,657 $26,471 $28,286 $30,100 $242,357 Budget $13,756 $14,890 $15,632 $16,733 $18,742 $21,633 $23,553 $24,599 $28,479 $30,380 $32,278 $34,421 $275,094 Over/Under ($2,656) ($2,590) ($1,832) ($1,433) ($1,742) ($3,233) ($1,453) ($1,756) ($3,822) ($3,908) ($3,992) ($4,321) ($32,737) Feb Dec Jan Mar Nov Oct Sep Aug Jul Apr May Jun Marketing Expenses Budget $40,000 $30,000 $20,000 $10,000 $0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec © Copyright, 2006, JaxWorks, All Rights Reserved. © Copyright, 2006, JaxWorks, All Rights Reserved. Research & Development Expenses Summary of R&D Operating Expenses R&D Operating Expenses Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Totals Operating Expenses $21,500 $23,735 $24,908 $26,965 $29,740 $33,420 $36,130 $37,965 $42,635 $45,325 $48,013 $50,945 $421,281 Budget $19,595 $21,678 $23,754 $25,501 $27,581 $29,560 $31,539 $33,519 $35,498 $37,478 $39,457 $41,436 $366,595 Over/Under $1,905 $2,057 $1,154 $1,464 $2,160 $3,860 $4,591 $4,446 $7,137 $7,848 $8,556 $9,509 $54,686 Feb Dec Jan Mar Nov Oct Sep Aug Jul Apr May Jun 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, 2006, JaxWorks, All Rights Reserved. © Copyright, 2006, JaxWorks, All Rights Reserved. Research & Development Expenses Summary of R&D Payroll Salaries Expenses Marketing Payroll Salaries Expenses Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Totals Payroll Salaries $35,256 $38,625 $40,540 $43,698 $48,482 $55,053 $59,683 $62,564 $71,114 $75,705 $80,291 $85,366 $696,375 Budget $19,595 $21,678 $23,754 $25,501 $27,581 $29,560 $31,539 $33,519 $35,498 $37,478 $39,457 $41,436 $366,595 Over/Under $15,661 $16,947 $16,786 $18,197 $20,902 $25,493 $28,144 $29,045 $35,616 $38,227 $40,834 $43,929 $329,780 Feb Dec Jan Mar Apr May Jun Nov Oct Sep Aug Jul Payroll Salaries Budget $100,000 $80,000 $60,000 $40,000 $20,000 $0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec © Copyright, 2006, JaxWorks, All Rights Reserved. © Copyright, 2006, JaxWorks, All Rights Reserved. Total Research & Development Expenses Summary of R&D Expenses Total Marketing Expenses Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Totals Marketing Expenses $56,756 $62,360 $65,448 $70,663 $78,222 $88,473 $95,813 $100,529 $113,749 $121,030 $128,304 $136,311 $1,117,656 Budget $39,190 $43,356 $47,508 $51,002 $55,161 $59,120 $63,079 $67,037 $70,996 $74,955 $78,914 $82,873 $733,190 Over/Under $17,566 $19,004 $17,940 $19,661 $23,061 $29,353 $32,734 $33,491 $42,753 $46,075 $49,390 $53,438 $384,466 Feb Dec Jan Mar Nov Oct Sep Aug Jul Apr May Jun Marketing Expenses Budget $150,000 $100,000 $50,000 $0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec © Copyright, 2006, JaxWorks, All Rights Reserved. © Copyright, 2006, JaxWorks, All Rights Reserved. Total All Operating Expenses Summary of All Operating Expenses Total All Operating Expenses Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Totals All Operating Expenses $151,512 $166,935 $180,988 $198,511 $220,904 $247,375 $277,596 $291,813 $324,492 $347,270 $370,038 $394,026 $3,171,460 Budget $123,285 $138,239 $149,386 $159,398 $178,612 $195,740 $211,138 $223,911 $245,189 $260,528 $275,860 $291,924 $2,453,209 Over/Under $28,227 $28,696 $31,602 $39,113 $42,293 $51,635 $66,458 $67,902 $79,302 $86,742 $94,178 $102,102 $718,251 Feb Dec Nov Oct Sep Aug Jul Jan Mar Apr May Jun All Operating Expenses Budget $500,000 $400,000 $300,000 $200,000 $100,000 $0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec © Copyright, 2006, JaxWorks, All Rights Reserved. © Copyright, 2006, JaxWorks, All Rights Reserved. Earnings Before Income Tax Summary of Earnings Before Income Tax Earnings Before Income Tax Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Totals EBIT -$36,995 -$25,858 -$29,374 -$48,929 -$44,852 -$31,386 -$40,679 -$37,818 -$43,765 -$62,178 -$50,582 -$70,205 -$522,620 Budget -$27,191 -$29,685 -$53,299 -$59,888 -$75,728 -$74,987 -$72,394 -$70,273 -$56,471 -$87,562 -$62,644 -$71,703 -$741,824 Over/Under ($9,804) $3,827 $23,925 $10,959 $30,877 $43,601 $31,716 $32,455 $12,706 $25,383 $12,062 $1,498 $219,204 Feb Dec Nov Jan Mar Apr May Oct Sep Aug Jul Jun EBIT Budget $0 ($20,000) ($40,000) ($60,000) ($80,000) ($100,000) Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec © Copyright, 2006, JaxWorks, All Rights Reserved. © Copyright, 2006, JaxWorks, All Rights Reserved. Net Income (Loss) Summary of Net Income (Loss) Net Income (Loss) Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Totals Net Income -$26,116 -$19,169 -$22,206 -$37,328 -$34,556 -$20,565 -$28,804 -$28,537 -$34,434 -$49,058 -$42,675 -$58,146 -$401,595 Budget -$16,312 -$22,996 -$46,131 -$48,287 -$65,432 -$64,166 -$60,520 -$60,992 -$47,140 -$74,441 -$54,738 -$59,644 -$620,799 Over/Under ($9,804) $3,827 $23,925 $10,959 $30,877 $43,601 $31,716 $32,455 $12,706 $25,383 $12,062 $1,498 $219,204 Feb Dec Nov Oct Sep Jan Mar Apr May Aug Jul Jun Net Income Budget $0 Jan ($20,000) Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec ($40,000) ($60,000) ($80,000) © Copyright, 2006, JaxWorks, All Rights Reserved. © 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 Copyright Notice © 2007, 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.