Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
AGENDA REPORT 1996 1016 CC REG ITEM 07K
T ..K*-) AGENDA REPORT CITY OF MOORPARK /. TO: Honorable City Council FROM: Richard Hare, Deputy City Manager Prepared By: SG Shellabarger, Recreation Pu DATE: September 6, 1996 (CC Meeting of October 2, 1996) SUBJECT: Consider Resolution 96 -____ Approving a Budget Amendment in the Amount of $12,232.62 BACKGROUND The City of Moorpark has offered Summer Camp at Arroyo Vista Community Park since 1994. Camp Moorpark has seen increased success and popularity. The following table shows gross revenues for the history of the program: YEAR REVENUE 1994 $30,214 1995 $43,520 1996 $75,243 Camp runs from June to September, Monday through Friday from 10:00 am to 4:00 pm with extended care from 6:30 am to 6:00 pm. A change from a 3 day -a -week minimum enrollment to 2 day -a -week minimum enrollment, as well as the addition of attractive features to the camp schedule of activities, caused a sharp participant increase for 1996. At the peak of our season, Camp Moorpark had an enrollment of over 100 children per day. DISCUSSION Staff had compiled the direct costs and revenues for Camp Moorpark. Revenue projections for the 1996 program were conservative when the budget was prepared. Increased registrations led to additional revenues and increased expenditures for required supplies, materials and staff. Because of the program's higher than expected enrollment, the expenditure budget for Camp Moorpark was insufficient to meet the program's needs. An additional 20% has been added to the requested amendment amounts which will serve as a reserve for Camp start up costs for 1997 Camp Moorpark as approximately 20% of the camp season occurs in June, the last month of FY 96/97. REVENUES TOTAL 1996 CAMP REVENUE $75,243.47 1996 Camp Revenues in FY 95/96 $14,622.00 1996 Camp Revenues in FY 96/97 $60,621.47 1997 Revenues in FY 96/97 (20% Projected) $15,048.69 TOTAL FY 96/97 CAMP REVENUE PROJECTION $75,670.16 FY 96/97 ADOPTED BUDGET $40,000.00 VARIANCE $35,670.16 UU�i'� UU Memorandum to the Honorable City Council Budget Amendment for Camp Moorpark September 6, 1996 Page 2 EXPENDITURES TOTAL 1996 CAMP EXPENDITURE $49,250.87 1996 Camp Expenditures in FY 95/96 $4,948.43 1996 Camp Expenditures in FY 96/97 $44,302.44 1997 Expenditures in FY 96/97 (Budgeted) $400.00 1997 Expenditures in FY 96/97 (Projected 209 of total 1996 Expenditure) $9,850.17 TOTAL FY 96/97 CAMP EXPENDITURE PROJECTION $54,552.61 FY 96/97 ADOPTED BUDGET $42,320.00 BUDGET AMENDMENT REQUEST $12,232.62 96197 ADOPTED BUDGET LESS PROJECTED FINAL RECOMMENDATION (Roll Call Vote Required) s That the City Council adopt Resolution 96 Approving a Budget Amendment in the Amount of $12,232.62 Camp Revenues LINE ITEM DATE DESCRIPTION ACTUAL TO 8/31 PROJECTED AFTER 8/31 01.3.400.496 6/7/96 95/96 Earned $4,771.00 $4,771.00 01.3.400.496 6/14/96 95/96 Earned $2,392.00 $2,392.00 01.3.400.496 6/18/96 95/96 Earned $61.00 $61.00 01 .3.400.496 6/21/96 95/96 Earned $4,528.00 $4,528.00 01 .3.400.496 6/21/96 95/96 Earned $108.00 $108.00 01.3.400.496 6/28/96 95/96 Earned $2,313.00 $2,313.00 01.3.400.496 6/28/96 95/96 Earned $449.00 $449.00 Registration Fee $14,622.00 $14,622.00 FY 94/95 Only LINE ITEM DATE DESCRIPTION ACTUAL PROJECTED TO 8/31 AFTER 8/31 100.700.7001 .000.3702 DEFERRED 96/97 To Be Earned $3,687.00 $3,687.00 100.700.7001.000.3702 DEFERRED 96/97 To Be Earned $2,813.00 $2,813.00 100.700.7001.000.3702 DEFERRED 96/97 To Be Earned $1,941.00 $1,941.00 100.700.7001-000.3702 DEFERRED 96/97 To Be Earned $432.00 $432.00 100.700.7001.000.3702 DEFERRED 96/97 To Be Earned $1,546.07 $1,546.07 100.700.7001 .000.3702 DEFERRED 96/97 To Be Earned $5,100.00 $5,100.00 100.700.7001 .000.3702 DEFERRED 96/97 To Be Earned $287.00 $287.00 100.700.7001-000.3702 DEFERRED 96/97 To Be Earned $47.00 $47.00 100.700.7001.000.3702 7/9/96 96/97 Earned $4,569.00 $4,569.00 100.700.7001.000.3702 7/12/96 96/97 Earned $7,646.00 $7,646.00 100.700.7001.000.3702 7/12/96 96/97 Earned $691.00 $691.00 100.700.7001.000.3702 7/16/96 96/97 Earned $761.00 $761.00 100.700.7001.000.3702 7/23/96 96/97 Earned $5,967.00 $5,967.00 100.700.7001.000.3702 7/26/96 96/97 Earned $75.00 $75.00 100.700.7001.000.3702 7/30/96 96/97 Earned $5,916.00 $5,916.00 100.700.7001.000.3702 7/30/96 96/97 Earned $239.00 $239.00 100.700.7001.000.3702 7/30/96 96/97 Earned $65.00 $65.00 100.700.7001.000.3702 7/30/96 96/97 Earned $125.00 $125.00 100.700.7001.000.3702 8/6/96 96/97 Earned $6,221.50 $6,221.50 100.700.7001.000.3702 8/9/96 96/97 Earned $171.00 $171.00 100.700.7001.000.3702 8/9/96 96/97 Earned $4,040.00 $4,040.00 100.700.7001.000.3702 8/16/96 96/97 Earned $68.00 $68.00 100.700.7001.000.3702 8/16/96 96/97 Earned $75.00 $75.00 100.700.7001.000.3702 8/16/96 96/97 Earned $4,170.00 $4,170.00 100.700.7001.000.3702 8/20/96 96/97 Earned $51.00 $51.00 100.700.7001.000.3702 8/20/96 96/97 Earned $3,401.00 $3,401.00 100.700.7001.000.3702 8/30/96 96/97 Earned $265.00 $265.00 100.700.7001.000.3702 8/30/96 96/97 Earned $2,009.80 $2,009.80 100.700.7001.000.3702 8/30/96 96/97 Earned $30.00 100.700.7001.000.3702 8/30/96 96/97 Earned $228.10 100.700.7001.000.3702 7/30/96 Refund ($66.00) ($66.00) 100.700.7001.000.3702 7/30/96 Refund ($75.00) ($75.00) Page 1 oo o2 Camp Revenues LINE ITEM DATE DESCRIPTION ACTUAL PROJECTED TO 8/31 AFTER 8/31 100.700.7001.000.3702 7/30/96 Refund ($239.00) ($239.00) 100.700.7001.000.3702 7/30/96 Refund ($171.00) ($171.00) 100.700.7001.000.3702 7/30/96 Refund ($116.00) ($116.00) 100.700.7001.000.3702 7/30/96 Refund ($92.00) ($92.00) 100.700.7001 .000.3702 7/30/96 Refund Fee $10.00 $10.00 100.700.7001 .000.3702 7/30/96 Refund Fee $10.00 $10.00 100.700.7001.000.3702 7/30/96 Refund ($78.00) ($78.00) 100.700.7001.000.3702 7/30/96 Refund ($280.00) ($280.00) 100.700.7001.000.3702 8/31/96 Refund ($75.00) ($75.00) 100.700.7001-000.3702 8/31/96 Refund ($68.00) ($68.00) 100.700.7001 .000.3702 8/31/96 Refund ($89.00) ($89.00) 100.700.7001 .000.3702 8/31/96 Refund ($51.00) ($51.00) 100.700.7001 .000.3702 8/31/96 Refund ($209.00) ($209.00) 100.700.7001 .000.3702 8/31/96 Refund ($76.00) ($76.00) 100.700.7001 .000.3702 8/31/96 Refund ($183.00) ($183.00) 100.700.7001 .000.3702 8/31/96 Refund Fee $10.00 $10.00 100.700.7001-000-3702 8/31/96 Refund ($346.00) ($346.00) 100.700.7001 .000.3702 8/31/96 Refund Fee $10.00 $10.00 100.700.7001 .000.3702 8/31/96 Refund ($102.00) ($102.00) 100.700.7001 .000.3702 8/31/96 Refund ($36.00) ($36.00) 100.700.7001-000.3702 8/31/96 Refund Fee $10.00 $10.00 Registration Fee Total $60,077.37 $60,335.47 FY 96/97 Only ACTUAL PROJECTED FINAL LINE ITEM DATE DESCRIPTION ACTUAL PROJECTED TO 8/31 FINAL 100.700.7001.000.3711 7/12/96 Admin Fee $180.00 $180.00 100.700.7001.000.3711 7/16/96 Admin Fee $20.00 $20.00 100.700.7001-000.3711 8/31/96 Admin Fee $20.00 $20.00 Admin Fee TOTAL $200.00 $220.00 FY 96/97 Only LINE ITEM DATE DESCRIPTION ACTUAL PROJECTED TO 8/31 FINAL 100.700.7001.000.3799 7/12/96 T -Shirt $42.00 $42.00 100.700.7001.000.3799 7/16/96 T -Shirt $24.00 $24.00 Other Fees TOTAL $66.00 $66.00 FY 96/97 Only Page 2 OOU103 Camp Revenues ACTUAL PROJECTED TOTAL 1996 CAMP REVENUE $74,965.37 $75,243.47 1996 Camp Revenues in FY 95/96 $14,622.00 1996 Camp Revenues in FY 96/97 $60,343.37 $60,621.47 1997 Revenues in FY 96/97 (20% Projected) $15,048.69 TOTAL FY 96/97 CAMP REVENUE PROJECTION $75,670.16 FY 96/97 ADOPTED BUDGET $40,000.00 VARIANCE $35,670.16 96197 PROJECTED FINAL LESS ADOPTED BUDGET Page 3 000 -� 04 Camp Expenditures LINE ITEM DATE EXPENDITURE ACTUAL PROJECTED TO 8/31 FINAL 01.4.149.994 6/19/96 Wildwood Bus $210.45 $210.45 01 .4.149.994 6/21/96 Pool Bus $180.90 $180.90 01.4.149.994 6/26/96 Bowling Bus $180.90 $180.90 01 .4.149.994 6/28/96 Pool Bus $180.90 $180.90 01 .4.149.994 3/31/96 Training Video $181.29 $181.29 01 .4.149.994 3/31/96 Paper Direct $101.67 $101.67 01 .4.149.994 5/31/96 Pizza Party $46.35 $46.35 01 .4.149.994 5/31/96 WorldWide Games $516.75 01 .4.149.994 5/31/96 Hardware $34.66 $34.66 01.4.149.994 6/29/96 T- Shirts $821.66 $821.66 01 .4.149.994 6/29/96 Petty Cash $48.83 $48.83 01 .4.149.994 6/29/96 Smart & Final $154.22 $154.22 01 .4.149.994 6/30/96 S &S Crafts $232.36 $232.36 01.4.149.994 6/30/96 Kmart - -file cabinet $98.99 $98.99 01.4.149.994 6/30/96 T- Shirts $167.25 $167.25 01 .4.149.994 3/31/96 MUSD Flyers $321.75 $321.75 01.4.149.994 6/30/96 Hugg -- Gymnastics $502.50 $502.50 01 .4.149.994 6/30/96 Harley's Simi Bowl $142.00 $142.00 01 .4.149.994 6/30/96 Pony Rides $825.00 $825.00 Camp Moorpark 95/96 Total $4,431.68 $4,948.43 LINE ITEM DATE EXPENDITURE ACTUAL PROJECTED TO 8/31 FINAL 100.700.7001.000.9003 7/5/96 Payroll $1,812.60 $1,812.60 100.700.7001 .000.9003 7/31/96 Payroll $5,289.29 $5,289.29 100.700.7001.000.9003 8/8/96 Payroll $5,981.36 $5,981.36 100.700.7001.000.9003 8/23/96 Payroll $5,313.54 $5,313.54 100.700.7001.000.9003 9/6/96 Payroll $4,600.00 100.700.7001.000.9003 9/20/96 Payroll $2,300.00 Payroll Total $18,396.79 $25,296.79 LINE ITEM DATE EXPENDITURE ACTUAL PROJECTED TO 8/31 FINAL 100.700.7001 .000.9004 7/31/96 Overtime $21.21 $21.21 100.700.7001.000.9004 8/9/96 Overtime $8.56 $8.56 Overtime Total $29.77 $29.77 Page 1 0 0 b 05 Camp Expenditures LINE ITEM DATE EXPENDITURE ACTUAL PROJECTED TO 8/31 FINAL 100.700.7001.000.9012 7/5/96 Unemployment Insurance $61.63 $1,812.60 100.700.7001 .000.9012 7/31/96 Unemployment Insurance $177.86 $177.86 100.700.7001.000.9012 8/8/96 Unemployment Insurance $202.75 $202.75 100.700.7001.000.9012 8/23/96 Unemployment Insurance $180.66 $180.66 100.700.7001.000.9012 9/6/96 Unemployment Insurance $160.00 100.700.7001.000.9012 9/20/96 Unemployment Insurance $60.00 Unemployment Insurance Total $622.90 $2,593.87 LINE ITEM DATE EXPENDITURE ACTUAL PROJECTED TO 8/31 FINAL 100.700.7001 .000.9013 7/31/96 Retirement Contributions $12.90 $12.90 100.700.7001.000.9013 8/8/96 Retirement Contributions $3.45 $3.45 100.700.7001.000.9013 8/23/96 Retirement Contributions $7.00 100.700.7001.000.9013 9/6/96 Retirement Contributions $3.50 Retirement Contributions Total $16.35 $26.85 LINE ITEM DATE EXPENDITURE ACTUAL PROJECTED TO 8/31 FINAL 100.700.7001-000.9014 7/5/96 Medicare & Social Security $26.28 100.700.7001 .000.9014 7/31/96 Medicare & Social Security $76.87 $76.87 100.700.7001-000.9014 7/31/96 Medicare & Social Security $388.77 $388.77 100.700.7001-000.9014 8/8/96 Medicare & Social Security $86.85 $86.85 100.700.7001-000.9014 8/8/96 Medicare & Social Security $407.03 $407.03 100.700.7001.000.9014 8/23/96 Medicare & Social Security $77.05 $77.05 100.700.7001.000.9014 8/23/96 Medicare & Social Security $398.51 $398.51 100.700.7001.000.9014 9/6/96 Medicare & Social Security $500.00 100. 700.7001 .000.9014 9/20/96 Medicare & Social Security $250.00 Medicare & Social Securi• Total $1,435.08 $2,211.36 LINE ITEM DATE EXPENDITURE ACTUAL PROJECTED TO 8/31 FINAL 100.700.7001.000.9199 7/17/96 Movie Trip (Melody) $52.00 $52.00 100.700.7001.000.9199 7/17/96 CPR Course $270.00 $270.00 100.700.7001.000.9199 7/17/96 Movie Trip (Mann) $231.00 $231.00 100.700.7001.000.9199 7/24/96 Magic Mountain $1,355.00 $1,355.00 100-700.7001-000.9199 7/30/96 Union Ice $545.58 $545.58 100.700.7001.000.9199 7/12/96 Pool Bus $228.03 $228.03 100. 700.7001 .000.9199 7/16/96 Dodger Bus $268.21 $268.21 100.700.7001.000.9199 7/19/96 Pool Bus $224.88 $224.88 100.700.7001-000.9199 7/24/96 Magic Mountain Bus $342.35 $342.35 100.700.7001-000.9199 7/31/96 Chuck E. Cheese Bus $180.90 $180.90 100.700.7001.000.9199 7/26/96 Pool $210.45 $210.45 100.700.7001-000.9199 7/31/96 Monarch (Shirts) $513.92 $513.92 100.700.7001-000.9199 7/5/96 Pool Bus $198.49 $198.49 100.700.7001-000.9199 8/30/96 Movie Trip Bus Bus $230.85 $230.85 Page 2 Camp Expenditures LINE ITEM DATE EXPENDITURE ACTUAL PROJECTED TO 8/31 FINAL 100.700.7001.000.9199 7/31/96 Chuck E. Cheese $460.37 $460.37 100.700.7001 .000.9199 8/31/96 Dodger Tickets $564.00 $564.00 100.700.7001 .000.9199 8/14/96 Discovery Zone $273.00 $273.00 100.700.7001 .000.9199 8/2/96 Pool Bus $180.90 $180.90 100.700.7001.000.9199 8/20/96 Gymnastics $427.50 $427.50 100.700.7001.000.9199 8/8/96 Woodworking $544.00 $544.00 100.700.7001 .000.9199 8/31/96 Pony Rides $300.00 $300.00 100.700.7001 .000.9199 8/7/96 Roller Rink $290.50 $290.50 100.700.7001 .000.9199 8/21/96 Space Station $186.00 $186.00 100.700.7001 .000.9199 7/30/96 Jolly Jump $69.00 $69.00 100.700.7001 .000.9199 6/21/96 Pool $75.00 100.700.7001.000.9199 7/5/96 Pool $45.00 100.700.7001.000.9199 7/12/96 Pool $96.00 100.700.7001.000.9199 7/19/96 Pool $94.50 100.700.7001.000.9199 7/26/96 Pool $99.00 100.700.7001.000.9199 7/29/96 Karate $250.00 100.700.7001.000.9199 8/2/96 Pool $96.00 100.700.7001-000.9199 8/7/96 Roller Rink Bus $230.00 100.700.7001-000.9199 8/9/96 Pool Bus $230.00 100.700.7001.000.9199 8/9/96 Pool $96.00 100.700.7001 .000.9199 8/14/96 Discovery Zone Bus $230.00 100.700.7001-000.9199 8/16/96 Pool Bus $230.00 100.700.7001.000.9199 8/16/96 Pool $96.00 100.700.7001-000.9199 8/21/96 Space Station Bus $230.00 100.700.7001 .000.9199 8/23/96 Pool Bus $230.00 100.700.7001.000.9199 8/23/96 Pool $96.00 100.700.7001 .000.9199 8/26/96 Paint Pals $200.00 100.700.7001 .000.9199 8/28/96 Zoo Bus $230.00 100.700.7001.000.9199 8/28/96 Zoo $172.00 100.700.7001-000.9199 8/30/96 Pool Bus $230.00 100.700.7001.000.9199 8/30/96 Pool $96.00 Services Total $8,146.93 $11,498.43 LINE ITEM DATE EXPENDITURE ACTUAL PROJECTED TO 8/31 FINAL 100.700.7001.000.9225 7/17/96 Cake $19.99 $19.99 100.700.7001.000.9225 7/17/96 Supplies $49.04 $49.04 100.700.7001 .000.9225 7/9/96 Smart & Final $235.92 $235.92 100.700.7001 .000.9225 7/8/96 Smart & Final $127.00 $127.00 100.700.7001 .000.9225 7/25/96 Smart & Final $89.86 $89.86 100.700.7001 .000.9225 7/26/96 Smart & Final $83.71 $83.71 100.700.7001 .000.9225 8/6/96 Smart & Final $147.96 $147.96 100.700.7001 .000.9225 7/31/96 Smart & Final $173.32 $173.32 100.700.7001 .000.9225 7/20/96 Smart & Final $34.86 $34.86 Page 3 060107 Camp Expenditures LINE ITEM DATE EXPENDITURE ACTUAL TO 8/31 PROJECTED FINAL 100.700.7001 .000.9225 8/30/96 General Supplies $94.24 $94.24 100.700.7001 .000.9225 8/31/96 Oriental Trading $251.30 $251.30 100.700.7001 .000.9225 8/31/96 General Supplies $47.01 $47.01 100.700.7001 .000.9225 8/31/96 Smart & Final $158.24 $158.24 100.700.7001.000.9225 7/8/96 Oriental Trading $144.81 100.700.7001 .000.9225 7/8/96 US Toy $87.95 100.700.7001.000.9225 7/17/96 Conejo Lock & Key $205.92 100. 700.7001 .000.9225 ENCUMBERED Smart & Final $100.00 100. 700.7001 .000.9225 ENCUMBERED Smart & Final $100.00 100.700.7001 .000.9225 ENCUMBERED Smart & Final $152.04 100.700.7001 .000.9225 ENCUMBERED S &S Crafts $292.20 100.700.7001 .000.9225 ENCUMBERED Smart & Final $50.00 Supplies Total $1,512.45 $2,645.37 TOTAL 1996 CAMP EXPENDITURE $49,250.87 1996 Camp Expenditures in FY 95/96 $4,948.43 1996 Camp Expenditures in FY 96/97 $44,302.44 1997 Expenditures in FY 96/97 (Budgeted) $400.00 1997 Expenditures in FY 96/97 (20% Projected) $9,850.17 TOTAL FY 96197 CAMP EXPENDITURE PROJECTION $54,552.61 FY 96/97 ADOPTED BUDGET $42,320.00 BUDGET AMENDMENT REQUEST $12,232.61 96197 ADOPTED BUDGET LESS PROJECTED FINAL Page 4 oou Js