{"text_format":"3","workbook":"xlsx","n_sheets":25,"sheets":["1-Info Section Cover Sheet","2-SFA Policies","3-Bid Point Calculator","4-SFA Staffing Patterns","5-FSMC Staffing Patterns","6-FSMC Proposed Staff Patterns","7-Cost Information","8-Equipment List","9-USDA Foods","10-SD Info - Brkfst","11-SD Info - Lunch","12-SD Info - Snacks","13-SD Info - Suppers","14-Revenue Info","15-Meal Equiv Calculator","16-Bldg Demographics","17-Services by Location","18-Cost Responsibility Detail","19-Claims for Reimbursement","20-Breakfast Menu","21-Lunch Menu","22-A la Carte","23-Food Spec Cover Sht","24-Bid Sheet Cover","25-Bid without Advance Payment"],"not_rendered":{"defined_names":22},"read":"whole","date_system":"1900"}

{"sheet":"1-Info Section Cover Sheet","index":0,"n_rows":11,"n_cols":1,"rows_kept":11}
["Information Section"]
[]
["The School District Representative will fill out the Information Section and include it in the Contract bid proposal packet. This will represent all  information about cost, income, and service needs."]
[]
["When projecting average daily participation (ADP) and A la Carte/Catering information for the School District Information - Breakfast, Lunch, Supper, and Snack sheets, make sure to use the same month or months.  The same month or months must also be used when projecting the revenue information on the Projected Revenue information sheet."]
[]
["The Bid Point Calculator and Evaluation Criteria Matrix is used to advise potential bidders of the value placed on the written and/or oral presentation.  "]
[]
["A sample Bid Point Calculator is provided, as well as suggested non-price criteria that can be used on the Bid Point Calculator."]
[]
["The Bid Point Calculator and Evaluation Criteria Matrix is used to calculate which bidder will be awarded the Contract.  The bidder with the maximum number of points, not necessarily the lowest price bidder, will be awarded the Contract."]

{"sheet":"2-SFA Policies","index":1,"n_rows":11,"n_cols":2,"rows_kept":11}
["SFA must attach the following district and/or food service policies to this bid packet:"]
[]
["1. Procurement Policy to include:"]
[null,"a. Written code of conduct (related to School Food Service)"]
[null,"b. District Small Purchase Threshold (if different from State and Federal)"]
[null,"c. Bid Protest Procedures (highly recommended as a best practice)"]
[]
["2. Meal Charging Policy "]
[null,"a. May include Humanitarian/Alternate Meal policy"]
[]
["3. Bad Debt"]

