Quick Business Inventory

Upon analyzing Some Dude’s business needs and the current methods being used we developed a program using Excel spreadsheets to incorporate an inventory management system. The system will allow the business to organize and control incoming raw product as well as outgoing product demand. In addition, this system will track the in-house processes in the manufacturing of the final product. It will have an order history so that sales reports can be created simply and quickly. Budgeting will be more efficiently figured by having all the information so easily accessible.

The company is in need of an updated systems inventory program. Currently, the employees hand counts each of the raw ingredients and finished product as needed. This is time consuming for the company and uses time which could be better spent marketing or developing new products. An updated inventory system will also save time in the office by keeping current updated records which can be accessed on demand. Sales reports, customer and vendor information, and product information are all included in the new program. Our solution to their issues is the Quick businesses inventory system or Quick B.I.S.

The current method of invoice used by the company is a template which requires the employee to enter information for each order including company name, location, order, etc., every time an order is submitted. The new program eliminates the need for a calculator or address booklet making information recovery on a customer possible in a moment. This is the first spreadsheet in Quick B.I.S. and is automatically populated with the needed information upon entering the customer name.

The spreadsheet following the invoice is the customer page. This page is essentially an address book. It manages the date of delivery for current orders and has a quick reference to the amount of product that can be made with the raw ingredients on hand. The previous page pulls from this page to populate the address, phone number, and other customer information fields on the invoice.

Following the customer page is a calculator page. This part of the spreadsheet is the sum of the inventory in the warehouse and it can calculate out of that inventory what finished product can be produced. It also tracks what is on hand so that the employees can be alerted when a raw ingredient becomes low and it is time to reorder. This is very important because the vendors that supply the company with raw product have different lead times in order to get the ingredients shipped in a timely manner. This page will increase efficiency in the office by allowing the employee to see at a glance what will need to be ordered and when.

The next spreadsheet is the supplier’s page. On this spreadsheet the user can enter the raw ingredients ordered from specific vendors. The page contains a list of the vendors used by the company and pull down menus to select the products ordered. Once the amount of product ordered is entered, the program then populates the inventory page to show what is in stock and what how