BUSINESS BUDGET
Month/Year: Aug-08
SUMMARY
Total income Total expenses Income less expenses:
ACTUAL
BUDGETED
OVER BUDGET
UNDER BUDGET
########## 1,318,080.00 339,760.00 314,910.00 ########## 1,003,170.00 ACTUAL BUDGETED
114,420.00 24,850.00 89,570.00
OVER BUDGET 200,000.00 500.00 20.00 -88,000.00 1,000.00 -100.00 1,000.00 114,420.00 OVER BUDGET UNDER BUDGET NOTES UNDER BUDGET NOTES Increase advertising next year.
INCOME DETAILS
Sales Interest earned Fees Commissions Rent Royalties Other Total income:
########## 1,200,000.00 5,000.00 1,000.00 10,000.00 9,000.00 2,500.00 5,000.00 4,500.00 980.00 98,000.00 8,000.00 2,600.00 4,000.00
########## 1,318,080.00 ACTUAL BUDGETED
EXPENSE DETAILS SELLING
Salaries and wages Commissions Advertising Delivery Shipping Travel Other Total sales expenses: Percent of total:
246,000.00 10,000.00 6,000.00 0.00 0.00 4,600.00 1,000.00 267,600.00 78.76%
248,000.00 12,000.00 8,000.00 0.00 0.00 5,600.00 1,200.00 274,800.00 87.26%
-2,000.00 -2,000.00 -2,000.00 Increase Here 3%.
-1,000.00 -200.00 -7,200.00
ADMINISTRATIVE
Salaries and wages Employee benefits Payroll taxes Insurance Loans Office supplies Travel & entertainment Postage Furnishings Contributions Dues Other Total admin. expenses: Percent of total: 12,000.00 5,000.00 500.00 14,000.00 6,000.00 4,000.00 200.00 300.00 0.00 0.00 0.00 0.00 42,000.00 12.36% 10,000.00 6,000.00 500.00 14,000.00 5,000.00 4,100.00 190.00 320.00 0.00 0.00 0.00 0.00 40,110.00 12.74% 1,890.00 10.00 -20.00 1,000.00 -100.00 2,000.00 -1,000.00
SERVICE & EQUIPMENT
Accounting Legal Utilities Telephone Equipment purchases Rent & maintenance Other Total S&E expenses: Percent of total: 1,200.00 5,000.00 15,000.00 5,000.00 3,400.00 560.00 0.00 30,160.00 0.09 1,500.00 6,000.00 15,789.00 4,800.00 3,000.00 600.00 0.00 31,689.00 0.10 -1,529.00 200.00 400.00 -40.00 -300.00 -1,000.00 -789.00 Too high.
© Copyright, 2006, JaxWorks, All Rights Reserved.
Income and Expenses Budget Versus Actual 2,000,000.00 1,500,000.00 1,000,000.00 500,000.00
0.00
1
Income Expense
2
© Copyright, 2006, JaxWorks, All Rights Reserved.
Administrative Expenses 16,000.00 14,000.00 12,000.00 10,000.00 8,000.00 6,000.00 4,000.00 2,000.00 0.00 Salaries Payroll Loans
Actual
Travel
Furnish
Dues
Budgeted
© Copyright, 2006, JaxWorks, All Rights Reserved.
Services Expenses 18,000.00 16,000.00 14,000.00 12,000.00 10,000.00 8,000.00 6,000.00 4,000.00 2,000.00 0.00 Accounting Utilities
Actual
Equipment
Budgeted
Other
© Copyright, 2006, JaxWorks, All Rights Reserved.
Income Details 1,600,000.00 1,400,000.00 1,200,000.00 1,000,000.00 800,000.00 600,000.00 400,000.00 200,000.00 0.00 Sales Fees
Actual Income
Rent
Estimated Income
Other
© Copyright, 2006, JaxWorks, All Rights Reserved.
Selling Expense Details 300,000.00 250,000.00
200,000.00
150,000.00 100,000.00 50,000.00 0.00 Salaries Advertising
Actual
Shipping
Budgeted
Other
© Copyright, 2006, JaxWorks, All Rights Reserved.
Since 1996, JaxWorks has offered a suite of Free Excel workbooks and spreadsheets, and asso PDF and HTML documents, that cover a number of financial, accounting and sales functions. Th 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 o in the Office suite this site is invaluable.
JaxWorks Small Business Spreadsheet Factory
d spreadsheets, and associated MS Word, ng and sales functions. These are
guides are in
vity analysis,
ore about MS Excel and other applications
Factory