''Automated Inventory-Tracking Database Model''

Chitra Ashar
chitra_aus@yahoo.com
DIT
Charles Sturt University
210 Brilliant Street
Australia

Phillip Keaton
pkeaton@csu.edu.au
DIT
Charles Sturt University

Australia

Warwick Newell
wnewell@csu.edu.au
DIT
Charles Sturt University

Australia

Nick Drewitt-Smith
nick01@asiaonline.com.au

Charles Sturt University

Australia

Rick Stevenson
rsteve05@postoffice.csu.edu.au

Charles Sturt University

Australia

Abstract

Automated Inventory-Tracking Database Model Date – 31/08/01 Authors Phillip Keaton Chitra Ashar-Nasser Nick Drewitt-Smith Warwick Newell Rick Stevenson David Tien (Lecturer) Al Hammond (Lecturer) Project Abstract Bathurst Speciality Blending (BSB) is a company that specialises in the blending of animal food mixtures, for large organisations such as Uncle Ben Australia. BSB relies greatly on keeping track of all their workplace activities, i.e. ordering and receiving materials, creating new recipes and creating and dispatching batches. Their current computer system for keeping track of their business processes is inadequate and archaic, and doesn’t provide them with the desired level of flexibility, easy of use or automation. Our software solution will equip BSB to execute their business undertakings effectively and competitively with an opportunity to expand in future years with fewer constraints. It employs a friendlier, more appealing interface and incorporates much-needed functionalities like statistical forecasting analysis, advanced tailor-made reporting mechanisms and in-built error checks. It will also provide an intelligent means to automatic re-calculation of the ratios of different recipe ingredients and hassle-free inventory tracking through issuing low-quantity level warnings. The software system interacts with a Microsoft Access Database and uses Visual Basic 6 as its Application Development Environment. Our software will change the way BSB works by completely and efficiently automating its batching operations, thereby turning a task into an experience for every single employee at BSB.


© ATCM, Inc. 2001.