budget

mbibey
template.xlsx

Sheet1

SAMPLE INC.
Budgeted Expenses
For the Years Ended December 31, xxx2
Over (Under) Budget
Budget Actual Amount
Employee Costs:
Salary Full Time 830,000 824,480
Salary Part Time 200,000 224,300
Salary Overtime 50,000 54,345
Employee Benefits 315,000 330,938
Total 1,395,000 1,434,063
Other Costs:
Maintenance 1,800 1,536
Travel 3,500 4,255
Telephone 1,200 1,523
Postage 4,000 2,650
Professional Dues 600 560
Rent 65,000 65,000
Office Supplies 7,000 7,234
Miscellaneous 800 533
Total 83,900 83,291
Grand Total 1,478,900 1,517,354
Number of Full-Time Employees 25 23
Analysis:

Sheet2

Sheet3

1

2

3

4

5

6

7

8

9

A

B

C

Budget

830,000

200,000

Salary Full Time

SAMPLE INC.

Budgeted Expenses

For the Years Ended December 31, xxx2

Employee Costs:

Salary Part Time