Operating Expense Analysis1
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 Operating Expense Analysis1 as PDF for free.
More details
- Words: 1,299
- Pages: 4
Line item
January February
Labor and salaries $85,000 Fringe benefits 25500 Depreciation 10000 Supplies 5000 Maintenance, repair, and overhaul 8000 Utilities 4000 Marketing programs 2000 Public relations 2000 Travel and entertainment 7000 Nonbillable travel and entertainment 2000 Rent 10000 Insurance 2500 Professional services Data processing Litigation expense Dues and subscriptions 500 Bank charges 350 Telephone 450 Recruiting expenses Postage 50 Interest expense Property taxes 400 General and miscellaneous 1000 Other 150 TOTAL $165,900
March
Q1
April
May
June
$85,000 25500 10000 5000 10000 4000 4000 1500 9500 2000 10000 2500 3500
$85,000 25500 10000 5000 10000 4000 4000 1500 9500 2000 10000 2500 2500
$85,000 25500 10000 5000 10000 4000 4000 1500 9500 2000 10000 2500 2000
$255,000 76500 30000 15000 30000 12000 12000 4500 28500 6000 30000 7500 8000
150
3500 500 600 550 150 100
3500 500 625 550 250 100
3500 500 575 550 250 100
1200 3000 650 $506,125
400 1000 300 $179,600
400 1000 300 $178,725
400 1000 300 $178,175
$85,000 25500 10000 5000 8000 4000 2000 2000 8000 2000 10000 2500 3000
$85,000 25500 10000 5000 8000 4000 2000 2000 8000 2000 10000 2500 3000
$255,000 76500 30000 15000 24000 12000 6000 6000 23000 6000 30000 7500 6000
500 425 450
500 500 450
1500 1275 1350
50
50
400 1000 200 $170,025
400 1000 300 $170,200
Q2
July August September
Q3
October November December
$85,000 25500 10000 5000 12000 4000 2500 1500 15000 2000 10000 3000 3000 1000
$85,000 25500 10000 5000 12000 4000 2500 1500 15000 2000 10000 3000 3000 1000
$85,000 25500 10000 5000 12000 4000 2500 1500 15000 2000 10000 3000 3000 1000
$255,000 76500 30000 15000 36000 12000 7500 4500 45000 6000 30000 9000 9000 3000
$90,000 27000 10000 5000 10000 4000 2500 1500 12000 2000 10000 3000 2500 1000
10500 1500 1800 1650 650 300
500 650 600 250 100
500 600 600 250 100
500 600 600 200 100
1500 1850 1800 700 300
500 550 550 150 100
1200 3000 900 $536,500
400 1000 350 $183,350
400 1500 350 $183,800
400 1300 350 $183,550
1200 3800 1050 $550,700
400 1500 400 $184,650
Q4
$90,000 27000 10000 5000 10000 4000 2500 1500 13000 2000 10000 3000 2000 1000 2000 500 450 500
$90,000 27000 10000 5000 10000 4000 2500 1500 8000 1000 10000 3000 3000 1000 2500 500 350 400
200
350
$270,000 81000 30000 15000 30000 12000 7500 4500 33000 5000 30000 9000 7500 3000 4500 1500 1350 1450 150 650
400 2000 400 $187,450
400 2500 500 $183,500
1200 6000 1300 $555,600
Line item
January February
Labor and salaries $80,000 Fringe benefits 24000 Depreciation 10000 Supplies 4500 Maintenance, repair, and overhaul 8000 Utilities 4500 Marketing programs 2500 Public relations 2000 Travel and entertainment 10000 Nonbillable travel and entertainment 1500 Rent 10000 Insurance 2500 Professional services 3000 Data processing Litigation expense 1000 Dues and subscriptions 750 Bank charges 500 Telephone 500 Recruiting expenses 150 Postage 75 Interest expense Property taxes 400 General and miscellaneous 1000 Other 250 TOTAL $167,125
April
May
June
$80,000 24000 10000 4500 8000 4500 2500 2000 10000 1500 10000 2500 3000
$80,000 24000 10000 4500 8000 4500 2500 2000 10000 1500 10000 2500 3000
March
$240,000 72000 30000 13500 24000 13500 7500 6000 30000 4500 30000 7500 9000
Q1
$80,000 24000 10000 4500 8000 4500 3000 2000 10000 1500 10000 2500 4000
$80,000 24000 10000 4500 8000 4500 3000 2000 10000 1500 10000 2500 4000
$80,000 24000 10000 4500 8000 4500 3000 2000 10000 1500 10000 2500 4000
$240,000 72000 30000 13500 24000 13500 9000 6000 30000 4500 30000 7500 12000
Q2
$80,000 24000 10000 5000 8000 4500 2500 2500 10000 1500 10000 2500 4000
July
$80,000 24000 10000 5000 8000 4500 2500 2500 10000 1500 10000 2500 4000
AugustSeptember $80,000 24000 10000 5000 8000 4500 2500 2500 10000 1500 10000 2500 4000
$240,000 72000 30000 15000 24000 13500 7500 7500 30000 4500 30000 7500 12000
Q3
October November December $82,500 24750 10000 5000 8000 4500 2500 2500 10000 1500 10000 2500 3000
$82,500 24750 10000 5000 8000 4500 2500 2500 10000 1500 10000 2500 3000
$82,500 24750 10000 5000 8000 4500 2500 2500 10000 1500 10000 2500 3000
$247,500 74250 30000 15000 24000 13500 7500 7500 30000 4500 30000 7500 9000
Q4
1000 750 500 500 150 75
1000 750 500 500 150 75
3000 2250 1500 1500 450 225
1000 750 500 500 150 100
1000 750 500 500 150 100
1000 750 500 500 150 100
3000 2250 1500 1500 450 300
1000 750 500 500 150 100
1000 750 500 500 150 100
1000 750 500 500 150 100
3000 2250 1500 1500 450 300
1000 750 500 500 150 150
1000 750 500 500 150 250
1000 750 500 500 150 300
3000 2250 1500 1500 450 700
400 1000 250 $167,125
400 1000 250 $167,125
1200 3000 750 $501,375
400 1000 250 $168,650
400 1000 250 $168,650
400 1000 250 $168,650
1200 3000 750 $505,950
400 1000 250 $169,150
400 1000 250 $169,150
400 1000 250 $169,150
1200 3000 750 $507,450
400 1500 250 $171,950
400 2000 250 $172,550
400 2500 250 $173,100
1200 6000 750 $517,600
Line item
January February
Labor and salaries $5,000 Fringe benefits -1500 Depreciation Supplies -500 Maintenance, repair, and overhaul Utilities 500 Marketing programs 500 Public relations Travel and entertainment 3000 Nonbillable travel and entertainment -500 Rent Insurance Professional services 3000 Data processing Litigation expense 1000 Dues and subscriptions 250 Bank charges 150 Telephone 50 Recruiting expenses 150 Postage 25 Interest expense Property taxes General and miscellaneous Other 100 TOTAL $1,225
March
Q1
April
May
June
$5,000 -1500
$5,000 -1500
$15,000 -4500
$5,000 -1500
$5,000 -1500
$5,000 -1500
$15,000 -4500
-500
-500
-1500
500 500
500 500
1500 1500
2000 -500
2000 -500
7000 -1500
-500 -2000 500 -1000 500 500 -500
-500 -2000 500 -1000 500 500 -500
-500 -2000 500 -1000 500 500 -500
-1500 -6000 1500 -3000 1500 1500 -1500
3000
500
1500
2000
4000
-2500 250 -100 -50
-2500 250 -125 -50 -100
-2500 250 -75 -50 -100
-7500 750 -300 -150 -200
-50 $10,950
1000 250 75 50 150 25
1000 250 50 150 25
3000 750 225 150 450 75
50 $2,900
-50 $3,075
100 $4,750
-50 $10,075
-50 $9,525
Q2
-150 $30,550
July
AugustSeptember
Q3
October November December
Q4 $22,500 variance dueNotes to elimination of .25 $22,500 Marketing FTE in Q1, which was not back-filled. -6750
$5,000 -1500
$5,000 -1500
$5,000 -1500
$15,000 -4500
$7,500 -2250
$7,500 -2250
$7,500 -2250
-4000 500
-4000 500
-4000 500
-12000 1500
-2000 500
-2000 500
-2000 500
-6000 1500
1000 -5000 -500
1000 -5000 -500
1000 -5000 -500
3000 -15000 -1500
1000 -2000 -500
1000 -3000 -500
1000 2000 500
3000 -3000 -500
-500 1000 -1000 1000 250 -150 -100 -100
-500 1000 -1000 1000 250 -100 -100 -100
-500 1000 -1000 1000 250 -100 -100 -50
-1500 3000 -3000 3000 750 -350 -300 -250
-500 500 -1000 1000 250 -50 -50
-500 1000 -1000 -1000 250 50
-500
-1500 1500 -3000 -1500 750 150 50 300 50
-550 $38,000
-100 $14,200
-500 -100 $14,650
-300 -100 $14,400
-800 -300 $43,250
50
150 50
-1000 -1500 250 150 100 150 -50
-150 $12,700
-150 $14,900
-250 $10,400
Quarterly operating expense analysis
$560,000
$550,000
$540,000
$530,000
$520,000
$510,000
$500,000
$490,000
$480,000
$470,000 Q1
Q2
Actual
Budget
Q3
Q4
Related Documents
Operating Expense Analysis1
June 2020 6
Operating Expense Budget
November 2019 5
Analysis1
July 2020 7
Water Analysis1
April 2020 16
Job Analysis1
June 2020 7