Loading...
HomeMy WebLinkAboutOrdinance 008-2014 Ordinance No. 08-14 An Ordinance Authorizing a Supplemental Appropriation to the 2014 Budget for the purpose of providing for additional funds for the Operation of the City. Be It Ordained by the City of Brookings, South Dakota: Whereas,the 2013 assigned fund balances were established for capital projects and capital equipment in 2014; and Whereas, bonding for 2014 capital equipment and projects was created; and Whereas, payment for the Bond Anticipation Note is due; and Whereas, responsibilities were transferred between funds for the override accounts receivable and override accounts payable; and Whereas,there is a need to recognize PEG grant revenues; and Whereas, it is necessary to recognize the outstanding economic incentives; and Whereas, it is necessary to reduce budgets for insurance premium discounts and refunds; and Whereas,the SRF loan principal and interest payments need to be adjusted; and Whereas State Law (SDCL 9-21-7) and the City Charter (4.06 (a) permit supplemental appropriations provided there are sufficient funds and revenues available to pay the appropriation when it becomes due. Now,Therefore, Be It Resolved by the City Council that the City Manager be authorized to make the following budget adjustments to the 2014 budget: Budget Amendment#1 Revenue Expense Policy&Adm-City Coucil,City Clerk, City Manager 9,795 Financial Adm-Finance, Human Res 60,653 Other-Non-Dept, Gen Gov Buildings, IT 5,556,919 7,340,016 Public Safety-Police, Fire,Animal Control 205,956 Public Works-Comm Dev, Engineer, Street (27,931) Culture & Recreation- Park,Rec,Forestry,Library,Aquatic,IceArena 14,000 109,658 Total General Government 6,570,919 7,698,147 75% Public Improvement 910,100 (2,406,542) 25%S&U Tax (814,851) Swiftel Center 75,880 75,880 Special Assessment (1,500,000) Storm Drainage 107,885 Total Special Revenue 985,980 (4,537,628) Bel-Digester Project 4,494,834 445,676 S Main Ave Project 1,700,000 1,700,000 Total Capital Projects 6,194,834 2,145,676 Liquor Fund (598,400) (533,219) Airport Fund (449) Edgebrook Golf Course (596) Solid Waste Collection 252 Landfill 890,000 891,245 Research &Technology Center (243) Total Enterprise Funds 291,600 356,990 All Ordinances or parts of Ordinances in conflict herewith are hereby repealed. First Reading: May 27, 2014 Second Reading: June 10, 2014 Published: June 16, 2014 CtTY OF BROOKINGS / l�-� J -�-- G\TY OF Tim Reed, Mayor �O��� e,�° i �b�•��O X S �f�� 9. `�Z�n Nc N .� / Shari Thornes, City Clerk General Ledger Budget Adjtistment Detail � �� �� '� �� � User; rthompson s c� �r T fe o► w �t �o t a+. Printed: tl5/14/2f)14- l:40PM Printed: 2tl14 .. .. I f~••1 • .. - . . . . F' ". . .- . . . . .. Acrount Number Account Ucscription Beginning Budget Amount Budget pute Transaction Description Transi'er Description 101-000-4-663-50 Bond Proceeds 0.00 OS/14/20I4 Finance cepital equipment 753,319.00 ')53,319.00 0.00 753,319.00 753,319.00 l01-000-6-7q0-01 Transfer in from Liquor I�und �pp,ppp,pp OS/14/20t4 Adjuat for override fec -523,b00.00 176,400.00 70Q.OQ0.00 -523,600.00 17b,400.00 101•OOQ-6-700-03 Trantfer In ftom 73%S&U Tax 733,000.00 OS/14/2014 Finnnce capital equipment •733,QOO.QO 0,00 933,QQO,pO •733,000.� 0.00 101-401-5•130-00 Workmuna Compensation I97.00 OS/14/2014 Adjuat Budget to Actuai far Inaurance -12.00 I85.00 197.00 -12.00 185.00 101-401-5-421•p0 Tnsurenae I,Q�0.00 OS/14/201A AdjuAt Budgot[o Actuai for insurance -78.00 g52,00 1,Q30.00 -78.00 452.00 101-4Q3-S-130-00 Workmant Comps�wtion ST0,00 OS/IM2014 Adjust Budgot to Actual for Insurance -3b.Q0 574.00 570.00 -3b.OQ 334.00 l01-403-5-421-00 insumnce 442.00 OS/14/2014 Adjust BudIIct to Actual for[nsuranac -34.00 qp$,pp aa2.00 -3a.00 aoa.00 101-403-5-428-57 Public Education Mistoric 30,000.00 OS/14/2014 2013 Assigned Fuads-P E Historic 10,000.00 40,000.00 3Q000.00 10,000.00 40,OOO.UO 101-405-4-381-1 I SaleslOA-Wine,Liquor O,pp OS/14/2014 Invoice ovcrride fee moved to Finance From 601-000-4-381-11 1,450,000.00 1,450,000.00 O.t10 I,450,000.00 1,450,000.00 GL-Budgct Adjustmcnt Detail(5/14/2014- 1:40 PM) Pagc 1 Accaunt Numbcr Account Description Beginning Budget Amount Budget Date Tr�nsartion Descriptinn Trnnsfer Description 101-405-4-381-31 S0IC9/OA HCCY 0.00 OS/14/2014 Invoice overcide fee m�ved to Financ� Frum 601-000-4381-31 1,650,Otl0,00 1,650,000.00 0.00 1,650,OOU.00 1,650,000.� 101-405-4-38i-32 Sales/OA Malt 6eer U.00 OS/14/2014 Invoice overcide fee moved to Finance From 60t-000-4-381-32 2,634,0OO.Ob 2,634,000.00 0.00 2,634,OOb.OU 2,634,000.00 101-405-4-381-97 OA Mkrup/Brcwpds 0.00 OS/14/2014 Moved from Liquor to Finance 1,70b.00 1,700.00 0.00 I,700.00 1,700.00 IOI-40S-4-381-98 Markup l0%/OA Beer-Malt 0.00 OS/14/2014 Invoice override fee moved to Finance From 601-000-4-381-98 425,000.00 425,000.00 0.00 423,000.00 425.000.00 101-405-4-381-99 Markup 119�6/OA Wine-Liquor 0.00 OS/14l2014 Invoice ovcrridc fcc movcd to Financc From 601-000-4-381-99 139,500.00 159,5�.00 0.00 I 54,500.00 159,SOO.OQ 101-405-5-832-07 OA Purchascs-Wine,Liquor 0.00 OS/14/201A Moved from Liquor to Finance 1,450,000.00 l,450,000.00 0.00 1,430,0�.00 1,440,000.00 101-405-5•852-08 OA-Purchases BecdMalt Becr O.OQ OS/14/2014 Moved from Liquor to Financc 4,284,000.00 4,284,OOQ.00 0.00 4,284,OOO.QO 4,284,000.(� 101-406-5-130-OQ Workmans Compensetion 507.00 OS/14l2014 Adjust Budgetto ActualforInsurancc -33.00 474.OQ 507.00 -33.00 A74.OQ 101-406-5-421-00 Insurance 148.00 OS/14/2014 AdJust BudBet to Actual for Insurance -t2.00 136.00 148.00 -12.� 136.00 101-41M5-130-00 Workmans Compensation 471.00 OS/1M2014 Adjust Budget to Actual for[nsurance -30.00 441.00 4?1.00 -30.00 441.� 101-414-5-421-00 insurance 297.00 OS/14/2014 Adjust Hudgctto Actualforinsurancc -21.00 276.00 297.00 -21.00 276.00 GL-Budgct Adjustmcnt Dctail(5/14/2014- 1:40 PM) Page 2 Acrnunt Number Account DexeripNnn Be�inninq Budget Amount tiudget bate Trnnsactlon Deseriptinn Transfer nrsrription 1U1=415�5-101•00 Regul�r Pey 262,171.U0 OS/14/2014 lnvoice override fee ryasition SO,Otl0.00 312,17I.00 262,171.00 50,000.00 312,171.00 101-415-5-120-00 fICA 20,2A1,00 OS/14/2014 Mnveoverrideinvaice 3,700.00 23,90L00 ?0,201.00 3,700.00 23,901.00 101-415-5-121•09 Retirement 14,844.00 OS/l4✓2014 Invoicc overcido fee 3,0(�1.00 18,R44.QQ 15,844.OQ 3,000.00 t8,844.00 101-415-5-130-00 Workmana CompanaAtion 913.00 OS/14/2014 A�just Budget to Actual for[nsursnce -58.00 855.00 913.00 -58.00 855.00 101-415-5-421•00 Insuroacc 691.00 03/14/2014 Adjuat Hudgetto Actusiforinsurancc -138.Q0 353.00 691.OQ -138.W S53.Q0 101-415•5-427-02 Regianation&Traininp 3,]10.Q0 OS/14/2014 Fesud hotlinc and trainin$ 4,2UO,Q0 7,510.00 3,310.00 4,20Q.OQ ?,SlO.OQ 101-416-5-101•OA Ovarttime Aay I,QQO.QQ OS/14l2014 IT/Dom�in changca PD dk Lib/oto S,OOQ.OQ b,Q00,Q0 1�0�1.OQ S,QOO.AQ b,Q00.Q0 101-416-5-130-00 Wo�kmans Compa�aadon 18I.00 OS/!4/201A Adjuat Budgetto Actualforinsumnce -12.00 164.QQ 181.00 •12.00 lb9.QQ 101-A16-5-421-00 Insurancc 280.00 OS/14/2014 Adjust Budgetto ActualforInsurance •144.Q0 136.00 • 280.00 -14at.OQ 136.U0 101-416-5-940-IS Other Capital-Finence 27,162.00 OS/14/2014 2013 Assigned Funds-Naw station-ave 13,000.00 40,162.00 27,162.00 13,OOO.QO 40,142.00 10t-416-5-940-19 Other Capital-Eng 2,400.00 OS/14l2014 Pictometry Adjustment 13,776.00 16,176.00 GL-Bud�et Adjustmcnt Dctail(SJl4/2014- 1:40 PM) Pa,gc 3 Aecount Nu►nber Account Description Reginning Budget Amount Budget b�te Trunsaction Description Transfer Description 2,400.00 13,77G.00 16,176.U0 101-416-3=950-Oi Capitel less thsn$S,U00•1"f i,00U.b0 U5/14/2014 2013 Assigned Funds-PD&Lib to Cit 5,000,00 6,OtlU.00 I,000.00 5,000.00 6,000.00 101-4�5-5-950-18 Capital legs than SS,000-C Dev 3,6pp.pp 04/14/2014 2013 Assigned Funds-Code Enforce E 8,206.00 11,806.00 3,600.00 8,206,00 11,806.00 101-419-5-421-00 Insurance 13,633.00 03/14/2014 Adjust Budget to Actuel for Insurance -387.00 15,266.00 13,653.00 -387.00 13,266.Qb 101-417-5-425-0I Maintenance Office Equipmont 4,SOO.OQ 05/14/2014 Decrease bud$et .900.00 3,600.00 4,500.00 -90Q.00 3.60Q.00 101-417-S-911-2 t Public Sa&ry Buildin�a IO,OOO.QQ OS/14/2014 Dccro�se budgat-Done 2013 -I0,000.00 O.OQ IO,OOQ.00 -10,000.00 O.QO 101•417-5-940-00 Othcr Capital 0.00 03/I4/2014 GGB Parking Lot From 101-431•5-960-00 33,000.00 33,OOO.QO QS/IA/2014 2013 Aasigned Funds-3rd St Parking I 45,412.00 $p,412.QQ 0.00 80,412.00 80,412.00 !O1-A17-S-9S0-01 CSpIfAI J88S flfAt$5,000 S,IQQ.QO OS/l4/2014 Increase budgeted Expense 4,OOQ.00 9,(OO.OQ S�IOO.QO 4,OQ0.4Q 9,1QQ.pQ 101-418-5-130-00 Workmans Compensation 3,487.00 OS/I42014 Adjust Budget to Actual for Insurancc -254.00 3,23�.00 3.467.00 -254.00 3,233.d0 101-418-5-421-00 Inaurance 1,886.00 OSJI4J2014 Adjust Budget to Actual for Insurance -316.00 1,570.00 1,886.00 -316.00 1,570.00 101-418-5-911-00 Buildin�s&Structures O.QO OS/14/2014 2013 Assigned Funds-Food Pantry Ra 9,000,00 g,ppp,pp 0.00 9,000.00 9,000.00 101-418-5-940-00 Other Capitsl p,pp GL-Budgct Adjustmcnt Dctail(5/14/2014- i:40 PM) Pagc 4 Account Number Account DescrlpHon 13tginning Budget Amount Badget b�te 7'runsuction Descriptioo Transfer besrripHon OS/14/2014 2013 Assigncd runds-Cndc EnfSoftw 6,675.00 6,675.00 0,00 6,675.00 6,675,00 101-419-5-130-00 Workrnana Compengatinn 4,319.00 I15/14/2014 Adjust Budget to Actual Por tnsurance -330.00 4,199.00 4,529.00 -330,00 4,199.00 101-419-5-421-00 Ineurancc 5,217.00 OS/14/2014 Adjust Budget to Actual for Insurance -1,175.00 4,042.00 5,217.06 •1,174.4U 4,042.b0 101-A19-S-416-01 Ofticc Supplies 6,0OO.Ob 03/l4/2014 Transfcrwithlndepartment TolAl-419-3-930-00 -900.00 3,100.00 6,000,00 -900,00 3,IQ0.00 101-419-5-930-00 Machincry&Auto Equipment 20,0�.00 OS/14/20t4 Tranaferwithindopartmcnt From 101-419-5-426-01 900.Oq 20,900.00 20,004.00 9Qp.pp 20,900.OQ 101-A20-4-334-OQ 0rents O.QO OS/14/2014 PEG Grant 140,OOO.QO 140,OQ0.00 0.00 1 AO,OQQ.OQ 140.QQQ.00 101-42Q-S-421-pp lnaurence 9,QOp,pQ OS/14/2014 Adjust Budset to Actual for In�urance .4,231.OQ A,769.00 9,OQp.QO .4,231.00 a,769.00 101-A21-S-130-00 Workmans Compansation 53,721.Q0 OS/14/2014 Adjust Budget w Acwal for Inaurance -S 1 S.QO 3S,2Q?.QO 55,722.00 -S 1 S.OQ 33,2Q7.Q0 101-421-5-A21-00 [nauranoc 24,777.Q0 OS/l4/2014 Adjust Budgot to Actual for Inaurance 4,061.Q0 28,838.00 24,777.00 4,061.00 28,838.00 ]01-42t-5-91 I-00 Building&Structures 0.00 OS/l4/2014 Fence around Firoarms Range 20,319.00 20,319.00 G.00 20,319.00 20,319.�0 101-421-5-930-00 Machinery&Auto Equipment 65,818.06 OS/14i2014 2013 Assigned Funds-PD/Camera 6-21 6,017.00 7t,S35.00 65,818.00 6,017.00 71,835.00 GL-Budgct Adjustmcnt Dctail(S/14/2014- 1:40 PM) pagc$ Accnunt Nunyber Account Description 13c�inning Ciudget Amount Budget Date Transartinn DescripNon Trunsfer Description l 01-422-5•130-00 Wc�rkmans Cnmpcns�tian 14,028.00 OS/14/3014 Adjust Budgetto Actuulforinsurencc -1,G34.00 t2,394.00 14,tl2R.00 -1,634.UU 12,394.tl0 101-422-5-421-00 Insurance 30,281.00 OS/l4/2014 Adjust$udget to Actual for Inaurance -2,342,00 27,939.00 30,281.00 -2,342.00 27,939.00 IOI•422-SA23-03 Maintename Trucka 7,g00,00 OS/14/2014 2013 insurence Reimbursed-Engine 1 1,714.00 9,2t4.00 7,500.00 t,714.00 9,214.00 101-422-5-920-00 Fumiture.4 Equipment 160,000.00 OS/14/2014 2013 Aasigned Funds•Safety Houee& 178,300.00 336,5�.00 160,000.00 178,500.00 338,SOQ.00 101-431-5-130-00 Workmana Compenaetion 3b,370.00 OS/14/2014 Adjust Budgotto Actualforinaurancc -2,533,00 33.83�.00 36,370.00 -2,533.00 33,637.00 101-43t-S-421-00 In�urance 33,7I4.00 OSll4l2014 Adjust Budqet to Aetual for Imurance -3,998.OQ �1,7l6.OQ 35,714.00 -3,998.00 31,716,OQ 101-431-5-960•00 Strcet&Sidcwalk tmprovcmcnu 730,000.00 OS/14/2014 GGB Parkin$Lot To 101-417-5-940-00 -35,000.00 693,000.00 730,p04.00 -33,000.00 693,QOA.OQ 101-442-5-130-00 Workmans Compensation �,q�{g,pp OS/l4l2014 Adjust Budgetto Actualforinsurance -116.00 1,332.Q4 1.448.00 -116.00 1,3�2.QQ lO1-442-5-421-OQ Insurancc 543.OQ OS/t4/2014 Adjust Budget to Actual for Insunnce -48.00 495.00 543.00 -48.00 495.00 101-448-5-421-00 Insurance 8.qqp.� OS/14/2014 Adjust Budgetto Actualforinsurance -1,863.00 6,137.00 8,OOO.QO -1,863.00 6,137.00 10i-449-5-101-07 Clothing/Boot Allowance Zp,pp OSJi4/2014 Hillcrcst Aquatic Ctr/Lifcguards Unifc From IO1-451-5•426-17 1,500.00 1,320.00 20.00 I,500.00 1,520.00 GL-Budget Adjustment Detail(S/14/2014- 1:40 PM) Page 6 Acrount Number Arrount ncsrription 13eginning Budget Amaunt Budget bate Transuction Description Transfer Desrr[ption t b I-449-5-130-tl0 Wnrkmans Compenx�tion 8,164.00 b5/14/2014 AdjustCiudqetto Actualforin�urnnce -52b.00 7,644.00 8,164.OU -520.00 7,644.00 101-444-5-421-00 tnsur�nce 9,128.00 tl5/14/2014 Adjust Budgettu Aetualforinsuranee -9SS.A0 8,170.00 9,128.00 -958.00 8,I70.00 101-449-5-920-00 Fumiture&Equipment 43,000.00 OS/14/2014 2013 Asaigned Fudds-ADA Ramp 5,000.00 48,000.00 43,000.00 5,000,00 48,OQO.OQ 141-451-4-A46-03 Rocroation Program Fees 105,000.00 OSl14/2014 Anticipsted Rev/Dye&Daah Evsnt 14,OOQ.QO 119,000.00 103,000.00 14.000.00 I 19,000.00 10t-451-5-130-00 Workmane Com�nsation 1,869.00 OS/IA/2014 Adjust Hudgct ta Actual for[nsurancc -119A0 1,750.00 1,869.00 -119.OQ 1,750.00 101-A31-S-A41-00 Insurance 3,503.00 OS/IA/201�4 Ac�uat Budgot eo Actual for Inaurance -IS9.00 1,346.00 2,SOS.QO -1S4.U0 2,�46,� 101-451-3-42b-07 Recroetion Supplies 33,650.00 05/l4/2014 Antiaipatcd Expcnae/Dyc&Dash 1A,000.00 A7,6SO.W 33,bS0.QQ 14,OQO.QO 47,b34.00 101-451-5-�126•17 Unifortns l0,QQ0.00 OS/IAl2014 Hilkrest Aquatic CtdLifeguertis Unifc To lO1-449-S-101-07 -1,SQQ.OQ 8,SQ0.00 10,000.00 -i,S00.� 8,�00.00 ]01-452-5-130-00 Wo�kmans Compensation 24,088.00 OSl14/2014 Adjust Budget to Actua!for Insurance -1,752.00 2T,336.00 24,088.00 -1,752.QQ 22,336.OQ I01-452-5-421-00 Insurance 18,379.00 OS/14/2014 Adjust Budgetto Actualforinsurance -6,609.00 11,970.00 18,579.00 -6,609.00 11,970.00 141-452-5-422-03 Consulting/Engineerin� 4,O�Q.00 OS/l4/2014 2013 Assigned Funds-Fast Pitch Plan 15,000.00 19,OQ0.00 GL-Budgct Adjustment Dctail(5l14/2014- 1:40 PM) Pagc 7 Arrount Numbcr Account Descriptinn �eginning liudget Amount Budget UgCe Transuction Uescription Transfer Description 4,000.00 l S,OOOAO 19,OOOAO 101=452-5-911-00 Building&Structures U.00 OS/14/2014 2b13 Assigned Funds-Shelden Project 52,593.00 52,593.00 0.00 52,393.00 52,593.00 1(f1-452-5-920-00 Fumiture&Bquipment 0.00 OS/14/2014 2013 Assigned Funds-Playground Eqp 40,000.00 40,000.00 0.00 40,000.00 40,000.00 101-453-5-136-00 Workmana Compensation S88,OQ OS/l4/2014 Ac�just Budget to Actual for Inaurance -38,00 350.00 588.00 -38.00 SS0.00 101�4S3-S-421-00 Insurance ?,703.00 OS/14/2014 AQjuat Budget to Actual for Insurance -684.00 7,021.00 7.705.00 -b84.Q4 7,021.QQ 101-454-5-130-00 Work�ru�na Gompe�attoa 46,372.Q0 OS/14/2014 Adjust Budgetto Actualfortneurancc -2,617.Op 43,935.00 46,572.00 -2,617.00 43,9SS.OQ 101-454-5-421-00 Tnauranec $,313.OQ OS/14/2414 Ad)ust Budgetto Actuslforinsuranca -784.00 7,331.Q0 8,315.00 •784.�Q 7,531.OQ 101-4SS-3-l3Q-p0 Workmana Companeation 2,119.00 4S/14/2014 Ac�ust Budgct to Actual for lnaurance -135.00 1,984.OQ 2,119.00 -133.00 1,9&4.Q0 101-ASS-S-421-00 lnaumnce 8,484.Q0 OS/14l201A AQjust Budget W Actual far lnsura�c -697.00 7,787.00 8,484.00 -697.OQ 7,T87.W t01-495-5-�166-0I Economic Dcvelopment Grent 250,000.00 OS/l4/2014 Inccndvc grantbalance 899,I84.00 1,149,I84.Q0 250,000.00 899,184.00 1,149,184.00 212-000-5-466-01 Economic Deveopment Grent 15,833.00 OS/14/2014 Incentive grent balance 271,463.00 287,296.00 15,833.00 27I,463.00 287,296.00 212-000-7-899-00 Trapsfer out Generel Fund 1,048,IOI.00 OS/14/2014 FinanceCapital Equipment -1,048,101.00 0.00 GL-Budget Adjustment Dctail(5/14i2014- I:40 PM) pag�g Accnunt Nurnbcr Arrnunt Description BrginninY Budget Amount Budget Date Transnctinn Description Transfer bescrlption 1,048,101.00 -1,048,101.00 0,00 212-000-7-894-04 Trnnsfer out-Edgebrook 3g,2�3,pp OS/14/20t4 Finonce�epitxl�quipment •38,213.00 0.00 38,213.00 -38,213.00 0.00 2t3-000-5-470-04 BAN Loan Payabie 0.00 OS/14l2014 Pay loan on Di�estor Project A,625,000.00 4,625,0�.00 0.00 4,623,000.00 4,623,000.00 213-000-S-SSb-63 Eennomic Incentivc Grent 47,300.00 OS/IA/2014 Economic[ncentive C3rent 8t4,386.W 861,$8$,00 47,SQ0.00 814,3$B.AO 861,888.00 2�3-000-6-?OQ-01 Transferin Liquor O.pp OS/IA/2014 FinanccCapital 20,IOO.OQ 20,1Q0.00 o.o0 2o,ioo.00 so,iaa.00 213-000-6-7Q0-02 Transfer in Landflll p.pp OS/14J2014 Fi�anceCapital g90,00p.Op 89p,ppp,pp O.QO 89Q.OQQ.QQ 890.00O.QO 213-000-7-849-00 Tranafor out Gcnerel Fund 733,000.00 OS/14l2Q14 FinanceCapitalEquipment -733,0�.00 0.00 73a,QQ0.00 .733,OA0.00 0.00 213-OQO-7•899-01 Transfcr Qutto Airpoct 2,I19.930.QQ OS/14/2014 Financa capit4t project -2,119,p30.OQ O.QO 2,114,93Q.OQ -a,119,930.00 0.00 213-000-7-$99-U3 Transfer out-Swiftel C!P 293,t�10.00 OS/14/2014 Financc Capital Equipment -293,0OO.OQ O.QO 293,0OO.OQ -293,OOO.QO O.OQ 213-000-7-899-25 Transfee out-Main Ave S&34th 2,SOO,Q00.00 OS/14/2014 Finance capital project -2,500,000.00 0.00 2,SOO.Op0.00 -2,SQ0,000.00 0.00 213-U00-7-899-29 Transfcr out SA Scwer Exten 1,830,000.00 OS/14/201A Finance capital proj�t -1,850,000.00 O.OQ 1,850.000.00 -1.850,OW.00 0.00 213-000-7-899-30 Transfer out-Nature Park 350,000.00 GL-Budgct Adjustment Dctail(it14/2014- 1:A0 Pbi) pas�g Arcoant Numbcr Account Description i3e�inning Budget Amount Budget Dgte 'Cransaction Description Transfer llescriptinn OS/14/2014 rinencc capitai prnjcct -350,000.00 0.00 350,000.00 -350,000.00 0.00 224-000-4-663-SO Bond Prceeedg 0.00 OS/14/2014 Finance cepital equipment 968,880.00 968,880.00 0.00 968,880.00 968,880.00 224-000-5-440-01 Capitel 293,000.00 OS/14/2014 Finance capital equ�pmenl 673,880.00 968,880.00 293,000.00 6T5,880.00 9bN,8N0.00 224-t�0-6-700-04 Tranafer in Snies&Uae'fax 293,OQ0.� OS/14/2014 Flnance capital equipment -293,000.00 0.00 293,000.00 -293,000.00 0.00 280-Q00-4-6b3-SO Bond Procada O.QQ OS/14/2014 Finance capital projcct 350,000.00 330,OOO.QO 0.00 350,000.00 350,000.00 280-000•6•700-20 Transfcrin-Saloa&Use Tex 1,83�,OQQ.00 OS/14/2014 Ffnancc Capital Project -1,8SO,OOO.QO 0.00 1,850.000.00 -1,850,000,Q0 Q,OQ 282-000-5-130-00 Workmwn:Componsat{on 2,OSO.QO OS/14/20I4 Adjust Budgct to Actual for Inwranec -131.00 1,919.OQ 2,050.00 -131.00 1,919.QQ 282-000•5-421-QO (muran¢o 12Q.AQ QS/14/2014 Adjust Budget w Actual for lnarance 16.OQ 136.QQ 120.00 16.00 13b.00 282•000-5-470•11 Principal Paytncnt-SRF Loan 63,OOQ.OU OS/14/2014 Incrcasc budgeVSltF Prin Pay 2b,S00.Q0 9t,SQQ.OQ 65,000.00 26,500.00 91,SQ0.00 282-000-5-470-12 tnterese Payment-SRF Loan SS,QOO.AQ OS/l4l2014 Incroase budget/Interost Pey 81,500.00 136,500.00 55,000.00 RI,SOO.QO 136,SOU.00 S19-000-4-663-50 Bond Proceeds 0.00 OS/14/2014 Finance capital project 350,000.00 350,000.00 0.00 350,000.00 350,000.00 OL•Budgct Adjustmcnt Dctail(5/14/2014- 1:40 PM) Pagc 10 Arrnunt Numbcr Account Description Beginning Budgtt Amount �3udget Date Trunsaction Descriptian Transfer Description 519-000-6-70tl•04 Transferin-5�Ics&Usc Tax 350,000.00 05/14/2b14 Finence Cspital i'raject -350,n00.00 0.00 35U,000.0O -35C1,000.00 0.00 522-tl00-4-334•Og Cirnnt g2,g7g,pp OS/l4/2014 Remaining Grant Money 114,455.00 207,334.00 92,8'f4,00 114,455.00 207,334.00 522-000-4-653-SO Proceeds ti�orn BAN 319,621.00 OS/14/2014 Advance from Bnnd Anticipetion Note 3,880,379.00 4,200,000.00 319,621.00 3.880,379.00 4,200,pq0.0p 522-000-4-C69-02 MleceUauooua 0.04 OS/IA/2014 Reimbursement 500,000.00 xOQ,pOQ.00 0.00 500.000.00 500,000.00 522-000-5-422-03 Consulting - sp,ppp,pp OS/14/2014 2013 csnyaver budget for projeet 43,000,00 43,OOO.QO SO.OM1.00 43,000.00 9S.00Q.00 522-000-5-940-00 Qther Capiu�l 362,300.� OS/14/2014 2013 carryovor of budget for projcct 40U,b7b.00 7b3,17b.00 31�Z,500.00 400,67b.00 7b3,176.40 523-000-A-663-SO Bcmd Pmceeds p,p(1 03/!4l20t4 Financc Capital Project 4,2QQ,ODQ.Q4 4,200,OOQ.QO .,.�.. o.oa a,zta.cxm.00 a,zca,oaa.aa 523-000-5-422-03 Consultin�lEngin�ring O.Op OS/14/2014 Increase in budget �p0,ppp,� �(�,pqp,� �_ Q.00 20Q�OOQ.00 200,QOO.OQ 323-Q00-5-9q0.0p Other Cepital �,500,000.40 OS114/2014 Financc Capital Project I,Spp,Q00.00 q,Q�,OpO,Qp 2�SU0,000.00 1,500,000.00 4,�O,OQ0.00 523-000-6-'700-04 Ttansfer in 75%Salex 6t Usc 2,500,000.00 OS/14/2014 Finance Capital Project -2,SOO.00i1.00 0.00 a,soo,000.00 -s,soo,000.00 a.00 601-000-4-381-11 Sales/Opereting Agree Liq/Wine 1,450,000.00 OS/14/2014 invoicc ovcrcidc fcc moved ro Financc To 101-405-4-381-11 -1,450,000.00 0.00 t,450,000.00 -1,450,000.00 0.00 GL-Budgct Adjustmcnt I�tail(5/1412014- 1:40 PM) Pa�c I 1 Account Numbcr Account Desrription Beginnin�Budgct Amount Budget Dgte Transaction Description Transfpr Uescrtption 601-000-4-381-31 Sule�/Opereting Agrtement Beer i,650,OC10.0U OS/14/2014 ]nvoice nvorride fee moved to Pinence To 101-405-4-361•31 •1,650,OOO.dO 0.00 I,650,000,00 -1,650,000.00 0.00 601-Ob0-4-381-32 SaleslOperating Agreement•Malt 2,634,000.00 OS/14/2014 Invoice ovorride fee movod tn Finence 'Po I01-405-4-381-32 -2,b34,00d.00 0.00 2,634,000.00 -2,634,000.00 0.00 601-000-4-381-98 Operating Agreement Markup 10% 425,0�.00 OS/!4/2014 Invoice overeide fee moved w Fiaance To 101•405-4-381-98 -A23,000.00 0.00 425.000.00 -425,0OO.OQ 0.00 601-000-4-3&1-99 Operadng Agreement Markup 11Yo 139,500.00 OS/i4/2014 lnvoice override Pee moved to Finanae To l01-405•4-381•99 -159,SOO.OQ b.00 159,500.00 .159,304.00 0.00 601-000-4-6b3-SO Band Procaeds 0.00 05/14/2014 Finance capital equipment 2Q,100.()0 10,100.00 0.00 20,IQO.OQ 20,1Q�.00 601-000-4-842-d7 Purchases/[,iquor-Bera -I,ASO,OOO.W OS/14/2014 Cloae line iteMmoved to Financc 1,4SO,OOQ.00 Q,QQ •1,450,000.00 1,430,000.00 0.00 601-(�0-4-852-08 PutchaseslBeer-Bars -4,230,000.00 OS/14/2014 Closo linc item/movcd to Financc 4,2SO,OOQ.00 0.00 � -4,250�000.00 4.250,QOO.QQ Q.OQ 601-000-5-101-� RcgulAr Pay 258,91Q.Q4 OS/14/Z014 Pmployee Resignation -30,QOQ.OQ 228,910.00 258,910.00 -30,Op0.00 228,910.QQ 601-000-5-130-00 Worlcmans Compensation 2,744,00 OS/14/2014 Adjust Budyet to Actuel for L�surance 488.00 3,232.00 2,744.00 488.00 3,231.00 601-000-5-421-00 Inaurancc 4,875.00 OS/14/2014 Adjust Budget to Acwal for Insorance -207.00 4,668.00 4,875.OQ -2p7.Q0 4,668.00 601-0�-7-899-00 Transfer out Geaeral Fwxl 700,000.00 OS/14/2014 Adjust for loss of override fee -523,600.00 176,400.00 GL-Budget Adjustmcnt Detail(5114/2014- I:40 PM) Pagc 12 Account Number Account Desrriptfon Beginning Budget Amount l3udget Date 'I'ransuction bescription Tr�nsfer De�cription '700,000.00 -523,600.00 176,40tl,00 dOt-b00-7-899-20 Transfer Out to I'ublic(mprnve p,dp OS/14/2014 TrunsfertoPubliclmprovementFund 20,100.00 20,100.00 0.00 20,100,00 20,100,00 606-000•4-663-SU Bond Procceds 0.00 OS114/2014 Finence capitsl improvement 2,119,930.00 2,119,930.f� 0.00 2,1 I9,430.00 2,119,930,00 606-000-5-130-00 Workman:Compentation Z,273,pp 05/14/2014 Adjuat BudQetto Actuelforlttsurance 801.00 3,074.00 2,273.00 801.OQ 3,074.00 606-000-5-421-00 inaurance 10,833.00 OSl14/2014 Adjust Hudget to Actuel#'o�(nsurance -1,250.00 9,583.00 1Q.833.00 •1,250.00 9,583.00 60b-OQO-6-700-04 Tranakr In Salca&Upa 7'ax 2,114,930.00 OS/14/2014 Financa CapiUil Projact -2,119,930.00 0.00 2,I 19,93Q.40 -2,119,930.00 Q.00 647-OQO-A-663-SO Bond Procecds p.q0 QS/14/2014 FinAnce capital impeovamants 91,213.00 91,213.Op O.OQ 91,113.Q0 A1,213.OQ b07-000-5•130-00 Workmana Compcnaation 5.971.00 OS/14/2014 Adjust Budget w Actual for Insurance -435.00 S,S36.00 5,971.00 -435.00 S,S14.00 607-000-3-421-00 Insuronce q,g�4.pp OS/14/2014 Adjust Budgct to Actual for Ineurance -161.Q0 4,A63.00 4.624.00 -161.00 4,463.Q0 607-000-6-700-04 Transferin 25%Saloa&Usc 38,213,00 `OS/14/2014 Finance Capital Equipmest -38,213.00 0.00 38,213.00 -38,213.00 0.00 607-000-6-700-09 Transfer in 759�o Public Impravc 53,000.00 OSJIM2014 Finance capital equipment -53,000.00 0.00 53,000.00 -53,000.00 0.00 612-000-5-130-00 Workmans Compensation 15,242.00 OS/14/2014 Adjust Budget to Actual for I�surance 1,81d.00 17,05&.00 GI.-Budgct Adjustment Dctail(5/14/2014- 1:40 PM) Pagc 13 Account Numbcr Accnunt bescription Beginning Budget Ambunt Budget bate 'Cransaction Descriptinn Tr�nsfcr Description 15,242.00 1,816.00 17,058.00 612-000-5-421-00 Insurence 16,d$9.OU OS/14/2014 Adjust Budget to Actusl fur Insurence -1,564.Ob 15,125,00 16,689.00 -1,564.00 15,125.00 625-000-4-663-SO Bond Proceeda 0.00 OS/14/2014 Finance capital equipment 890,000.00 890,000.00 0.00 890,000.00 890,000.00 623-000-5-130-00 Worktneas Compeaeadon 8,124.00 OS/14/2014 A�just Budget to Actual for Insurance 2,879.00 11,003.00 8,124.00 2,879.00 II,003.00 613-000-5.421-00 Insuranca �,q3�,pp OS/14/2014 Adjust Budgct ro Actual tbr Ineurance -1,634.� 5,597.00 7.231.00 -1,634.()a S,S97.00 625-OOp-7-849-20 Tranafer Public[mprovament p,(�► OS/14l20 i 4 Tranafer to PubHc lmprovement B90,p00.0p 89p,Opp.pp 0.00 840�OQQ.QO 890�OQ0.00 630-000.5-421-QO Insunnce a,qpF,pp OS/14R014 AdJuat Budget to Actual for Inauranco -2A3.00 2,b63.00 2,406.00 -243.OQ 2.bb3.QQ GL-Budgct Adjustmcnt Detail(S/14/2014- 1:40 PM) p��14