10EDUCATION

MONTHLY BUDGET
BUDGET OVERVIEW
BUDGET TOTALS ESTIMATED PRIVATE ACTUAL DIFFERENCE
ESTIMATED ACTUAL
Income 63,300.00 126,600.00 57,450.00 (5,850.00)
80,000.00
Expenses 54,500.00 109,000.00 39,775.00 (14,725.00) 63,300.00
60,000.00 54,500.00

40,000.00
is cell. Top 5 Operating Expenses are automatically updated in Top5Expenses table, below.
20,000.00
WHAT ARE MY TOP 5 HIGHEST OPERATING EXPENSES? 0.00
Income Expenses
EXPENSE AMOUNT % OF EXPENSES 15% REDUCTION
Supplies 4,500.00 11.3% 675.00 EXPENSE OVERVIEW
Taxes 3,200.00 8.0% 480.00 5,000.00
Advertising 2,500.00 6.3% 375.00 4,000.00
Interest 2,200.00 5.5% 330.00 3,000.00
Total 12,400.00 31.2% 1,860.00
2,000.00
1,000.00
0.00
INCOME ESTIMATED ACTUAL TOP 5 AMOUNT DIFFERENCE 1 2 3 4
Net sales 60,000.00 54,000.00 54,000.00 (6,000.00) AMOUNT % OF EXPENSES
Asset sales (gain/loss) 300.00 450.00 450.00 150.00
Interest income 3,000.00 3,000.00 3,000.00 0.00
INCOME OVERVIEW
Total Income 63,300.00 57,450.00 (5,850.00) 60,000.00

40,000.00

20,000.00
PERSONNEL EXPENSES ESTIMATED ACTUAL TOP 5 AMOUNT DIFFERENCE
Wages 9,500.00 9,600.00 9,600.00 (100.00) 0.00
Net sales Asset sales Interest income
Employee benefits 4,000.00 0.00 0.00 4,000.00
(gain/loss)
Commission 5,000.00 4,500.00 4,500.00 500.00
ACTUAL ESTIMATED
Total Personnel Expenses 18,500.00 14,100.00 4,400.00
10EDUCATION

MONTHLY BUDGET
OPERATING EXPENSES ESTIMATED ACTUAL DIFFERENCE Missing
values 6

Advertising 3,000.00 2,500.00 500.00

Bad debts 2,000.00 2,000.00

Cash discounts 1,500.00 2,175.00 (675.00)

Delivery costs 2,000.00 1,500.00 500.00

Depreciation 1,000.00 1,000.00

Dues and subscriptions 500.00 525.00 (25.00)

Insurance 1,300.00 1,300.00

Interest 2,000.00 2,200.00 (200.00)

Legal and auditing 1,000.00 1,000.00

Maintenance and repairs 4,500.00 4,600.00 (100.00)

Office supplies 800.00 750.00 50.00

Postage 400.00 350.00 50.00

Rent or mortgage 4,100.00 4,100.00

Sales expenses 350.00 400.00 (50.00)

Shipping and storage 900.00 840.00 60.00

Supplies 5,000.00 4,500.00 500.00

Taxes 3,000.00 3,200.00 (200.00)

Telephone 250.00 250.00

Utilities 1,400.00 1,385.00 15.00

Other 1,000.00 750.00 250.00