Transcript LPSS Budget Workshop 04/18/02

Lafayette Parish School System
Child Nutrition Department
Proposed Budget for Fiscal Year 2002-2003
Highlights:
Increase in federal reimbursement due to the 4-year old
program for all the school year.
Completion of computerization update and networking
of all cafeterias to main frame computer $97,000.
Major equipment update in cafeterias $439,500.
Fund Balance:
June 30, 3002 (projected)
Proposed budget for FY 2002 - 2003
June 30, 2003 (projected)
$ 1,521,160
$ (512,352)
$ 1,008,808
Lafayette Parish School System
Proposed Budget for Child Nutrition for FY 2002 - 2003
Notes
Note #1
The 4-year old program that started in January 2001 increased Federal sales for lunch, breakfast, and snacks. This increase will continue for the
entire school year. The Federal reimbursement historically increases by at least 2% each year.
Note #2
New hires in February 2002, increased employee payroll and decreased the substitute payroll. This increase reflects the balance of the change for a
whole year.
Note #3
Fringe benefits increase due to: 1) the increase in employee payroll; 2) the retirement cost increased by 2% or $59,200; and 3) the group
hospitalization premiums increased $86,000.
Note #4
Food cost increase due to increased sales; electricity increase due to increased sales; and grease traps expense increase due to increased sales.
Note #5
Equipment Purchases: $439,500.
During the past 3 years, the purchases of equipment averaged less than $87,000 per year. A major refurbishing is planned for FY 2002-2003 (see
attached listing of planned purchases of equipment by school).
Note #6
Computerizaton Update and Networking: $97,000.
The central office of the Child Nutrition Department approves over 15,000 free and reduced applications annually, produces and distributes rosters
daily, as procesed, for the cafeteria managers to manually input and update. The networking will allow the central office to process the
applications, download daily via the network and each cafeteria's roster will be automatically updated, eliminating manual input and insuring that
all cafeteria rosters are correct. This will also connect all cafeterias to the bon appetit software in the main frame. This will allow for the
maintenance and updating of only the main frame software instead of each individual school.
Actual
FY 2000-2001
Fund Balance
Beginning
Summer feeding
Profit for school year
Ending Fund Balance
$
$
961,866 $
(35,964)
547,835
1,473,737 $
Projected
FY 2001-2002
1,473,737
47,423
1,521,160
Proposed
FY 2002-2003
$
$
1,521,160
(512,352)
1,008,808
The major refurbishing of equipment and the cost of networking ($536,500) has reduced the projected fund balance to
$1,008,808. The resultant fund balance is still at a reasonable level for this fund.
Lafayette Parish School System
DEBT SERVICE FUNDS
Combining Statements of Revenues, Expenditures, and Changes in Fund Balance
FY 2002 - 2003
BUDGET
Sinking
Fund
REVENUES:
Ad Valorem Taxes
Sales Taxes
Interest
Total Revenues
EXPENDITURES:
Pension Fees/General Admin.
$
$
$
9,556,639
86,000
9,642,639
$
13,400
Debt Service:
Principal Reduction
Interest Payments
Total Expenditures
Other Financing Sources/Uses:
Transfers In
Transfers Out
Transfer to Capital Improvement
Transfer to Minor Ren/Imp.
Total Other Financing Sources/Uses
Sales Tax Revenue Bonds
Reserve
Fund
$
190,000
190,000
$
-
4,555,000
5,000,780
$
$
$
Excess (Deficit)
9,569,180
190,000
(500,000)
(310,000)
$
$
$
9,556,639
276,000
9,832,639
$
13,400
$
$
$
(236,541)
-
(190,000)
(190,000)
Total
General
Obligation Bonds
School
District No. 1
$
$
593,660
27,032
620,692
$
593,660
9,556,639
303,032
10,453,331
$
44,000
$
57,400
4,555,000
5,000,780
$
$
$
-
9,569,180
190,000
(690,000)
(500,000)
Total
460,000
178,943
5,015,000
5,179,723
$
682,943
$
$
-
$
$
(236,541)
$
(62,251)
10,252,123
190,000
(690,000)
(500,000)
(298,792)
Beginning Fund Balance (Deficit)
$
3,389,862
$
9,569,393
$
12,959,255
$
988,944
$
13,948,199
Ending Fund Balance
$
3,153,321
$
9,569,393
$
12,722,714
$
926,693
$
13,649,407
Lafayette Parish School System
TOTAL BONDS OUTSTANDING PER YEAR
Outstanding Principal Balances
FY 2002 - 2003
FY Ending
General
Sales Tax
Total Outstanding
Years
June 30
Obligation Bonds (1)
Revenue Bonds
For the Year
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
$
3,745,000
3,285,000
2,805,000
2,300,000
1,770,000
1,210,000
620,000
$
101,000,000
96,445,000
91,635,000
86,560,000
81,210,000
75,565,000
69,610,000
63,325,000
56,740,000
49,850,000
42,635,000
35,075,000
29,120,000
22,880,000
16,730,000
10,290,000
3,545,000
1,880,000
965,000
(1) Debt service of the General Obligation Bonds is funded by property taxes.
$
104,745,000
99,730,000
94,440,000
88,860,000
82,980,000
76,775,000
70,230,000
63,325,000
56,740,000
49,850,000
42,635,000
35,075,000
29,120,000
22,880,000
16,730,000
10,290,000
3,545,000
1,880,000
965,000
Lafayette Parish School System
SALES TAX REVENUE BONDS
Outstanding Principal Balances
FY 2002-2003
1994 Bonds
June 30, 2002
$
Principal Reduction
June 30, 2003
$
(1,015,000)
$
Principal Reduction
June 30, 2004
14,800,000
1995 Bonds
13,785,000
12,710,000
$
(355,000)
$
(1,075,000)
$
6,455,000
1998 Bonds
6,100,000
5,730,000
$
(2,380,000)
$
(370,000)
$
57,845,000
1999 Bonds
55,465,000
52,960,000
$
(420,000)
$
(2,505,000)
$
9,900,000
2001 Bonds
9,480,000
9,025,000
$
(385,000)
$
(455,000)
$
12,000,000
Total
11,615,000
(4,555,000)
$
(405,000)
$
11,210,000
101,000,000
96,445,000
(4,810,000)
$
91,635,000
Lafayette Parish School System
CONSOLIDATED SCHOOL DISTRICT #1
General Obligation Bonds
Outstanding Principal Balances
FY 2002-2003
SERIES 1993
June 30, 2002
$
Principal Reduction
June 30, 2003
(460,000)
$
Principal Reduction
June 30, 2004
3,745,000
3,285,000
(480,000)
$
2,805,000
Lafayette Parish School System
FUTURE DEBT SERVICE REQUIREMENTS
Principal & Interest
FY 2002-2003
Year Ending
General
Sales Tax
Years
June 30
Obligation Bonds
Revenue Bonds
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
2003
2004
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
Total
$
$
638,943
638,703
641,863
643,380
647,940
650,500
651,000
0
0
0
0
0
0
0
0
0
0
0
0
4,512,329
$
9,555,780
9,558,356
9,557,501
9,551,570
9,550,506
9,549,856
9,553,590
9,559,630
9,557,586
9,561,055
9,569,393
7,611,060
7,617,390
7,234,215
7,236,140
7,238,800
1,842,250
1,009,000
1,013,250
$ 145,926,929
Total
$
$
10,194,723
10,197,059
10,199,364
10,194,950
10,198,446
10,200,356
10,204,590
9,559,630
9,557,586
9,561,055
9,569,393
7,611,060
7,617,390
7,234,215
7,236,140
7,238,800
1,842,250
1,009,000
1,013,250
150,439,258
Lafayette Parish School System
Sales Tax Fund Budget
FY 2002 - 2003
Combining Statement
'65 Tax
1%
Revenues:
LPSS 1965 Sales Tax
LPSS 1988 Sales Tax
LPSS 2002 Sales Tax
Other Government Entity Taxes
Interest Income
Total Revenues
$ 37,575,952
Net Revenues For Distribution
$
16,833,928
2002 Tax
1/2%
$
-
Other
Government
Entities
$
-
16,665,589
56,000
$ 37,631,952
Percentage of Collection
Expenses:
Salaries
Group Insurance & Retirement
Professional Services
Office Space
Postage & Printing
Data Processing & Microfilming
Supplies & Materials
Travel & Staff Development
Capital Outlays
Tax Free Shopping Refund
Other Expenses
Total Expenses
School Board
'88 Tax
1/2%
16,080
$ 16,850,008
28%
$
$
97,440
22,540
77,000
13,440
17,080
5,040
1,705
1,395
28,000
3,360
6,440
273,440
$ 37,358,512
Distributions:
General Fund-'65 Tax
$ 26,808,614
Bond Sinking Fund-'65 Tax
9,556,639
Capital Improvement Fund-'65 Tax
575,000
Minor Repair & Improvement-'65 Tax
418,259
General Fund-'88 Tax
General Fund-2002 Tax
Other Government Entities
$ 37,358,512
Total Distributions
Full Time Positions:
Administrative (2), Professional (4), Secretarial (4)
15,920
$ 16,681,509
12%
$
$
41,970
9,708
33,166
5,789
7,357
2,171
387
317
12,060
1,447
2,773
117,145
66,668,940
100,000
$ 66,768,940
12%
$
$
41,550
9,612
32,834
5,731
7,283
2,149
383
313
11,940
1,433
2,747
115,975
Totals
$
37,575,952
16,833,928
16,665,589
66,668,940
188,000
$ 137,932,409
48%
$
$
167,040
38,640
132,000
23,040
29,280
8,640
3,025
2,475
48,000
5,760
11,040
468,940
100%
$
$
306,450
70,888
242,166
42,269
53,717
15,851
5,117
4,187
88,060
10,567
20,253
859,525
$ 16,732,863
$ 16,565,534
$ 66,300,000
$ 120,391,375
$
$
$
$
-
-
-
16,732,863
16,565,534
$ 16,732,863
Total Positions:
$ 16,565,534
10
66,300,000
$ 66,300,000
26,808,614
9,556,639
575,000
418,259
16,732,863
16,565,534
66,300,000
$ 120,391,375
LPSB CAPITAL IMPROVEMENT FUND
2002/2003
PROPOSED BUDGET
Requested
Notes
Revenue:
Projected Fund Balance @ 6/30/2002
20,604
Sales Tax Revenue
Interest Income
Rent, Leases & Royalties
Transfer from Debt Service Fund
Total Revenues
(1)
575,000
70,000
34,748
500,000
$
1,200,352
Expenditures:
See Schedule 1
6,990,908
Total Expenditures
$
6,990,908
Projected Fund Balance @ 6/30/2003
$
(5,790,556)
Note (1) The proposed budget has been prepared under the assumption that all funds appropriated
through 2001/02 will be expended by June 30, 2002. Any carry-over funding will be
addressed at a later date once that determination has been made.
LPSB CAPITAL IMPROVEMENT FUND
2002/2003
Schedule 3
Planning & Facilities Department Projects
Requested
School-Site Projects:
Prarie Elementary - Rear Entrance Bus Drive & Coulee Crossing
Prarie Elementary - Box Culverts at Coulee to regain playground
Carencro High - Replace (2) Air Handler Units in Clrm Bldg.
Martin Middle - Replace Pipe Insulation on 4-pipe HVAC System
Faulk Elementary - Replace Pipe Insulation on 4-pipe HVAC System
Montgomery Elem - Replace Pipe Insulation on 4-pipe HVAC System
Judice Middle - Replace Pipe Insulation on 4-pipe HVAC System
Broussard Middle - Hot Water Heating Piping Renovations
Judice Middle - Replace Fire Alarm & Intercom System
Broussard Middle - Replace Fire Alarm & Intercom System
L. Leo Judice - Replace Fire Alarm & Intercom System
Lafayette High - New Mechanized Bleachers
Fire Sprinkler System Monitoring @ 14 schools
Fire Sprinkler System Inspections @ 14 schools
Fire Sprinkler System Inspections @ 4 Schools
Total - Planning & Facilities
$
600,000
400,000
250,000
225,000
225,000
225,000
65,000
75,000
175,000
150,000
100,000
400,000
19,000
24,000
6,000
$
2,939,000