HomeMy WebLinkAboutCOM 0804.018 2002-2004
V
O -
F m
HAWAII COUNTY ECONOMIC OPPORTUNITY COUNCIL
47 Rainbow Drive
Hilo, Hawaii 96720.2098 m.
Telephone (808) 961.2681
Fax (808) 935-9213
o ~
We are sending 4 pages (including this cover sheet).
This information is for:
To: Hawaii County Legislative Auditors Office
Attn- M Uri,,
From: George Yokoyama Executive Director
Date. November 16. 2004
Time:
Note; As requested we are submitting for the Council's review, the following
documents;
Report of HCEOC Transportation program Budget vs. Actuals 03-04 FY.
Report of HCEOC Transportation program Budget vs. Actuals to 9/30/04.
Report of Estimated Transportation program costs for 04-05 FY based on
extrapolation of 9/30/04 costs.
If you have any questions please call me.
Gomm. Na W. 18
Ref. To: dal
Ref. Late
HCEOC TRANSPORTATION SERVICES PROGRAMS
Budget vs. Actuals July 2004 to June 2005
Nutrition Transportation
Transportation " County Office on Aging Total
Budget Actual 9/30 Budget Actual 9/30 Budget Actual 9/30
Revenue:
Federal $ 123,348.00 $ 9,788.57 - - 123,348.00 9,788.57
County 298,000.00 16,840.00 176,171.00 14,665.00 474,171.00 31,505.00
State - OCS 92,197.00 23,049.25 - - 92,197.00 23,049.25
Medicaid 70,000.00 17,898.15 - - 70,000.00 17,898.15
583,545.00 67,575.97 176,171.00 14,665.00 759,716.00 82,240.97
Salaries S 342,572.28 S 90,498.65 S 92,700.00 S 25,507.75 435,272.28 116,006.40
P/R taxes 17.41% 113,682.64 15,755.81 27,000.00 4,440.90 140,682.64 20,196.71
Fringe 15.18% 9,654.63 15,264.24 4,850.00 4,292.89 14,504.63 19,557.13
Supplies 3,090.00 1,746.90 600.00 465.78 3,690.00 2,212.68
Postage 215.00 101.36 60.00 25.68 275.00 127.04
Telephone 4,978.00 1,256.88 2,000.00 567.38 6,978.00 1,824.26
Publ. & Printing 1,070.00 414.02 371.00 124.20 1,441.00 538.22
Rental of Space 940.00 406.00 300.00 94.00 1,240.00 500.00
Utilities 2,785.00 787.28 1,000.00 256.02 3,785.00 1,043.30
Office Repr & Maint 740.00 134.59 250.00 17.20 990.00 151.79
Insurance 20,600.00 25,092.62 9,500.00 9,500.12 30,100.00 34,592.74
Audit 2,121.00 - 1,000.00 - 3,121.00 -
Staff Training 590.00 - - - 590.00 -
Data Processing 2,815.00 241.36 1,400.00 132.01 4,215.00 373.37
Vehicle Maint 54,507.27 10,263.04 19,000.00 3,110.77 73,507.27 13,373.81
Vehicle Gas & Oil 33,966.35 14,837.68 15,700.00 5,785.36 49,666.35 20,623.04
Employee Physical 720.00 125.51 350.00 41.84 1,070.00 167.35
Equipment Repair 165.00 15.24 90.00 20.84 255.00 36.08
Total 595,212.17 176,941.18 176,171.00 54,382.74 771,383.17 231,323.92
Actual Revenues Lem Actual Expenditures (109,365.21) (39,717.74) (149,082.95)
Outstanding Receivable 9/30 29,568.50 15,297.00 44,865.50
Adjusted Revenues Less Expenditures (79,796.71) (24,420.74) (104,217.45)
* County Trans & County Disabled Trans combined to one contract for 04-05 FY $145,000 + 153,000, Total 5298,000.
HCEOC TRANSPORTATION SERVICES PROGRAMS
**Budget vs. Estimated Expenditures July 2004 to June 2005
Nutrition Transportation
Transportation " County Office on Aging Total
Budget Estimated Budget Estimated Budget Estimated
Revenue:
Federal S 123,348.00 S 123,348.00 - - 123,348.00 123,348.00
County 298,000.00 298,000.00 176,171.00 176,171.00 474,171.00 474,171.00
State - OCS 92,197.00 92,197.00 - - 92,197.00 92,197.00
Medicaid 70,000.00 70,000.00 - - 70,000.00 70,000.00
583,545.00 583,545.00 176,171.00 176,171.00 759,716.00 759,716.00
Salaries S 342,572.28 S 361,994.60 S 92,700.00 S 102,031.00 435,272.28 464,025.60
P/R taxes 17.41% 113,682.64 63,023.26 27,000.00 17,763.60 140,682.64 80,786.86
Fringe 15.18% 9,654.63 61,056.96 4,850.00 17,171.56 14,504.63 78,228.52
Supplies 3,090.00 6,987.60 600.00 1,863.12 3,690.00 8,850.72
Postage 215.00 405.44 60.00 102.72 275.00 508.16
Telephone 4,978.00 5,027.52 2,000.00 2,269.52 6,978.00 7,297.04
Publ. & Printing 1,070.00 1,656.08 371.00 496.80 1,44L00 2,152.88
Rental of Space 940.00 1,624.00 300.00 376.00 1,240.00 2,000.00
Utilities 2,785.00 3,149.12 1,000.00 1,024.08 3,785.00 4,173.20
Ollice Repr & Maint 740.00 538.36 250.00 68.80 990.00 607.16
Insurance 20,600.00 25,092.62 9,500.00 9,500.12 30,100.00 34,592.74
Audit 2,121.00 3,150.00 1,000.00 1,050.00 3,121.00 4,200.00
Staff Training 590.00 590.00 - - 590.00 590.00
Data Processing 2,815.00 3,793.20 1,400.00 528.04 4,215.00 4,321.24
Vehicle Maint 54,507.27 41,052.16 19,000.00 12,443.08 73,507.27 53,495.24
Vehicle Gas & Oil 33,966.35 59,350.72 15,700.00 23,141.44 49,666.35 82,492.16
Employee Physical 720.00 502.04 350.00 167.36 1,070.00 669.40
Equipment Repair 165.00 132.16 90.00 83.36 255.00 215.52
Total 595,212.17 639,125.84 176,171.00 190,080.60 771,383.17 829,206.44
Esdawted Revenues Less FAUmated
Expenditures (55,580.84) (13,909.60) (69,490.44)
* County Trans & County Disabled Trans combined to one contract for 04-05 FY $145,000 + 153,000, Total $298,000.
Estimated expenditures based on extrapolation of 9/30/04 actuals to 12 months.
Y o ~ ~ m n m~ ~ pa ~ ~ C ~ ~ n o e 'y ~ w
p~ n n a w
n' P 'G (R~ fD iai ~y N Q N O (P R
Ftp m `'O v, P~ a 4 fD
Ia.
e e
' En
^rv ~ •
N
H H
O b b w N O N J O~ O ~ A N C
to W1 N Vi W
S S S S S S S S S S S S S S S oJO of g S S''S S S ,o t2l
e O
H H ~ ~ n
C .Ap w w N N w N w N W > n w W N H w end p Q,
y A ~1 r OW p ~1 b b JJo W 00 u A N b 00VJ 00 4Ni ~O W G TO
b A N N W A N b .N+ a P T N Oo N a N N a b G J S PO
v J O O w w N O S b O ~ w W O. r u0i d w ~ S S 'S S S y b
7 H M
_ r ~ O Cxi A ry
25. ~ J J J w w a N o. a
~rt J. g o W w g g g o g U g oJO o p
S S S S S S S S S S S S S S S S OAe N S S S ~ H C O
y z
H A N `n
oq otfj
O ~ b J w N O ON T T
w a v n _o~o oUnO d w oNO a ~ S. ,UO wDp w a C~7
v O N OHD W H ~ 8 8 N O. O ~ W N T W 6 b 8 8 ~ C
H ~ b
N
w N N w J r N N O N w w w O O
8 w pw .H-W }.i N J 88 Npp pwp w ~--Oo ppJ W V 8 8 Dp p A
O O O O J N 0 0 0 0 0 U O H O O W A .OAO O O
8 8$ 8$ 8 8 8 8$$ 8 8 8 8 8 8 $ $
y
_ n a'^
r C c0 "--J cpON O w n C. OJ N ~ w8 w `1 w
W W J OWO O O b O O w .OH. N N J Tp ~V O O J ~ O A N W ' S S a N 0 J W t~A BOO O Y O S 8
Y b N A aJ
r N b ~ Oe A uu ~ pn ~ N ~ N O pb ~Jw{ A 8U N d Ww =
W 0 0 b~ N t~ii ~ O O O O Op J~p H ~ Ap ~D ? Op V 'Jp" aAp0 .Y
l~n 8 8 8 S S 8 8 8 8 8 8 0 S O 8 ~ A 8 8 0 8 0 0 C
p. VV p A J A
O w T b V n pAAp ~pp+ A J A O 0 wo w w N A w A
N J m N pw b Ap r J tNn w T W a A uNi T Op J .J. w m
OJO OJO OH. OHO O b O O O b b b w b N W O P J W 8 0 8 8 8