CSE498, Collaborative Design, Spring 2012
Computer Science and Engineering
Michigan State University

Meijer is a family owned chain of supercenters committed to providing quality food and products to its customers all across the Midwestern United States. Health and food safety standards are an important part of the culture at Meijer.

Meijer has two types of health and food safety inspections, internal and external. Meijer employees complete internal audits with each department being graded with an effectiveness score. External audits are conducted by local, state, and food safety agencies like the USDA.

Currently, internal audits are done by paper and pencil. The resulting audits must be entered subsequently into a computer database. Safety violations are counted manually.

Our Food Safety Audits and Reports system replaces the pencil and paper system with a web-based system.

A tablet-based web application is used by internal inspectors within each store. Upon completion, the results of the inspection are automatically uploaded into Meijer’s central health and food safety database.

A second web application is used by Meijer managers to view and print reports. The reports are generated by store, based on a specified date range. The reports can be viewed and printed.

Our web applications are written using HTML 5, JavaScript, ASP.NET, and C#. Microsoft SQL Server 2008 is the database engine. Reports are generated using SQL Server Reporting Services.