HomeMy WebLinkAbout4.g. Project 194 TransfersEXECUTIVE SUMMARY FOR ACTION
CITY COUNCIL MEETING DATE: December 3, 1991
AGENDA ITEM:
AGENDA SECTION:
Project #194 Transfers
Consent
PREPARED BY:
AGENDA+T E IVI G-
4
Jeff May, Finance Director
ATTACM(ENTS:Copies of Transfers, Copy of
AP BY
Resolution, Copy of Project Costs
L�'
U
Attached are five transfers for the Shannon Parkway North of
Dalmation Improvements Project, Project #194. The transfers are
for temporary funding costs, administrative costs, watermain core
costs, storm sewer core costs, and street core costs.
The temporary funding transfer is to offset interest revenues
that the General Fund may have lost from the time the project
costs were first paid until the time that the bond proceeds for
the project were received and the project could fund itself.
This transfer comes from the Construction Fund, as a project
cost, and goes to the General Fund.
The administrative costs transfer takes 4% of the total
construction cost to offset some of the in-house costs that are
incurred by the City during the course of a project. This
transfer comes from the Construction Fund, as a project cost, and
goes to the General Fund.
The core transfers are for costs that are designated to be their
share of the costs for the project. These transfers come from
various Core Funds and go to the Debt Service Fund associated
with this project. This is because these were costs of the
project not assessed that have to be recouped by the Debt Service
Fund in order to repay the debt. The Utility Commission approved
the Water Core transfer and the Storm Sewer Core transfer
November 25, 1991.
The justification for all of these transfers is included in the
copy of the resolution and the breakdown of the project costs.
RECOMMENDED ACTION:
Approve the transfers from Fund 409 to Fund 101 for the temporary
funding costs and the administrative costs, and the transfers from
Funds 203, 605 & 607 to Fund 327 for the core shares of the project,
for Project #194, Shannon Parkway North of Dalmation Improvements.
COUNCIL ACTION:
TRANSFER FORM
Transfer fro$•
Paid-up Debt Sery Fund
102 - 49300 - 01 - 710
EDA Funds
201 - 46300 - 01 - 710
MSA Funds
203 - 49003 - 01 - 710
Water Core Facility Funds
605 - 49501 - 01 - 710
Sewer Core Facility Funds
606 - 49502 - 01 - 710
Storm Sewer Surcharge Funds
607 - 49503 - 01 - 710
Water Funds
601 - 49400 - 01 - 710
Sewer Funds
602 - 49450 - 01 - 710
Other FundsPkwy
q6i - gVooJ - 01 - 710
N c+L pAw�ri —
- - 01 - 720
�Qtl?'M � 1
- 39208 - 00 - 000
Transfer to:
Amount to be
transfered:
S
S
S
s
S
S `
$
S
$
Amount to be
transfered in:
_ - 39201 - 00 - 000
$
(Transfer from Gen'l Fund)
- 39202 - 00 - 000
$
(Contribution from Enterprise Funds)
_
)oL - 39203 - 00 - 000
$
(Transfer from_)
- 39204 - 00 - 000
$
(Transfer from Water Hook -Up Core Fund)
_
- 39205 - 00 - 000
$
(Transfer from Sewer Hook -Up Core Fund)
_
- 39206 - 00 - 000
4
(Transfer from Store Sewer Connect Fees)
_
- 39207 - 00 - 000
$
(Transfer from EDA Fund)
- 39208 - 00 - 000
$
(Transfer from NSA Fund)
_
- 39209 - 00 - 000
E
(Transfer from Paid-up Debt Sery Fund)
Authorized by: Department:
^tLa� cc.frLtc��C
Date authorized:
Reason for transfer: _I A'*Fs 0e ti r-W�. "i��Pw A0E'4 Fw c ►.ril+k'61 COS' fvre f'Rw'�►' � 1Q
C 5 �.Nw.+ Pw-+Y Nue14 � Dalh�t,>u,.� J�-••� ;� Crc'�reAl �.V..j
General Journal Entry:
QUI - 10100
- 104_
- 104
3920 3 - 00 - 000
�u1 - 29300
Q - 29400
40� - N� - L) - 710
q
,4 QA - 10100
�,Sss.vy
- 104 _
- 104
General journal entry entered by:
Date entered: - -
Journal Entry Type:�±_(Normally will be Type 4)
Journal Entry t:
Authorized by:
Date authorized: , Z - d - y'f
Department:
Reason for transfer: 7*A-IJS?eA 7,,) cwrie y % A/Jn-471`-,C6_ RA ?It%4J r' * 19 T/
PA1?r.«t4 M,..eN4 vA A,4.,�►�,�w� Z�7 jf Frt•.rR,4� F,,,��
General Journal Entry:
��i - 10100
TRANSFER
FORM
- 104
- 3920 3 - 00 - 000
gni - 29300
1409 - 29400
3.,g>�.s�
X05 - %49o,%) - of - 71 0
Amount to be
- 104_
Transfer from:
General journal entry entered by:
transfered:
Paid-up Debt Sery Fund
102 -
49300 -
01 -
710
$
EDA Funds
201 -
46300 -
01 -
710
$
NSA Funds
203 -
49003 -
01 -
710
S
Water Core Facility Funds
605 -
49501 -
01 -.710
$
Sewer Core Facility Funds
606 -
49502 -
01 -
710
S
Storm Sewer Surcharge Funds
607 -
49503 -
01 -
710
s
Nater Funds
601 -
49400 -
01 -
710
$
Sewer Funds
602 -
49450 -
01 -
710
$
Other Fund
Y -q -
01 -
710
S 31.244.9 A.
N ct� AMaw�rPh
-
01 -
720
$
Qew"� ,4y
Amount to be
Transfer to:
transfered in:
- 39201
- 00
- 000
s
(Transfer
from
Gea'l Fund)
_
- 39202
- 00
- 000
$
(Contribution from Enterprise Funds)
&f -0o_&
rot
- 39203
- 00
- 000
$ 31. al .9
(Transfer
from_)
_
- 39204
- 00
- 000
$
(Transfer
from
Water Hook -Up Core Fund)
- 39205
- 00
- 000
$
(Transfer
from
Sewer Hook -Up Core Fund)
- 39206
- 00
• 000
$
(Transfer
from
Storm Sewer Connect Fees)
_
- 39207
- 00
- 000
s
(Transfer
from
EDA Fund)
- 39208
- 00
- 000
S
(Transfer
from
MSA Fund)
_
- 39209
- 00
- 000
$
(Transfer
from
Paid-up Debt Sery Fund)
Authorized by:
Date authorized: , Z - d - y'f
Department:
Reason for transfer: 7*A-IJS?eA 7,,) cwrie y % A/Jn-471`-,C6_ RA ?It%4J r' * 19 T/
PA1?r.«t4 M,..eN4 vA A,4.,�►�,�w� Z�7 jf Frt•.rR,4� F,,,��
General Journal Entry:
��i - 10100
3�, kar.S1
- 104
- 3920 3 - 00 - 000
gni - 29300
1409 - 29400
3.,g>�.s�
X05 - %49o,%) - of - 71 0
10100
- 104_
- 104
General journal entry entered by:
Date entered: - -
Journal Entry Type: �i(NoTnally will be Type 4)
Journal Entry 1:
3�,$dl.4Z
Transfer from:
Paid-up Debt Sery Fund
EDA Funds
MSA Funds
Water Core Facility Funds
Sewer Core Facility Funds
Stork Sewer Surcharge Funds
Water Funds
Sewer Funds
Other Funds
Transfer to:
,DCgx,5# .j W
Authorized by:
TRANSFER FORM
102 —49300 - 01 - 710
101 - 46300 - 01 - 710
203 - 49003 - 01 - 710
605 - 49501 - 01 - 710
606 - 49502 - 01 - 710
607 — 49503 - 01 - 710
601 - 49400 01 - 710
602 - 49450 - 01 - 710
- 01 - 710
-01-720
• 39201— 00 - 000
_ - 39202 - 00 000
_ - 39203 - 00 - 000
_ - 39204 - 00 - 000
_ • 39205 00 - 000
_ - 39206 - 00 - 000
_ - 39207 - DO - 000
39208 - 00 - 000
• 39209 - 00 - 000
Date authorized: _L? - .3 - _
Amount to be
transfered:
S
s
s
s
S
s
s
s
Amount to be
transfered in:
(Transfer from Gen'l Fund)
(Contribution from Enterprise funds)
(Transfer frok )
(Transfer from Water Hook -Up Core Fund)
(Transfer frok Sewer Hook -Up Core Fund)
(Transfer from Storm Sewer Connect Fees)
(Transfer fro& EDA Fund)
(Transfer from NSA Fund)
(Transfer from Paid-up Debt Sery Fund)
Department; ege— �..e
Reason for transfer:"t A.Qst e : Cu.�rt MSA 5AA QV.r PA%3%'eT*ITy
X)L.%6 ! cls SOAV
General Journal Entry:
3 �.� _ 10100
104
104
3a2 - 39201, - 00 - 000
3.�_ 29300
�_ - 29400
>_3_1 -'-A203 -01 - 71 Z)
10100
104
104
General journal entry entered by:_
Date entered: - -
aJ� YJJ,3�
Journal Entry Type: ` (Hornally will be Type 4)
Journal Entry t:
TRANSFER FORM
Amount to be
Transfer from: transfered:
Paid-up Debt Sery Fund 102 - 49300 - 01 - 710 $
EDA Funds 201 - 46300 - 01 - 710 $
NSA Funds 203 49003 - 01 - 710 $
—Water Core Facility Funds 605 - 49501 - 01 • 710 $ to<' ,yZ.1 0
Sever Core Facility Funds 606 - 49502 - 01 - 710 $
Stora Sever Surcharge Funds `607 - 44503 - 01 • 710 $
Water Funds 601 - 49400 - 01 - 710 $
Sewer Funds 602 - 49450 - 01 - 710 $
Other funds - 01 - 710 s
-01-720 $
Amount to be
Transfer to: transfered in:
_ - 39201- 00 - 000 $
_ • 39202 - 00 - 000 $
_ - 39203 - 00 - 000 4
Defirs ay W trtyq& aL-1 - 39204 - 00 - 000 t (" 'r I (-IQ Ce
- 39205 - 00 - 000 $
_ - 39206 - 00 - 000 $
_ - 39207 - 00 - 000 $
_ - 39208 - 00 - 000 $
_ - 39209 - 00 - 000 $
Authorized by: Department: "
(transfer from Gen'1 Fund)
(Contribution from Enterprise Funds)
(Transfer from j
(Transfer fro& Water Hook -Up Core Fund)
(Transfer from Sewer Hook -Up Core Fund)
(Transfer from Stora Sewer Connect Fees)
(Transfer from EDA Fund)
(Transfer from NSA Fund)
(Transfer from Paid-up Debt Sery Fund)
Date authorized: 4L - .5-
Reason for transfer: -RA.Nsr-zk "y Qwc,P- wA6t'-0- Qwzc sAAL W- p,e4�1 -r 4'19
yi, wW 4 /_J V&TVI-LW- .D*-- A;�N .. \ 'n1 kms,— Schee ;.-.0 N keoiPA.—
'General
A.-
;General Journal Entry:
- 10100
- 104 _
- 104
a
3920q - 00 - 000
ail - 29300
Lus - 29400
YSStl -ut -71v
10100
104_
104
General journal entry entered by:
Date entered: -
Journal Entry Type: `i(Normally will be Type 4)
Journal Entry t:
41,67y.SJ
TRANSER FORM
Amount to be
Transfer froa: ransfered:
Paid-up Debt Sery Fund 102 - 49300 - 01 - 710 $ -
• EDA Funds 201 — 46300 - 01 - 710 $�—
KSA Funds 203 - 49003 - 01 - 710 $
Water Core Facility Funds 60$ - 49$01 - 01 - 710 $
Sewer Core Facility Funds 606 - 49502 - 01 - 710 $
Store Sewer Surcharge Funds 607 - 49503 - 01 - 710 $�
Water Funds 601 - 49400 - 01 - 710 $
Sewer Funds 602 - 49450 - 01 - 710 $_
Other Funds _ - 01 - 710 $
-01-720 $
Amount to be
Transfer to: transfered in:
39201 - 00 - 000 S
_ 39202 - 00 - 000 S
_,- 39203 - 00 000 $
_ • 39204 - 00 - 000 $
39205 - 00 - 000 $
Daar Sew w �G 1tS8 3.17 - 39206 - 00 - 000 S-11 #144,;S"
39207 - 00 - 000 $
_ - 39208 - 00 - 000 $
_ 39209 • 00 000 $
Authorized by: �e
Date authorized: L -
Department:
(Transfer from Gen'l Fund)
(Contribution from Enterprise Funds)
(Transfer from }
(Transfer from Water Hook -Up Core Fund)
(Transfer from Sewer Hook -Up Core Fund)
(Transfer from Store Sewer Connect Fees)
(Transfer from EDA Fund)
(Transfer from MSA Fund)
(Transfer from Paid-up Debt Sery Fund)
Reason for transfer _IARA ,,s Vx%P_ 10
SSV ¢.0—
Qjtj
S,IW r C1,4 -'e0,;, - +Ili
6.4,A, '>'e, -.,Y
NvATi,F
UA LAk-0,1 4 •11,) 6�T
StktJ F+..A fwC �C�A1(.►at�+l
General Journal Entry:
3�7 - 10100
i'1,')yl.3S-
- 104
104
3 �� • 3920 - 00 - 000
341 - 29300
60 - 29400
but -'42M -Of -710
3r
foul - 10100
1-7,.744, 3i
- 104 _
- 104
General journal entry entered by:
Date entered: - -
Journal Entry Type: L(Normally will
be Type 4)
Journal Entry t:
F2
CITY OF ROSEMOUNT
DAKOTA COUNTY, MINNESOTA
RESOLUTION 1991 -
A RESOLUTION DECLARING COST TO BE ASSESSED AND ORDERING
PREPARATION OF PROPOSED ASSESSMENT, AND CALLING
FOR HEARING ON THE PROPOSED ASSESSMENT
SHANNON PARKWAY STREET AND UTILITY IMPROVEMENTS
CITY PROJECT #194
WHEREAS, a contract has been let for Shannon Parkway Street and
Utility Improvements and the contract price for such improvement
is $785,747.99, and the expenses incurred or to be incurred in the
making of such improvement amount to $173,598.05 so that the total
cost of the improvement will be $959.346.04.
NOW, THEREFORE, BE IT RESOLVED by the City Council of Rosemount
Minnesota:
1. The portion of the cost of such improvement to be paid by the
City is hereby declared to be $272,215.57 and the portion of
the cost to be assessed against benefited property owners is
declared to be $687,130.47.
2. Assessments shall be payable in equal annual installments
extending over a period of 10 years, the first of the
installments to be payable with general taxes for the year -
1992, and shall bear interest at the rate of 2% points per
annum above the interest rate paid by the City for its bonds
from date of the adoption of the assessment resolution.
3. The City Clerk, with the assistance of the Public Works
Director shall forthwith calculate the proper amount to be
specially assessed for such improvement against every
assessable lot, piece or parcel of land within the district
affected, without regard to cash valuation, as provided by
law, and he shall file a copy of such proposed assessment in
his office for public inspection; and
BE IT FURTHER RESOLVED by the City Council of Rosemount, Minnesota:
1. A hearing shall be held on the 22nd day of October, 1991, in
the City Hall at 7:00 p.m., or as soon thereafter as possible,
to pass upon such proposed assessment and at such time and
place all personsowningproperty affected by such improvement
will be given an opportunity to be heard with reference to
such assessment.
2. The City Clerk is hereby directed to cause a notice of the
hearing on the proposed assessment to be published once in the
y official newspaper at least two weeks prior to the hearing,
and she shall state in the notice the total cost of the
improvement. She shall also cause mailed notice to be given
to the owner of each parcel described in the assessment roll
not less than two weeks prior to the hearings.
BE IT FURTHER RESOLVED by the City Council of Rosemount, Minnesota:
The owner of any property so assessed may, at any time prior
to certification of the assessment to the County Auditor, pay
the whole of the assessment on such property, with interest
accrued to the date of payment, to the City, except that no
interest shall be charged if the entire assessment is paid
within 30 days from the adoption of the assessment. The owner
may at any time thereafter, pay to the County Auditor the
entire amount of the assessment remaining unpaid, with
interest accrued to December 31 of the year in which such
payment is made. Such payment must be made before November
15 or interest will be charged through December 31 of the
succeeding year.
ADOPTED this 1st day of October, 1991.
Vernon J. Napper, Mayor
ATTEST:
Susan M. Walsh, City Clerk
Motion by: Seconded by:
Voted in favor•
Voted against•
CURRENT DATE:
11/5/91
PROJECT: SHANNON PARKWAY NORTH
PROJECT #: 194
CONTRACT ft: 89-5
COST
COMPONENT
PROFESSIONAL
LEGAL
BOND
PROJECT
DESCRIPTION
COST
FACTOR
CONSTRUCTION
ENGINEERING
SERVICES
LEGAL
NOTICES
ISSUANCE
Sanitary __-'-0.000
$0.00
#0.00
#0.00
#0.04
#0.00
$0.00
Sanitary
Lateral
0.190
$151.128.75
#19.975.49
$1.367.99
$178.75
#60.73
$1,977.01
Watermain
0.068
#54,458.30
#7.198.04
#492.95
#64.41
#21.88
#712.40
Coro
Watermain
Lateral
0.108
$86.139.21
#11.385.46
$779.72
$101.88
#34.61
#1,126.84
Storm
0.018
$14.714.69
#1.944.92
$133.19
$17.40
#5.91
#192.49
Cora
Storm
Lateral
0.104
$82,920.91
$10.960.10
#750.59
$98.08
#33.32
#1.084.74
Strout
0.218
$173.149.91
$22.886.14
$1.567.32
$204.80
#69.57
#2.265.08
Coro
Strout
Lateral
0.281
$223,236.22
$29.506.32
$2.020.69
#264.04
#89.70
#2.920.90
Street
Lights
0.012
$9.800.00
#1.295.32
#88.71
$11.59
#3.94
$128.20
Proposed
Total
1.000
$795,547.99
$105,151.81
$7.201.16
#940.95
#319.66
#1O,4O7.07
Actual
Total
(to date)
$795,597.99
$105,151.81
$7,201.16
#940.95
$319.66
$10.A07.07
4.0p.
TEMP.
FUNDING
RIGHT-
COST PER
ADMIN.
INTEREST
OF -WAY
CONTINGENCIES
TOTAL --_-_---UNITS
------UNIT
----
$0.00
$0.00
$0.00
$0.00
$0.00
66,045.15
$1,511.29
$0.00
$0.00
$102,295.16
7842
$23.24
62,178.33
$544.58
$0.00
$0.00
$65,670.90
53,445.57
$861.39
$0.00
$0.00
$109,874.70
7020
$14.80
$588.59
$147.15
$0.00
$0.00
$17,744.35
63,316.84
$829.21
$0.00
$0.00
$99,993.77
8362
$11.96
1;6.926.00
$1,731.50
$0.00
$0.00
$208,800.33
68,929.45
$2,232.36
$0.00
$0.00
$269,199.08
7872
$34_20
$992.00
$98.00
$0.00
$0.00
$11,817.75
7872
$1.50
31,821.92
$7,955.48
$959,346.04
31,821.92 $7,955.
ID
$959.346_04
Loss Sanitary Coro $0.00
Loss Watormain Cora $65,670.,90
Loss Storm Sower Coro $17,744.35
Loss Street Core $208,800.33
Total Assessment Amount $667,130.46