Quarterly Budget Analysis
August 12, 2008 XYZ Manufacturing, Inc.
For the Quarter Ending: 03/31/06
This Quarter Budget Item
Sales Revenue Cost of sales Gross Profits Variable Expenses Selling Expenses Inspection Budget $500,000 300,000 $200,000 $100,000 10,000 Actual $550,000 320,000 $230,000 $120,000 8,000 Variance $50,000 20,000 $30,000 $20,000 (2,000) Budget $1,000,000 600,000 $400,000 $200,000 20,000
Year-to-Date
Actual $1,200,000 640,000 $560,000 $240,000 16,000 Variance $200,000 40,000 $160,000 $40,000 (4,000)
Total Variable Expenses Fixed Expenses Rent Depreciation
$110,000 $60,000 20,000
$128,000 $70,000 19,000
$18,000 $10,000 (1,000)
$220,000 $120,000 40,000
$256,000 $150,000 38,000
$36,000 $30,000 (2,000)
Total Fixed Expenses Income From Operations Interest Income Interest Expense Net Income Before Taxes Taxes Net Income After Taxes
$80,000 $10,000 2,000 1,000 $7,000 2,000 $5,000
$89,000 $13,000 3,000 1,500 $8,500 1,500 $7,000
$9,000 $3,000 1,000 500 $1,500 (500) $2,000
$160,000 $20,000 4,000 2,000 $14,000 4,000 $10,000
$188,000 $116,000 6,000 3,000 $107,000 3,000 $104,000
$28,000 $96,000 2,000 1,000 $93,000 (1,000) $94,000
Non-Income Statement Items
Loan Repayments Owner Withdrawals (or dividends) Fixed Asset Expenditures 14,000 20,000 100,000 13,000 25,000 90,000 (1,000) 5,000 (10,000) 28,000 20,000 100,000 26,000 25,000 90,000 (2,000) 5,000 (10,000)
© 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.
ides are in
y analysis,
about MS Excel and other applications in the Office
sheet Factory