Streamlined Expense Estimates
Planned Expenses Employee Costs Employee wages Employee benefits Employee training Subtotal Office Costs Office lease Office utilities Office supplies Subtotal Marketing Costs Web site costs Collateral costs Marketing events Subtotal
Jan $85,000 22,950 4,000 $107,950
Feb $85,000 22,950 4,000 $107,950
Mar $85,000 22,950 4,000 $107,950
Apr $87,500 23,625 4,000 $111,125
May $87,500 23,625 4,000 $111,125
Jun $87,500 23,625 4,000 $111,125
Jul $87,500 23,625 4,000 $111,125
Aug $92,400 24,948 4,000 $117,348
Sep $92,400 24,948 4,000 $117,348
Oct $92,400 24,948 4,000 $117,348
Nov $92,400 24,948 4,000 $117,348
Dec $92,400 24,948 4,000 $117,348
YEAR $1,067,000 288,090 48,000 $1,355,090
$12,000 2,000 250 $14,250
$12,000 2,000 250 $14,250
$12,000 2,000 250 $14,250
$12,000 2,000 250 $14,250
$12,000 2,000 250 $14,250
$12,000 2,000 250 $14,250
$12,000 2,000 250 $14,250
$12,000 2,000 250 $14,250
$12,000 2,000 250 $14,250
$12,000 2,000 250 $14,250
$12,000 2,000 250 $14,250
$12,000 2,000 250 $14,250
$144,000 24,000 3,000 $171,000
$2,000 500 5,000 $7,500
$2,000 500 5,000 $7,500
$2,000 500 5,000 $7,500
$2,000 500 5,000 $7,500
$2,000 500 5,000 $7,500
$2,000 500 5,000 $7,500
$2,000 500 5,000 $7,500
$2,000 500 5,000 $7,500
$2,000 500 5,000 $7,500
$2,000 500 5,000 $7,500
$2,000 500 5,000 $7,500
$2,000 500 5,000 $7,500
$24,000 6,000 60,000 $90,000
TOTALS Monthly Planned Expenses TOTAL Planned Expenses
$129,700 $129,700
$129,700 $259,400
$129,700 $389,100
$132,875 $521,975
$132,875 $654,850
$132,875 $787,725
$132,875 $920,600
$139,098 $1,059,698
$139,098 $1,198,796
$139,098 $1,337,894
$139,098 $1,476,992
$139,098 $1,616,090
$1,616,090
Streamlined Expense Estimates
Actual Expenses Employee Costs Employee wages Employee benefits Employee training Subtotal Office Costs Office lease Office utilities Office supplies Subtotal Marketing Costs Web site costs Collateral costs Marketing events Subtotal
Jan $85,000 22,950 4,000 $107,950
Feb $85,000 22,950 4,000 $107,950
Mar $85,000 22,950 4,000 $107,950
Apr $89,000 24,030 4,000 $113,030
May $89,000 24,030 4,000 $113,030
Jun $89,000 24,030 4,000 $113,030
Jul $87,500 23,625 4,000 $111,125
Aug $92,400 24,948 4,000 $117,348
Sep $92,400 24,948 4,000 $117,348
Oct $92,400 24,948 4,000 $117,348
Nov $92,400 24,948 4,000 $117,348
Dec $92,400 24,948 4,000 $117,348
YEAR $1,071,500 289,305 48,000 $1,360,805
$12,000 2,250 255 $14,505
$12,000 2,300 245 $14,545
$12,000 2,400 220 $14,620
$12,000 1,800 215 $14,015
$12,000 1,640 220 $13,860
$12,000 1,650 234 $13,884
$12,000 1,550 310 $13,860
$12,000 1,760 185 $13,945
$12,000 1,900 190 $14,090
$12,000 2,100 245 $14,345
$12,000 2,300 220 $14,520
$12,000 2,350 204 $14,554
$144,000 24,000 2,743 $170,743
$2,150 600 2,500 $5,250
$1,890 650 6,000 $8,540
$2,190 400 8,500 $11,090
$2,050 550 2,300 $4,900
$1,950 495 4,300 $6,745
$2,200 700 5,600 $8,500
$2,000 300 4,550 $6,850
$2,300 450 5,050 $7,800
$2,045 450 6,025 $8,520
$2,100 420 7,500 $10,020
$2,150 800 3,200 $6,150
$2,250 400 4,900 $7,550
$25,275 6,215 60,425 $91,915
TOTALS Monthly Actual Expenses TOTAL Actual Expenses
$127,705 $127,705
$131,035 $258,740
$133,660 $392,400
$131,945 $524,345
$133,635 $657,980
$135,414 $793,394
$131,835 $925,229
$139,093 $1,064,322
$139,958 $1,204,280
$141,713 $1,345,993
$138,018 $1,484,011
$139,452 $1,623,463
$1,623,463
Streamlined Expense Estimates
Expense Variances Employee Costs Employee wages Employee benefits Employee training Subtotal Office Costs Office lease Office utilities Office supplies Subtotal Marketing Costs Web site costs Collateral costs Marketing events Subtotal
Jan $ $ $ $ $ $ $ $
Feb $ $ $ $
Mar $ $ $ $
Apr (1,500) (405) (1,905) $ $ $ $
May (1,500) (405) (1,905) $ $ $ $
Jun (1,500) (405) (1,905) $ $ $ $
Jul $ $ $ $
Aug $ $ $ $
Sep $ $ $ $
Oct $ $ $ $
Nov $ $ $ $
Dec $ $ $ $
YEAR (4,500) (1,215) (5,715)
$ $ $ $
(250) (5) (255)
$ $ $ $
(300) 5 (295)
$ $ $ $
(400) 30 (370)
$ $ $ $
200 35 235
$ $ $ $
360 30 390
$ $ $ $
350 16 366
$ $ $ $
450 (60) 390
$ $ $ $
240 65 305
$ $ $ $
100 60 160
$ $ $ $
(100) 5 (95)
$ $ $ $
(300) 30 (270)
$ $ $ $
(350) 46 (304)
$ $ $ $
257 257
$ $ $ $
(150) (100) 2,500 2,250
$ $ $ $
110 (150) (1,000) (1,040)
$ $ $ $
(190) 100 (3,500) (3,590)
$ $ $ $
(50) (50) 2,700 2,600
$ $ $ $
50 5 700 755
$ $ $ $
(200) (200) (600) (1,000)
$ $ $ $
200 450 650
$ $ $ $
(300) 50 (50) (300)
$ $ $ $
(45) 50 (1,025) (1,020)
$ $ $ $
(100) 80 (2,500) (2,520)
$ $ $ $
(150) (300) 1,800 1,350
$ $ $ $
(250) 100 100 (50)
$ $ $ $
(1,275) (215) (425) (1,915)
TOTALS Monthly Expense Variances TOTAL Expense Variances
$ $
1,995 1,995
$ $
(1,335) $ 660 $
(3,960) $ (3,300) $
930 $ (2,370) $
(760) $ (3,130) $
(2,539) $ (5,669) $
1,040 $ (4,629) $
5 $ (4,624) $
(860) $ (5,484) $
(2,615) $ (8,099) $
1,080 $ (7,019) $
(354) $ (7,373)
(7,373)
Streamlined Expense Estimates
Expense Category Employee Costs Office Costs Marketing Costs TOTALS
Actual Expenses $1,360,805 170,743 91,915 $1,623,463
Actual Expenses
Office Costs 10% Marketing Costs 6%
Employee Costs 84%
Monthly Expenses
$160,000
$140,000
$120,000
$100,000
Expenses
$80,000
$60,000
$40,000
$20,000
$-
$(20,000)
Variance Planned Actual
1 $1,995 $129,700 $127,705
2 $(1,335) $129,700 $131,035
3 $(3,960) $129,700 $133,660
4 $930 $132,875 $131,945
5 $(760) $132,875 $133,635
6 $(2,539) $132,875 $135,414
7 $1,040 $132,875 $131,835
8 $5 $139,098 $139,093
9 $(860) $139,098 $139,958
10 $(2,615) $139,098 $141,713
11 $1,080 $139,098 $138,018
12 $(354) $139,098 $139,452
Month