HomeMy WebLinkAbout6.h. Budget AmendmentsAGENDA ITEM: Budget Amendments
AGENDA SECTION:
Consent
PREPARED BY: Jeff May, Finance Director
AGENDA NO. 10.1(1.
ATTACHMENTS: Council Memo, Resolution, Donation
Worksheets
APPROVED BY:
RECOMMENDED ACTION: Motion to adopt A Resolution Approving the Am ment of
Certain 2006 Budget Items for the General Fund and the Equipment CIP Fun as outlined
in the attached memo.
9 ROSEMOUNT
CITY COUNCIL
City Council Meeting Date: December 19, 2006
EXECUTIVE SUMMARY
ISSUE
Amend the General Fund budget to reflect donations expended during the 4 quarter of 2006.
Amend the Equipment CIP Fund budget to reflect the Police Department Buffer Zone grant.
BACKGROUND
This item is on the agenda for Council to formally amend the 2006 General Fund budget by resolution for
donation items that Council had previously authorized covering expenditures made during the third
quarter of 2006. This item also addresses the grant revenues and expenditures for the Police Department's
Buffer Zone grant for the year 2006.
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 4 quarter of 2006.
4 ROSEMOUN 1
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: December 11, 2006
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 is also a request to amend both the revenue
and expenditure budgets for the Equipment GIP fund for the Pohce Department Buffer Zone
grant. 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)
Total Revenues
Detail for Expenditures:
101 45100 -01- 439.00 (Other Miscellaneous Charges)
Total Expenditures
EQUIPMENT GIP FUND DETAIL
1,566.52
1,566.52
1,566.52
1,566.52
Detail for Revenues:
207 33100.00 (Federal Grants Aids) 131,003.95
Total Revenues 131,003.95
Detail for Expenditures:
207- 49007 -01- 585.00 (Police Grant Equipment) 131,003.95
Total Expenditures 131,003.95
WHEREAS, the City Council recognizes the need to amend certain items from the 2006
General Fund Operating Budget, the totals which are as follows:
(1) General operating revenues, the total which reflects an increase of $1,566.52;
(2) General operating expenditures, the total which reflects an increase of
$1,566.52;
WHEREAS, the City Council recognizes the need to amend certain items from the 2006
Equipment CIP Fund Budget, the totals which are as follows:
(1) Equipment CIP revenues, the total which reflects an increase of $131,003.95;
(2) Equipment CIP expenditures, the total which reflects an increase of
$131,003.95;
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 2006 General
Fund Operating Budget and the 2006 Equipment CIP Budget.
ADOPTED this 19` day of December, 2006.
ATTEST:
Amy Domeier, City Clerk
CITY OF ROSEMOUNT
DAKOTA COUNTY, MINNESOTA
RESOLUTION 2006
A RESOLUTION APPROVING THE AMENDMENT OF
CERTAIN 2006 BUDGET ITEMS
William H. Droste, Mayor
Motion by: Seconded by:
Voted in favor:
Voted Against:
Members Absent:
RECEIPT OF DONATION
Donation Received on.
Amount Received:
Receipt for Donation.
Purpose of Donation
Amount to be Spent
To be Spent from Acct
Purpose of Expenditure:
DONATION REVENUE WORKSHEET
02 -21 -06
N/A
Teen Night
Account for Donation: 101 -22223 00
(Must be Liability assigned for each individual Department
$1000 from First State Bank of Rosemount
EXPENDITURE OF DONATION
$350
(Must be Expenditure corresponding to individual Department.)
AMENDMENT OF BUDGETS
Amend Donation Revenue Acct #101- 36230.00: $350
Amend Expenditure Acct #101- 45100 -01- 439.00 $350
(The two dollar amounts should be the same
GEAL JOURNAL ENTRY TO ADJUST DONATION LIABILITY
Debit 101 -22223 00 (Donation Liability $350
Credit: 101- 36230.00 $350
101- 45100 -01 -439 00
Teen Night
Journal entry to reduce deferred donation revenue and increase donation revenue to actual per Council
action on October 3. 2006.
2
AGENDA ITEM: Expenditure Approval from the Donation
Account— Parks Recreation Dept.
AGENDA SECTION:
Consent
PREPARED BY: Dan Schultz, Parks Recreation Director
AGENDA NO. 6.g.
ATTACHMENTS: Donation Revenue Worksheet
APPROVED BY:_,..--
RECOMMENDED ACTION: Motion to approve the donation expenditure of $3'50
for the DJ for the September 2006 Teen Night.
EXPENDITURE
AMOUNT
USE /ITEM PURCHASED
DONATION
FROM
$350
Ricld Miller DJ for 09 -08 -06 Teen Night
1" State Bank
Rosemount
4 ROSEMOUNT
City Council Regular Meeting: October 3, 2006
SUMMARY
CITY COUNCIL
EXECUTIVE SUMMARY
Please consider the expenditure of funds from the Donation Account for the above item.
RECEIPT OF DONATION
Donation Received on:
Amount Received.
Receipt for Donation
Purpose of Donation:
DONATION REVENUE WORKSHEET
02 -21 -06
N/A
Teen Night
Account for Donation 101 -22223 00
(Must be Liability assigned for each individual Department
Amount to be Spent: $213.67
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.)
Credit: 101 -36230 00
Packet page 108 of 177
EXPENDITURE OF DONATION
Teen Night
AMENDMENT OF BUDGETS
$1000 from First State Bank of Rosemount
$213 67
$213 67
GENERAL JOURNAL ENTRY TO ADJUST DONATION LIABILITY
y
r'
Debit 101 -22223 00 (Donation Liability $213.67
$213 67
Journal entry to reduce deferred donation revenue and increase donation revenue to actual per Council
action on November 7, 2006.
2
EXPENDITURE
AMOUNT
USE /ITEM PURCHASED
DONATION
FROM
$80.22
Sam's Club supplies for Teen Night
1" State Bank
Rosemount
$133 45
Pepsi Cola supplies for Teen Night
1" State Bank
Rosemount
$213 67
TOTAL
AGENDA ITEM: Expenditure Approval from the Donation
Account Parks Recreation Dept.
AGENDA SECTION:
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 $213 67
for Teen Night supplies.
ROSEMOUNT
City Council Regular Meeting: November 7, 2006
SUMMARY
Packet page 107 of 177
CITY COUNCIL
EXECUTIVE SUMMARY
Please consider the expenditure of funds from the Donation Account for the above item.
RECEIPT OF DONATION
Donation Received on:
Amount Received'
Receipt for Donation.
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
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
Packet page 63 of 148
DONATION REVENUE WORKSHEET
02 -21 -06
$1000 from First State Bank of Rosemount
N/A
Teen Night
EXPENDITURE OF DONATION
$571 85
101 45100 -01- 439.00
(Must be Expenditure corresponding to individual Department
Teen Night
AMENDMENT OF BUDGETS
$571 85
$571 85
GENERAL JOURNAL ENTRY TO ADJUST DONATION LIABILITY
y r
Debit 101- 22223.00 (Donation Liability $571.85
Credit 101 -36230 00 5571 85
Journal entry to reduce deferred donation revenue and increase donation revenue to actual per Council
action on November 21, 2006
TY 161
2
EXPENDITURE
AMOUNT
USE/ITEM PURCHASED
DONATION
FROM
$70.95
Sam's Club supphes for Teen Night
1" State Bank
Rosemount
$350.00
Ricki Miller DJ services for Teen Night 10 -13 -06
1" State Bank
Rosemount
$150 90
Pepsi Cola supphes for Teen Night
1" State Bank
Rosemount
$571 85
TOTAL
AGENDA ITEM: Expenditure Approval from the Donation
Account Parks Recreation Dept
AGENDA SECTION:
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 $571 85
for Teen Night supplies.
ROSEMOUNT
CITY COUNCIL
City Council Regular Meeting' November 21, 2006
EXECUTIVE SUMMARY
SUMMARY
Please consider the expenditure of funds from the Donation Account for the above item.
Packet page 62 of 148
RECEIPT OF DONATION
Donation Received on:
Amount Received:
Receipt for Donation'
Purpose of Donation.
Amount to be Spent:
To be Spent from Acct
Purpose of Expenditure
DONATION REVENUE WORKSHEET
02 -21 -06
Account for Donation: 101- 22223.00
(Must be Liability assigned for each individual Department.)
$1000 from First State Bank of Rosemount
N/A
Teen Night
EXPENDITURE OF DONATION
$431
101-45100-01-439.00
(Must be Expenditure corresponding to individual Department
Teen Night
AMENDMENT OF BUDGETS
Amend Donation Revenue Acct #101- 36230.00: $431
Amend Expenditure Acct #101-45100-01-439.00 5431
(The two dollar amounts should be the same.)
GENERAL JOURNAL ENTRY TO ADJUST DONATION LIABILITY
Debit: 101 -22223 00 (Donation Liability $431
Credit' 101 -36230 00 $431
Journal entry to reduce deferred donation revenue and increase donation revenue to actual per Council
action on December 19, 2006.
2
EXPENDITURE
AMOUNT
USE /ITEM PURCHASED
DONATION
FROM
$350.00
Ricki Miller DJ services for Teen Night 11 -10 -06
1" State Bank
Rosemount
$81.00
Pizza N Pasta Teen Night 10 -13 -06
1' State Bank
Rosemount
$431.00
TOTAL
AGENDA ITEM: Expenditure Approval from the Donation
Account Parks Recreation Dept.
AGENDA SECTION:
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 $350
for DJ Services in November and $80 for pizza in October, for the Teen Night program.
4 ROSEMOUNT
CITY COUNCIL
City Council Regular Meeting: December 19, 2006
EXECUTIVE SUMMARY
SUMMARY
Please consider the expenditure of funds from the Donation Account for the above items.
May, Jeff
From: Kalstabakken,Gary
Sent: Thursday, December 07, 2006 2 43 PM
To: May, Jeff
Subject: Grant
Page 1 of 1
Jeff,
The total dollar amount for the Buffer Zone grant for this year is $145,134 To date, we have received $119,307 04 Once the
invoices for the laptops that arrived this week are received, I will request an additional $11,696.91. That request will bring our
grant monies received this year to $131,003 95
In January we should receive the remaining items from this grant, squad cameras, and will request reimbursement for the
remaining $14,130 05. I did submit an amendment to the grant that will increase the amount another $3478 for a grand total of
$148,612 It is unknown if this amount will be available to increase our 2005/06 grant until all grantees have submitted their
reimbursements
For next year, we are eligible for $179, 550 My intention is to submit a request for the full amount and if we meet their
requirements, the full amount is guaranteed and will need to be spent by 10/01/2007 Deadline date is February 1 for submittal.
Gary Kalstabakken
Chief of Police
City of Rosemount
2875 West 145 Street
Rosemount, MN 55068
651 322.2010
gary kalstabakken@ci rosemount mn us
1 n /11 P Art
12 -11 -2006 2 34 PM D E T A I L L I S T I N G PAGE: 1
FUND 207- EQUIPMENT CIP FUND PERIOD TO USE Jan -2006 THRU Dec -20D6
DEPT N/A SUPPRESS ZEROS ACCOUNTS. 33100 00 THRU 33100 00
POST DATE TRAIT REFERENCE PACKET =DESCRIPTION VEND INV /JE NOTE AMOUNT= BALANCE
33100 00 FEDERAL GRANTS AIDS
B E G I N N I N G B A L A N C E 0 00
7/14/06 7/18 B08237 Deposit 072785 00375 PYMT #1- BUFFER ZONE GRANT JE# 008223
)/11/06 10/17 808914 Deposit 073359 00408 BUZZER ZONE (FED'L THRU STATE) JE# 008899
ACCOUNT TOTAL DE 0 00 CR 119,307.04CR
000 ERRORS IN THIS REPORT'
REPORT TOTALS
BEGINNING BALANCES
REPORTED ACTIVITY
ENDING BALANCES
0.00
0.00
0 DD
0 00
119,307.04CR
1 19,307. 04 CR
83,764 40CR 83,764 40CR
35,542 64CR 119,307 04CR
12 -11 -2006 2 36 PM
FUND 207 EQUIPMENT CIP FUND
DEPT 9007 EQUIPMENT CIP
POST DATE TRAN REFERENCE PACKET DESCRIPTION VEND INV /JE 0 NOTE AMOUNT= BALANCE
49007 -01 -585 00 POLICE GRANT EQUIPMENT
B E G I N N I N G B A L A N C E 0 00
2/02/06 2/02 A55004 CHK 081717 OOB80 CAMERAS,DVR,TRANSMITTER, 000899 5667849
2/02/06 2/02 A55020 CHK 061794 00680 ACU -T BUNDLE KIT 001132 52870
2/02/06 2/02 A55025 CHK- 081839 00880 THERMAL EYE PALM IR 250 001137 5292
2/16/06 2/16 A56132 CHK 982055 00890 2 HEAD MO RETURNED 192536 CM209855
2/16/06 2/16 A56133 CHK 082055 00890 2 HEAD MOUNTS 192536 I318508
2/16/06 2/16 A56134 CHK 082055 00890 NIGHT VISION POCKETSCOPE 192536 I321494
2/16/06 2/16 A56135 CHK 052055 00890 2 HELMET MOUNTS 192535 I124608
3/02/06 3/02 A56708 CHK: 082183 00900 3 SENTINEL RADIO ALARMS 001162 9894
3/02/06 3/02 A56709 CHK 082182 00900 TACTICAL SURVEILLANCE SY 001163 126903
3/14/06 3/16 A57173 CHK 000000 00913 FEBRUARY SALES 0 USE TAX 000031 200603143478
3/16/06 3/16 A57217 CHK 082332 00913 COBRA FIELDSCOUT HANDSEL 001179 200603143455
3/30/06 3/30 A58242 CHK 062534 00925 ADD'L PYMT -COBRA HANDSEL 001179 YH- 00001 -11
4/18/06 4/19 A59370 CHK: 000000 00948 MARCH SALES 6 USE TAX 000031 200604183609
8/31/06 8/31 A66674 CHK 084830 01063 3 CABLE KITS FOR VID 5 001390 0087604 -IN
8/31/06 8/31 A66675 CHK 084830 01063 3 DIGITAL VIDEO SYSTEMS/ 001390 0089308 -IN
9/19/06 9/21 A68380 CHK 000000 01088 AUGUST SALES n USE TAX 000031 200609194156
9/28/06 9/28 A68681 CHK 085280 01089 MOBILE VISION INSTALL-NE 051340 ST091806 -2
9/28/06 9/28 A68682 CHK 085280 01089 MOBILE VISION INSTALL-NE 051340 ST091806 -3
9/28/06 9/28 A68683 CHK- 085280 01089 M03ILE VISION INSTALL NE 051340 ST091806 -4
10/07/06 10/12 A69278 CHK 000000 01102 8 BUSHNELL BINOCULARS 001337 0015306430
10/12/06 10/12 A69363 CHK 085490 01102 PROL =ANT ML150 G2-POLICE 031530 61278
10/12/06 10/12 A69364 CHK 085490 01102 USB 2 0 9 -IN -I R /W -?OLIC 031530 61365
11/02/06 11/02 A70335 522K 085778 01116 3- VIKING MEMORY 1GB 001479 110356100
11/02/06 11/02 A70336 CNN 085778 01116 1- VIKING MEMORY 1GB 001479 110359998
11/02/06 11/02 A70337 CHK- 085778 01116 4- PANASONIC TOUGHBOOK 29 001479 110367223
11/16/06 11/16 A71361 CHK 085981 01137 3 CAR MOUNT PORT REP RET 001479 110395101
11/16/06 11/16 A71362 CIIK 085981 01137 4 CAR MOUNT PORT REPLICA 001479 110384956
ACCOUNT TOTAL DB 126,433 47 CR: 1,325 82CR
000 ERRORS IN THIS REPORT'
REPORT TOTALS
EEGINNING BALANCES
REPORTED ACTIVITY
EKDING BALANCES
D E T A I L L I S T I N G
SUPPRESS ZEROS ACCOUNTS 49007 -01 -585 00 THRU 49007 -01 -585 00
0 00
126,433 47
126,433 47
PERIOD TO USE
0 00
1,325 82CR
1,325 82CR
PAGE 1
Jan -2006 LHRU Dec -2006
3,633,75 3,633.75
9,600 00 13,233 75
12,565 94 25,799 69
255 49CR 25,544 20
271 42 25,815 62
22,088 49 47,904.11
440 80 48,344 91
12,370 D0 60,714 91
16,415 -00 77,129 91
624 00 77,753 91
3,680 00 81,433 91
10 00 81,443 91
2,110 88 83,554 79
349 73 83,904 52
18,575 15 102,479 67
6 47 102,486 14
315 00 102,801 14
315 00 103,116 -14
315 OD 103,431 14
1,021 89 104,453 03
4,638 08 109,091 11
63 90 109,155 01
431 33 109,586 34
143 78 109,730 -12
15,020 76 124,750 88
1,070 33CR 123,680 55
1,427 10 125,107 65