Detailed Expense Estimate
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Detailed Expense Estimate as PDF for free.
More details
- Words: 1,354
- Pages: 6
Detailed Expense Estimates
Planned Expenses
Feb
Mar
Apr
May
Jun
$85,000 22,950 $107,950
$85,000 22,950 $107,950
$85,000 22,950 $107,950
$87,500 23,625 $111,125
$87,500 23,625 $111,125
$87,500 23,625 $111,125
$87,500 23,625 $111,125
$9,800 300 40 250 180 200 600 $11,370
$9,800 400 300 40 250 180 200 600 $11,770
$9,800 400 300 40 250 180 200 600 $11,770
$9,800 100 300 40 250 180 200 600 $11,470
$9,800 100 300 40 250 180 200 600 $11,470
$9,800 100 300 40 250 180 200 600 $11,470
Marketing Costs Web site hosting Web site updates Collateral preparation Collateral printing Marketing events Miscellaneous expenses Subtotal
$500 200 5,000 200 2,000 200 $8,100
$500 200 0 200 2,000 200 $3,100
$500 200 0 200 2,000 200 $3,100
$500 200 5,000 200 5,000 200 $11,100
$500 200 0 200 2,000 200 $3,100
Training/Travel Training classes Training-related travel costs Subtotal
$2,000 2,000 $4,000
$2,000 2,000 $4,000
$2,000 2,000 $4,000
$2,000 2,000 $4,000
Monthly Planned Expenses
$131,420
$126,820
$126,820
TOTAL Planned Expenses
$131,420
$258,240
$385,060
Employee Costs Wages Benefits Subtotal Office Costs Office lease Gas Electric Water Telephone Internet access Office supplies Security Subtotal
Jan
Jul
Aug
Sep
Oct
Nov
Dec
YEAR
$92,400 24,948 $117,348
$92,400 24,948 $117,348
$92,400 24,948 $117,348
$92,400 24,948 $117,348
$92,400 24,948 $117,348
$1,067,000 288,090 $1,355,090
$9,800 100 300 40 250 180 200 600 $11,470
$9,800 100 300 40 250 180 200 600 $11,470
$9,800 100 300 40 250 180 200 600 $11,470
$9,800 100 300 40 250 180 200 600 $11,470
$9,800 400 300 40 250 180 200 600 $11,770
$9,800 400 300 40 250 180 200 600 $11,770
$117,600 2,300 3,600 480 3,000 2,160 2,400 7,200 $138,740
$500 1,000 0 200 2,000 200 $3,900
$500 200 5,000 200 2,000 200 $8,100
$500 200 0 200 5,000 200 $6,100
$500 200 0 200 2,000 200 $3,100
$500 200 5,000 200 2,000 200 $8,100
$500 200 0 200 2,000 200 $3,100
$500 1,000 0 200 5,000 200 $6,900
$6,000 4,000 20,000 2,400 33,000 2,400 $67,800
$2,000 2,000 $4,000
$2,000 2,000 $4,000
$2,000 2,000 $4,000
$2,000 2,000 $4,000
$2,000 2,000 $4,000
$2,000 2,000 $4,000
$2,000 2,000 $4,000
$2,000 2,000 $4,000
$24,000 24,000 $48,000
$137,695
$129,695
$130,495
$134,695
$138,918
$135,918
$140,918
$136,218
$140,018
$1,609,630
$522,755
$652,450
$782,945
$917,640
$1,056,558
$1,192,476
$1,333,394
$1,469,612
$1,609,630
TOTALS
Detailed Expense Estimates
Actual Expenses
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
YEAR
Employee Costs Wages Benefits Subtotal
$85,000 22,950 $107,950
$85,000 22,950 $107,950
$85,000 22,950 $107,950
$88,000 23,760 $111,760
$88,000 23,760 $111,760
$88,000 23,760 $111,760
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$519,000 140,130 $659,130
Office Costs Office lease Gas Electric Water Telephone Internet access Office supplies Security Subtotal
$9,800 4 288 35 224 180 256 600 $11,387
$9,800 430 278 33 235 180 142 600 $11,698
$9,800 385 268 34 265 180 160 600 $11,692
$9,800 230 299 36 245 180 221 600 $11,611
$9,800 87 306 34 245 180 256 600 $11,508
$9,800 88 290 36 220 180 240 600 $11,454
$0 0 0 0 0 0 0 0 $0
$0 0 0 0 0 0 0 0 $0
$0 0 0 0 0 0 0 0 $0
$0 0 0 0 0 0 0 0 $0
$0 0 0 0 0 0 0 0 $0
$0 0 0 0 0 0 0 0 $0
$58,800 1,224 1,729 208 1,434 1,080 1,275 3,600 $69,350
Marketing Costs Web site hosting Web site updates Collateral preparation Collateral printing Marketing events Miscellaneous expenses Subtotal
$500 200 4,800 100 1,800 145 $7,545
$500 200 0 500 2,200 156 $3,556
$500 200 0 100 2,200 123 $3,123
$500 200 5,500 100 4,700 223 $11,223
$500 200 0 600 1,500 187 $2,987
$500 1,500 0 180 2,300 245 $4,725
$0 0 0 0 0 0 $0
$0 0 0 0 0 0 $0
$0 0 0 0 0 0 $0
$0 0 0 0 0 0 $0
$0 0 0 0 0 0 $0
$0 0 0 0 0 0 $0
$3,000 2,500 10,300 1,580 14,700 1,079 $33,159
Training/Travel Training classes Training-related travel costs Subtotal
$1,600 1,200 $2,800
$2,400 2,200 $4,600
$1,400 1,400 $2,800
$1,600 1,200 $2,800
$1,200 800 $2,000
$2,800 3,500 $6,300
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$11,000 10,300 $21,300
Monthly Actual Expenses
$129,682
$127,804
$125,565
$137,394
$128,255
$134,239
$0
$0
$0
$0
$0
$0
$782,939
TOTAL Actual Expenses
$129,682
$257,486
$383,051
$520,445
$648,700
$782,939
$782,939
$782,939
$782,939
$782,939
$782,939
$782,939
TOTAL Planned Expenses
Detailed Expense Estimates
Expense Variances
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
YEAR
Employee Costs Wages Benefits Subtotal
$0 0 $0
$0 0 $0
$0 0 $0
($500) (135) ($635)
($500) (135) ($635)
($500) (135) ($635)
$87,500 23,625 $111,125
$92,400 24,948 $117,348
$92,400 24,948 $117,348
$92,400 24,948 $117,348
$92,400 24,948 $117,348
$92,400 24,948 $117,348
$548,000 147,960 $695,960
Office Costs Office lease Gas Electric Water Telephone Internet access Office supplies Security Subtotal
$0 (4) 12 5 26 0 (56) 0 ($17)
$0 (30) 22 7 15 0 58 0 $72
$0 15 32 6 (15) 0 40 0 $78
$0 (130) 1 4 5 0 (21) 0 ($141)
$0 13 (6) 6 5 0 (56) 0 ($38)
$0 12 10 4 30 0 (40) 0 $16
$9,800 100 300 40 250 180 200 600 $11,470
$9,800 100 300 40 250 180 200 600 $11,470
$9,800 100 300 40 250 180 200 600 $11,470
$9,800 100 300 40 250 180 200 600 $11,470
$9,800 400 300 40 250 180 200 600 $11,770
$9,800 400 300 40 250 180 200 600 $11,770
$58,800 1,076 1,871 272 1,566 1,080 1,125 3,600 $69,390
Marketing Costs Web site hosting Web site updates Collateral preparation Collateral printing Marketing events Miscellaneous expenses Subtotal
$0 0 200 100 200 55 $555
$0 0 0 (300) (200) 44 ($456)
$0 0 0 100 (200) 77 ($23)
$0 0 (500) 100 300 (23) ($123)
$0 0 0 (400) 500 13 $113
$0 (500) 0 20 (300) (45) ($825)
$500 200 5,000 200 2,000 200 $8,100
$500 200 0 200 5,000 200 $6,100
$500 200 0 200 2,000 200 $3,100
$500 200 5,000 200 2,000 200 $8,100
$500 200 0 200 2,000 200 $3,100
$500 1,000 0 200 5,000 200 $6,900
$3,000 1,500 9,700 820 18,300 1,321 $34,641
$400 800 $1,200
($400) (200) ($600)
$600 600 $1,200
$400 800 $1,200
$800 1,200 $2,000
($800) (1,500) ($2,300)
$2,000 2,000 $4,000
$2,000 2,000 $4,000
$2,000 2,000 $4,000
$2,000 2,000 $4,000
$2,000 2,000 $4,000
$2,000 2,000 $4,000
$13,000 13,700 $26,700
Monthly Expense Variances
$1,738
($984)
$1,255
$301
$1,440
($3,744)
$134,695
$138,918
$135,918
$140,918
$136,218
$140,018
$826,691
TOTAL Expense Variances
$1,738
$754
$2,009
$2,310
$3,750
$6
$134,701
$273,619
$409,537
$550,455
$686,673
$826,691
Training/Travel Training classes Training-related travel costs Subtotal TOTALS
Detailed Expense Estimates Expense Category Employee Costs Office Costs Marketing Costs Training/Travel TOTALS
Planned Expenses $1,355,090 138,740 67,800 48,000 $1,609,630
Planned Expenses
Actual Expenses $659,130 69,350 33,159 21,300 $782,939
Expense Variances $695,960 69,390 34,641 26,700 $826,691
Actual Expenses
Training/Travel 2.72% Marketing Costs 4.24% Office Costs 8.86%
Training/Travel 2.98% Marketing Costs 4.21% Office Costs 8.62%
Employee Costs 84.19%
Variance Percentage 51% 50% 51% 56% 51%
Employee Costs 84.19%
Monthly Expenses $150,000 $140,000 $130,000 $120,000 $110,000 $100,000
Expenses
$90,000 $80,000 $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
Related Documents
Detailed Expense Estimate
April 2020 8
Estimate
November 2019 38
Estimate
November 2019 29
Estimate
July 2020 20
Estimate
June 2020 17
Travel Expense
April 2020 24More Documents from "Dana A Daspit Conte"
Budget Planning
April 2020 7
Feasibility Assessment Template
April 2020 14
Npv And Irr Rules
May 2020 10
Petty Cash Report
April 2020 12
Detailed Expense Estimate
April 2020 8