{"sheet":"3-Bid Point Calculator","index":2,"n_rows":39,"n_cols":8,"rows_kept":39,"merged":[[0,0,0,7],[1,2,1,7]]}
["Bid Point Calculator and Evaluation Criteria Matrix"]
[null,null,"Company Name"]
[]
[null,"Bid Calculation and Evaluation Criteria"]
[null,"Bid (list bid price per meal/meal equivalent from lowest to highest)"]
[null,"Subtract lowest bid from bid above",{"v":0,"d":"0.00"},{"$f":"+D5-C5","v":{"v":0,"d":"0.00"}},{"$f":"+E5-C5","v":{"v":0,"d":"0.00"}},{"$f":"+F5-C5","v":{"v":0,"d":"0.00"}},{"$f":"+G5-C5","v":{"v":0,"d":"0.00"}},{"$f":"+H5-C5","v":{"v":0,"d":"0.00"}}]
[null,"Divide answer from above by lowest bid",{"v":0,"d":"0.00"},{"$f":"+D6/C5","v":{"$error":"#DIV/0!"}},{"$f":"+E6/C5","v":{"$error":"#DIV/0!"}},{"$f":"+F6/$C$5","v":{"$error":"#DIV/0!"}},{"$f":"+G6/$C$5","v":{"$error":"#DIV/0!"}},{"$f":"+H6/$C$5","v":{"$error":"#DIV/0!"}}]
[null,"Subtract answer above from 1",{"$f":"ROUND(1-C7,2)","v":{"v":1,"d":"1.00"}},{"$f":"1-D7","v":{"$error":"#DIV/0!"}},{"$f":"1-E7","v":{"$error":"#DIV/0!"}},{"$f":"1-F7","v":{"$error":"#DIV/0!"}},{"$f":"1-G7","v":{"$error":"#DIV/0!"}},{"$f":"1-H7","v":{"$error":"#DIV/0!"}}]
[51,"Multiply answer above by 51 or more",{"$f":"+C8*51","v":{"v":51,"d":"51.00"}},{"$f":"+D8*51","v":{"$error":"#DIV/0!"}},{"$f":"(E8*51)","v":{"$error":"#DIV/0!"}},{"$f":"+F8*0.51*100","v":{"$error":"#DIV/0!"}},{"$f":"+G8*0.51*100","v":{"$error":"#DIV/0!"}},{"$f":"+H8*0.51*100","v":{"$error":"#DIV/0!"}}]
["Pts\nBelow","List Non-Price Criteria and Sub-criteria Below\n(points will total 100 when added to Bid Points)"]
[11,"Management Candidate"]
[null,"Experience working in K-12 school foodservice 5 years or more in Michigan (5 pts)"]
[null,"Experience staffing K-12 breakfast and lunch programs (2 pts)"]
[null,"Experience with menu development and special events (2 pts)"]
[null,"Experience conducting procurement (2 pts)"]
[9,"FSMC Support and Back-up"]
[null,"Management of K-12 schools in Michigan (5 pts)"]
[null,"Communication (2 pts)"]
[null,"Problem resolution (2 pts)"]
[6,"Marketing and Merchandising Plan"]
[null,"Targeting audience (2 pts)"]
[null,"Recognition of holiday and special events (2 pts)"]
[null,"Expanding/increasing participation in breakfast and lunch (2 pts)"]
[4,"Nutrition Education"]
[null,"Promotional materials (2 pts)"]
[null,"Samples/examples of materials used (2 pts)"]
[6,"Employee Training and Development"]
[null,"Training program for foodservice employees (2 pts)"]
[null,"Safety and sanitation (2 pts)"]
[null,"Professional development for on-site manager (2 pts)"]
[11,"Integrity of Projected Operating Budget/Forecast"]
[null,"Integrity of information (5 pts)"]
[null,"Monitoring of food cost (2 pts)"]
[null,"Monitoring of labor cost (2 pts)"]
[null,"Financial reports (2 pts)"]
[2,"FSMC Guarantees/Guaranteed Returns "]
[null,"Guaranteed minimum return and surplus revenue (2 pts)"]
[]
[{"$f":"SUM(A9:A38)","v":100},"TOTAL",{"$f":"SUM(C9:C30)","v":{"v":51,"d":"51.00"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]

{"sheet":"4-SFA Staffing Patterns","index":3,"n_rows":36,"n_cols":8,"rows_kept":36,"merged":[[0,0,0,3],[1,0,1,3]]}
["SFA Employees (SY 2018-2019)"]
["CURRENT STAFFING PATTERNS"]
[]
["School Building","Job Title","Hours to be Worked","Total Wages/\nAnnual \nCompensation\n/Benefits","Hrs/Wk","Days/Yr","Rate","Long."]
["Districtwide","Van Driver",{"$f":"(E5/4)*F5","v":{"v":1322.5,"d":"1,322.50"}},{"$f":"12495*1.018+7000+1080.46","v":{"v":20800.37,"d":"20,800.37"}},28.75,{"v":184,"d":"184.00"},10.61,{"v":0,"d":"0.00"}]
["Middle School","Kitchen Assistant",{"$f":"(E6/5)*F6","v":{"v":885.0899999999999,"d":"885.09"}},{"$f":"((((C6/F6)*G6)*F6)*134.2%)+H6+3000","v":{"v":16412.646275,"d":"16,412.65"}},24.45,{"v":181,"d":"181.00"},11.25,{"v":50,"d":"$50.00"}]
["Middle School","Kitchen Assistant",{"$f":"(E7/5)*F7","v":445.26},{"v":11862.117453599998,"d":"11,862.12"},{"v":12.3,"d":"12.30"},{"v":181,"d":"181.00"},14.58,{"v":150,"d":"$150.00"}]
["Middle School","Kitchen Assistant",807.26,{"v":20962.656742,"d":"20,962.66"},{"v":22.3,"d":"22.30"},{"v":181,"d":"181.00"},16.35,{"v":250,"d":"$250.00"}]
["High School","Kitchen Assistant",807.26,{"v":19161.808357599995,"d":"19,161.81"},{"v":22.3,"d":"22.30"},{"v":181,"d":"181.00"},14.78,{"v":150,"d":"$150.00"}]
["Moline Christian","Kitchen Manager",{"v":724,"d":"724.00"},{"v":19359.26064,"d":"19,359.26"},{"v":20,"d":"20.00"},{"v":181,"d":"181.00"},{"v":16.580000000000002,"d":"16.58"},{"v":250,"d":"$250.00"}]
["Pine Street Elementary","Kitchen Assistant",{"v":946.6299999999999,"d":"946.63"},{"v":21989.697731799995,"d":"21,989.70"},26.15,{"v":181,"d":"181.00"},14.83,{"v":150,"d":"$150.00"}]
["Pine Street Elementary","Kitchen Program Manager",{"v":1267,"d":"1,267.00"},{"v":32053.319160000003,"d":"32,053.32"},{"v":35,"d":"35.00"},{"v":181,"d":"181.00"},16.94,{"v":250,"d":"$250.00"}]
["Pine Street Elementary","Kitchen Assistant",{"v":765.6299999999999,"d":"765.63"},{"v":14896.792053799998,"d":"14,896.79"},21.15,{"v":181,"d":"181.00"},11.53,{"v":50,"d":"$50.00"}]
["Dorr Elementary","Kitchen Manager",{"v":1127.6299999999999,"d":"1,127.63"},{"v":28188.8455008,"d":"28,188.85"},31.15,{"v":181,"d":"181.00"},16.48,{"v":250,"d":"$250.00"}]
["Dorr Elementary","Kitchen Assistant",{"v":946.6299999999999,"d":"946.63"},{"v":22345.403420599996,"d":"22,345.40"},26.15,{"v":181,"d":"181.00"},15.11,{"v":150,"d":"$150.00"}]
["Middle School","Kitchen Assistant",{"v":629.8799999999999,"d":"629.88"},{"$f":"((((C16/F16)*G16)*F16)*134.208%)+H16+3000","v":{"v":12644.715127039999,"d":"12,644.72"}},{"v":17.4,"d":"17.40"},{"v":181,"d":"181.00"},{"v":11.350000000000001,"d":"11.35"},{"v":50,"d":"$50.00"}]
["Middle School","Kitchen Assistant",{"v":1350.2599999999998,"d":"1,350.26"},{"$f":"((((C17/F17)*G17)*F17)*134.2%)+H17+3000","v":{"v":32007.21636039999,"d":"32,007.22"}},{"v":37.3,"d":"37.30"},{"v":181,"d":"181.00"},15.87,{"v":250,"d":"$250.00"}]
["Baker Elementary","Kitchen Assistant",{"v":1138.49,"d":"1,138.49"},{"$f":"((((C18/F18)*G18)*F18)*134.2%)+H18+3000","v":{"v":19718.8825578,"d":"19,718.88"}},31.45,{"v":181,"d":"181.00"},10.91,{"v":50,"d":"$50.00"}]
["Dorr Elementary","Kitchen Assistant",{"v":868.8,"d":"868.80"},{"$f":"((((C19/F19)*G19)*F19)*134.2%)+H19+3000","v":{"v":21473.479648,"d":"21,473.48"}},{"v":24,"d":"24.00"},{"v":181,"d":"181.00"},15.63,{"v":250,"d":"$250.00"}]
["Pine Street Elementary","Kitchen Assistant",997.31,{"$f":"((((C20/F20)*G20)*F20)*134.2%)+H20+3000","v":{"v":24824.8471224,"d":"24,824.85"}},27.55,{"v":181,"d":"181.00"},16.12,{"v":250,"d":"$250.00"}]
["Steeby Elementary","Kitchen Manager",{"v":1205.4599999999998,"d":"1,205.46"},{"$f":"((((C21/F21)*G21)*F21)*134.2%)+H21+3000","v":{"v":30654.300800799992,"d":"30,654.30"}},{"v":33.3,"d":"33.30"},{"v":181,"d":"181.00"},{"v":16.939999999999998,"d":"16.94"},{"v":250,"d":"$250.00"}]
["High School","Kitchen Assistant",807.26,{"$f":"((((C22/F22)*G22)*F22)*134.208%)+H22+3000","v":{"v":18014.350910975998,"d":"18,014.35"}},{"v":22.3,"d":"22.30"},{"v":181,"d":"181.00"},13.72,{"v":150,"d":"$150.00"}]
["Dorr Elementary","Kitchen Assistant",{"v":848.8899999999999,"d":"848.89"},{"$f":"((((C23/F23)*G23)*F23)*134.2%)+H23+3000","v":{"v":15250.943169799999,"d":"15,250.94"}},23.45,{"v":181,"d":"181.00"},10.71,{"v":50,"d":"$50.00"}]
["Baker Elementary","Kitchen Assistant",662.46,{"$f":"((((C24/F24)*G24)*F24)*134.2%)+H24+3000","v":{"v":12571.4183372,"d":"12,571.42"}},{"v":18.3,"d":"18.30"},{"v":181,"d":"181.00"},10.71,{"v":50,"d":"$50.00"}]
["Pine Street Elementary","Kitchen Assistant",807.26,{"$f":"((((C25/F25)*G25)*F25)*134.2%)+H253000","v":{"v":14863.464862399998,"d":"14,863.46"}},{"v":22.3,"d":"22.30"},{"v":181,"d":"181.00"},13.72,{"v":150,"d":"$150.00"}]
["Baker Elementary","Kitchen Manager",{"v":1127.6299999999999,"d":"1,127.63"},{"$f":"((((C26/F26)*G26)*F26)*134.2%)+H26+3000","v":{"v":28642.82933879999,"d":"28,642.83"}},31.15,{"v":181,"d":"181.00"},{"v":16.779999999999998,"d":"16.78"},{"v":250,"d":"$250.00"}]
["High School","Kitchen Assistant",{"v":543,"d":"543.00"},{"$f":"((((C27/F27)*G27)*F27)*134.2%)+H27+3000","v":{"v":10651.413,"d":"10,651.41"}},{"v":15,"d":"15.00"},{"v":181,"d":"181.00"},{"v":10.5,"d":"10.50"}]
["High School","Kitchen Program Manager",{"v":1422.6599999999999,"d":"1,422.66"},{"$f":"((((C28/F28)*G28)*F28)*134.2%)+H28+3000","v":{"v":37582.130279599995,"d":"37,582.13"}},{"v":39.3,"d":"39.30"},{"v":181,"d":"181.00"},17.93,{"v":350,"d":"$350.00"}]
["Middle School","Kitchen Program Manager",{"v":1267,"d":"1,267.00"},{"$f":"((((C29/F29)*G29)*F29)*134.208%)+H29+3000","v":{"v":32786.2148032,"d":"32,786.21"}},{"v":35,"d":"35.00"},{"v":181,"d":"181.00"},17.37,{"v":250,"d":"$250.00"}]
["High School","Kitchen Assistant",{"v":1086,"d":"1,086.00"},{"$f":"((((C30/F30)*G30)*F30)*134.2%)+H33000","v":{"v":23755.8156,"d":"23,755.82"}},{"v":30,"d":"30.00"},{"v":181,"d":"181.00"},{"v":16.3,"d":"16.30"},{"v":250,"d":"$250.00"}]
["High School","Kitchen Assistant",{"v":765.6299999999999,"d":"765.63"},{"$f":"((((C31/F31)*G31)*F31)*134.2%)+H31+3000","v":{"v":16427.730489199996,"d":"16,427.73"}},21.15,{"v":181,"d":"181.00"},13.02,{"v":50,"d":"$50.00"}]
["High School","Kitchen Assistant",{"v":765.6299999999999,"d":"765.63"},{"$f":"((((C32/F32)*G32)*F32)*134.2%)+H32+3000","v":{"v":14054.2621766,"d":"14,054.26"}},21.15,{"v":181,"d":"181.00"},10.71,{"v":50,"d":"$50.00"}]
["Districtwide","Substitutes","Varies",{"$f":"9000*134.2%+3000","v":{"v":15077.999999999998,"d":"15,078.00"}}]
["Districtwide","Clerical",{"$f":"20*36","v":{"v":720,"d":"720.00"}},{"$f":"28585*134.2%+1000","v":{"v":39361.06999999999,"d":"39,361.07"}}]
["Total"]
[null,null,{"$f":"SUM(C5:C35)","v":{"v":27058.509999999995,"d":"27,059"}},{"$f":"SUM(D5:D34)","v":{"v":648396.0019194159,"d":"648,396.00"}}]

{"sheet":"5-FSMC Staffing Patterns","index":4,"n_rows":5,"n_cols":10,"rows_kept":5,"merged":[[0,0,0,9],[1,0,1,9],[2,3,2,9]]}
["FSMC Employees (SY 2018-2019)"]
["CURRENT STAFFING PATTERNS"]
[{"$nulls":3},"Mark with an \"X\" to indicate if employee compensation included the following:"]
["School Building","Job Title","Hours to be Worked","Employee Health ","Family Health","Dental ","Vision","Retirement","Paid Time Off/ Holiday/ Sick","Life Insurance"]
["District-wide","Food Service Director",{"v":40,"d":"40.00"},"X","X","X","X","X","X","X"]

{"sheet":"6-FSMC Proposed Staff Patterns","index":5,"n_rows":4,"n_cols":3,"rows_kept":4,"merged":[[0,0,0,2],[1,0,1,2]]}
["PROPOSED STAFFING PATTERNS BY FSMC"]
["To be completed by FSMC for districts requesting transition of employees to FSMC."]
[]
["School Building","Job Title","Hours to be Worked"]

{"sheet":"7-Cost Information","index":6,"n_rows":28,"n_cols":2,"rows_kept":28,"merged":[[0,0,0,1],[2,0,2,1]]}
["PROJECTED COST INFORMATION"]
[]
["Based 180 Days of Service in School Year 2018-2019"]
[]
[]
["EXPENSES ","TOTAL COST"]
["(From Food Service Account)"]
["Food Cost (including commodities delivery charge)",{"v":571500,"d":"$571,500.00"}]
["Food Cost for Fresh Fruit and Vegetable Program (FFVP) Only",{"v":0,"d":"$0.00"}]
["Labor - SFA Employees (not a bid item)",{"v":479005,"d":"$479,005.00"}]
["Labor - FSMC Employees",{"v":0,"d":"$0.00"}]
["Fringe Benefits - SFA Employees (not a bid item)",{"v":169391,"d":"$169,391.00"}]
["Fringe Benefits -  FSMC Employees",{"v":0,"d":"$0.00"}]
["On-Site Manager Salary & Benefits","Bid Item"]
["Contracted Services* (vending)",{"v":5000,"d":"$5,000.00"}]
["Transportation Cost (mileage)",{"v":2600,"d":"$2,600.00"}]
["Non-Food (Supplies and Other Materials)",{"v":47500,"d":"$47,500.00"}]
["Non-Food (Supplies and Other Materials) FFVP Only",{"v":0,"d":"$0.00"}]
["Indirect Cost (assigned to food service)",{"v":0,"d":"$0.00"}]
["Other (Maintenance and Repair, Cleaning, Capital Outlay)",{"v":51000,"d":"$51,000.00"}]
["Other (Dues and fees, other expenses, sales tax)",{"v":30000,"d":"$30,000.00"}]
[]
[]
["Total",{"$f":"SUM(B8:B23)","v":{"v":1355996,"d":"$1,355,996.00"}}]
[]
[]
[]
["*FSMC Administrative Cost and FSMC Management Fee, if applicable, have not been included."]

{"sheet":"8-Equipment List","index":7,"n_rows":123,"n_cols":5,"rows_kept":123,"merged":[[0,0,0,4],[1,0,1,4],[3,1,3,4]]}
["EQUIPMENT INVENTORY LIST"]
["SFA will list the food service equipment used in food service and identify if it is a SFA or FSMC provided item. "]
[]
[null,"Mark an \"X\" in the appropriate columns for each item."]
["Equipment List","Expendable (one time use)","Non-Expendable (reusable)","SFA ","FSMC"]
["High School"]
["Combi Oven",null,"x","x"]
["Convection Oven (2)",null,"x","x"]
["Dish Machine",null,"x","x"]
["Robo coupe",null,"x","x"]
["Serving Line- Multiple Pieces",null,"x","x"]
["Mongolian Grill",null,"x","x"]
["Slicer",null,"x","x"]
["Walk in cooler and Freezer",null,"x","x"]
["Walk in Blast Chiller",null,"x","x"]
["Open air cooler",null,"x","x"]
["Pizza Oven",null,"x","x"]
["Hot holding unit- 4",null,"x","x"]
["Cold holding unit",null,"x","x"]
["Gas Grill",null,"x","x"]
["Turbo Oven",null,"x","x"]
["Serving utensils",null,"x","x"]
["Garbage disposal",null,"x","x"]
["Tilt Skillet",null,"x","x"]
["Range with burners",null,"x","x"]
["Microwave",null,"x","x"]
["Mixer",null,"x","x"]
["Three compartment sink",null,"x","x"]
["Prep Table - Multiple Tables",null,"x","x"]
["Carts - 8",null,"x","x"]
[]
[]
["Middle School"]
["Oven",null,"x","x"]
["Range",null,"x","x"]
["Microwave",null,"x","x"]
["Dishwasher",null,"x","x"]
["Three compartment sink",null,"x","x"]
["Serving Equipment-Multiple units",null,"x","x"]
["Prep Table - Multiple Tables",null,"x","x"]
["Serving utensils",null,"x","x"]
["3 door Frezzer-2",null,"x","x"]
["Hot Holding unit-2",null,"x","x"]
["Refrigerators - 3",null,"x","x"]
["Milk Cooler - 1",null,"x","x"]
[]
[]
["Pine Elementary"]
["Oven- 1",null,"x","x"]
["Range",null,"x","x"]
["Microwave",null,"x","x"]
["Dishwasher",null,"x","x"]
["Three compartment sink",null,"x","x"]
["Serving Equipment-Multiple units",null,"x","x"]
["Prep Table - Multiple Tables",null,"x","x"]
["Serving utensils",null,"x","x"]
["3 door Frezzer-1",null,"x","x"]
["Hot Holding unit-2",null,"x","x"]
["Refrigerators - 1",null,"x","x"]
["Milk Cooler - 1",null,"x","x"]
["Mixer",null,"x","x"]
[]
[]
[]
["Baker Elementary"]
["Oven- 1",null,"x","x"]
["Range",null,"x","x"]
["Microwave",null,"x","x"]
["Dishwasher",null,"x","x"]
["Three compartment sink",null,"x","x"]
["Serving Equipment-Multiple units",null,"x","x"]
["Prep Table - Multiple Tables",null,"x","x"]
["Serving utensils",null,"x","x"]
["3 door Frezzer-1",null,"x","x"]
["Hot Holding unit-1",null,"x","x"]
["Refrigerators - 1",null,"x","x"]
["Milk Cooler - 1",null,"x","x"]
[]
[]
["Dorr Elementary"]
["Oven- 1",null,"x","x"]
["Range",null,"x","x"]
["Microwave",null,"x","x"]
["Dishwasher",null,"x","x"]
["Three compartment sink",null,"x","x"]
["Serving Equipment-Multiple units",null,"x","x"]
["Prep Table - Multiple Tables",null,"x","x"]
["Serving utensils",null,"x","x"]
["3 door Frezzer-1",null,"x","x"]
["Hot Holding unit-1",null,"x","x"]
["Refrigerators - 1",null,"x","x"]
["Milk Cooler - 1",null,"x","x"]
["Carts- 3",null,"x","x"]
[]
[]
["Baker Elementary"]
["Oven- 1",null,"x","x"]
["Range",null,"x","x"]
["Microwave",null,"x","x"]
["Dishwasher",null,"x","x"]
["Three compartment sink",null,"x","x"]
["Serving Equipment-Multiple units",null,"x","x"]
["Prep Table - Multiple Tables",null,"x","x"]
["Serving utensils",null,"x","x"]
["3 door Frezzer-1",null,"x","x"]
["Hot Holding unit-1",null,"x","x"]
["Refrigerators - 1",null,"x","x"]
["Milk Cooler - 1",null,"x","x"]
["Carts- 3",null,"x","x"]
[]
["Steeby  Elementary"]
["Oven- 1",null,"x","x"]
["Range",null,"x","x"]
["Microwave",null,"x","x"]
["Three compartment sink",null,"x","x"]
["Serving Equipment-Multiple units",null,"x","x"]
["Prep Table - Multiple Tables",null,"x","x"]
["Serving utensils",null,"x","x"]
["3 door Frezzer-1",null,"x","x"]
["Hot Holding unit-1",null,"x","x"]
["Refrigerators - 1",null,"x","x"]
["Milk Cooler - 2",null,"x","x"]
["Carts- 3",null,"x","x"]

{"sheet":"9-USDA Foods","index":8,"n_rows":12,"n_cols":2,"rows_kept":12,"merged":[[0,0,0,1],[2,0,2,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[17,0,17,1]]}
["USDA FOODS INFORMATION"]
[]
["SFA will attach SY 2017-2018 Year End PAL Report  "]
[]
[]
["SY 2019-2020 Consortia Election:  ","Great Lakes Consortia"]
[]
[]
["SY 2017-2018 Annual Delivery Fees:  ",{"v":1347.5,"d":"$1,347.50"}]
[]
[]
["Please describe any major changes that took place in the district between SY 2017-2018 and SY 2018-2019 that would impact USDA Food Entitlement Usage. "]

{"sheet":"10-SD Info - Brkfst","index":9,"n_rows":37,"n_cols":8,"rows_kept":37,"merged":[[4,2,4,3],[4,4,4,6],[34,0,34,7],[36,0,36,7]]}
["SCHOOL DISTRICT INFORMATION: BREAKFAST PROGRAM"]
["PROJECTED PRICES/COUNTS/OTHER INCOME"]
["NSLP/CACFP/SFSP"]
[]
[null,null,"Meal Prices",null,"COUNTS\n*Reimbursable Meal ADP",null,null,"Projected Total for \nSchool Year"]
["School Building","Enrollment","Adult","Student","Paid","Free","Reduced","A la Carte & Other Income"]
["NSLP"]
["Baker Elementary",464,{"v":2,"d":"$2.00"},{"v":1.75,"d":"$1.75"},{"$f":"414/23","v":{"v":18,"d":"18.00"}},{"$f":"1246/23","v":{"v":54.17391304347826,"d":"54.17"}},{"$f":"318/23","v":{"v":13.826086956521738,"d":"13.83"}}]
["Steeby Elementary",426,{"v":2,"d":"$2.00"},{"v":1.75,"d":"$1.75"},{"$f":"355/23","v":{"v":15.434782608695652,"d":"15.43"}},{"$f":"1069/23","v":{"v":46.47826086956522,"d":"46.48"}},{"$f":"240/23","v":{"v":10.434782608695652,"d":"10.43"}}]
["Dorr Elementary",608,{"v":2,"d":"$2.00"},{"v":1.75,"d":"$1.75"},{"$f":"299/23","v":{"v":13,"d":"13.00"}},{"$f":"1337/23","v":{"v":58.130434782608695,"d":"58.13"}},{"$f":"136/23","v":{"v":5.913043478260869,"d":"5.91"}}]
["Pine Street Elementy",494,{"v":2,"d":"$2.00"},{"v":2,"d":"$2.00"},{"$f":"221/23","v":{"v":9.608695652173912,"d":"9.61"}},{"$f":"1201/23","v":{"v":52.21739130434783,"d":"52.22"}},{"$f":"189/23","v":{"v":8.217391304347826,"d":"8.22"}}]
["Middle School",494,{"v":2,"d":"$2.00"},{"v":2,"d":"$2.00"},{"$f":"90/23","v":{"v":3.9130434782608696,"d":"3.91"}},{"$f":"759/23","v":{"v":33,"d":"33.00"}},{"$f":"129/23","v":{"v":5.608695652173913,"d":"5.61"}}]
["High School",912,{"v":2,"d":"$2.00"},{"v":2,"d":"$2.00"},{"$f":"299/23","v":{"v":13,"d":"13.00"}},{"$f":"1576/23","v":{"v":68.52173913043478,"d":"68.52"}},{"$f":"265/23","v":{"v":11.521739130434783,"d":"11.52"}}]
[]
[]
["Total",{"$nulls":3},{"$f":"SUM(E8:E15)","v":{"v":72.95652173913044,"d":"72.96"}},{"$f":"SUM(F8:F15)","v":{"v":312.52173913043475,"d":"312.52"}},{"$f":"SUM(G8:G15)","v":{"v":55.52173913043478,"d":"55.52"}},{"v":0,"d":"$0.00"}]
[]
["CACFP"]
["SFA does not currently participate, but reserves the right to add in the future."]
[]
[]
[]
[]
["Total",{"$nulls":3},{"$f":"SUM(E19:E23)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(F19:F23)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(G19:G23)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"$0.00"}]
[]
["SFSP"]
["SFA does not currently participate, but reserves the right to add in the future."]
[]
[]
[]
[]
["Total",{"$nulls":3},{"$f":"SUM(E27:E31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(F27:F31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(G27:G31)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"$0.00"}]
[{"$nulls":7},{"$f":"SUM(H16,H24,H32)","v":{"v":0,"d":"$0.00"}}]
[]
["The ADP (Average Daily Participation) and A la Carte/Catering Information is based on data from a projection for the current school year (2018-2019) using the month of October, 2018.  Use this ADP to determine the number of projected breakfasts sold on the Revenue Information Sheet for the entire school year.  For example, the projected number of paid breakfasts sold is determined by taking the paid ADP above and multiplying it by the number of days of breakfast indicated at the top of the Projected Revenue Information sheet."]
[]
["*ADP by building is calculated using the following formula:  number of meals served divided by the number of service days per building."]

{"sheet":"11-SD Info - Lunch","index":10,"n_rows":38,"n_cols":10,"rows_kept":38,"merged":[[4,2,4,3],[4,4,4,6],[35,0,35,7],[37,0,37,7]]}
["SCHOOL DISTRICT INFORMATION: LUNCH PROGRAM"]
["PROJECTED PRICES/COUNTS/OTHER INCOME"]
["NSLP/CACFP/SFSP"]
[]
[null,null,"Meal Prices",null,"COUNTS\n*Reimbursable Meal ADP",null,null,"Projected Total for \nSchool Year"]
["School Builiding","Enrollment","Adult","Student","Paid","Free","Reduced","A la Carte & Other Income"]
["NSLP"]
["Baker Elementary",464,{"v":4.65,"d":"$4.65"},{"v":2.55,"d":"$2.55"},{"$f":"1548/23","v":{"v":67.30434782608695,"d":"67.30"}},{"$f":"2651/23","v":{"v":115.26086956521739,"d":"115.26"}},{"$f":"808/23","v":{"v":35.130434782608695,"d":"35.13"}},{"v":500,"d":"$500.00"},null,"Add'l milk"]
["Steeby Elementary",426,{"v":4.65,"d":"$4.65"},{"v":2.55,"d":"$2.55"},{"$f":"1713/23","v":{"v":74.47826086956522,"d":"74.48"}},{"$f":"2429/23","v":{"v":105.6086956521739,"d":"105.61"}},{"$f":"627/23","v":{"v":27.26086956521739,"d":"27.26"}},{"v":500,"d":"$500.00"},null,"Add'l milk"]
["Dorr Elementary",608,{"v":4.65,"d":"$4.65"},{"v":2.55,"d":"$2.55"},{"$f":"2575/23","v":{"v":111.95652173913044,"d":"111.96"}},{"$f":"3133/23","v":{"v":136.2173913043478,"d":"136.22"}},{"$f":"679/23","v":{"v":29.52173913043478,"d":"29.52"}},{"v":500,"d":"$500.00"},null,"Add'l milk"]
["Pine Street Elementy",494,{"v":4.65,"d":"$4.65"},{"v":2.9,"d":"$2.90"},{"$f":"2349/23","v":{"v":102.1304347826087,"d":"102.13"}},{"$f":"3144/23","v":{"v":136.69565217391303,"d":"136.70"}},{"$f":"854/23","v":{"v":37.130434782608695,"d":"37.13"}},{"v":33156.41,"d":"$33,156.41"},null,"2 pricing cards"]
["Middle School",494,{"v":4.65,"d":"$4.65"},{"v":2.9,"d":"$2.90"},{"$f":"2286/23","v":{"v":99.3913043478261,"d":"99.39"}},{"$f":"2474/23","v":{"v":107.56521739130434,"d":"107.57"}},{"$f":"629/23","v":{"v":27.347826086956523,"d":"27.35"}},{"v":34656.41,"d":"$34,656.41"},null,"2 pricing cards"]
["High School",912,{"v":4.65,"d":"$4.65"},"$2.90 - $3.90",{"$f":"5172/23","v":{"v":224.8695652173913,"d":"224.87"}},{"$f":"4406/23","v":{"v":191.56521739130434,"d":"191.57"}},{"$f":"983/23","v":{"v":42.73913043478261,"d":"42.74"}},{"v":69312.83,"d":"$69,312.83"},null,"4 pricing cards"]
["Moline Christian School",31,{"v":4.65,"d":"$4.65"},{"v":2.7,"d":"$2.70"},{"v":49.8,"d":"49.80"},{"v":1.6,"d":"1.60"},{"v":5.1,"d":"5.10"},{"v":0,"d":"$0.00"}]
["St. Therese Catholic School",254,{"v":4.65,"d":"$4.65"},{"v":2.7,"d":"$2.70"},8.87,1.83,1.65,{"v":0,"d":"$0.00"}]
["Total",{"$nulls":3},{"$f":"SUM(E8:E15)","v":{"v":738.8004347826087,"d":"738.80"}},{"$f":"SUM(F8:F15)","v":{"v":796.3430434782609,"d":"796.34"}},{"v":205.8804347826087,"d":"205.88"},{"$f":"SUM(H8:H15)","v":{"v":138625.65000000002,"d":"$138,625.65"}}]
[]
["CACFP"]
["SFA does not currently participate, but reserves the right to add in the future."]
[]
[]
[]
[]
["Total",{"$nulls":3},{"$f":"SUM(E19:E23)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(F19:F23)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(G19:G23)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"$0.00"}]
[]
["SFSP"]
["SFA does not currently participate, but reserves the right to add in the future."]
[]
[]
[]
[]
[]
["Total",{"$nulls":3},{"$f":"SUM(E27:E32)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(F27:F32)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(G27:G32)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"$0.00"}]
[{"$nulls":7},{"$f":"SUM(H16,H24,H33)","v":{"v":138625.65000000002,"d":"$138,625.65"}}]
[]
["The ADP (Average Daily Participation) and A la Carte/Catering Information is based on data from a projection for the current school year (2018-2019) using the month of October, 2018.  Use this ADP to determine the number of projected lunches sold on the Revenue Information Sheet for the entire school year.  For example, the projected number of paid lunches sold is determined by taking the paid ADP above and multiplying it by the number of days of lunch indicated at the top of the Projected Revenue Information sheet."]
[]
["*ADP by building is calculated using the following formula:  number of meals served divided by the number of service days per building."]

{"sheet":"12-SD Info - Snacks","index":11,"n_rows":37,"n_cols":7,"rows_kept":37,"merged":[[4,2,4,3],[4,4,4,6],[34,0,34,6],[36,0,36,6]]}
["SCHOOL DISTRICT INFORMATION: SNACK PROGRAM"]
["PROJECTED PRICES/COUNTS/OTHER INCOME"]
["NSLP/CACFP/SFSP"]
[]
[null,null,"Meal Prices",null,"COUNTS\n*Reimbursable Snacks ADP"]
["School Building","Enrollment","Adult","Student","Paid","Free","Reduced"]
["NSLP"]
["SFA does not currently participate, but reserves the right to add in the future."]
[]
[]
[]
[]
[]
[]
["Total",{"$nulls":3},{"$f":"SUM(E7:E14)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(F7:F14)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(G7:G14)","v":{"v":0,"d":"0.00"}}]
[]
["CACFP"]
["SFA does not currently participate, but reserves the right to add in the future."]
[]
[]
[]
[]
[]
["Total",{"$nulls":3},{"$f":"SUM(E17:E23)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(F17:F23)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(G17:G23)","v":{"v":0,"d":"0.00"}}]
[]
["SFSP"]
["SFA does not currently participate, but reserves the right to add in the future."]
[]
[]
[]
[]
["Total",{"$nulls":3},{"$f":"SUM(E27:E31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(F27:F31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(G26:G31)","v":{"v":0,"d":"0.00"}}]
[]
[]
["The ADP (Average Daily Participation) and A la Carte/Catering Information is based on data from a projection for the current school year (2018-2019) using the month(s) of insert month(s), year.  Use this ADP to determine the number of projected snacks sold on the Revenue Information Sheet for the entire school year.  For example, the projected number of paid snacks sold is determined by taking the paid ADP above and multiplying it by the number of days of snack indicated at the top of the Projected Revenue Information sheet."]
[]
["*ADP by building is calculated using the following formula:  number of meals served divided by the number of service days per building."]

{"sheet":"13-SD Info - Suppers","index":12,"n_rows":34,"n_cols":7,"rows_kept":34,"merged":[[4,2,4,3],[4,4,4,6],[31,0,31,6],[33,0,33,6]]}
["SCHOOL DISTRICT INFORMATION: SUPPER PROGRAM"]
["PROJECTED PRICES/COUNTS/OTHER INCOME"]
["CACFP/SFSP"]
[]
[null,null,"Meal Prices",null,"COUNTS\n*Reimbursable Meal ADP"]
["School Building","Enrollment","Adult","Student","Paid","Free","Reduced"]
["CACFP"]
["SFA does not currently participate, but reserves the right to add in the future."]
{"$rows_empty":8}
["Total",{"$nulls":3},{"$f":"SUM(E7:E16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(F7:F16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(G7:G16)","v":{"v":0,"d":"0.00"}}]
[]
["SFSP"]
["SFA does not currently participate, but reserves the right to add in the future."]
{"$rows_empty":8}
["Total",{"$nulls":3},{"$f":"SUM(E20:E28)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(F20:F28)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(G19:G28)","v":{"v":0,"d":"0.00"}}]
[]
[]
["The ADP (Average Daily Participation) and A la Carte/Catering Information is based on data from a projection for the current school year (2018-2019) using the month(s) of insert month(s), year.  Use this ADP to determine the number of projected suppers sold on the Revenue Information Sheet for the entire school year.  For example, the projected number of paid suppers sold is determined by taking the paid ADP above and multiplying it by the number of days of supper indicated at the top of the Projected Revenue Information sheet."]
[]
["*ADP by building is calculated using the following formula:  number of meals served divided by the number of service days per building."]

{"sheet":"14-Revenue Info","index":13,"n_rows":122,"n_cols":7,"rows_kept":122,"merged":[[0,0,0,3],[35,0,35,3],[36,0,36,3],[37,0,37,3],[121,0,121,3]]}
["PROJECTED REVENUE INFORMATION"]
[]
["Based on 180 of Breakfast, 175 days of Lunch, 0 days of Snacks for NSLP"]
[]
["LOCAL REVENUE"]
[null,"Number Sold","Price"]
["Breakfasts"]
["Elementary Paid",{"$f":"SUM('10-SD Info - Brkfst'!E8:E10)*180","v":{"v":8358.260869565218,"d":"8,358"}},{"v":1.75,"d":"$1.75"},{"$f":"+B8*C8","v":{"v":14626.956521739132,"d":"$14,626.96"}}]
["Secondary Paid (inc. Pine)",{"$f":"SUM('10-SD Info - Brkfst'!E11:E13)*180","v":{"v":4773.913043478261,"d":"4,774"}},{"v":2,"d":"$2.00"},{"$f":"+B9*C9","v":{"v":9547.826086956522,"d":"$9,547.83"}}]
["Reduced",{"$f":"SUM('10-SD Info - Brkfst'!G16)*180","v":{"v":9993.91304347826,"d":"9,994"}},{"v":0.3,"d":"$0.30"},{"$f":"+B10*C10","v":{"v":2998.173913043478,"d":"$2,998.17"}}]
["Adult",0,{"v":4.65,"d":"$4.65"},{"$f":"+B11*C11","v":{"v":0,"d":"$0.00"}}]
[null,null,"Breakfast Revenue",{"$f":"SUM(D8:D11)","v":{"v":27172.956521739135,"d":"$27,172.96"}}]
[]
["Lunches"]
["Elementary Paid",{"$f":"SUM('11-SD Info - Lunch'!E8:E10)*175","v":{"v":44404.34782608696,"d":"44404"}},{"v":2.55,"d":"$2.55"},{"$f":"B15*C15","v":{"v":113231.08695652174,"d":"$113,231.09"}}]
["Parochial Paid",{"$f":"SUM('11-SD Info - Lunch'!E14:E15)*175","v":{"v":10267.249999999998,"d":"10267"}},{"v":2.7,"d":"$2.70"},{"$f":"B16*C16","v":{"v":27721.574999999997,"d":"$27,721.58"}}]
["Pine & MS Paid",{"$f":"SUM('11-SD Info - Lunch'!E11:E12)*175","v":{"v":35266.304347826095,"d":"35266"}},{"v":2.9,"d":"$2.90"},{"$f":"B17*C17","v":{"v":102272.28260869568,"d":"$102,272.28"}}]
["HS Paid",{"$f":"SUM('11-SD Info - Lunch'!E13)*175","v":{"v":39352.17391304348,"d":"39352"}},"$2.90 - $3.90",{"$f":"(((2.9+3.4+3.9)/3)*B18)","v":{"v":133797.39130434784,"d":"$133,797.39"}}]
["Reduced",{"$f":"SUM('11-SD Info - Lunch'!G16)*175","v":{"v":36029.07608695652,"d":"36029"}},{"v":0.4,"d":"$0.40"},{"$f":"+B19*C19","v":{"v":14411.630434782608,"d":"$14,411.63"}}]
["Adult",617,{"v":4.65,"d":"$4.65"},{"$f":"+B20*C20","v":{"v":2869.05,"d":"$2,869.05"}}]
[null,null,"Lunch Revenue",{"$f":"SUM(D15:D20)","v":{"v":394303.01630434784,"d":"$394,303.02"}}]
[]
["Special Milk"]
["     Elementary Paid",null,null,{"$f":"+B24*C24","v":{"v":0,"d":"$0.00"}}]
["     Secondary Paid",null,null,{"$f":"+B25*C25","v":{"v":0,"d":"$0.00"}}]
[null,null,"Special Milk Revenue",{"v":0,"d":"$0.00"}]
[]
["*A la Carte Sales","Actual 17-18 sales","=",{"v":138625.65,"d":"$138,625.65"},null,{"$f":"D28+D29","v":{"v":205643.36,"d":"$205,643.36"}}]
["**Catering and Other Functions","Actual 17-18 sales","=",{"v":67017.71,"d":"$67,017.71"}]
["Other (i.e. Head Start, Senior Citizens, etc.)",null,"=",{"v":0,"d":"$0.00"}]
["Other Sponsors",null,"=",{"v":0,"d":"$0.00"}]
["Summer Programs",null,"=",{"v":36215.93,"d":"$36,215.93"}]
[]
[null,null,"Total Local Revenue",{"$f":"+D12+D21+D26+D28+D29+D30+D31+D32","v":{"v":663335.262826087,"d":"$663,335.26"}}]
[]
["*Includes income from vending machines, if applicable."]
["**Identify schools having vended meal contracts with the school district in the School District "]
["Information sheet for Breakfast, Lunch, etc. and Building Demographics/Service Information sheet."]
["FEDERAL REIMBURSEMENTS"]
[null,"Number Sold","Federal Rates for SY 2018-19"]
["Breakfasts: NSLP "]
["Free",null,1.79,{"$f":"+B42*C42","v":{"v":0,"d":"$0.00"}},null,{"$f":"SUM(D42:D55)","v":{"v":142843.14782608693,"d":"$142,843.15"}},{"$f":"SUM(B42:B55)/2","v":{"v":39689.99999999999,"d":"39690"}}]
["Free, severe need",{"$f":"SUM('10-SD Info - Brkfst'!F16)*180","v":{"v":56253.91304347826,"d":"56,254"}},2.14,{"$f":"+B43*C43","v":{"v":120383.37391304347,"d":"$120,383.37"}}]
["Reduced",null,1.49,{"$f":"+B44*C44","v":{"v":0,"d":"$0.00"}}]
["Reduced, severe need",{"$f":"SUM('10-SD Info - Brkfst'!G16)*180","v":{"v":9993.91304347826,"d":"9,994"}},1.84,{"$f":"+B45*C45","v":{"v":18388.8,"d":"$18,388.80"}}]
["Paid",{"$f":"SUM('10-SD Info - Brkfst'!E16)*180","v":{"v":13132.173913043478,"d":"13,132"}},0.31,{"$f":"+B46*C46","v":{"v":4070.973913043478,"d":"$4,070.97"}}]
[]
["Breakfast: CACFP"]
["Free, At-Risk",null,1.79,{"$f":"+B49*C49","v":{"v":0,"d":"$0.00"}}]
["Reduced",null,1.49,{"$f":"+B50*C50","v":{"v":0,"d":"$0.00"}}]
["Paid ",null,0.31,{"$f":"+B51*C51","v":{"v":0,"d":"$0.00"}}]
[]
["Breakfast: SFSP"]
["Urban or Vended sites",null,{"v":2.19,"d":"2.1900"},{"$f":"+B54*C54","v":{"v":0,"d":"$0.00"}}]
["Rural or Self-prep sites",null,2.2325,{"$f":"+B55*C55","v":{"v":0,"d":"$0.00"}}]
[]
["Lunches: NSLP"]
["Free",null,3.31,{"$f":"+B58*C58","v":{"v":0,"d":"$0.00"}},null,{"$f":"SUM(D58:D78)","v":{"v":624486.9940217392,"d":"$624,486.99"}},{"$f":"SUM(B58:B78)","v":{"v":304679.1847826087,"d":"304679"}}]
["Free + $.06",{"$f":"SUM('11-SD Info - Lunch'!F16)*175","v":{"v":139360.03260869568,"d":"139,360"}},3.37,{"$f":"+B59*C59","v":{"v":469643.30989130447,"d":"$469,643.31"}}]
["Free, severe need",null,3.33,{"v":0,"d":"$0.00"}]
["Free, severe need + $.06",null,3.39,{"$f":"+B61*C61","v":{"v":0,"d":"$0.00"}}]
["Reduced",null,2.91,{"v":0,"d":"$0.00"}]
["Reduced + $.06",{"$f":"SUM('11-SD Info - Lunch'!G16)*175","v":{"v":36029.07608695652,"d":"36,029"}},2.97,{"$f":"+B63*C63","v":{"v":107006.35597826088,"d":"$107,006.36"}}]
["Reduced, severe need",null,2.93,{"v":0,"d":"$0.00"}]
["Reduced, severe need + $.06",null,2.99,{"$f":"+B65*C65","v":{"v":0,"d":"$0.00"}}]
["Paid",null,0.31,{"v":0,"d":"$0.00"}]
["Paid + $.06",{"$f":"SUM('11-SD Info - Lunch'!E16)*175","v":{"v":129290.07608695653,"d":"129,290"}},0.37,{"$f":"+B67*C67","v":{"v":47837.32815217391,"d":"$47,837.33"}}]
["Paid, severe need ",null,0.33,{"$f":"+B68*C68","v":{"v":0,"d":"$0.00"}}]
["Paid, severe need + $.06",null,0.39,{"v":0,"d":"$0.00"}]
[]
["Lunches: CACFP"]
["Free, At-Risk",null,3.31,{"$f":"+B72*C72","v":{"v":0,"d":"$0.00"}}]
["Reduced",null,2.91,{"$f":"+B73*C73","v":{"v":0,"d":"$0.00"}}]
["Paid",null,0.31,{"$f":"+B74*C74","v":{"v":0,"d":"$0.00"}}]
[]
["Lunches: SFSP"]
["Urban or Vended sites",null,3.8575,{"$f":"+B77*C77","v":{"v":0,"d":"$0.00"}}]
["Rural or Self-prep sites",null,3.9225,{"$f":"+B78*C78","v":{"v":0,"d":"$0.00"}}]
[]
["Snacks: NSLP"]
["Free",null,0.91,{"$f":"+B81*C81","v":{"v":0,"d":"$0.00"}},null,{"$f":"SUM(D81:D91)","v":0},{"$f":"SUM(B81:B92)/3","v":0}]
["Reduced",null,0.45,{"$f":"+B82*C82","v":{"v":0,"d":"$0.00"}}]
["Paid",null,0.08,{"$f":"+B83*C83","v":{"v":0,"d":"$0.00"}}]
[]
["Snacks: CACFP"]
["Free, At-Risk",null,0.91,{"$f":"+B86*C86","v":{"v":0,"d":"$0.00"}}]
["Reduced",null,0.45,{"$f":"+B87*C87","v":{"v":0,"d":"$0.00"}}]
["Paid",null,0.08,{"$f":"+B88*C88","v":{"v":0,"d":"$0.00"}}]
[]
["Snacks: SFSP"]
["Urban or Vended sites",null,{"v":0.91,"d":"0.9100"},{"$f":"+B91*C91","v":{"v":0,"d":"$0.00"}}]
["Rural or Self-prep sites",null,{"v":0.93,"d":"0.9300"},{"$f":"+B92*C92","v":{"v":0,"d":"$0.00"}}]
[]
["Suppers: CACFP"]
["Free, At-Risk",null,3.31,{"$f":"+B95*C95","v":{"v":0,"d":"$0.00"}},null,{"$f":"SUM(D95:D100)","v":0},{"$f":"SUM(B95:B101)","v":{"v":0,"d":"0 "}}]
["Reduced",null,2.91,{"$f":"+B96*C96","v":{"v":0,"d":"$0.00"}}]
["Paid",null,0.31,{"$f":"+B97*C97","v":{"v":0,"d":"$0.00"}}]
[]
["Suppers: SFSP"]
["Urban or Vended sites",null,3.8575,{"$f":"+B100*C100","v":{"v":0,"d":"$0.00"}}]
["Rural or Self-prep sites",null,3.9225,{"$f":"+B101*C101","v":{"v":0,"d":"$0.00"}}]
[]
[null,null,"Total Meals Reimbursement",{"$f":"SUM(D42:D100)","v":{"v":767330.1418478262,"d":"$767,330.14"}}]
[]
["Special Milk"]
["Paid",null,{"v":0.205,"d":"0.2050"},{"$f":"+B106*C106","v":{"v":0,"d":"$0.00"}},null,{"$f":"SUM(D106:D107)","v":0},{"$f":"SUM(B106:B107)","v":0}]
["Free",null,"enter avg cost"]
[]
[null,null,"Special Milk Reimbursement",{"$f":"+D106+D107","v":{"v":0,"d":"$0.00"}}]
[]
[null,"Total Federal Reimbursement",null,{"$f":"+D103+D109","v":{"v":767330.1418478262,"d":"$767,330.14"}}]
[null,"31a Payment (State Aid Status Report",null,{"v":959,"d":"$959.00"}]
[null,"31d Payment (State Aid Status Report)",null,{"v":59174.53,"d":"$59,174.53"}]
[null,"31f Payment (State Aid Status Report)"]
[null,"Fresh Fruit and Vegetable (FFVP) Grant"]
[null,"Interest Income"]
[null,"Total Local Revenue",null,{"$f":"+D34","v":{"v":663335.262826087,"d":"$663,335.26"}}]
[]
[null,null,"Total Revenue",{"$f":"SUM(D111:D118)","v":{"v":1490798.9346739133,"d":"$1,490,798.93"}}]
[]
[]
["These figures are based on projected revenue for the current school year (2018-2019) using the month of October, 2018.  Multiply the ADP from the SD Info - Breakfast and Lunch sheets by the number of days above to determine the number of projected meals sold. "]

{"sheet":"15-Meal Equiv Calculator","index":14,"n_rows":24,"n_cols":4,"rows_kept":24,"merged":[[0,0,0,3],[2,0,2,3]]}
["PROJECTED MEALS/MEAL EQUIVALENTS CALCULATOR"]
[]
["CELLS ARE AUTO-FILL; DO NOT ENTER MEAL COUNTS ON THIS PAGE"]
[]
[]
[]
["Federal Free Lunch Rate",{"v":3.31,"d":"$3.3100"}]
["+ Commodity Rate",{"v":0.235,"d":"$0.2350"}]
["Total",{"$f":"SUM(B7:B8)","v":{"v":3.545,"d":"$3.5450"}}]
[null,"*A la carte and catering income",{"$f":"SUM('14-Revenue Info'!F28)","v":{"v":205643.36,"d":"$205,643.36"}}]
[null,null,"A la Carte/catering Meal Equivalents (Divide Income by Total)",{"$f":"+C10/B9","v":{"v":58009.41043723554,"d":"58009"}}]
[null,null,"Breakfasts Served ",{"$f":"+'14-Revenue Info'!$G$42","v":{"v":39689.99999999999,"d":"39690"}}]
[null,null,"Lunches Served ",{"$f":"+'14-Revenue Info'!$G$58","v":{"v":304679.1847826087,"d":"304679"}}]
[null,null,"Snacks Served",{"$f":"+'14-Revenue Info'!$G$81","v":0}]
[null,null,"Suppers Served",{"$f":"+'14-Revenue Info'!$G$81","v":0}]
[null,null,"*Total Meals and snacks served, A la Carte Meal Equivalents",{"$f":"SUM(D11:D15)","v":{"v":402378.59521984425,"d":"402379"}}]
["*Note that we are opening a new wing in our Middle School."]
[]
[]
["A la Carte income includes any income from dining room operations which are not part of the"]
["Reimbursable Meals Program."]
[]
["*The A la Carte and catering income, total meals, snacks, and meal equivalents is based on data from a  "]
["projection for the current school year (2018-2019) using the month of October, 2018."]

{"sheet":"16-Bldg Demographics","index":15,"n_rows":21,"n_cols":9,"rows_kept":21,"merged":[[0,0,0,8],[3,0,4,0],[3,1,4,1],[3,2,4,2],[3,3,3,4],[3,5,3,8]]}
["BUILDING DEMOGRAPHICS"]
[]
[]
["School Building","Grades \n(SY 2018-19)","Grades \n(SY 2019-20)","Service Times",null,"# of Days/Year"]
[{"$nulls":3},"Breakfast","Lunch","Breakfast","Lunch","Snack","Supper"]
["Baker Elementary","Pre-K - 1","Pre-K - 1","8:45 am - 9:05 am","11:15 am - 1:30 pm",180,175,0,0]
["Dorr Elementary","Pre-K - 4","Pre-K - 3","8:15 am - 8:50 am","11:20 am - 1:15 pm",180,175,0,0]
["Steeby Elementary","2 - 4","2 - 3","8:30 am - 8:45 am","10:30 am - 1:05 pm",180,175,0,0]
["Pine Street Elementary","5 - 6","4 - 5","7:15 am - 7:30 am","11:05 am - 12:40 pm",180,175,0,0]
["Middle School","7 - 8","6 - 8","7:15 am - 7:45 am","11:16 am - 12:44 pm",180,175,0,0]
["High School","9 - 12","9 - 12","7:15 am - 7:40 am","11:08 am - 12:37 pm",180,175,0,0]
["Moline Christian","Pre-K - 8","Pre-K - 8","N/A","12:00 pm - 12:20 pm",0,175,0,0]
["St. Therese","Pre-K - 6","Pre-K - 6","N/A","12:15 pm - 12:35 pm",0,175,0,0]
[]
["*Note that we are opening a new wing in our Middle School."]
["**Additionally, note that we are starting prior to Labor Day next school year; 8/26/19 is the first day for students."]
[]
["List school(s) or sites having VENDED meal contract(s) with the School District:"]
[]
["List Child Nutrition Program \nMeals Provided","List Types of \nMeals Provided",null,"Is there a written contract/agreement?  Yes or No","Anticipated $ Value of Vended Agreement"]
["N/A"]

{"sheet":"17-Services by Location","index":16,"n_rows":11,"n_cols":8,"rows_kept":11,"merged":[[0,0,0,7]]}
["SERVICES BY LOCATION:  The services that are indicated below with an \"x\" are to be provided at the following locations.  Indicate either Full Serve OR Offer vs. Serve, not both."]
[]
["School Building","Full Serve\nBreakfast","Offer vs. Serve\nBreakfast","Full Serve\nLunch","Offer vs. Serve \nLunch","A la Carte","Adult\nMeals","Split Session\nKindergarten\nSpecial Milk"]
["Baker Elementary",null,"X",null,"X","X","X"]
["Dorr Elementary",null,"X",null,"X","X","X"]
["Steeby Elementary",null,"X",null,"X","X","X"]
["Pine Street Elementary",null,"X",null,"X","X","X"]
["Middle School",null,"X",null,"X","X","X"]
["High School",null,"X",null,"X","X","X"]
["Moline Christian",{"$nulls":3},"X",null,"X"]
["St. Therese",{"$nulls":3},"X",null,"X"]

{"sheet":"18-Cost Responsibility Detail","index":17,"n_rows":97,"n_cols":9,"rows_kept":97,"merged":[[0,0,0,8],[2,0,2,8]]}
["Cost Responsibility Detail Sheet (to be completed by SFA)"]
[]
["Indicate with an \"x\" whether the cost will be paid by the FSMC, the School District, or whether the cost does not apply to the prospective contract."]
[]
[null,"Areas of Responsibility",null,null,"FSMC",null,"SFA",null,"N/A"]
[]
["Food"]
[null,"Food Purchases",null,null,"X"]
[null,"Commodity Delivery & Processing Charges",null,null,"X"]
[null,"Storage/Warehousing Charges",null,null,"X"]
[null,"Processing and Payment of Invoices",null,null,"X"]
[]
["Non-Food"]
[null,"Cleaning/Janitorial Supplies",null,null,"X"]
[null,"Paper/Disposable Supplies",null,null,"X"]
[null,"Tickets/Tokens/Cards",{"$nulls":4},"X"]
[]
["Labor","FSMC Employees:"]
[null,"Salary/Wages",null,null,"X"]
[null,"Fringe Benefits (Vacation, Sick Leave, Holiday Pay)",null,null,"X"]
[null,"Insurance (Life, Medical, Dental)",null,null,"X"]
[null,"Retirement - Social Security",null,null,"X"]
[null,"Payroll Taxes",null,null,"X"]
[null,"Workers Compensation",null,null,"X"]
[null,"Unemployment Compensation",null,null,"X"]
[null,"Uniforms - Tuition Reimbursement",null,null,"X"]
[null,"Preparation & Processing of Payroll",null,null,"X"]
[]
[null,"SFA Employees:"]
[null,"Wages",{"$nulls":4},"X"]
[null,"Fringe Benefits (Vacation, Sick Leave, Holiday Pay)",{"$nulls":4},"X"]
[null,"Insurance (Life, Medical, Dental)",{"$nulls":4},"X"]
[null,"Retirement - Social Security",{"$nulls":4},"X"]
[null,"Payroll Taxes",{"$nulls":4},"X"]
[null,"Workers Compensation",{"$nulls":4},"X"]
[null,"Unemployment Compensation",{"$nulls":4},"X"]
[null,"Uniforms - Tuition Reimbursement",{"$nulls":4},"X"]
[null,"Preparation & Processing of Payroll",{"$nulls":4},"X"]
[]
["Equipment Replacement, Maintenance, & Repair"]
[null,"Major, Non-expendable",{"$nulls":4},"X"]
[null,"Expendable:"]
[null,"Silverware/Glassware/Trays/Utensils"]
[null,null,"Initial Inventory",{"$nulls":3},"X"]
[null,null,"Replacement During Operation",null,"X"]
[]
["Telephone/Computer"]
[null,"Local",{"$nulls":4},"X"]
[null,"Long Distance",{"$nulls":4},"X"]
[null,"Internet Access",{"$nulls":4},"X"]
[]
["Office Materials and Supplies"]
[null,"Paper",null,null,"X"]
[null,"Printing",null,null,"X",null,"X"]
[null,"Postage",null,null,"X",null,"X"]
[]
[null,"Areas of Responsibility",null,null,"FSMC",{"$nulls":3},"N/A"]
[]
["Linens and Laundry",{"$nulls":7},"X"]
[]
["Trash Removal"]
[null,"From Kitchen",null,null,"X",null,"X"]
[null,"From Dining Area",{"$nulls":4},"X"]
[null,"From Premises",{"$nulls":4},"X"]
[]
["Pest Control",{"$nulls":5},"X"]
[]
["Insurance"]
[null,"Liability Insurance (Product and Public)",null,null,"X",null,"X"]
[null,"Insurance on Supplies/Inventory",null,null,"X",null,"X"]
[null,"Product Liability",null,null,"X"]
[]
["Equipment Rental (explain)",{"$nulls":7},"X"]
[]
["Car/Truck Rental (explain)",{"$nulls":7},"X"]
[]
["Vehicle Maintenance and Transportation",{"$nulls":5},"X"]
[]
["Travel and Training"]
[null,"Professional Standards Training",null,null,"X",null,"X"]
[]
["Taxes and Licenses",{"$nulls":3},"X",null,"X"]
[]
["Promotional and Educational Materials",{"$nulls":3},"X"]
[]
["Cleaning Responsibilties"]
[null,"Preparation Areas",{"$nulls":4},"X"]
[null,"Serving Areas",{"$nulls":4},"X"]
[null,"Kitchen Floors",{"$nulls":4},"X"]
[null,"Dining Room Floors",{"$nulls":4},"X"]
[null,"Hoods, Duct Work",{"$nulls":4},"X"]
[null,"Routine Cleaning of Tables and Chairs",{"$nulls":4},"X"]
[null,"Cafeteria Walls",{"$nulls":4},"X"]
[null,"Light Fixtures",{"$nulls":4},"X"]
[null,"Windows",{"$nulls":4},"X"]
[null,"Grease Traps",{"$nulls":4},"X"]
[null,"Restrooms",{"$nulls":4},"X"]

{"sheet":"19-Claims for Reimbursement","index":18,"n_rows":5,"n_cols":3,"rows_kept":5}
["CLAIM REIMBURSEMENTS"]
["MDE will supply the district with claim data for appropriate months. "]
["SFA will identify which claim(s) were used to calculate ADP on the SDI pages."]
[]
["See attached.",null," "]

{"sheet":"20-Breakfast Menu","index":19,"n_rows":5,"n_cols":3,"rows_kept":5}
["Attach a sample 21-day cycle Breakfast Menu prepared by the SFA.  This menu must have"]
["21 or more days that actually have breakfast being served to the students.  This menu"]
["must be used for the first 21-day cycle of the new school year."]
[]
["See attached.",null," "]

{"sheet":"21-Lunch Menu","index":20,"n_rows":5,"n_cols":1,"rows_kept":5}
["Attach a sample 21-day cycle Lunch Menu prepared by the SFA.  This menu must have"]
["21 or more days that actually have lunch being served to the students.  This menu"]
["must be used for the first 21-day cycle of the new school year."]
[]
["See attached."]

{"sheet":"22-A la Carte","index":21,"n_rows":6,"n_cols":1,"rows_kept":6}
["A la Carte Information"]
[]
["Insert or attach a separate PDF of the SFA's A la Carte items and pricing.  "]
[]
[]
["See attached."]

{"sheet":"23-Food Spec Cover Sht","index":22,"n_rows":30,"n_cols":1,"rows_kept":30}
["School Meals Program - Food Specifications Cover Sheet"]
[]
["SEE ATTACHED DOCUMENT\nNutrition Standards, Food Specifications, Meal Patterns "]
[]
["Notes"]
[]
["The USDA may update program requirements at any time. "]
[]
["The Vendor is responsible to adhere to the most current USDA guidance at the time of bid submission and must continuously ensure meals are in compliance with USDA requirements for the duration of the contract."]
[]
["The SFA must monitor the Vendor's compliance with these requirements in accordance with the terms set forth in the RFP. "]
[]
["Each meal must include the appropriate serving of each required food component and must be consistent with the targeted dietary specifications for sodium, calories, saturated and trans fat."]
[]
["Additional information about School Meals, Meal Pattern Requirements, Nutrition Standards, Regulations, Policy Memos, and Guidance Materials can be found at the following links:"]
["Click for Link to MDE-School Nutrition Programs-National School Lunch Program"]
["Click for Link to USDA-School Meals Nutrition Standards"]
["Click for Link to USDA-School Meals - Policy"]
[]
["While not inclusive, here are a few key USDA Policy memos that may be helpful:  "]
["1. USDA Memo SP 10-2012 (v.9) August 3, 2015 - Q & As on the Final Rule - \"Nutrition Standards in the NSLP & SBP\""]
["2. USDA Memo SP 41-2015,  July 21, 2015 - Updated OVS Guidance (SY 2015-16)"]
[]
["Additional Child Nutrition Program Information links:"]
["Click for Link to MDE-Food and Nutrition Programs-Summer Food Service Program"]
["Click for Link to MDE-Food and Nutrition Programs-Child and Adult Care Food Program"]
["Click for Link to MDE-Food and Nutrition Programs-School Nutrition Programs-Fresh Fruit and Vegetable Program"]
[]
["Enter Specific Requirements for this SFA: NONE"]
["WUS abides by the MDE-School Nutrition Programs - National School Lunch Program standards."]

{"sheet":"24-Bid Sheet Cover","index":23,"n_rows":13,"n_cols":1,"rows_kept":13}
["Bid Sheet"]
[]
[]
["The SFA (School Food Authority) will provide a blank bid sheet with every RFP (Request for Proposal) used for a cost reimbursable contract."]
[]
["The FSMC (Food Service Management Company) will return the completed bid sheet in a separate envelope marked \"Bid Sheet - Cost Reimbursable Contract.\""]
[]
["Use of a meal and meal equivalent figure different than the one supplied by the SFA will cause the bid to be \"non-responsive.\""]
[]
["The school district representative will insert the number of meal and  meal equivalents per year on the bid sheet.  "]
[]
["The bid sheet will be inserted into the RFP/Cost Reimbursable Contract after the "]
["Food Specification Sheet(s)."]

{"sheet":"25-Bid without Advance Payment","index":24,"n_rows":63,"n_cols":10,"rows_kept":63,"merged":[[0,0,0,10],[1,0,1,10],[2,0,2,10],[3,0,3,10],[51,0,51,9],[58,0,58,9],[60,0,60,9],[62,0,62,9]]}
["Bid Sheet - Cost Reimbursable Contract"]
["Projected Operating Cost"]
["Without Advance Payment"]
["Wayland Union Schools"]
[]
["This bid is offered by",{"$nulls":4},"(Food Service Management Company) based upon"]
[]
[null,{"$f":"SUM('15-Meal Equiv Calculator'!D16)","v":{"v":402378.59521984425,"d":"402,379"}},null,"equivalent meals per year."]
[]
["Expenses that the SFA is contracting for are indicated by an \"X\" in the Bid Items Column below."]
[]
[{"$nulls":6},"\"X\" Bid Items",null,null,"Cost"]
[]
["Food Cost - Including Commodities Delivery Charge",{"$nulls":5},"X"]
[null,"  - Net of VDA/Rebates"]
[]
["Food Cost - FFVP ( as defined in RFP)"]
[]
["Labor"]
[]
["Fringe Benefits"]
[]
["On-Site Manager Salary and Benefits",{"$nulls":5},"X"]
[]
["Contracted Services (not utilities or FSMC administrative costs)"]
[]
["Transportation Cost"]
[]
["Non-Food Cost",{"$nulls":5},"X"]
[]
["Non-Food Cost - FFVP (as defined in RFP)"]
[]
["Utilities Paid by Food Service Fund"]
[]
["Other (as defined on cost information sheet)"]
[]
["Flat Rate for FFVP (as defined in RFP)"]
[]
["FSMC Administrative Cost",{"$nulls":5},"X"]
[]
["FSMC Management Fee",{"$nulls":5},"X"]
[]
["Total Cost (Bid Items Only)"]
[]
[]
["Bid Price Per Meal (Total Cost divided by Equivalent Meals Per Year)"]
[]
[]
["Additional Food Service Markup (Refer to RFP) if applicable"]
[]
[]
["By submission of this bid, the bidder certifies that, in the event the bidder receives an award under this solicitation, the bidder shall operate in accordance with all applicable program laws and regulations.  This contract shall be in effect for one year and may be renewed by mutual agreement for four additional one-year periods."]
[]
[]
["Signed:"]
[null,"Food Management Company Representative",{"$nulls":4},"Date"]
[]
[]
["This form is to be submitted in a separate envelope marked: Bid Sheet - Cost Reimbursable Contract."]
[]
["Insert this into the contract immediately before the signature page prior to signing."]
[]
["The Food Service Management Company must use the bid sheet provided by the school district in the pre-bid packet when submitting its bid."]