HomeMy WebLinkAbout6.e. Budget AmendmentsAGENDA ITEM: Budget Amendments
AGENDA SECTION:
Consent
PREPARED BY: Jeff May, Finance Director
AGED 6
ATTACHMENTS: Council Memo, Resolution, Donation
Worksheets
APPROVED BY:
RECOMMENDED ACTION: Motion to adopt A RESOLUTION APPROVING T E
AMENDMENT OF CERTAIN 2005 BUDGET ITEMS for the General Fund as outlined in the
attached memo
ROSEMOUN 1'
CITY COUNCIL
City Council Meeting Date: October 18, 2005
EXECUTIVE SUMMARY
ISSUE
Amend the General Fund budget to reflect donations expended during the 3` quarter of 2005.
BACKGROUND
This item is on the agenda for Council to formally amend the 2005 General Fund budget by resolution for
donation items that Council had previously authorized covermg expenditures made during the third
quarter of 2005
Rather than bringing a resolution before the Council each time there is a need to spend money from
donations previously received, we have developed procedures that allow us to have you authorize the
expenditure and amend the budgets at the tune the expenditure is made and then periodically bring to you
a resolution that formally amends the budgets for a number of these donation expenditures. The attached
memo and donation worksheets support the figures given in the resolution.
SUMMARY
Recommend the above motion to approve the budget amendments for the 3 quarter of 2005.
4 ROSEMOUNT
MINNESOTA
M E M O R A N D U M
To: Mayor Droste
Council Members Baxter, DeBettignies, Shoe Corrigan Sterner
From: Jeff May, Finance Director
Date: October 5, 2005
Subject: Budget Amendments
This is a request to amend both the revenue and expenditure budgets for the General Fund for
expenditures of donations previously received. This memo is to show the line by hme detail of the
actual changes to be made to the budgets, of which the totals are summarized in the Resolution
before you.
GENERAL FUND DETAIL
Detail for Revenues:
101 36230.00 (Donations)
Total Revenues
Detail for Expenditures
101- 45100 -01- 439.00 (Other Miscellaneous Charges)
Total Expenditures
5,538.20
5,538.20
5,538.20
5,538.20
CITY OF ROSEMOUNT
DAKOTA COUNTY, MINNESOTA
RESOLUTION 2005
A RESOLUTION APPROVING THE AMENDMENT OF
CERTAIN 2005 BUDGET ITEMS
WHEREAS, the City Council recognizes the need to amend certain items from the 2005 General
Fund Operating Budget, the totals which are as follows:
(1) General operating revenues, the total which reflects an increase of $5,538.20;
(2) General operating expenditures, the total which reflects an maease of $5,538.20;
NOW, THEREFORE, BE IT RESOLVED, that the City Council of the City of Rosemount
hereby approves the amendment of the above hsted budget items for the 2005 General Fund
Operating Budget.
ADOPTED this 18th day of October, 2005.
ATTEST:
Linda J. Jentmk, City Clerk
William H Droste, Mayor
Motion by: Seconded by:
Voted in favor:
Voted Against:
Members Absent:
EXPENDITURE
AMOUNT
USE /ITEM PURCHASED
DONATION
FROM
$296.69
Ken Talbert Reimbursement from Veterans' Memonal fund
for flag poles, flags, storage bins
Various
$300.00
Rsmt Express Acct Safety Camp Presentation
Various
$1282.15
Pilgnm Promotions Safety Camp T -shirts
Various
$24.02
Cub Foods Safety Camp Supplies
Various
$1902.86
TOTAL
AGENDA ITEM: Expenditure Approval from the Donation
Account Parks Recreation Dept.
AGENDA SECTION:
Consent
PREPARED BY: Dan Schultz, Parks Recreation Director
AG ri-Emc1 6 F
ATTACHMENTS: Donation Revenue Worksheets
APPROVED BY:
RECOMMENDED ACTION: Motion to approve the expenditures listed below a d detailed
on the attached donation revenue worksheets.
SUMMARY
ROSEMOUNT
CITY COUNCIL
City Council Regular Meeting: July 5, 2005
EXECUTIVE SUMMARY
Please consider the expenditure of funds from the Donanon Account for the above items
RECEIPT OF DONATION
Donation Received on:
Amount Received:
Receipt for Donation:
Purpose of Donation:
DONATION REVENUE WORKSHEET
Various
Various
N/A
Account for Donation: 101- 22223.00
(Must be Liability assigned for each individual Department.)
Amount to be Spent:
To be Spent from Acct
Amend Donation Revenue Acct #101- 36230.00:
Amend Expenditure Acct #101- 45100 -01- 439.00
.(The two- dollar amounts should be the same.)
EXPENDITURE OF DONATION
$296.69
Debit 101- 22223.00 (Donation Liability $296 69
Credit. 101- 36230.00 $296.69
Vet's Memorial Ken Talbert
101-45100-01-439.00
(Must be Expenditure corresponding to individual Department)
Purpose of Expenditure:
Vet's Memorial Ken Talbert
AMENDMENT OF BUDGETS
$296.69
$296.69
4$\
GENERAL JOURNAL ENTRY TO ADJUST DONATION LIABILITY
Joumal entry to reduce deferred donation revenue and increase donation revenue to actual per Council
action on July 5, 2005,'.
2
RECEIPT OF DONATION
Donation Received on: Various
Amount Received Various
Receipt for Donation: N/A
Purpose of Donation:
Account for Donation' 101- 22223.00
(Must be Liability assigned for each individual Department.)
Amount to be Spent:
To be Spent from Acct
Credit: 101- 36230.00
DONATION REVENUE WORKSHEET
Safety Camp -Rsmt Express Acct
EXPENDITURE OF DONATION
$300
(Must be Expenditure corresponding to individual Department.)
Purpose of Expenditure:
Amend Donation Revenue Acct #101 36230.00: $300
Amend Expenditure Acct #101- 45100 -01- 439.00 $300
(The two- dollar amounts should be the same.)
Debit: 101 -22223 00 (Donation Liability $300
101-45100-01439.00
Safety Camp -Rsmt Express Acct
AMENDMENT OF BUDGETS
GENERAL JOURNAL ENTRY TO ADJUST DONATION LIABILITY
$300
Journal entry to reduce deferred donation revenue and increase donation revenue to actual per Council
action on July 5, 2005
3
RECEIPT OF DONATION
DONATION REVENUE WORKSHEET
Donation Received on: Various
Amount Received: Various
Receipt for Donation: NSA
Purpose of Donation:
Account for Donation:
(Must be Liability assigned for each individual Department.)
Amount to be Spent:
To be Spent from Acct
Amend Donation Revenue Acct #101 36230,00:
Amend Expenditure Acct #101 45100 -01- 439.00
(The two- dollar amounts should be the same.)
Debit 101 -22223 00 (Donation Liability $1282.15
Credit: 101- 36230.00
Safety Camp Pilgrim
101 22223.00
EXPENDITURE OF DONATION
$1282.15
101-45100-01439.00
(Must be Expenditure corresponding to individual Department.)
Purpose of Expenditure:
Safety Camp Pilgrim
AMENDMENT OF BUDGETS
$1282.15
$1282.15
$1282.15
GENERAL JOURNAL ENTRY TO ADJUST DONATION LIABILITY
Journal entry to reduce deferred donation revenue and increase donation revenue to actual per Council
action on July 5, 2005
4
RECEIPT OF DONATION
Donation Received on: Various
Amount Received: Various
Receipt for Donation: NSA
Purpose of Donation:
Account for Donation: 101- 22223.00
(Must be Liability assigned for each individual Department.)
Amount to be Spent:
To be Spent from Acct
Amend Donation Revenue Acct #101 36230.00:
Amend Expenditure Acct #101- 45100 -01- 439.00
(The two- dollar amounts should be the same.)
DONATION REVENUE WORKSHEET
EXPENDITURE OF DONATION
Safety Camp -Cub
$24.02
(Must be Expenditure corresponding to individual Department.)
Purpose of Expenditure:
AMENDMENT OF BUDGETS
GENERAL JOURNAL ENTRY TO ADJUST DONATION LIABILITY
Debit: 101 -22223 00 (Donation Liability $24.02
Credit: 101- 36230.00 $24.02
Journal entry to reduce deferred donation revenue and increase donation revenue to actual per Council
action on July 5, 2005
101- 45100- 01439.00
Safety Camp -Cub
$24.02
$24.02
5
EXPENDITURE
AMOUNT
USE /ITEM PURCHASED
DONATION
FROM
$125.00
Rosemount Express Account Leprechaun Days Blarney
Stone Hunt
Various
$300.00
Rosemount Express Account Entertainment for the Run for
the Gold event.
Vanous
$425 00
TOTAL
AGENDA ITEM: Expenditure Approval from the Donation
Account Parks Recreation Dept.
AGENDA SECTION:
Consent
PREPARED BY: Dan Schultz, Parks Recreation Director
AGE¢'. T
LW)
ATTACHMENTS: Donation Revenue Worksheets
APPROVED BY:
&i
RECOMMENDED ACTION: Motion to approve the expenditures listed below and detailed
on the attached donation revenue worksheets.
ROSEMOUNT
CITY COUNCIL
City Council Regular Meeting: July 19, 2005
SUMMARY
EXECUTIVE SUMMARY
Please consider the expenditure of funds from the Donation Account for the above items.
RECEIPT OF DONATION
Donation Received on:
Amount Received:
Receipt for Donation:
Purpose of Donation:
DONATION REVENUE WORKSHEET
Various
Various
N/A
Account for Donation: 101 22223.00
(Must be Liability assigned for each individual Department.)
Amount to be Spent:
To be Spent from Acct
EXPENDITURE OF DONATION
$125.00
101- 45100 -01- 439.00
(Must be Expenditure corresponding to individual Department.)
Purpose of Expenditure:
Amend Donation Revenue Acct #101- 36230.00:
Amend Expenditure Acct #101 45100 -01- 439.00
(The two dollar amounts should be the same.)
AMENDMENT OF BUDGETS
GENERAL JOURNAL ENTRY TO ADJUST DONATION LIABILITY
Debit 10 22223.00 (Donation Liability $125.00
Credit: 101 36230.00 $125.00
Lep Days —Rsmt Exp Acct
Lep Days —Rsmt Exp Acct
$125.00
$125.00
Journal entry to reduce deferred donation revenue and increase donation revenue to actual per Council
action on July 19, 2005.
2
RECEIPT OF DONATION
Donation Received on:
Amount Received:
Receipt for Donation:
Purpose of Donation:
Amount to be Spent:
To be Spent from Acct
Amend Donation Revenue Acct #101- 36230.00:
Amend Expenditure Acct #101-45100-01439.00
(The two- dollar amounts should be the same.)
Credit: 101 36230.00
DONATION REVENUE WORKSHEET
Various
Various
NIA
Account for Donation: 101 22223.00
(Must be Liability assigned for each individual Department.)
EXPENDITURE OF DONATION
$300.00
(Must be Expenditure corresponding to individual Department.)
Purpose of Expenditure:
AMENDMENT OF BUDGETS
GENERAL JOURNAL ENTRY TO ADJUST DONATION LIABILITY
Debit: 101- 22223.00 (Donation Liability $300.00
$300.00
Journal entry to reduce deferred donation revenue and increase donation revenue to actual per Council
action on July 19, 2005.
Run for the Gold -Rsmt Exp Acct
101-45100-01-439.00
$300.00
$300.00
Run for the Gold -Rsmt Exp Acct
3
EXPENDITURE
AMOUNT
USE /ITEM PURCHASED
DONATION
FROM
$300.00
Rosemount Express Account Lep Days Battle of the Bands
Sound and Lights (Horizon Pro- Sound)
Various
$249.75
Sam's Club Run for the Gold Supplies
Various
$99 99
Terry's Ace Hardware Lep Days Wet N' Wild Event Supplies
Various
$649 74
TOTAL
AGENDA ITEM: Expenditure Approval from the Donation
Account Parks Recreation Dept.
AGENDA SECTION:
Consent
PREPARED BY: Dan Schultz, Parks Recreation Director
AGEft/€IM.
ATTACHMENTS: Donation Revenue Worksheets
APPROVED BY: h,
RECOMMENDED ACTION: Motion to approve the expenditures listed below and detailed
on the attached donation revenue worksheets.
4 ROSEMOUNT
CITY COUNCIL
City Council Regular Meeting: August 1, 2005
EXECUTIVE SUMMARY
SUMMARY
Please consider the expenditure of funds from the Donation Account for the above items.
RECEIPT OF DONATION
DONATION REVENUE WORKSHEET
Donation Received on: Various
Amount Received: Various
Receipt for Donation: N/A
Purpose of Donation:
Lep Days —Battle
Account for Donation: 101- 22223.00
(Must be Liability assigned for each individual Department.)
Amount to be Spent:
To be Spent from Acct
EXPENDITURE OF DONATION
$300
Amend Donation Revenue Acct #101 36230.00: $300
Amend Expenditure Acct #101- 45100 -01- 439.00 $300
(The two- dollar amounts should be the same.)
Debit: 101 22223.00 (Donation Liability $300
Credit. 101- 36230.00 $300
101-45100-01-439.00
(Must be Expenditure corresponding to individual Department.)
Purpose of Expenditure:
Lep Days Battle
AMENDMENT OF BUDGETS
GENERAL JOURNAL ENTRY TO ADJUST DONATION LIABILITY
Journal entry to reduce deferred donation revenue and increase donation revenue to actual per Council
action on August 1, 2005.
2
RECEIPT OF DONATION
Donation Received on• Various
Amount Received. Various
Receipt for Donation: wA
Purpose of Donation:
Account for Donation: 101 22223.00
(Must be Liability assigned for each individual Department.)
Amount to be Spent:
To be Spent from Acct
Amend Donation Revenue Acct #101 36230.00:
Amend Expenditure Acct #101-45100-01-439.00
(The two dollar amounts should be the same.)
Credit 101- 36230.00
DONATION REVENUE WORKSHEET
Run for the Gold -Sams
EXPENDITURE OF DONATION
$249.75
(Must be Expenditure corresponding to individual Department.)
Purpose of Expenditure:
AMENDMENT OF BUDGETS
GENERAL JOURNAL ENTRY TO ADJUST DONATION LIABILITY
Debit: 101 -22223 00 (Donation Liability $249 75
101-45100-01-439.00
Run for the Gold -Sams
$249 75
$249.75
$249.75
Journal entry to reduce deferred donation revenue and increase donation revenue to actual per Council
action on August 1. 2005.
3
RECEIPT OF DONATION
DONATION REVENUE WORKSHEET
Donation Received on: Various
Amount Received. Various
Receipt for Donation: N/A
Purpose of Donation:
Lep Days WetnWild
Account for Donation: 101 -22223 00
(Must be Liability assigned for each individual Department.)
Amount to be Spent:
To be Spent from Acct
Amend Donation Revenue Acct #101 36230.00:
Amend Expenditure Acct #101-45100-01-439.00
(The two- dollar amounts should be the same.)
Debit: 101 -22223 00
Credit: 101 -36230 00
EXPENDITURE OF DONATION
$99.99
101-45100-01-439.00
(Must be Expenditure corresponding to individual Department.)
Purpose of Expenditure:
Lep Days WetnWild
AMENDMENT OF BUDGETS
GENERAL JOURNAL ENTRY TO ADJUST DONATION LIABILITY
(Donation Liability $99.99
$99 99
$99.99
$99.99
Journal entry to reduce deferred donation revenue and increase donation revenue to actual per Council
action on August 2005.
4
EXPENDITURE
AMOUNT
USE /ITEM PURCHASED
DONATION
FROM
$325.00
Matt Bruns, Mitch Siefert, Eric Hegernes Leprechaun Days
Battle of the Bands Prize Awards
Various
$1,400.00
Transfer of Funds to the Leprechaun Days Committee per
Service Agreement
AMF City Limits
Lanes /Comm
Charities of MN
$1,725.00
TOTAL
AGENDA ITEM: Expenditure Approval from the Donation
Account Parks Recreation Dept.
AGENDA SECTION:
Consent
PREPARED BY: Dan Schultz, Parks Recreation Director
AG {t� 6 C
live si
1
ATTACHMENTS: Donation Revenue Worksheets
APPROVED BY:
RECOMMENDED ACTION: Motion to approve the expenditures listed below id detailed
on the attached donation revenue worksheets.
1 ROSE tO INT EXECUTIVE SUMMARY
CITY COUNCIL
City Council Regular Meeting: August 16, 2005
SUMMARY
Please consider the expenditure of funds from the Donation Account for the above items.
RECEIPT OF DONATION
Donation Received on:
Amount Received•
Receipt for Donation:
Purpose of Donation:
Amount to be Spent.
To be Spent from Acct
DONATION REVENUE WORKSHEET
Various
Various
N/A
(Must be Liability assigned for each individual Department
Youth Prog Battle of Bands
Account for Donation: 101 -22223 00
EXPENDITURE OF DONATION
$325
Amend Donation Revenue Acct #101- 36230.00: $325
Amend Expenditure Acct #101-45100-01-439.00 $325
(The two dollar amounts should be the same.)
101 45100 -01- 439.00
(Must be Expenditure corresponding to individual Department.)
Purpose of Expenditure'
Youth Prog Battle of Bands
AMENDMENT OF BUDGETS
GENERAL JOURNAL ENTRY TO ADJUST DONATION LIABILITY
Debit' 101 -22223 00 (Donation Liability $325
Credit: 101 -36230 00 $325
Journal entry to reduce deferred donation revenue and increase donation revenue to actual per Council
action on August 16, 2005.
2
RECEIPT OF DONATION
Donation Received on
Amount Received*
Receipt for Donation:
Purpose of Donation:
DONATION REVENUE WORKSHEET
07 -20 -05
N/A
Misc —Lep Days Comm
Account for Donation: 101 -22223 00
(Must be Liability assigned for each individual Department.)
Amount to be Spent:
To be Spent from Acct
Amend Donation Revenue Acct #101-36230.00:
Amend Expenditure Acct #101-45100-01-439.00
(The two- dollar amounts should be the same.)
Debit: 101 22223.00 (Donation Liability $1,400.00
Credit 101 -36230 00
AMF City Limits Lanes /Comm Charities of MN
EXPENDITURE OF DONATION
$1,400 00
101- 45100 -01- 439.00
(Must be Expenditure corresponding to individual Department
Purpose of Expenditure:
Misc —Lep Days Comm
AMENDMENT OF BUDGETS
$1,400 00
$1,400 00
$1,400 00
GENERAL JOURNAL ENTRY TO ADJUST DONATION LIABILITY
Journal entry to reduce deferred donation revenue and increase donation revenue to actual per Council
action on August 16, 2005
3
AGENDA ITEM: Expenditure Approval from the Donation
Account Parks Recreation Dept.
AGENDA SECTION:
Consent
PREPARED BY: Dan Schultz, Parks Recreation Director
AGEN17/ 4 0
Ys'
Tierney Bros. Misc Companion Speaker, hard case, stand,
extension cables for sound system.
ATTACHMENTS: Donation Revenue Worksheet
APPROVED BY:
RECOMMENDED ACTION: Motion to approve the donation expenditure of $855.60
detailed on the donation revenue worksheet for audio /video equipment.
EXPENDITURE
AMOUNT
USE /ITEM PURCHASED
DONATION
FROM
$835.60
Tierney Bros. Misc Companion Speaker, hard case, stand,
extension cables for sound system.
Various
4 ROSE
City Council Regular Meeting: September 6, 2005
SUMMARY
MOUNT
CITY COUNCIL
EXECUTIVE SUMMARY
Please consider the expenditure of funds from the Donation Account for the above item.
RECEIPT OF DONATION
DONATION REVENUE WORKSHEET
Donation Received on: Various
Amount Received Various
Receipt for Donation: N/A
Purpose of Donation:
Account for Donation: 101 -22223 00
(Must be Liability assigned for each individual Department
EXPENDITURE OF DONATION
Amount to be Spent: $835 60
To be Spent from Acct 101- 45100 -01- 439.00
(Must be Expenditure corresponding to individual Department
Purpose of Expenditure:
Amend Donation Revenue Acct #101- 36230.00:
Amend Expenditure Acct #101-45100-01-439.00
(The two dollar amounts should be the same.)
Misc Tierney Brs
Misc Tierney Brs
AMENDMENT OF BUDGETS
$835 60
$835 60
GEN, JOURNAL ENTRY TO ADJUST DONATION LIABILITY
Debit 101 -22223 00 (Donation Liability $835.60
Credit: 101 36230.00 $835 60
Journal entry to reduce deferred donation revenue and increase donation revenue to actual per Council
action on September 6. 2005.
2
B
Project Summary
1
Original Contract Amount
$443,123 59
2
Contract Changes Addition
$29,467 66
3
Contract Changes Deduction
$0 00
4
Revised Contract Amount
$472,591 25
5
Value Completed to Date
$458,928.54
6
Material on Hand
$0 00
7
Amount Earned
$458,928 54
8
Less Retainage
$0 00
9
Subtotal
$458,928 54
10
Less Amount Paid Previously
$445,160 68
11
Liquidated Damages
SO 00
12
AMOUNT DUE THIS PAY VOUCHERS NO. 8 FINAL
$13,767 86
01562 -00 Pay Vouchers 8
s
WSB
Associates Inc.
HEREBY CERTIFY THAT A FINAL EXAMINATION HAS BEEN MADE OF THE ABOVE NOTED CONTRACT, THAT
THE CONTRACT HAS BEEN COMPLETED, THAT THE ENTIRE AMOUNT OF WORK SHOWN IN THE FINAL
VOUCHER HAS BEEN PERFORMED AND THE TOTAL VALUE OF THE WORK PERFORMED IN ACCORDANCE
WITH, AND PURSUANT TO, THE TERMS OF THE CONTRACT IS AS SHOWN IN THIS FINAL VOUCHER.
Recommended for Approval by:
WSB Associates, Inc.
Approved by Contractor:
Erickson Construction
yd rfl
Specified Contract Completion Date
12/1/2004
Owner: City of Rosemount
2875 145th Street West
Rosemount, MN 55068 -4941
For Period: 9/1/2005 to 9/30/2005
Contractor: Erickson Construction
13616 Pleasant Lane
Burnsville, MN 55337
Pay Vouchers
RSMT Rosewood Townhomes
Client Contract No.
Project No 01562 -00
Client Project No.
Construc •rver
Approved
City of R
Date
Comment:
Tuesday, October 11, 2005
Date: 10/11/2005
Request No.: 8 FINAL
1 of 4