Sales and Inventory

Evercom Auto Supply is working under manual method which sometimes causes customer dissatisfaction because of the slow process on how they transact to their customers and the occurrence of some errors that are not expected such as doubling the items purchased by the customers, misplaced of the carbon copy of receipt, mistakes in listing of an items purchased by the customer, sometimes the items purchased by the customer is not listed on a receipt, a wrong computation of the items purchased by the customer and sometimes they forgot to record the damage item. The occurrence lost and improper recording of some items. They had difficulties on accessing the item in the inventory due to manual system operation.

2.1.1. Specific Problem

1. How to develop a module that will monitor the fast and slow moving of items, reorder, critical level, safety stock and back order of its inventory?

Evercom Auto Supply doesn’t have a computerized system, they do not monitor on their fast and slow moving items, reorder, critical level, safety stock and back order. It is difficult to determine what items are in demand and those are not because their records of sales and inventory are written at one record book. The owner is not aware in monitoring the stocks, if the stocks are in critical level or re-ordering point and needed to replenish. The owner doesn’t have idea about the safety stock and he doesn’t know if the items have damage or not.

2. How to design, develop, and implement a module that will improve their purchasing order?

Evercom Auto Supply purchased their items from their supplier. There will be in-charge person to check their items manually. After checking all the items, the person in-charge will write down all the items on a piece of paper that is needed to order. Sometimes the supplier will go to the store and ask the owner if what they want to order. There are times that they need to order large quantities of an item. It takes a lot of time to do that...