<Company Name>

Streamlined Expense Estimates

Planned Expenses Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YEAR
Employee Costs
Employee wages $85,000 $85,000 $85,000 $87,500 $87,500 $87,500 $87,500 $92,400 $92,400 $92,400 $92,400 $92,400 $1,067,000
Employee benefits 22,950 22,950 22,950 23,625 23,625 23,625 23,625 24,948 24,948 24,948 24,948 24,948 288,090
Employee training 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 48,000
Subtotal $107,950 $107,950 $107,950 $111,125 $111,125 $111,125 $111,125 $117,348 $117,348 $117,348 $117,348 $117,348 $1,355,090

Office Costs
Office lease $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $144,000
Office utilities 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 24,000
Office supplies 250 250 250 250 250 250 250 250 250 250 250 250 3,000
Subtotal $14,250 $14,250 $14,250 $14,250 $14,250 $14,250 $14,250 $14,250 $14,250 $14,250 $14,250 $14,250 $171,000

Marketing Costs
Web site costs $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $24,000
Collateral costs 500 500 500 500 500 500 500 500 500 500 500 500 6,000
Marketing events 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 60,000
Subtotal $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $90,000

TOTALS
Monthly Planned Expenses $129,700 $129,700 $129,700 $132,875 $132,875 $132,875 $132,875 $139,098 $139,098 $139,098 $139,098 $139,098 $1,616,090
TOTAL Planned Expenses $129,700 $259,400 $389,100 $521,975 $654,850 $787,725 $920,600 $1,059,698 $1,198,796 $1,337,894 $1,476,992 $1,616,090
<Company Name>
Streamlined Expense Estimates

Actual Expenses Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YEAR
Employee Costs
Employee wages $85,000 $85,000 $85,000 $89,000 $89,000 $89,000 $87,500 $92,400 $92,400 $92,400 $92,400 $92,400 $1,071,500
Employee benefits 22,950 22,950 22,950 24,030 24,030 24,030 23,625 24,948 24,948 24,948 24,948 24,948 289,305
Employee training 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 48,000
Subtotal $107,950 $107,950 $107,950 $113,030 $113,030 $113,030 $111,125 $117,348 $117,348 $117,348 $117,348 $117,348 $1,360,805

Office Costs
Office lease $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $144,000
Office utilities 2,250 2,300 2,400 1,800 1,640 1,650 1,550 1,760 1,900 2,100 2,300 2,350 24,000
Office supplies 255 245 220 215 220 234 310 185 190 245 220 204 2,743
Subtotal $14,505 $14,545 $14,620 $14,015 $13,860 $13,884 $13,860 $13,945 $14,090 $14,345 $14,520 $14,554 $170,743

Marketing Costs
Web site costs $2,150 $1,890 $2,190 $2,050 $1,950 $2,200 $2,000 $2,300 $2,045 $2,100 $2,150 $2,250 $25,275
Collateral costs 600 650 400 550 495 700 300 450 450 420 800 400 6,215
Marketing events 2,500 6,000 8,500 2,300 4,300 5,600 4,550 5,050 6,025 7,500 3,200 4,900 60,425
Subtotal $5,250 $8,540 $11,090 $4,900 $6,745 $8,500 $6,850 $7,800 $8,520 $10,020 $6,150 $7,550 $91,915

TOTALS
Monthly Actual Expenses $127,705 $131,035 $133,660 $131,945 $133,635 $135,414 $131,835 $139,093 $139,958 $141,713 $138,018 $139,452 $1,623,463
TOTAL Actual Expenses $127,705 $258,740 $392,400 $524,345 $657,980 $793,394 $925,229 $1,064,322 $1,204,280 $1,345,993 $1,484,011 $1,623,463
<Company Name>
Streamlined Expense Estimates

Expense Variances Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YEAR
Employee Costs
Employee wages $- $- $- $(1,500) $(1,500) $(1,500) $- $- $- $- $- $- $(4,500)
Employee benefits $- $- $- $(405) $(405) $(405) $- $- $- $- $- $- $(1,215)
Employee training $- $- $- $- $- $- $- $- $- $- $- $- $-
Subtotal $- $- $- $(1,905) $(1,905) $(1,905) $- $- $- $- $- $- $(5,715)

Office Costs
Office lease $- $- $- $- $- $- $- $- $- $- $- $- $-
Office utilities $(250) $(300) $(400) $200 $360 $350 $450 $240 $100 $(100) $(300) $(350) $-
Office supplies $(5) $5 $30 $35 $30 $16 $(60) $65 $60 $5 $30 $46 $257
Subtotal $(255) $(295) $(370) $235 $390 $366 $390 $305 $160 $(95) $(270) $(304) $257

Marketing Costs
Web site costs $(150) $110 $(190) $(50) $50 $(200) $- $(300) $(45) $(100) $(150) $(250) $(1,275)
Collateral costs $(100) $(150) $100 $(50) $5 $(200) $200 $50 $50 $80 $(300) $100 $(215)
Marketing events $2,500 $(1,000) $(3,500) $2,700 $700 $(600) $450 $(50) $(1,025) $(2,500) $1,800 $100 $(425)
Subtotal $2,250 $(1,040) $(3,590) $2,600 $755 $(1,000) $650 $(300) $(1,020) $(2,520) $1,350 $(50) $(1,915)

TOTALS
Monthly Expense Variances $1,995 $(1,335) $(3,960) $930 $(760) $(2,539) $1,040 $5 $(860) $(2,615) $1,080 $(354) $(7,373)
TOTAL Expense Variances $1,995 $660 $(3,300) $(2,370) $(3,130) $(5,669) $(4,629) $(4,624) $(5,484) $(8,099) $(7,019) $(7,373)
<Company Name>
Streamlined Expense Estimates

Expense Category Actual Expenses

Actual Expenses

Marketing Costs 5.66%

Office Costs 10.52%

Employee Costs 83.82%

$140,000

$130,000

$120,000

$110,000

$100,000

$90,000

$80,000
Expenses

$70,000

$60,000

$50,000

$40,000

$30,000

$20,000

$10,000

$0

($10,000)
C C C C C C C C C C C C C C C C C C C C C C C C C C C C C C C C C C C C
ol ol ol ol ol ol ol ol ol ol ol ol ol ol ol ol ol ol ol ol ol ol ol ol ol ol ol ol ol ol ol ol ol ol ol ol
u u u u u u u u u u u u u u u u u u u u u u u u u u u u u u u u u u u u
Month
C C C C
ol ol ol ol
u u u u