This project is aimed at developing a Computer-Based Sales and Inventory System for MySolutions.
This system can be used to store the details of the inventory, update the inventory based on the sale details, produce receipts for sales, generate sales and inventory reports periodically etc.
This is one integrated system that contains both the user component (used by salespersons, sales managers inventory managers etc) and the admin component (used by the administrators for performing admin level functions such as adding new items to the inventory, changing the price of an item etc).
This system runs on multiple terminals, offers a GUI interface to its users and connects to a common database(s). 2.1 Problem Statement
Based on the data gathered from Mr. Jobert Bantilan, I.T head of the company, revealed some of their problems on their current inventory system, usually the employee tasked to maintain the inventory is being operated manually. This is a very confusing process and is very prone to human errors, after observing their regular business operation, we have….
2.2 General Problem
How to develop a Computer Based Sales and Inventory System for MySolutions Inc. that will help to enhance their current sales and inventory transaction.
2.2.1 Specific Problems
It states the problem in the company to relate with the specific problems. * How to develop a module that will notify the company about those products that is in critical level.
* How to develop a module that will generate pertinent reports on their sales and inventory transaction. 2.3 Proposed Research Project
2.2.1 General Objectives
The proponents aim in develop a Computer Based Sales and Inventory System for MySolutions Inc. that will help to enhance their current sales and inventory transaction.
The proposed computer based system will enabled the user to store, track down and update product’s inventory as well as the critical level. It can be used to monitor the sales transaction. Generation of all pertinent reports needed for the company’s decision making will be readily available upon demand. It will give a password protected user level accounts that will secure the company’s record and information.
2.2.2 Specific Objectives
This study aims to:
* Develop a module that will notify the company about those products that is in critical level.
With this module, it monitors the product that is on critical level and will prompt the company by notifying them automatically. By determining either the product reaches the flooring by seating the ceiling of a certain product according to stocks. Because of that the company can now sustain the number of products that the customer need. The company can also avoid the unavailability of the product.
* Develop a module that will generate pertinent reports on their sales and inventory transaction.
With this module, the owner already has his soft copy of the receipt that he issue to his customer. The owner can now have an accurate inventory. It will help the owner to easily trace how many products had been purchase from his company. It will also give him an idea what are the profitable products so that the owner cans double the stocks of that product. Once the owner noticed that his product had been sold-out within one month, the owner can avoid the unavailability of his product. It also helps the owner to know what the profitable products are. It will help the owner to trace products that is needed to be replenished.
2.2.3 Scope and Limitations
Scope of the System
The system is designed to help the MySolutions in their everyday sales transaction. It will also help the company in doing their inventory. It will help them to lessen the time they will...