| > COUNTY HOME |
|
MONTHLY SUMMARY: MEDINA COUNTY HOME OPERATING REVENUES AND EXPENSES (Cumulative Levy Period Report) |
||||||||||||||||||||||||
|
July 02 |
August 02 |
September 02 |
October 02 |
November 02 |
December 02 |
January 03 |
February 03 |
March 03 |
April 03 |
May 03 |
June 03 |
July 03 |
August 03 |
September 03 |
October 03 |
November 03 |
December 03 |
January 04 |
February 04 |
March 04 |
April 04 |
May 04 |
Cumulative Total |
|
|
Revenues: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Resident Fees |
$34,752.15 |
$36,121.17 |
$25,757.07 |
$34,685.07 |
$43,090.90 |
$37,819.90 |
$34,538.88 |
$40,615.05 |
$35,944.54 |
$38,647.54 |
$32,268.17 |
$34,310.83 |
$25,029.58 |
$27,150.91 |
$31,992.99 |
$28,475.96 |
$22,327.37 |
$31,605.39 |
$24,036.58 |
$29,051.48 |
$53,137.88 |
$50,783.37 |
$25,098.59 |
$777,241.37 |
|
Farm Lease/Misc. Receipts |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
32.85 |
4,721.50 |
0.00 |
0.00 |
0.00 |
0.00 |
19.25 |
0.00 |
2.77 |
0.00 |
47.53 |
1,600.00 |
0.00 |
170.51 |
0.00 |
0.00 |
6,594.41 |
|
Tax Levy Proceeds |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
354,022.99 |
0.00 |
7,744.12 |
0.00 |
0.00 |
833.05 |
287,289.54 |
44,543.08 |
0.00 |
44,592.30 |
0.00 |
0.00 |
24.18 |
327,098.85 |
7,995.86 |
1,074,143.97 |
|
Revenue Total |
$34,752.15 |
$36,121.17 |
$25,757.07 |
$34,685.07 |
$43,090.90 |
$37,819.90 |
$34,538.88 |
$40,647.90 |
$394,689.03 |
$38,647.54 |
$40,012.29 |
$34,310.83 |
$25,029.58 |
$28,003.21 |
$319,282.53 |
$73,021.81 |
$22,327.37 |
$76,245.22 |
$25,636.58 |
$29,051.48 |
$53,332.57 |
$377,882.22 |
$33,094.45 |
$1,857,979.75 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Expenses: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Salaries-Administrator |
$3,814.40 |
$3,814.40 |
$3,814.40 |
$3,814.40 |
$5,721.60 |
$3,814.40 |
$3,814.40 |
$3,814.40 |
$3,814.40 |
$3,814.40 |
$6,355.20 |
$3,929.60 |
$3,929.60 |
$3,929.60 |
$3,929.60 |
$5,894.40 |
$3,929.60 |
$3,929.60 |
$3,929.60 |
$3,929.60 |
$3,929.60 |
$6,427.20 |
$4,048.00 |
$98,142.40 |
|
Salaries-1st Shift |
26,815.34 |
26,221.63 |
26,395.23 |
27,756.81 |
41,257.21 |
27,361.01 |
27,615.18 |
27,187.33 |
26,757.81 |
27,097.03 |
52,150.54 |
26,485.42 |
26,419.57 |
26,752.24 |
26,930.67 |
43,518.92 |
29,138.56 |
29,360.21 |
30,782.27 |
30,053.19 |
28,568.04 |
48,485.98 |
29,699.39 |
712,809.58 |
|
Salaries-2nd Shift |
6,067.94 |
7,002.68 |
5,713.16 |
5,049.54 |
7,968.34 |
5,405.18 |
5,195.46 |
5,353.72 |
5,730.73 |
6,394.47 |
9,692.88 |
7,382.64 |
7,184.02 |
8,855.61 |
7,327.89 |
10,878.55 |
7,589.79 |
7,960.76 |
7,961.28 |
7,159.50 |
7,755.81 |
10,399.01 |
6,986.50 |
167,015.46 |
|
Salaries-3rd Shift |
4,088.09 |
4,057.48 |
4,514.41 |
3,850.05 |
5,755.26 |
3,882.56 |
4,344.16 |
4,264.48 |
4,183.22 |
3,843.71 |
6,692.97 |
4,277.25 |
4,379.48 |
4,364.86 |
5,115.09 |
7,554.25 |
5,962.74 |
5,106.61 |
4,818.14 |
5,345.04 |
5,346.11 |
7,192.32 |
4,508.98 |
113,447.26 |
|
Fringe Benefits |
15,389.61 |
15,340.52 |
14,731.33 |
14,737.74 |
17,754.63 |
22,737.35 |
15,618.28 |
14,152.38 |
14,126.36 |
14,242.61 |
18,342.75 |
14,419.13 |
14,396.24 |
15,132.01 |
15,098.18 |
18,530.85 |
16,087.04 |
23,362.97 |
17,181.22 |
17,040.23 |
16,933.71 |
20,973.70 |
16,873.93 |
383,202.77 |
|
Supplies/Food |
16,616.85 |
10,518.37 |
8,453.18 |
11,644.89 |
8,610.67 |
11,563.56 |
14,619.65 |
10,613.11 |
9,689.18 |
12,398.64 |
12,687.20 |
12,091.08 |
8,766.88 |
14,302.07 |
9,247.21 |
16,019.93 |
8,104.17 |
11,205.39 |
7,909.29 |
7,558.79 |
9,450.70 |
7,459.41 |
13,370.95 |
252,901.17 |
|
Repairs |
135.00 |
664.50 |
0.00 |
0.00 |
105.95 |
131.35 |
927.97 |
108.87 |
165.67 |
0.00 |
564.40 |
0.00 |
0.00 |
568.00 |
497.50 |
2,075.78 |
2,581.23 |
517.80 |
887.90 |
344.50 |
580.85 |
327.73 |
259.66 |
11,444.66 |
|
Travel |
0.00 |
282.80 |
0.00 |
0.00 |
220.00 |
0.00 |
0.00 |
514.86 |
0.00 |
0.00 |
506.22 |
100.00 |
0.00 |
0.00 |
0.00 |
158.00 |
0.00 |
563.84 |
0.00 |
0.00 |
256.28 |
0.00 |
317.72 |
2,919.72 |
|
Contract Services/Utilities |
5,575.15 |
6,803.32 |
1,966.38 |
6,140.12 |
3,923.57 |
1,893.87 |
5,556.74 |
4,124.17 |
3,528.19 |
4,576.68 |
4,647.64 |
3,462.56 |
4,665.59 |
4,847.16 |
4,435.70 |
4,256.77 |
1,496.54 |
5,969.75 |
3,854.26 |
3,942.21 |
4,620.57 |
3,908.89 |
5,849.62 |
100,045.45 |
|
Other Expenses/Gasoline |
452.01 |
398.01 |
439.23 |
398.33 |
413.03 |
669.73 |
1,101.06 |
469.94 |
1,552.44 |
850.93 |
441.10 |
614.40 |
149.94 |
1,321.47 |
631.44 |
511.04 |
193.69 |
1,109.81 |
1,306.20 |
933.72 |
476.66 |
592.50 |
193.83 |
15,220.51 |
|
Equipment-Rental |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
43.00 |
95.60 |
52.40 |
39.40 |
44.20 |
56.00 |
0.00 |
168.80 |
0.00 |
31.80 |
531.20 |
|
Equipment-Purchase |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
2,000.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
350.00 |
0.00 |
2,350.00 |
|
Medical |
2,197.08 |
1,469.57 |
2,138.07 |
1,239.59 |
2,049.39 |
400.00 |
3,572.13 |
1,368.30 |
1,454.70 |
983.56 |
1,061.50 |
1,044.80 |
209.09 |
736.09 |
1,077.21 |
229.60 |
1,085.43 |
878.60 |
451.99 |
685.53 |
222.95 |
302.88 |
6,937.96 |
31,796.02 |
|
Resident Activities |
213.68 |
60.00 |
174.84 |
0.00 |
317.48 |
103.69 |
712.21 |
153.11 |
61.98 |
55.09 |
186.16 |
302.16 |
80.00 |
0.00 |
378.10 |
0.00 |
65.54 |
422.52 |
50.00 |
0.00 |
62.47 |
74.90 |
50.00 |
3,523.93 |
|
Indirect Costs |
2,403.58 |
2,403.58 |
2,403.58 |
2,403.58 |
2,403.58 |
2,403.58 |
2,925.00 |
2,925.00 |
2,925.00 |
2,925.00 |
2,925.00 |
2,925.00 |
2,925.00 |
2,925.00 |
2,925.00 |
2,925.00 |
2,925.00 |
2,925.00 |
3,618.67 |
3,618.67 |
3,618.67 |
3,618.67 |
3,618.67 |
67,614.81 |
|
Capital Improvements |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
45,250.00 |
0.00 |
64,524.00 |
0.00 |
10,033.70 |
0.00 |
781.36 |
3,991.50 |
7,760.00 |
2,826.00 |
8,807.50 |
0.00 |
0.00 |
35,436.25 |
5,830.00 |
0.00 |
185,240.31 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
||||
|
Expense Total |
$83,768.73 |
$79,036.86 |
$70,743.81 |
$77,035.05 |
$96,500.71 |
$80,366.28 |
$86,002.24 |
$120,299.67 |
$73,989.68 |
$141,706.12 |
$116,253.56 |
$87,067.74 |
$73,105.41 |
$84,558.47 |
$83,680.69 |
$120,365.49 |
$82,024.73 |
$102,164.56 |
$82,806.82 |
$80,610.98 |
$117,427.47 |
$115,943.19 |
$92,747.01 |
$2,148,205.25 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Cash Flow Surplus/(Deficit) |
($49,016.58) |
($42,915.69) |
($44,986.74) |
($42,349.98) |
($53,409.81) |
($42,546.38) |
($51,463.36) |
($79,651.77) |
$320,699.35 |
($103,058.58) |
($76,241.27) |
($52,756.91) |
($48,075.83) |
($56,555.26) |
$235,601.84 |
($47,343.68) |
($59,697.36) |
($25,919.34) |
($57,170.24) |
($51,559.50) |
($64,094.90) |
$261,939.03 |
($59,652.56) |
($230,572.95) |
Note: levy collection period is January, 2003 through December, 2007; expenditure period is July, 2002 through June, 2007.
Prepared by: Medina Co. Finance Dept.