These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience

Wednesday, April 13, 2011

BYUIS Shipping Template

BYU Independent Study employs a number of processes to accomplish its day-to-day operations. One of the processes allows employees (field agents, sales, marketers) to place orders and requests for SWAG and booth supplies to be delivered to destination locations before arriveing. These locations may be schools, hotels, or residential.

Before this program, BYUIS managed this process manually. The users are the field agents, sales specialists, and marketers. Users place orders with the shipping office at BYUIS. Orders were maintained in a notebook with sticker labels to match the shipping labels. Inventory was adjusted manually despite being kept in an excel spreadsheet.


· Give users a simple way to place orders.

· Track order from placement to receipt in one place.

· Inform users by email/text of delivery information.

· Update inventory after shipment.

· Preserve a platform that can handle employee turnover.

· Provide a Macros to:

o Show a form (dashboard) that will roll up all inventory information into one screen.

o Update Inventory from shipped requests.

These are the issues expressed by the BYUIS in this process. Excel is used to store all inventory information. Google docs and Google forms gather requests from users. Only the shipping office deals with the excel spreadsheet. He will receive orders and process then through third party software provided by FedEx. After recording all tracking numbers, the Google doc spreadsheet is scraped into Excel with VBA. Information from the orders/shipments update the inventory. A form has been created. It is not interactive. It is a dashboard. The dashboard of inventory data will simply display the inventory data (contained on 8 sheets) in one form view.

The programming cost estimate is approximately 30 hours. The larger portion of the project will be the support of the programs and processes through technical documentation. Because this is a “real world” project, documentation is essential. This project estimates an additional 20 hours of documentation including:

· Technical overview of Macros and program.

· “How to” customization examples

· Change Management Scenarios

o New User Employee

o New Inventory Item

o Change Web Resources


  3. Optional Email not setup by default -

No comments:

Post a Comment

Blog Archive