Budget Plan

Reviews
Shared by: Linda Oliver
Stats
views:
559
rating:
not rated
reviews:
0
posted:
1/1/2008
language:
pages:
0
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

Related docs
Marketing Budget Plan
Views: 128  |  Downloads: 27
business plan & budget update
Views: 2  |  Downloads: 0
BUDGET PER STRATEGIC PLAN OBJECTIVE
Views: 1  |  Downloads: 0
BUDGET PER STRATEGIC PLAN OBJECTIVE
Views: 1  |  Downloads: 0
Budget Plan
Views: 74  |  Downloads: 8
plan_budget
Views: 6  |  Downloads: 1
Budget Plan
Views: 5  |  Downloads: 0
Budget Plan
Views: 104  |  Downloads: 3
Budget Planner
Views: 6645  |  Downloads: 1005
Budget-Plan
Views: 58  |  Downloads: 2
Plan Budget
Views: 0  |  Downloads: 0
Plan and Budget
Views: 1  |  Downloads: 0
Monthly Average Budget Plan
Views: 263  |  Downloads: 10
Printable Budget Planner
Views: 6148  |  Downloads: 94
BUDGET REPORT
Views: 1  |  Downloads: 0
Other docs by Linda Oliver
Constitution Day 2007 Lesson Plan
Views: 425  |  Downloads: 6
Section IV-Prior Printed Histories
Views: 312  |  Downloads: 3