Automated purchasing: Forecasts to determine stock levels and print orders

Area of Science:

• Foodservice Operations
• Supply Chain Management
• Inventory Control Systems

Background:

• Effective inventory management is crucial in foodservice to prevent stockouts and reduce waste.
• Manual purchasing processes can be inefficient and prone to errors, impacting operational costs.
• Existing computer-assisted management systems may lack automated inventory optimization for frozen goods.

Purpose of the Study:

• To develop and implement an automated purchasing system for frozen foods, specifically including meat items.
• To optimize inventory levels and minimize stock outages through data-driven calculations.
• To integrate the automated system seamlessly with existing computer-assisted management infrastructure.

Main Methods:

• Developed an automated purchasing system integrating menu item forecast data with on-hand inventory quantities.
• Automated the calculation of order quantities and the generation of purchase requisitions.
• Incorporated safety stock levels, accumulated forecasts, and existing orders into the ordering model.

Main Results:

• The automated purchasing system was successfully developed and implemented.
• All system programs functioned as planned, producing complete and accurate computer documents.
• The system effectively optimized inventory levels and minimized stock outages for frozen foods.
• Smooth integration with the existing computer-assisted management system was achieved.

Conclusions:

• The developed automated purchasing system is effective for optimizing frozen food inventory in foodservice operations.
• The system's design, incorporating forecasts and safety stock, proved reliable and accurate.
• The system was retained for ongoing use, demonstrating its value and successful integration.