Inventory & Sales Tracking System

Statement of Work: Inventory and Sales Tracking System We are searching for an Inventory tracking system for The Food Court, Club, School Lunch, Strike Zone, Sakura Theater and Warehouse. The following functionalities are needed. A software administrative ability, recipe and menu tracking capability, Inventory Control Management, Sales tracking software, Production / Cost Card function, Nutritional Analysis, Ability to Interface with multiple vendors and multiple internal unit level systems , Mobile code reading or scanner capability, and set up technical training package. This inventory system must be able to Interface with multiple POS systems / software. Software Administrator This inventory system should allow us to centralize our inventories into one data base. It needs to employ internet technology to communicate between Software being used by our vendors. Software must be flexible and can be configured to meet the specialized needs of many different foodservice operations, such as Military Clubs, Fast Food Franchises, Theater Snack Bar, Bowling Snack Bar and Lounge operations. System needs to be able to send specific information to an individual profit center / unit, as well as multiple profit centers. Software needs to be able to decipher specific information when communicating with a specific Vendors / Client. Software should be able to allow Vendor / Client communications / information sharing for items like recipes, instructional video, PLU's / code reading, automated pricing updates, inventory / invoices tracking, transfers and requisitions. Recipe & Menu Costing Should be able to store, scale, and size an unlimited number of recipes / Production Cards. Instantly analyze recipes and menu costs by portion or yield. Update price changes from the vendors automatically. The software should allow for changes to ingredients in every recipe. Software should allow for effective costing for an entire function or individual item. Software should be able to auto-populate / generate recipe ingredient pull lists. Inventory Control Software must be able to track food cost and inventory values. Software should be able to track multiple invoices from different vendors and read individual vendor identification / item codes. System needs to have scanner code reading capability for physical inventory, be able to prepare orders and maintain par levels, track activity inventory movement through purchases and sales. Software needs to calculate inventory on-hand for multiple locations. System should be able to compare theoretical and actual usage and identify conflicts. Software needs to calculate overall food cost percentage for individual items and recipes / production card. System should have unlimited capacity for adding additional inventory items. Sales The system needs to track sales by hour, by day or period and rank sales by contribution to profit or number sold. Software needs to interface with multiple POS systems. System should have to the ability to print out sales data reports by profit center / unit for any period of time. Production The system should be able to create production cards for any recipe automatically based on par levels and desired quantity of product being prepared. Inventory should show automatic depletion once production cards show completion. System should be able to produce labels with production date and expiration date. Purchasing & Ordering Generate orders / requisitions based on preset par levels. Generate orders / requisitions for multi-vendors or single vendor. System should be able to generate requisitions sheets to be used in verifying / receiving of goods. System should generate customized reports for purchases, price variances, and credits. System needs to have the ability to analyze by inventory category, account category, profit center, location, etc. System needs to be able identify any price increases and decreases. Nutritional Analysis System should be able to accurately give analysis of nutritional values for commonly used ingredients. Allow end user to add specialty items and calculates nutritional values for recipes and menu items. Additional Requirements We would require a training package that would train our current staff and link us to our primary vendors through this system. The training needs to be customized to focus on the specific areas of the software that most apply to our operations. POS Interface Current POS systems in place are HSI, Micros and Subshop.