G&A Expense Budget
Your Company, Inc.
For Period Ending April 30, 2004
Budget FIXED Exec salaries Office salaries Employee benefits Payroll taxes Travel and entertainment Directors' fees and expenses Insurance Rent Depreciation Taxes Legal Audit Telephone Utilities Contributions Postage Dues Miscellaneous VARIABLE Office salaries Employee benefits Payroll taxes Travel and entertainment Telephone and telegraph Stationary and office supplies Bad debts Postage Contributions Miscellaneous TOTAL $3,200 1,300 22,900 14,200 4,100 38,400 18,600 47,500 46,600 40,400 28,200 10,600 15,500 31,000 36,500 27,300 21,300 14,800 This Month Actual $1,900 8,700 19,800 7,500 5,100 36,100 10,000 49,700 30,200 59,900 31,200 11,800 10,300 39,300 43,700 30,500 30,800 20,300 Variance ($1,300) 7,400 (3,100) (6,700) 1,000 (2,300) (8,600) 2,200 (16,400) 19,500 3,000 1,200 (5,200) 8,300 7,200 3,200 9,500 5,500 Budget $31,100 36,400 222,660 28,900 15,100 187,300 64,100 377,500 334,000 415,900 214,800 87,200 15,200 68,000 87,900 130,400 142,100 91,000 Year to Date Actual $46,600 45,100 259,000 41,800 20,000 167,800 58,200 333,300 201,400 404,600 193,900 104,100 21,400 97,400 92,100 161,900 180,700 97,800 Variance $15,500 8,700 36,340 12,900 4,900 (19,500) (5,900) (44,200) (132,600) (11,300) (20,900) 16,900 6,200 29,400 4,200 31,500 38,600 6,800
23,000 29,800 4,700 36,100 4,600 6,600 11,600 18,700 47,900 42,100 $647,500
32,400 27,800 3,300 53,400 6,300 8,100 10,700 20,400 47,500 34,900 $691,600
9,400 (2,000) (1,400) 17,300 1,700 1,500 (900) 1,700 (400) (7,200) $44,100
53,000 292,600 14,400 111,400 47,500 15,100 57,700 131,400 316,800 232,700 $3,822,160
29,500 170,200 17,100 108,900 44,300 13,400 80,700 70,900 212,300 331,900 $3,606,300
(23,500) (122,400) 2,700 (2,500) (3,200) (1,700) 23,000 (60,500) (104,500) 99,200 ($215,860)
© 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