Integrated School Nutrition Technology Software Solution for Saint Paul Public Schools’ Nutrition Services Y= Yes, Mandatory, N=No, Not Mandatory, D=Not Mandatory but highly desired. Specification Number Specification /Feature Mandatory Feature Feature in Current System Future Features (by July 2017) Feature not available 1.00 Modules 1.01 Point of Sale Y 1.02 Online Payments Y 1.03 Free and Reduced Meal Applications Y 1.04 Back Office/Central Administration Y 1.05 Inventory Y 1.06 Nutrition Analysis, Menu Planning, and Ordering Y 2.00 Point of Sale 2.01 Web-based system with real-time data transfer and communicates real-time to the main database N 2.02 Easy to use interface that is easily learned Y 2.03 Ability to seamlessly use a wireless terminal or connection without any issue to end users like speed Y 2.04 Tolerance: Ability to run in standalone mode, and update the POS main database automatically upon its availability in case of interrupted service to the server Y 2.05 Ability to check student's meal history, payments history, and account history from a local terminal and district terminals. Y 2.06 System must include reporting features on payments, meal counts and reconciliation Y 2.07 Ability to pre-order meals from the classroom N 2.08 Ability to e-mail low-balance letters to parents and/or employees Y 2.09 Ability for a single check to be split up and deposited into multiple student accounts from terminals Y 2.10 Option for automatic fund transferring between sibling's accounts Y 2.11 Terminal screens that are glare resistant under florescent light if equipment is purchased from vendor N 2.12 Ability to angle and move terminal screens if equipment is purchased from vendor Y 2.13 System has an extensive selection of standard preformatted reports Y 2.14 Ability to export reports to Microsoft 2007 or higher Y 2.15 Ability to export reports to a delimited file Y 2.16 Tracks meals served for all eligibility categories, i.e. free, reduced, full pay, etc. Y
5.21 Tool has capability to track Provision 2 program requirements, i.e. base year data, renewal dates Y 5.22 Manage all aspects of POS menu views from the back office, with access to items offered, price, and other menu view attributes Y 5.23 All reports are available for the entire school year and may be generated for any day or date Y 5.24 Provides automatic end of year student grade promotion and graduation or moves students based on student information system year end promotion Y 5.25 Account balance roll-over available for year end Y 5.26 Operates on Windows 10 or higher or independent PC Y 5.27 A single, centralized database stores all data Y 5.28 Customer digital photographs can either be added to the database from professional photographer's CD using the user defined import program or via data transfer from other designated software/device Y 5.29 New students or employees pictures can be added at the school or location site with a digital camera or webcam N 5.30 Word processor with mail merge included for messaging or letter writing or links to Microsoft Word 2016 or higher Y 5.31 Purchase and accounting controls can be defined for each individual customer i.e. purchasing privileges, charging limits, ala carte purchase limits, daily spending limits, dietary restrictions, food allergies, etc. Y 5.32 Ability to view or print a bank statement style student account statement showing all deposits and purchases Y 5.33 Ability communicate and to import and export data to and from PeopleSoft Y 5.34 Ability to interface with District’s communications system, Blackboard’s Connect 5. 5.35 Database must be SQL compliant Y 5.36 Ability to update POS software as USDA child nutrition programs are changed Y 5.37 Ability to include Child and Adult Care Food Program Federal requirements Y 5.38 Ability to create and export customizable financial reports in Excel format (i.e. Meals Per Labor Hour, Food Cost (in dollars and percentage of revenue) by individual sites, by district defined groups, and by district. Y
5.39 Meal Per Labor Hour reports that include ME for adult meals and a la carte purchases as well as meal counts for the following programs: SNP Breakfast SNP Lunch SNP Snack CACFP Breakfast CACFP Lunch/Supper CACFP Snack SFSP Breakfast SFSP Lunch/Supper SFSP Snack Kindergarten Milk FFVP Snack Y 5.40 Ability to include and Adult Care Food Program Federal requirements Y 5.41 Ability for site/school to determine if and when to make deposit. Y 6.00 Inventory 6.01 Ability to interact with District’s invoicing software (PeopleSoft) Y 6.02 Ability to accommodate perpetual inventory methodology Y 6.03 Ability to accommodate non-perpetual inventory methodology Y 6.04 Tool prevent unnecessary orders and keeps quantities at optimal levels Y 6.05 Ability to view real-time inventory levels while creating , reviewing, and approving purchase requests Y 6.06 Ability to receive previously ordered products with a single keystroke Y 6.07 Create and maintain reorder points on designated products Y 6.08 Ability to automatic calculation of item quantities needed for menu plans, considering committed on-hand and due-in quantities Y 6.09 Ability to provide a report that list quantities on-hand, quantities due-in and quantities needed. Y 6.10 Purchase orders grouped by vendor, location, deliver and date Y 6.11 System has comprehensive reporting package that tracks all aspects of product flow through the District Y 6.12 Ability to track inventory cost by item Y 6.13 Ability to retain inventory cost when transferring item between Y 6.14 Is Module optional N 6.15 Ability to have multiple bin locations for same product. Y 6.16 Ability to view item(s) by bin. Y 6.17 Ability to create inventory and inventory evaluations in editable Excel format. Y 6.18 Ability to zero out inventory when doing physical inventory. D 6.19 Ability to control and track inventory through scanning technology. Y