Customers - Continental Canteen

Continental Canteen is a division of Continental Services, Inc. They service more than 3000 vending machines in the tri-county Detroit area. They have two warehouses on the East and West sides of Detroit.

Vending Route Monitor
Designed and programmed an MS Access database that reports all of the metrics used to manage a vending route. These include vending sales by category, food cost, food waste, commissions, customers, machines, service calls, and inventory. The data was originally imported from the EMS vending software later updated to Vendmax (an MSSQL application). The report is run by route and can be totalled by district manager or all routes.

Plan-O-Gram Audit
A browser-based auditing report that compares a vending machine item setup (plan-o-gram) against the actual items sold (Dex reading) from a vending machine. This audit compares every slot in the plan-o-gram against what is vended in the Dex reading and reports any discrepancies. This report is organized by machine and can be requested by a single machine, a complete customer, or the entire vending route.