Superior Packing is a frozen vegetable repacking plant in San Antonio. This
operation mixes palletized boxes (usually weighing about 1000 pounds each) of frozen
vegetables into plastic bags or cases. These are sold to grocery stores or restaurants.
The existing application was written in Paradox. It took one person one entire
day to process the day's orders. This application was non-Y2K compliant, so it
had to be replaced.
We implemented a system using Microsoft SQL-Server 7.0 and Microsoft
Access/2000. This system cut the processing time from 1 work-day
(8 hours) to about four hours, provides costing analysis (previously
done by spreadsheet), and sales analysis functions (previously
carried out by importing sales information into Excel, sorting,
and summarizing). Development began in September 1999. The system
was put in production in mid-November, and was processing the
production cycle by the end of December. Sales analysis and costing
functions were complete by the end of January 2000.
|