Page 163 - Budgeting for Managers

Budgeting for Managers
146
February
January
Var
Proj
Proj
Act
Var
Diff
Expenses
(150)
Computer
850
-8%
100
100
100
(150)
250
Education 1,000 Act Diff -15% 1,200 1,300 (150) -60%
-60%
250
Insurance 250 250 — 0% 250 250 — 0%
Marketing 500 500 — 0% 1,000 750 (250) -25%
Medical 1,500 1,125 (375) -25% 1,500 2,000 500 33%
Miscellaneous 250 500 250 100% 300 100 (200) -67%
Office Rent 450 500 50 11% 450 450 — 0%
Office Supplies 100 50 (50) -50% 100 150 50 50%
Shipping & Post. 50 50 — 0% 75 75 — 0%
Subscriptions 100 1,200 1,100 1100% 100 — (100) -100%
Telephone 100 125 25 25% 150 100 (50 -33%
Travel 250 300 50 20% 100 100 — 0%
Total 4,800 5,500 750 16% 5,475 5.375 (100) -2%
March Quarter
Expenses Proj Act Diff Var Proj Act Diff Var
Computer 1,000 1,000 — 0% 3,200 3,150 (50) -2%
Education 250 500 250 100% 750 700 (50) -7%
Insurance 250 250 — 0% 750 750 — 0%
Marketing 1,500 1,350 (150) -10% 3,000 2,600 (400) -13%
Medical 500 1,500 2,000 400% 3,500 4,625 2,125 61%
Miscellaneous 150 75 (75) -50% 700 675 (25) -4%
Office Rent 450 450 — 0% 1,350 1,400 50 4%
Office Supplies 100 50 (50) -50% 300 250 (50) -17%
Shipping & Post. 100 50 (50) -50% 225 175 (50) -22%
Subscriptions 100 — (100) -100% 300 1,200 900 300%
Telephone 250 175 (75) -30% 500 400 (100) -20%
Travel 150 125 (25) -17% 500 525 25 5%
Total 4,800 5,525 1,725 36% 15,075 16,450 2,375 16%
Table 9-5. Actual vs. estimated for a quarter
However, if we have a line-item budget and one or more
items are overspent or underspent, then we need to request an
adjustment. Similarly, if it looks like we need more money than
we have in our total budget allocation, then we will need to
request an adjustment to get the funds we need. We’ll discuss
this in the next section.