HomeMy WebLinkAbout6.n. Budget Amendments4ROSEMOUNTEXECUTIVE SUMMARY
CITY COUNCIL
City Council Meeting Date: December 21, 2010
AGENDA ITEM: Budget Amendments
AGENDA SECTION:
Consent
PREPARED BY: Jeff May, Finance Director
AGENDA NO.
ATTACHMENTS: Council Memo, Resolution, Donation
APPROVED BY:
Worksheets & Supporting Documents
RECOMMENDED ACTION: Motion to adopt A Resolution Approving the Amendment of
Certain 2010 Budget Items.
ISSUE
Amend the General Fund budget to reflect donations expended during the 4t' quarter of 2010 and for
adjustments to the Building CIP Fund to reflect two grant projects — for the boilers at the Steeple Center
and for the lighting project at the Community Center.
BACKGROUND
This item is on the agenda for Council to formally amend the 2010 General Fund budget by resolution for
donation items that Council had previously authorized covering expenditures made during the fourth
quarter of 2010 and for the grant projects described above.
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 time 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 a quarter of 2010.
4ROSEMOUNT
MINNESOTA
M E M O R A N D U M
To: Mayor Droste
Council Members Bills, DeBettignies, Shoe - Corrigan & Weisensel
From: Jeff May, Finance Director
Date: December 16, 2010
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. Also, the Building CIP Fund budget will be
amended for the grant projects for the boilers at the Steeple Center and the lighting project at the
Community Center. This memo is to show the line by line 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) $ 4,947.15
--------------- --
Total Revenues $ 4,947.15
Detail for Expenditures:
101 - 42110 -01- 208.02 (Miscellaneous Supplies — Equipment) 1,666.60
101 - 45100 -01- 439.00 (Other Miscellaneous Charges) 3,280.55
Total Expenditures $ 2,556.98
BUILDING CIP FUND DETAIL
Detail for Revenues:
202 - 33100.00 (Federal Grants & Aids) $ 94,995.00
202 - 36265.00 (Use of Reserve Funds) 25,000.00
Total Revenues $ 119,995.00
Detail for Expenditures:
202 - 49002 -01- 524.00 (Community Center Lighting) $ 51,995.00
202 - 49002 -01- 525.00 (Steeple Center Boilers) 68,000.00
--------------- --
Total Expenditures $ 119,995.00
CITY OF ROSEMOUNT
DAKOTA COUNTY, MINNESOTA
RESOLUTION 2010 -
A RESOLUTION APPROVING THE AMENDMENT OF
CERTAIN 2010 BUDGET ITEMS
WHEREAS, the City Council recognizes the need to amend certain items from the 2010
General Fund Operating Budget, the totals which are as follows:
(1) General operating revenues, the total which reflects an increase of $4,947.15;
(2) General operating expenditures, the total which reflects an increase of
$4,947.15;
WHEREAS, the City Council recognizes the need to amend certain items from the 2010
Building CIP Fund, the totals which are as follows:
(1) Building CIP revenues, the total which reflects an increase of $119,995.00;
(2) Building CIP expenditures, the total which reflects an increase of $119,995.00;
NOW, THEREFORE, BE IT RESOLVED, that the City Council of the City of Rosemount
hereby approves the amendment of the above listed budget items for the 2010 General
Fund Operating Budget and the Building CIP Fund Budget.
ADOPTED this 21 st day of December, 2010.
William H. Droste, Mayor
ATTEST:
Amy Domeier, City Clerk
DONATION REVENUE WORKSHEET
RECEIPT OF DONATION
Donation Received On:
Amount Received:
Purpose of Donation:
Account # for Donation: 101 -22222
(Must be Liability # Assigned for Each Individual Department)
EXPENDITURE OF DONATION
Amount to be Spent: $ 1666.60
To be Spent from Account #:101 42110 01 208.02
(Must be Expenditure # Corresponding to Individual Department)
Purpose of Expenditure:
AMENDMENT OF BUDGETS
Amend Donation Revenue Account #101 - 36230.00: $ 1666.60
Amend Expenditure Account #101 -22222 $ 1666.60
(The Two Dollar Amounts Must be the Same)
GENERAL JOURNAL ENTRY TO ADJUST DONATION LIABILITY #
Debit: #101 -22222 (Donation Liability #) $ 1666.60
Credit: 101 -36230.00
$ 1666.60
Journal entry to reduce deferred donation revenue account and increase donation
revenue account to actual per City Council action on: December 21, 2010
RODl'SEMOLINT EXECUTIVE SUMMARY
CITY COUNCIL
City Council Meeting: December 21, 2010
AGENDA ITEM: Approve Expenditure of Funds From the
Police Equipment Fund
AGENDA SECTION:
Consent
PREPARED BY: Gary Kalstabakken, Chief of Police ' .
:1
-AGENDA NO.
ATTACHMENTS: Worksheet
APPROVED BY:
RECOMMENDED ACTION: Motion to authorize expenditure of funds in the amount of
$1666.60 from the Police Equipment Fund.
BACKGROUND
The Police Equipment Fund was set up to accept donations and some grant funds for the purchase of
police equipment. Council authorization is needed for the expenditure of any monies from this fund.
ISSUE
Council is asked to approve the expenditure of funds from the Police Equipment Fund for the purpose of
purchasing body armor for Sergeant Henry Cho. The total amount requested is $1119.99 for the body
armor. Funds are available in the Equipment Fund to cover this expense. In addition, a reimbursement
program through the Department of Justice and the MN Department of Public Safety will reimburse a
portion of the cost to the City and these funds will be returned to the Equipment Fund when received.
Council is also asked to approve the expenditure of funds that were utilized to host a teen dance during
Leprechaun Days. This dance was held at the American Legion and members of the Legion, Legion
Auxiliary, police officers and reserve officers served as chaperones at the event. The Legion donated
charitable gambling proceeds of $500 to provide food and prizes for teens in attendance at the dance.
Council is asked to approve the expenditure of $546.61 that was used for the teen dance.
There are adequate funds in the Equipment Fund to cover the expenses as described.
DONATION REVENUE WORKSHEET
RECEIPT OF DONATION
Donation Received on: 10 -06 -10
Amount Received: $2,000 from PepsiCo/Taco John's
Receipt # for Donation: # N/A
Purpose of Donation:
Reimburse Robert Trail /Dakota County Library
for books purchased for the "One Book, One
Rosemount" event
Account # for Donation: 101 - 22223.00
(Must be Liability # assigned for each individual Department.)
EXPENDITURE OF DONATION
Amount to be Spent: $2,000
To be Spent from Acct #: 101- 45100 -01- 439.00
(Must be Expenditure # corresponding to individual Department.)
Purpose of Expenditure:
Reimburse Robert Trail /Dakota County Library
for books purchased for the "One Book, One
Rosemount" event
AMENDMENT OF BUDGETS
Amend Donation Revenue Acct #101 -36230.00: $2,000
Amend Expenditure Acct #101 -45100-01-439.00 $2,000
(The two- dollar afaQunts should be the same.)
GENERAL JOURNAL ENTRY TO ADJUST DONATION LIABILITY #
Debit: 101 - 22223.00 (Donation Liability #) $2,000
Credit: 101- 36230.00 $2,000
Journal entry to reduce deferred donation revenue and increase donation revenue to actual per Council
action on October 19, 2010.
4ROSEMOUNTEXECUTIVE SUMMARY
CITY COUNCIL
City Council Regular Meeting: October 19, 2010
AGENDA ITEM: Expenditure Approval from the Donation
AGENDA SECTION:
Account — Parks & Recreation Dept.
Consent
PREPARED BY: Dan Schultz, Parks & Recreation Director
AGENDA NO. 4,j,
ATTACHMENTS: Donation Revenue Worksheet
APPROVED BY:
RECOMMENDED ACTION: Motion to approve the donation expenditure of $2,000 to
reimburse the Robert Trail Library/Dakota County Library for the purchase of books
associated with the "One Book, One Rosemount" event (co- sponsored by the Robert Trail
Library and the City of Rosemount) that is taking place during October, 2010.
EXPENDITURE
DONATION
AMOUNT
USE /ITEM PURCHASED
FROM
$2,000
Robert Trail Library /Dakota County Library —
PepsiCo/
Reimbursement for books (A Long Way Home From Chicago
Taco John's
by Richard Peck) for the "One Book, One Rosemount"
event.
SUMMARY
Please consider the expenditure of funds from the Donation Account for the above item.
i
_ •„�s
DONATION REVENUE WORKSHEET
RECEIPT OF DONATION
Donation Received on:
09 -08 -10
Amount Received:
$1500 from Life Wellness.Center
Receipt # for Donation:
# N/A
Purpose of Donation:
Run for the Gold — Ground Pounders Mailing —
City of Eagan
Account # for Donation:
101 - 22223.00
(Must be Liability # assigned for each individual Department.)
EXPENDITURE OF DONATION
Amount to be Spent: $500
To be Spent from Acct #: 101 - 45100 -01- 439.00
(Must be Expenditure # corresponding to individual Department.)
Purpose of Expenditure:
Run for the Gold — Ground Pounders Mailing —
City of Eagan
AMENDMENT OF BUDGETS
Amend Donation Revenue Acct #101 - 36230.00: $500
Amend Expenditure Acct #101 - 45100 -01- 439.00 $500
(The two - dollar amounts should be the same.)
GENERAL JOURNAL ENTRY TO ADJUST DONATION LIABILITY #
Debit: 101 - 22223.00 (Donation Liability #) $500
Credit: 101 - 36230.00 $500
Journal entry to reduce deferred donation revenue and increase donation revenue to actual per Council
action on November 1. 2010.
ROME 2
7P ROSEMOUNT EXECUTIVE SUMMARY
CITY COUNCIL
City Council Special Meeting: November 1, 2010
AGENDA ITEM: Expenditure Approval from the Donation
AGENDA SECTION:
Account — Parks & Recreation Dept.
Consent
PREPARED BY: Dan Schultz, Parks & Recreation Director
AGENDA NO. (�• j.
ATTACHMENTS: Donation Revenue Worksheet
APPROVED BY:
RECOMMENDED ACTION: Motion to approve the donation expenditure of $500.00 from
the Run for the Gold donation account to reimburse the City of Eagan for postage for the
first SORR Ground Pounders running series mailing.
EXPENDITURE
DONATION
AMOUNT
USE /ITEM PURCHASED
FROM
City of Eagan — Reimbursement for postage for first SORR
$500.00
Ground Pounders running series mailing.
Life Wellness Ctr
SUMMARY
Please consider the expenditure from the Donation Account for the above item.
DONATION REVENUE WORKSHEET
RECEIPT OF DONATION
Donation Received on:
Various
Amount Received:
Rosemount Lion's Club
Receipt # for Donation:
# N/A
Purpose of Donation:
Family Fun Fest/Youth Programs
Account # for Donation:
101- 22223.00
(Must be Liability # assigned for each individual Department.)
EXPENDITURE OF DONATION
Amount to be Spent:
$280.55
To be Spent from Acct #:
101 - 45100 -01- 439.00
(Must be Expenditure # corresponding to individual. Department.)
Purpose of Expenditure:
Family Fun Fest/Youth Programs
AMENDMENT OF BUDGETS
Amend Donation Revenue Acct #101 - 36230.00:
Amend Expenditure Acct #101 - 45100 -01- 439.00
(The two- dollar amounts should be the same.)
$280.55
$280.55
GENERAL JOURNAL ENTRY TO ADJUST DONATION LIABILITY #
Debit: 101 - 22223.00 (Donation Liability #) $280.55
Credit: 101- 36230.00 $280.55
Journal entry to reduce deferred donation revenue and increase donation revenue to actual per Council
action on December 7, 2010.
r0. I _
2
4ROSEMOUNTEXECUTIVE SUMMARY
CITY COUNCIL
City Council Regular Meeting: December 7, 2010
AGENDA ITEM: Expenditure Approval from the Donation
AGENDA SECTION:
Account — Parks & Recreation Dept.
Consent
PREPARED BY: Dan Schultz, Parks & Recreation Director
AGENDA NO.�,
ATTACHMENTS: Donation Revenue Worksheet
APPROVED BY:
RECOMMENDED ACTION: Motion to approve the donation expenditure of $280.55 for
the upcoming 2011 Family Fun Fest and $500.00 to reimburse the City of Apple Valley for
postage for event mailings for the 2010 Ground Pounders summer running series.
EXPENDITURE
DONATION
AMOUNT
USE /ITEM PURCHASED
FROM
$280.55
MooreFun Entertainment — Rental of Inflatables
Rosemount Lion's
Club
City of Apple Valley — Reimbursement for
$500.00
Ground ounders Running Series Mailing
Life Wellness Ctr
$780.55
Total
SUMMARY
Please consider the expenditure from the Donation Account for the above items.
DONATION REVENUE WORKSHEET
RECEIPT OF DONATION
Donation Received on: 09 -07 -10
Amount Received:
Receipt # for Donation:
Purpose of Donation:
Account # for Donation:
$1500 from Life Wellness Center
# N/A
Run for the Gold — Ground Pounders Event
Mailings — Apple Valley
101- 22223.00
(Must be Liability # assigned for each individual Department.)
EXPENDITURE OF DONATION
Amount to be Spent: $500
To be Spent from Acct #: 101 - 45100 -01- 439.00
(Must be Expenditure # corresponding to individual Department.)
Purpose of Expenditure: Run for the Gold — Ground Pounders Event
Mailings — Apple Valley
AMENDMENT OF BUDGETS
Amend Donation Revenue Acct #101 - 36230.00: $500
Amend Expenditure Acct #101 - 45100 -01- 439.00 $500
(The two- dollar amounts should be the same.)
GENERAL JOURNAL ENTRY TO ADJUST DONATION LIABILITY #
Debit: 101 - 22223.00 (Donation Liability #)
Credit: 101- 36230.00
$500
$500
Journal entry to reduce deferred donation revenue and increase donation revenue to actual per Council
action on December 7, 2010.
Q0
�► -J D 3
al
ROSEMOUNT EXECUTIVE SUMMARY
M RY
CITY COUNCIL
City Council Regular Meeting: December 7, 2010
AGENDA ITEM: Expenditure Approval from the Donation
AGENDA SECTION:
Account — Parks & Recreation Dept.
Consent
PREPARED BY: Dan Schultz, Parks & Recreation Director
AGENDA NO.
ATTACHMENTS: Donation Revenue Worksheet
APPROVED BY:
RECOMMENDED ACTION: Motion to approve the donation expenditure of $280.55 for
the upcoming 2011 Family Fun Fest and $500.00 to reimburse the City of Apple Valley for
postage for event mailings for the 2010 Ground Pounders summer running series.
EXPENDITURE
DONATION
AMOUNT
USE /ITEM PURCHASED
FROM
$280.55
MooreFun Entertainment — Rental of Inflatables
Rosemount Lion's
Club
City of Apple Valley — Reimbursement for
$500.00
Ground pounders Running Series Mailing
Life Wellness Ctr
$780.55
Total
SUMMARY
Please consider the expenditure from the Donation Account for the above items.
May, Jeff
From: Schultz, Dan
Sent: Tuesday, November 02, 2010 2:34 PM
To: Miller, Judy
Cc: May, Jeff; Schuster, Tom; Maurer, Lisa; Lehr, Ginny; Honl, Sonja
Subject: account codes for grants
Judy as per my message, below is the coding information about the grants.
1. Family Resource Center Playground $54,640
Revenues 205 - 33130.00 (CDBG)
Expenditures 205 - 49005 -01- 530.00
2. Family Resource Center Building Improv. $75,000
Revenues 205- 33130.00 (CDBG - R)
Expenditures 205- 49005 -01- 540.00
3. Boilers at the Steeple Center $68,000
Revenues 202 - 33100.00
Expenditures 202 - 49002 -01 - 525.00
4. Lighting at the RCC $51,995
Revenues 202 - 33100.00
Expenditures 202 - 49002 -01- 524.00
Dan Schultz
Parks and Recreation Director
City of Rosemount
651 - 322 -6012
1
May, Jeff
From: Schultz, Dan
Sent: Monday, September 20, 2010 4:23 PM
To: May, Jeff
Subject: state grants - breakdown
RCC /Arena lighting upgrades -
total cost grant $ City $
$51,995 $46,995 $5,000 (P &R and arena operating funds) �� -f u -C)),- w
Steeple Center
total cost grant $ City $
$68,000 $48,000 $20,000 ($10,000 Building CIP and $10,000 Steeple Center operating)
Dan Schultz i
Parks and Recreation Director �� a
City of Rosemount
651- 322 -6012
1