<<1>>
Board of Education Muscatine Community School District Monday, January 9, 2017 Meeting Location: City Hall Time: 7 p.m.
AGENDA I. Roll Call and Determination of Quorum II. Recite Pledge of Allegiance III. Welcome to Visitors and Media Representative and Introduction IV. Student Council Report V. Employee Recognition Awards (p. 3) VI. Citizens Speak VII. Consent Agenda** The following items are considered to be routine by the Board of Education and will be enacted by one motion. There will be no separate discussion of these items unless a Director so requests, in which event the item will be removed from the Consent Agenda and considered in its normal sequence from the agenda. A. Minutes (VIII-A-1-a) p. 7 B. Employment Recommendations (VIII-A-1-b) p. 10 C. Policies (VIII-A-1-c) p. 13 D. Bills and Claims (VIII-A-2-a) p. 17 VIII. Board Goals A. Action/Possible Action 1. Board Goal: Student Achievement a) The minutes of the December 12, 2016 Regular Meeting – action **(p. 7) b) Employment Recommendations – action** (p. 10) c) Consent Agenda Policies – action** (p. 13) (1) 504.1 Student Government (2) 504.4 Initiations (3) 505.4 Student Injury or Illness 2. Board Goal: Financial Stability a) Bills and Claims – action** (p. 17)
<<1>>
<<2>>
A.
II.
III. IV.
b) Approve the Early Retirements for FY17 – action (p. 18) c) Approve administration authority to seek modified supplemental amount from SBRC for the 2016-17 Returning Dropouts and Dropout Prevention AtRisk Program in the amount of $x and to attend such meeting as may be necessary to accomplish the same – action (p. 19) Discussion and Information
1. Board Goal: Student Achievement a) District Goal Setting Timeline b) Furniture Purchase Timetable c) Budget Development Timeline d) Future Ready Iowa Update 2. Board Goal: Financial Stability a) Financials for the Month of December (p. 24) Announcement/Meetings/Events January 16, 2017 Teacher Professional Development Day – No School for Students January 23, 2017 School Board Work Session; 6 p.m.; Administration Center Auditorium February 13, 2017 School Board Regular Session; 7 p.m.; City Hall Adjourn Exempt Session to Discuss Negotiations
<<2>>
Central Middle School HOME OF THE CHARGERS Secretary: Jeanne Petersen
901 Cedar Street, Muscatine, IA 52761 • P (563) 263-7784 / F (563) 263-0145 • Principal: Terry Hogenson
YOU ARE HERE: HOME > MCSD NEWS & ALERTS > MCSD NEWS & ALERTS > JANUARY EMPLOYEE AWARDS!
January Employee Awards!
<<3>>
Wednesday, January 4, 2017
The MCSD Employee Recognition Award is for those employees who go above and beyond on a continual basis for students, staff, and/or parents. Nominations can come from community members, parents, and staff members. The district would like to take this opportunity to introduce to you and congratulate January’s best of the best at MCSD! Rachel Reifert – 2nd Grade Teacher at Jefferson Elementary Nominated by Sarah Padilla
“Rachel completely cares for her students and will go to any lengths to help them succeed. “ Sarah Padilla
Tammy Ales – Special Education Strategist – DistrictWide Nominated by Whitney Ruckles “I am a first year special education teacher and Tammy has been so good at helping me to be successful. Tammy has reached out to all special education teachers and created an online classroom where we can go to get help and ideas. Within a day of reaching out to Tammy for advice she was in my classroom and helping me find a solution to my concerns. Tammy is someone who really does go above and beyond to help anywhere she can. I feel so fortunate to have her on my team.” Whitney Ruckles
Lynn Ralston – Math Teacher at West Middle School Nominated by Jonie Lopez
“Lynn always does her best to help all those who need it, whether it be a student or a teacher. She is the first person to take on extra tasks and committees even if her plate is already full. Her students and fellow employees always come first, and she does whatever she can to make sure of it. ” Jonie Lopez
<<3>>
<<4>>
Kelly Meyer – Guidance Clerk at Central Middle School Nominated by Dolores Torres
“Kelly Meyer is a very a dedicated hard working staff member that deserves to be recognized for all that she does to make this building run smoothly. Kelly would do anything for you in a heart beat. She is kind, generous and loved by all staff members and student body.” Dolores Torres
Julie Evans – Kindergarten Teacher at Mulberry Elementary Nominated by Jen Metcalf “Last year my child was lucky enough to have Julie Evans as his Kindergarten teacher. She did what every parent hopes teachers are doing with their child–providing all encompassing growth in children….What is astounding about Julie is her level in understanding that it takes both parents and teachers to help a child find success. She never made us feel like we were invading on her territory, interrupting her process or methods, or judging us for our initial path. She seemed to recognize that many parents will spend sleepless days, weeks, months, and years to find the answer needed to help their child — and that knowledge is one other thing she can use to help a child find success in the classroom. Our child is still smiling, still loving school and still thriving. And Julie helped give him that start.” Jen Metcalf
Anyone can nominate an outstanding staff member! Go to: MCSD Employee Recognition Form
All content is © 2000 2017 by Muscatine Community School District | |
Muscatine Community School District 2900 Mulberry Ave. Muscatine, IA 52761 (563) 2637223
[email protected]
<<4>>
<<5>>
ACTION/ POSSIBLE ACTION
<<5>>
<<6>>
Board Goal: Student Achievement
<<6>>
<<7>>
UNOFFICIAL MINUTES MUSCATINE SCHOOL BOARD OF EDUCATION REGULAR SESSION December 12, 2016 The Board of Education of the Muscatine Community School District, in the County of Muscatine, State of Iowa, met in regular session on Monday, December 12, 2016 at 7 p.m. at City Hall. Vice President Mary Wildermuth called the meeting to order. Directors Tim Bower, John Dabeet, and Randy Naber were present. Directors Tammi Drawbaugh, Aaron Finn, and Nathan Mather were absent. Also present were Superintendent Jerry Riibe and Director of Finance Tom Anderson. The board recited the Pledge of Allegiance. Vice President Wildermuth welcomed visitors and media representatives. There was no student council report. Five employees were recognized as those who go above and beyond for students, staff, and parents as part of the district’s Recognizing Excellence Employee Award Program. Employees are nominated by their peers, the community, and parents. The employees recognized for December were: Ashley Mohror, Heather Trego, Dave Hartman, Joy Schrock, and Dixie Luna. The district and board will be recognizing employees at each regular board meeting this school year. The board held a public hearing on the sale of Washington Elementary. A motion was made by Director Naber and seconded by Director Dabeet to open the public hearing. Roll call: Ayes: Directors Bower, Dabeet, Naber, and Wildermuth. There were no nays. Motion carried. Time: 7:05 p.m. There were no oral or written comments received. A motion was made by Director Dabeet and seconded by Director Bower to close the public hearing. Roll call: Ayes: Directors Bower, Dabeet, Naber, and Wildermuth. There were no nays. Motion carried. Time: 7:07 p.m. No one spoke during Citizens Speak. A motion was made by Director Bower and seconded by Director Dabeet to approve the consent agenda which includes: • The minutes of the November 14, 2016 Regular Meeting. • Employment Recommendations of: o New Hires – Certified: Crystal Pottebaum – Spanish Teacher at MHS. o Resignations – Certified: Heather Benninger – 3rd grade teacher at Mulberry (effective end of 2016-17 school year); Robert Rhum – MHS Spanish Teacher (effective 12/21/16). o New Hires – Schedule C: Mike Truitt – MHS Track.
<<7>>
<<8>>
• •
o Resignations – Schedule C: Colin Haggerty – MHS Wrestling. Policy 503.2 Anti-bullying/Anti-Harassment. Bills and Claims against the district dated December 12, 2016.
All ayes; motion carried. A motion was made by Director Naber and seconded by Director Bower to approve the following policies: 501.5 Elementary and Middle School Transfers 501.6 Non-resident Tuition 501.9 Approval of Open Enrollment Transfers – DELETE 501.11 Private Instruction 501.12 Dual Enrollment 501.13 Student Transfers In 501.14 Student Transfers Out or Withdrawals – NEW 501.15 Resident Students – NEW 501.16 Pregnant Students – NEW 501.17 Students of Legal Age – NEW 502.6 Student Drug, Tobacco, Alcohol Offenses 502.7 Search and Seizure 503.1 Non-discrimination Students – DELETE 503.10 Care of School Property – NEW All ayes; motion carried. Superintendent Riibe provided information on the Promise of Iowa – a campaign supported by all of the major education associations in Iowa in support of public education and the important role that public education plays in society. He noted that public education welcomes everyone and takes in all students regardless of background or situation. The video: The Promise of Iowa was also viewed. A motion was made by Director Dabeet and seconded by Director Bower to approve the Resolution of Support: Promise of Iowa Public Education Campaign. Directors Naber, Dabeet, Bower, and Wildermuth provided their own words of support for public education. All ayes; motion carried. A motion was made by Director Naber and seconded by Director Bower to approve the Resolution for the Sale of Washington Elementary to Muscatine Downtown Investors LLC in the amount of $275,000. All ayes; motion carried. Superintendent Riibe provided an update on the School Improvement Advisory Committee. He noted that the committee is made up of parents, students, community members, and MCSD faculty. This committee recently met with the University of Iowa research team and provided feedback for the district’s needs assessment. Dr. Riibe further noted that SIAC, the board, and
<<8>>
<<9>>
the district’s teacher advisory committee will meet to look at long- and short-term goals in the near future. Director of Finance Tom Anderson reviewed the district’s November financials. Vice President Wildermuth provided the following announcements and upcoming meetings and events: December 21, 2016 2-hour early dismissal for students December 22, 2016 – January 2, 2017 Winter Break – NO SCHOOL January 3, 2017 School Resumes January 9, 2017 School Board Meeting; 7 p.m.; City Hall Director Bower announced that Galen Housair and Darlene Blair of the Iowa Association of School Boards will be retiring at the end of the year and will be greatly missed at the state convention as both have done a lot for our district over the years. A motion was made by Director Naber and seconded by Director Dabeet to adjourn the meeting. Time: 7:25 p.m. Mary Wildermuth, Vice President Lisa Mosier Bunn, Secretary
<<9>>
FEBRUARY 1 3 , 2 017 EMPLOYMENT R ECOMMENDATIONS HIRES C ERTIFIED S TAFF RESIGNATIONS C ERTIFIED S TAFF NEW H IRES S CHEDULE C Bob L ong M S B asketball Troy K ulland M S T rack Wade M cLeod W restling A ssistant ( ½ c ontract), M HS Rob A wbrey W restling A ssistant ( ½ c ontract), M HS RESIGNATIONS S CHEDULE C Robert R hum M S T rack a nd M S F ootball Ben N ietzel M S B asketball NEW H IRES C LASSIFIED P ROFESSIONAL Debora F isk, $ 25,000 ( prorated), r eplaces L isa C arter, w ho t ransferred t o M HS
<<11>>
November 11,2016
Dear Mrs. bourot:*'
I am writing this letter to the Muscatine School District as my formai resignation from my Soanish teaching position as well as my middle school football and track positions effective at the end of the Fall Semester 2016.
I would like to take this opportunity to thank Muscatine for the last 23 years. I nave an opportunity to continue my teaching career at Mediapolis High School, which is where I have
lived during my time at Muscatine. I graduated from Mediapolis and tiiis gives me an opportunity to finish my career in my home town.
Again,thank you for all you've done for me in helping me to achieve this opportunity of returning to Mediapolis. Best of luck to Muscatine in the future and thank you.
Sincerely
Robert Rhum
<<11>>
<<12>>
12-12-16 To Whom It May Concern, It is with great regret that I am writing to inform you that I am resigning from my
position of Boys 8 th Grade Basketball Coach effective immediately as of 12/12/2016. I have greatly enjoyed my years in the program, and it is with great regret that I relinquish my position. Thank you,
.------'-
Ben Nietzel
<<12>>
MUSCATINE C OMMUNITY S CHOOL D ISTRICT B OARD P OLICY <<13>>
504.1 STUDENT GOVERNMENT A student government in any school may be organized within the framework of guidelines adopted by the building principal and his/her faculty representatives. The function of student government shall be to provide a channel of communication between students and the professional staff of the building or unit. Regulations and policies shall always remain the province of the Board and administration. LEG REF: Iowa Code § 279.8.
APPROVED: 0 2/12/90
REVIEWED: 0 1/10/11 <<13>>
REVISED: _ ______
MUSCATINE C OMMUNITY S CHOOL D ISTRICT B OARD P OLICY
<<14>>
504.4 INITIATIONS At no time or for any reason will the physical hazing of students, through initiation either in a group or singly, be tolerated. No organizations or individuals will be permitted to hold such initiations. LEG REF: Iowa Code § 279.8.
APPROVED: 0 2/12/90
REVIEWED: 1 0/11/10 <<14>>
REVISED: _ _____
MUSCATINE C OMMUNITY S CHOOL D ISTRICT B OARD P OLICY
<<15>>
505.4 STUDENT INJURY OR ILLNESS AT SCHOOL When a student becomes ill or is injured and requires more than minor care at school, the student's parents and/or guardian shall be noti ied by school personnel as soon as possible after these individuals are aware of the incident. The school district, while not responsible for medical treatment of an ill or injured student, will have authorized school personnel administer emergency or minor irst aid if possible. An ill or injured child will be turned over to the care of the parents, the parents' designee, or quali ied medical personnel as quickly as possible. It shall be the responsibility of the school personnel who witnessed the accident or cared for the student to ile an accident report with the superintendent within 48 hours after the student is injured at school. Parents and/or guardians shall be required to complete a medical emergency authorization form indicating the procedures to be followed, if possible, in an emergency involving their child. It shall be the responsibility of the parents to provide the school district with updated information on the emergency authorization form. The superintendent shall be responsible, in conjunction with the school nurse, to develop rules and regulations governing the procedure in the event a student should become ill or be injured at school. LEGAL REF: Iowa Code 613.17 281 Iowa Admin. Code 12.3(9) new standards
APPROVED: 0 2/12/90
REVIEWED: 1 0/11/10 <<15>>
REVISED: 0 6/12/00
<<16>>
Board Goal: Financial Stability
<<16>>
<<17>>
<<17>>
BRILES MACIAS HARRISON SYWASSINK DELEON PORTER MOSIER PUSATERI MURRAY WOODS IRWIN FERREIRA ECHELBARGER MARKS TRUITT
NANCY MARIE CHRIS JEFFREY KANDIS SHERRY BRENDA GAIL HENRY KAREN BETH DEBBIE SALLY SHEILA ANITA
FOOD SERVICE SCAP CUSTODIAL/MAINT CUSTODIAL/MAINT TEACHER SCAP SCAP TEACHER TEACHER TEACHER SCAP CLASSIFIED PRO TEACHER TEACHER TEACHER
GRANT MADISON CENTRAL CENTRAL MCKINLEY MCKINLEY MHS GRANT MHS MADISON ADMIN ADMIN WEST CENTRAL COLORADO
<<19>>
To:
Muscatine School Board
From: Tom Anderson Re:
Authority to seek SBRC Modified Supplemental Amount
Date: January 9, 2017
We are seeking SBRC Modified Supplemental Amount (MSA) for our 2017-18 Returning Dropouts and Dropout Prevention At-Risk Program in the amount of $1,105,829. The budget proposal and MSA application are included in your board packet. Asking for a motion to approve the request for modified supplemental amount from the SBRC in the amount of $1,105,829.
fy18 school board approval to seek at-risk sbrc ssa.doc <<19>>
1/4/2017
https://edinfo.ed.iowa.gov/AtRiskDropout/Print/DistrictBudget?districtformId=1268&btnName=Msa <<20>>
4581 0000 Muscatine Comm School District AtRisk\Dropout District Budget 20172018
MODIFIED SUPPLEMENTAL AMOUNT #
Description
Amount
1
Total budget figure from Budget Proposal section, above
2
**Maximum that can be used for building/districtwide programming for nonidentified students (5% of line 1)
3
Requested amount for programming targeting nonidentified students (Sum General Population Service Budgets)
4
Estimated amount to be used to pay for excess costs stipulated in IC 257.41(4) not included above
0
5
Estimated at risk formulagenerated funds for next fiscal year
$190,711
6
Estimated carryforward from project 1116 for the current fiscal year, from above
$0
7
Estimated carryforward from project 1119 for the current fiscal year, from above
$152,915
8
Estimated other resources to fund this program (e.g., donations, grants) as well as all TSS and TLC/TLS included in the Budget Proposal
0
9
Total budget less than other sources ((line 1+line 4)(lines 5 to 8))
$1,979,384
10 Minimum (25%) that must come from the regular district program cost (25 percent of line 9)
$2,323,010 $116,151 $0
$494,846
11 Budget Balance (subtract line 10 from line 9) 12 District cost per pupil 13
Certified enrollment (October 1, current school year) Certified enrollment was found and certified on 11/3/2016 11:16:00 AM.
$1,484,538 $6,591 5,084.20
14 Maximum modified supplemental amount possible (0.033 x line 12 x line 13) 15 Amount on line 11 or line 14, whichever is less 16
Requested modified supplemental amount Enter an amount greater than zero and equal to, or less than: $0
<<20>> https://edinfo.ed.iowa.gov/AtRiskDropout/Print/DistrictBudget?districtformId=1268&btnName=Msa
$1,105,829 $1,105,829
1105829
1/1
1/4/2017
https://edinfo.ed.iowa.gov/AtRiskDropout/Print/DistrictBudget?districtformId=1268&btnName=Budget <<21>>
4581 0000 Muscatine Comm School District AtRisk\Dropout District Budget 20172018
Budget Item
1
Allowable Object Code(s)
Function
1xxx, 212x, 219x, 2212, 2215, 2216, 2219
Description
FY 2017 FY 2016 FY 2016 MSA AtRisk DOP Actual (DOP) Actual Expenditures Program Expenditures (Project Budget (Project 1119) (Includes 1116) General)
FY 2017 FY 2017 AtRisk MSA (DOP) FY 2017 Estimated Estimated Estimated Expenditures Expenditures Total (Project (Project Expenditures 1116) 1119)
Expenditures (allowable + unallowable)
Expenditures (allowable + unallowable)
Total Available: Project 1116
Total Available: Project 1119
$258,349
$1,574,332
$190,711
$1,715,967
FY 2018 Total Proposed from Service Budgets
121129
Certified Staff Salaries
131292
881809
1101378
112051
806616
918,667
921123
44594
83293
131147
17446
121506
138,952
498376
2
211x, 213x, 214x, 219x, 229x
130139
Other Professional Salaries
3
1xxx
100109
Para Professional Salaries
16239
98331
129854
0
125387
125,387
141182
0
0
7000
0
0
0
0
4
241x, 249x
111119
Administrative Salaries (offsite program/school only)
5
241x, 249x
150159
Office/Clerical Salaries (offsite program/school only)
0
0
0
0
0
0
0
6
27xx
170179
Salaries Paid to Operative Employees
0
809
0
0
0
0
0
7
1xxx, 211x, 212x, 213x, 214x, 219x, 2212, 2215, 2216, 2219, 229x, 241x, 249x, 27xx
210 249,270 275
Employee Benefits
61597
410908
552688
61214
421543
482,757
680929
$1,475,150
$1,922,067 $190,711
$1,475,052
$1,665,763
$2,241,610
8
1xxx, 211x, 212x, 213x, 214x, 219x, 2212, 2215, 2216, 2219, 229x
310329
Purchased Administrative and Educational Services
56931
45000
0
60000
60,000
30000
9
2213, 2574
330 339,59x
Professional Development 0
3430
19300
0
0
0
6000
212x, 213x, 219x
347,349
Other Purchased Professional Services
0
0
0
0
0
0
0
11
1xxx, 211x, 212x, 213x, 219x, 2213, 2219, 2574, 27xx
511 519,561 569,580 599,951
Tuition,Travel,Shared Contracts
0
4281
0
0
0
0
0
12
1xxx, 211x, 212x, 219x, 2213, 2219, 222x, 229x, 2232, 2239, 241x, 249x, 2574, 27xx
611 619,626 627,641 669
Books,Periodicals,Supplies 328
22058
55300
0
28000
28,000
45400
13
1xxx
734739
Property (Equipment)
0
5243
0
0
0
0
0
14
1xxx
810819
Dues, Fees
0
0
0
0
0
0
0
15
1xxx
891899
Miscellaneous Expenses
0
0
0
0
0
0
0
$1,567,093
$2,041,667 $190,711
$1,563,052
$1,753,763
$2,323,010
Total Budgeted for Staff (budget items 17) $253,722
10
4300
Total (allowable budget items 1 15) $258,350 Estimated Carryforward Unallowable Expenditures $1
$0
$152,915
$7,239
<<21>> https://edinfo.ed.iowa.gov/AtRiskDropout/Print/DistrictBudget?districtformId=1268&btnName=Budget
1/1
<<22>>
DISCUSSION AND INFORMATION
<<22>>
<<23>>
Board Goal: Financial Stability
<<23>>
<<24>>
Muscatine CSD Treasurer's Report for the month of December, 2016 Comparisons:
YTD Dec-16
YTD Dec-15
Treasurer Balance by Fund: General Activity Management Special Purpose Trust Sales Tax PPEL Debt Service Nutrition Scholarship Trust Fund Agency Funds
$ 15,630,903.50 $ 315,237.83 $ 753,585.26 $ 53,494.50 $ 5,006,974.05 $ 1,164,577.96 $ $ 400,577.08 $ 162,417.38 $ 556,493.98
$ 13,923,763.90 $ 436,263.46 $ 731,423.34 $ 53,494.50 $ 1,851,886.44 $ 1,065,214.57 $ $ 242,201.69 $ 163,951.13 $ 64,623.56
Total of All Funds
$ 24,044,261.54
$ 18,532,822.59
<<24>>
<<25>>
Monthly Actual Revenues, Expenditures and Budget Comparison Muscatine Community School District FY 2017 Actual Revenue State Aid Property Taxes Income Surtaxes State Categorical Funds Federal Funds Tuition Other Total Monthly Revenues Total YTD Revenues
July $ $ $ $ $ $ $ $ $
133,648 340 74,072 208,060 208,060
Expenditures Salaries Benefits Energy (Fuel + Utilities)
$ $ $
July August September October 324,543 $ 555,717 $ 3,122,266 $ 2,668,104 $ 138,616 $ 227,141 $ 1,058,862 $ 916,325 $ $ 45,991 $ 81,862 $ 79,991 $
Other AEA Flowthrough Total Monthly Expendidtures Total YTD Expenditures
$ $ $ $
185,423 648,583 648,583
Monthly Gain/(Loss) YTD Gain/(Loss)
$ (440,522) $ (1,469,293) $ 152,491 $ 6,305,503 $ $ (440,522) $ (1,909,816) $ (1,757,324) $ 4,548,179 $
$ $ $ $ $ $ $ $ $
August (41,339) 94,783 53,445 261,505
September $ 3,614,076 $ 1,349,070 $ $ $ 43,095 $ $ 27,037 $ 5,033,278 $ 5,294,783
$ $ $ $ $ $ $ $ $
October 3,614,076 6,542,617 135,131 33,358 108,771 10,433,953 15,728,736
$ $ $ $ $ $ $ $ $
November 3,614,076 492,148 61,932 349,931 32,172 5,689 4,555,947 20,284,683
$ $ $ $ $ $ $ $ $
December January February March April 3,614,076 577,136 212,405 4,528 26,734 33,346 4,468,224 $ $ $ $ $ 24,752,907 $ 24,752,907 $ 24,752,907 $ 24,752,907 $ 24,752,907 $
November December 2,908,446 $ 3,250,833 1,003,431 $ 999,002 73,316 $ 55,418
$ 693,890 $ 398,931 $ 245,162 $ $ $ 218,867 $ 218,867 $ $ 1,522,738 $ 4,880,787 $ 4,128,450 $ $ 2,171,320 $ 7,052,107 $ 11,180,557 $
491,002 218,867 4,695,062 15,875,619
$ $ $ $
(139,115) $ 4,409,063 $
January
March
April
291,306 218,867 4,815,426 $ $ $ $ $ 20,691,045 $ 20,691,045 $ 20,691,045 $ 20,691,045 $ 20,691,045 $ (347,201) $ 4,061,862 $
Monthly General Fund Revenues and Expenses
$ $ 4,061,862 $ 4,061,862 $
$ $ 4,061,862 $ 4,061,862 $
June
$ 24,752,907 $ 24,752,907 May
Total $ 14,456,303 $ 8,960,972 $ 212,405 $ 335,239 $ 411,779 $ 32,512 $ 343,697 $ 24,752,907
June
$ 20,691,045 $ 20,691,045
$ $ $ $ $ $ $
Total 12,829,909 4,343,377 336,578 2,305,713 875,467 20,691,045
$ 4,061,862 $ 4,061,862
Year to Date General Fund Revenues and Expenses
$12,000,000
$30,000,000
$10,000,000
$25,000,000
$8,000,000
$20,000,000
$6,000,000
$15,000,000
$4,000,000
$10,000,000
$2,000,000
February
May
$5,000,000
$-
$-
$(2,000,000)
$(5,000,000)
$(4,000,000) Total Monthly Revenues
Total Monthly Expendidtures
Monthly Gain/(Loss)
Total YTD Revenues
<<25>> Page 1 of 4
Total YTD Expenditures
YTD Gain/(Loss)
1/6/2017
<<26>>
Monthly Actual Revenues, Expenditures and Budget Comparison Muscatine Community School District FY 2017 Actual Compared to Budget Revenue State Aid (A&L 9.11) Property Taxes (A&L 15.12) Income Surtaxes (A&L 10.17) State Categorical Funds Federal Funds Tuition Other Total Monthly Revenues Total YTD Revenues
$ $ $ $ $ $ $ $ $
114,924 334 67,914 183,172 183,172
$ $ $ $ $ $ $ $ $
August (15,610) (95,431) (41,339) 56,866 (95,514) 87,659
Other AEA Flowthrough Total Monthly Expendidtures Total YTD Expenditures
$ $ $ $ $ $ $ $
July (48,248) (34,426) 74,901 (7,773) (7,773)
$ $ $ $ $ $ $ $
August (220,702) (58,145) (6,115) 261,463 (23,499) (31,272)
Monthly Gain/(Loss) YTD Gain/(Loss)
$ $
190,945 $ 190,945 $
Expenditures Salaries Benefits Energy
July
September $ 1 $ 318,360 $ $ (19,925) $ 30,216 $ (1,246) $ (4,885) $ 322,520 $ 410,178
$ $ $ $ $ $ $ $ $
1 337,904 20,001 (33,853) (81,569) 242,483 652,662
$ $ $ $ $ $ $ $ $
1 (301,494) 29,716 230,668 6,974 (31,747) (65,883) 586,779
$ $ $ $ $ $ $ $ $
1 165,133 8,673 (38,050) (242,110) (29,070) (11,476) (146,900) 439,879
September $ 510,140 $ 106,435 $ 24,957 $ $ (65,003) $ $ 576,529 $ 545,257
$ $ $ $ $ $ $ $
October (467,646) (118,637) (4,162) (63,482) (653,928) (108,670)
$ $ $ $ $ $ $ $
November (668) 4,826 3,935 143,064 151,156 42,486
$ $ $ $ $ $ $ $
December 120,655 (40,978) (14,303) (52,950) 12,423 54,909
(217,039) $ 544,293 $
(159,323) 384,970
(72,015) $ 118,930 $
October
(254,009) $ (135,079) $
November
896,411 $ 761,332 $
December
January
January
February
March
March
April
April
May
May
June
Total $ $ $ $ $ $ $ $
2 504,293 8,673 11,235 (56,418) (23,008) (4,898) 439,879
$ $ $ $ $ $ $
Total (106,469) (140,926) 4,311 297,992 54,909
$ $
384,970 -
June
Year to Date General Fund Revenues and Expenses Compared to Budget
Monthly General Fund Revenues and Expenses Compared to Budget $1,000,000
$900,000
$800,000
$800,000 $700,000
$600,000
$600,000
$400,000
$500,000
$200,000
$400,000
$-
$300,000
$(200,000)
$200,000
$(400,000)
$100,000 $-
$(600,000) $(800,000) Total Monthly Revenues Compared to Budget
February
$(100,000) Total Monthly Expendidtures Compared to Budget
$(200,000)
Monthly Gain/(Loss) Compared to Budget
Total YTD Revenues
<<26>> Page 2 of 4
Total YTD Expenditures
YTD Gain/(Loss)
1/6/2017
<<27>>
Monthly Actual Revenues, Expenditures and Budget Comparison Muscatine Community School District FY 2017 Budget Revenue State Aid (A&L 9.12) Property Taxes (A&L 15.12) Income Surtaxes (A&L 10.17) State Categorical Funds Federal Funds Tuition Other Total Monthly Revenues Total YTD Revenues
July $ $ $ $ $ $ $ $ $
Expenditures Salaries Benefits Energy
$ $ $
July August September October 372,791 $ 776,419 $ 2,612,126 $ 3,135,750 $ 173,042 $ 285,286 $ 952,427 $ 1,034,963 $ $ 52,106 $ 56,905 $ 84,154 $
Other AEA Flowthrough Total Monthly Expendidtures Total YTD Expenditures
$ $ $ $
110,522 656,356 656,356
Monthly Gain/(Loss) YTD Gain/(Loss)
$ (631,468) $ (1,397,278) $ 406,500 $ 5,409,092 $ $ (631,468) $ (2,028,746) $ (1,622,246) $ 3,786,847 $
18,724 6 6,158 24,888 24,888
$ $ $ $ $ $ $ $ $
August 15,610 95,431 37,917 148,958 173,846
September $ 3,614,075 $ 1,030,711 $ $ 19,925 $ 12,879 $ 1,246 $ 31,922 $ 4,710,758 $ 4,884,604
$ $ $ $ $ $ $ $ $
October 3,614,075 6,204,713 115,130 67,211 190,340 10,191,470 15,076,074
$ $ $ $ $ $ $ $ $
$ 432,426 $ 463,934 $ 308,645 $ $ $ 218,867 $ 218,867 $ $ 1,546,236 $ 4,304,258 $ 4,782,378 $ $ 2,202,592 $ 6,506,850 $ 11,289,228 $
November 3,614,075 793,642 32,216 119,263 25,198 37,436 4,621,830 19,697,904
$ $ $ $ $ $ $ $ $
December 3,614,075 412,003 203,732 42,578 268,844 29,070 44,822 4,615,124 24,313,028
January $ 3,614,075 $ 114,533 $ $ 116,087 $ 285,621 $ 75,131 $ 46,778 $ 4,252,226 $ 28,565,254
February March $ 3,614,075 $ 3,614,075 $ 118,915 $ 463,573 $ 67,911 $ $ 8,662 $ 20,706 $ 207,659 $ 195,638 $ 59,027 $ 7,174 $ 48,302 $ 49,776 $ 4,124,551 $ 4,350,942 $ 32,689,805 $ 37,040,747
November December January February 2,909,114 $ 3,130,178 $ 2,791,648 $ 2,898,103 $ 998,606 $ 1,039,979 $ 975,160 $ 707,724 $ 69,382 $ 69,722 $ 87,012 $ 107,628 $ 347,938 218,867 4,543,906 15,833,133
$ $ $ $
77,924 $ 3,864,771 $
344,257 218,867 4,803,002 20,636,136
$ 315,723 $ 218,867 $ 4,388,410 $ 25,024,546
(187,878) $ 3,676,892 $
$ $ $ $ $ $ $ $ $
$ 406,666 $ $ 218,867 $ $ 4,691,124 $ $ 38,840,346 $
55,696 $ 5,712,570 $ 2,891,526 $ 8,604,095 $
May 3,614,075 444,954 22,357 165,237 22,170 47,902 4,316,695 51,761,137
June Total $ 3,614,075 $ 36,140,753 $ 322,709 $ 16,288,336 $ $ 271,642 $ 77,535 $ 679,050 $ 690,761 $ 2,171,511 $ 144,645 $ 453,665 $ 102,794 $ 708,699 $ 4,952,519 $ 56,713,656 $ 56,713,656
May June Total 2,987,357 $ 7,418,197 $ 34,707,928 1,007,269 $ 2,598,016 $ 11,755,371 84,003 $ 112,719 $ 937,750 184,664 218,867 4,482,160 43,322,506
$ 915,165 $ 4,995,754 $ 218,867 $ 2,188,667 $ 11,262,964 $ 54,585,470 $ 54,585,470
(165,465) $ (6,310,445) $ 2,128,186 8,438,631 $ 2,128,186
Budgeted Year to Date General Fund Revenues and Expenses
Budgeted Monthly General Fund Revenues and Expenses $14,000,000 $12,000,000
April 3,614,075 6,366,972 109,699 158,398 89,998 64,552 10,403,694 47,444,441
March April 2,723,926 $ 2,952,319 $ 973,911 $ 1,008,988 $ 109,836 $ 104,285 $
$ 897,108 $ 268,707 $ 218,867 $ 218,867 $ 4,829,430 $ 4,295,246 $ 29,853,976 $ 34,149,222
(136,184) $ (704,878) $ 3,540,708 $ 2,835,830 $
$ $ $ $ $ $ $ $ $
$60,000,000
$10,000,000
$50,000,000
$8,000,000
$40,000,000
$6,000,000 $4,000,000
$30,000,000
$2,000,000
$20,000,000
$-
$10,000,000
$(2,000,000)
$-
$(4,000,000)
$(10,000,000)
$(6,000,000) $(8,000,000) Total Monthly Budgeted Revenues
Total Monthly Budgeted Expendidtures
Monthly Gain/(Loss)
Total YTD Budgeted Revenues
<<27>> Page 3 of 4
Total YTD Budgeted Expenditures
YTD Gain/(Loss)
1/6/2017
<<28>>
Monthly Actual Revenues, Expenditures and Budget Comparison Muscatine Community School District FY 2017
Spending Authority Analysis Estimated FY 2017 General Fund Expenditures and Unspent Budget Authority through the end of December $60,000,000 $50,000,000 $40,000,000 $30,000,000 $20,000,000 $10,000,000 $Total FY 17 Estimated GF Expenditures
Total FY 17 Budgeted GF Expenditures
Over / (Under) Budget
$12,000,000 $10,000,000 $8,000,000 $6,000,000 $4,000,000 $2,000,000 $FY 16 Unspent Authorized Budget
FY 17 Estimated Unspent Authorized Budget
Change in Unspent Authorized
Enter the following information from your Unspent Authorized Budget worksheet Amounts in Blue are known from the Aid and Levy Worksheet, amounts in Yellow need to be estimated, and White cells are calculated. Please pay special attention to Miscellaneous income as that can change each month. Line Source 1 AidLevy 4.3/5.1 2 AidLevy 4.8/5.2 3 AidLevy 4.11/5.3 4 AidLevy 4.14/5.4 5 AidLevy 4.22/5.5 6 AidLevy 4.30/5.6 7 AidLevy 4.38/5.7 AidLevy 4.46/5.8 8 AidLevy 4.49/5.9 9 AidLevy 4.54/5.10 10 AidLevy 4.60/5.11 11 AidLevy 4.63/5.12 12 AidLevy 4.66/5.13 13 AidLevy 4.74/5.14 14 AidLevy 4.82/5.15 15 AidLevy 5.17 16 SBRC 17 SBRC 18 SBRC/DE 19 SBRC/DE 20 SBRC/DE 21 SBRC 22 SBRC 23 AidLevy 5.18 24 AidLevy 5.16 25 Calculated 26 AidLevy 7.35 27 AidLevy 10.27 28 AidLevy 11.3 29 See Note 1 30 Calculated 32 Calculated
Description Regular Program District Cost Regular Program Budget Adjustment Supplementary Weighting District Cost Special Ed District Cost Teacher Salary Supplement District Cost Professional Development Suppl District Cost Early Intervention Supplement District Cost Teacher Leadership Supplement District Cost
AEA Special Ed Support AEA Special Ed Support Adjustment AEA Media Services AEA Educational Services AEA Sharing District Cost AEA Teacher Salary Suppl District Cost AEA Professional Dev Suppl District Cost Dropout Prevention Allowable Growth SBRC Modified Supplemental Amt Other #1 OE SBRC Modified Supplemental Amt Other #2 LEP/ESL/ELL Special Ed Deficit Modified Supplemental Amt Special Ed Positive Balance Reduction AEA Special Ed Positive Balance Allowance for Construction Projects Unspent Allowance for Construction Enrollment Audit Adjustment AEA Prorata Reduction Maximum District Cost Total Preschool Foundation Aid Instructional Support Authority Ed Improvement Authority Other Miscellaneous Income Unspent Auth Budget - Previous Year Maximum Authorized Budget Expenditures Unspent Authorized Budget (UAB)
33 34 Calculated
<<28>> Page 4 of 4
FY 2017 Amounts
$ 34,075,470 $ 614,865 $ 684,113 $ 4,848,999 $ 2,893,694 $ 315,761 $ 389,293 $ 1,666,084 $ 1,716,787 $ $ 284,392 $ 310,323 $ $ 154,907 $ 18,190 $ 1,076,094 $ 212,718 $ 214,602 $ -
$ $ $ $ $ $ $ $ $ $ $
(2,836) 295,932 49,177,524 899,599 2,317,662 4,012,944 8,704,144 65,111,873 54,640,379 10,471,494
16.1%
Target 5-15%
1/6/2017
<<29>>
MUSCATINE COMMUNITY SCHOOL DISTRICT COMBINED INCOME STATEMENT AND BALANCE SHEET ACTIVITY FUND, TRUST FUND AND AGENCY FUND Dec-16 ACTIVITY FUNDS HIGH SCHOOL ACTIVITY FUND ACCOUNTS
Balance
Receipts
Expenses
November 30
Balance December 31
Activity Tickets-Werling
$4,337.57
Admin Fund-Smith
$6,053.14
$391.65
East Campus
$1,663.37
$0.00
$0.00
$1,663.37
Petty Cash-Schmelzer
$2,200.00
$0.00
$0.00
$2,200.00
Student Services-Werling
$10,956.91
$1,500.00
$1,175.77
$11,281.14
Total General Accounts
$25,210.99
$1,891.65
$1,175.77
$25,926.87
Band-Heid
$11,515.47
$7,775.00
$405.00
$18,885.47
$0.00
$554.99
$14,431.77
$1,262.68
Orchestra - Thoma Chorus-Ryan Diversity - TBD
$1,001.89
Interact Club - Ramos
$2,733.25
Young Ambassadors - TBD
$1,231.15
Drama-Mauck Forensics-Schrock
$0.00
$4,337.57 $6,444.79
$554.99 $739.40
$14,955.05
$0.00
$1,001.89
$100.00
$120.04
$2,713.21
$0.00
$0.00
$1,231.15
$415.00
$17,952.62
$570.00
$5,547.67
$18,367.62 $4,946.58
$1,171.09
$25,181.21
$70.00
$25,251.21
Newspaper/Weekly Auroran-Brown
$4,505.91
$358.80
$4,864.71
Auxilary Scholarship-Smith
Yearbook/Annual Auroran-Brown
$2,607.12
$0.00
$0.00
$2,607.12
Class of '12-Orr/Mueller
$395.00
$0.00
$0.00
$395.00
Future Business Leaders - TBD
$131.31
$0.00
$0.00
$131.31
$0.00
$62.62
French Club-Paulsen
$62.62
German Club-Reade
$1,488.23
$0.00
$376.39
$0.00
Spanish Club-Kroll MHS Science Club - Joslyn
$2,365.69
MHS Evironmental Club - Baille
$0.00
MHS Robotics Kitzman
$0.00
MHS National Honor Society - France
$0.00
Model UN-Hansen/Battern Student Council-Thomas/Walker Total Clubs/Organizations
$1,488.23 $0.00
$376.39
$0.00
$2,365.69
$4,997.46
$940.00
($116.75)
$6,054.21
$22,134.20
$9,375.30
$1,258.36
$30,251.14
$118,472.87
$21,607.86
$3,391.05
$136,689.68
Athletics-Werling
($8,087.83)
$49,368.28
$17,377.78
$23,902.67
Cheerleaders-Sink
($3,719.65)
$3,200.00
$5,651.63
($6,171.28)
Donation Fund-Werling
$28,577.48
$0.00
$0.00
$28,577.48
$4,537.65
$6,215.00
$1,497.72
$9,254.93
Pom Pom-Bisby Sports Calendar-Werling Tournaments-Werling Total Athletic Accounts
$139,518.82
$139,518.82
$34,465.35
$34,465.35
$195,291.82
$58,783.28 <<29>>
$24,527.13
$229,547.97
<<30>>
Total High School
$338,975.68
$82,282.79
<<30>>
$29,093.95
$392,164.52
<<31>>
CENTRAL MIDDLE SCHOOL ACCOUNTS Athletics-Walthart Fund Raisers-Hogenson
Balance
Receipts
Expenses
November 30
Balance December 31
$3,288.35
$1,923.77
$1,364.58
$0.00
$19.95
$19.95
$0.00
$6,860.84
$324.40
7th Grade Fund Raisers-Hogenson
$466.08
$12.00
8th Grade Fund Raisers-Hogenson
$9,003.52
$0.00
$0.00
$9,003.52
Band Fund Raisers-Hogenson
$8,794.85
$98.00
$136.83
$8,756.02
Student Council-Hogenson
$2,088.32
$0.00
$0.00
$2,088.32
General Activity-Hogenson
6th Grade Fund Raisers-Hogenson
$7,185.24 $478.08
$10,643.52
$46.00
Little Store-Hogenson
$1,767.90
$0.00
$0.00
$1,767.90
Music/Drama-Renee Mauck
$2,104.29
$0.00
$194.60
$1,909.69
$512.00
$64.00
$0.00
$576.00
$2,726.58
$0.00
$0.00
$2,726.58
($2,276.70)
$0.00
Yearbook-Hogenson Juice-Hogenson Bookfairs-Hogenson CMS Petty Cash-Hogenson Total CMS
WEST MIDDLE SCHOOL ACCOUNTS Athletics- Walthart
$200.00
$0.00
$46,199.50
$544.40
Balance
Receipts
$10,689.52
($2,276.70) $0.00 ($21.50)
Expenses
November 30
$0.00 $200.00 $46,765.40
Balance December 31
$12,875.35
$2,048.87
$10,826.48
$0.00
$4,557.80
Fund Raiser-Collinson
$4,557.80
$0.00
General Activity-Collinson
$4,700.43
$1,034.54
$0.00
$0.00
$0.00
$0.00
Music/Drama-Tristin Tolle
$3,700.98
$0.00
$194.60
$3,506.38
Student Council-Collinson
$0.00
$0.00
$0.00
$0.00
Yearbook -
$3,121.60
$16.00
$0.00
$3,137.60
Band - Hicks
$1,910.59
$120.00
$1,790.59
Little Store-Collinson
WMS Petty Cash-Collinson Total WMS CENTRAL OFFICE ACCOUNTS
$5,734.97
$200.00
$0.00
$0.00
$200.00
$31,066.75
$1,050.54
$2,363.47
$29,753.82
Balance
Receipts
Expenses
November 30
Balance December 31
Interest Investments
$3,512.25
$40.16
$0.00
$3,552.41
Total Central Office Accounts
$3,512.25
$40.16
$0.00
$3,552.41
$419,754.18
$83,917.89
$31,435.92
$472,236.15
Total Activity Fund
<<31>>
<<32>>
TRUST & AGENCY FUNDS CENTRAL OFFICE
Balance
TRUST ACCOUNTS
November 30
Receipts
Expenses
Balance December 31
B & P Rohling Scholarship
$10,634.55
$360.00
$1,000.00
$9,994.55
B & P Rohling Treasury Notes
$93,004.25
$0.00
$0.00
$93,004.25
B & P Rohling C.D. (27152)
$17,153.24
$0.00
$0.00
$17,153.24
Illeen Rohling Scholarship
$14,389.14
$0.00
$0.00
$0.00
$0.00
$0.00
Illeen Rohling C.D. (27153)
$28,450.35
$0.00
$0.00
$28,450.35
Jeff Culture Fair Scholarship
$1,550.85
$0.00
$0.00
$1,550.85
Total Trust Fund
$165,182.38
$360.00
$1,000.00
$164,542.38
CENTRAL OFFICE
Balance
Illeen Rohling Treasury Note
Receipts
$14,389.14
Expenses
SPECIAL PURPOSE TRUST ACCOUNTSNovember 30 Industrial Tech
Balance December 31
$45,218.86
$0.00
$0.00
$45,218.86
$738.07
$0.00
$0.00
$738.07
Madison Friends of Playground C.D.
$7,537.57
$0.00
$0.00
$7,537.57
Total Special Purpose Trust Fund
$53,494.50
$0.00
$0.00
$53,494.50
Madison Friends of Playground Checking
CENTRAL OFFICE AGENCY ACCOUNTS
Balance
Receipts
Expenses
November 30
Balance December 31
Retiree Health Insurance-COBRA
($25,810.37)
$83,275.23
$51,577.01
$5,887.85
Total Agency Fund
($25,810.37)
$83,275.23
$51,577.01
$5,887.85
Grand Total
$612,620.69
$167,553.12
$84,012.93
$696,160.88
Checking CNB #83
$179,319.61
$116,901.44
Agency CSB Checking #7203383
$228,515.99
$298,561.57
Money Market CNB#1202647
$283,199.46
$283,235.54
$0.00
$0.00
Payroll Checking FNB#1713759 Petty Cash
$2,600.00
$2,600.00
Certificates of Deposit
$53,141.16
$53,141.16
Treasury Notes
$93,004.25
$93,004.25
$837,284.22
$847,443.96
$18,541.74
$19,596.86
Accrued Salaries/Fringes Payable
$0.00
$50.68
Accrued Interest Receivable
$0.00
$0.00
$205,088.93
$5,928.37
Plus Accounts Receivable
$55,394.11
$77,746.37
Plus: Deposits in Transit
$3,431.25
$0.00
$672,478.91
$899,614.42
Bank Total Less: Warrants Outstanding
Less Accounts Payable
Reconciled Total
<<32>>