Dynamic Bar Coding

Overview

Before this project, the process to measure fuel was with handheld instruments and hand calculations. Errors could be made at every step in this process leading to large discrepancies. Using dynamic barcode scanning and Excel-based calculations mitigates the risk of human error while speeding up analysis.

Objectives

The objective was to create an Excel sheet that grabs data from a dynamic barcode and outputs inventory management analysis. Computations would automatically run in the background to reduce human intervention, and various graphs and charts would help easily display data.

Approach

• Describe the approach your team took to solve the problem using a bulleted list of steps
• For example, talk about how you gathered the customer needs and/or requirements
• Did you do some concept generation and selection?
• Did you review relevant patents, analyse existing products/processes, etc.?
• Did you have to visit the sponsor and gather data from them?
• What sort of simulation models/analyses did you use to evaluate different alternatives?
• Did you create CAD models?
• Did you fabricate a prototype? multiple prototypes? etc.
• Did you perform testing?
• How did you validate your model/results?
• What sort of results did you generate? How did you analyse them?

Outcomes

Finally, list the outcomes for this project making sure to clearly convey their implications for the sponsoring company:

• The sponsor will save $XXX as a result of this project
• Manufacturing/production times were reduced by XX hours/minutes as a result of this project
• The project reduced set up time, assembly time, tool wear, etc.
• If the project resulted in a new/unique product/approach/simulation, make sure to convey that as well.
• Finally, make sure this fits on one page, and submit both DOC and PDF to your instructor