Sales and Inventory System of Graph Image Paint Center
I. INTRODUCTION
1.1 RATIONALE OF THE STUDY
Inventory systems are tracking systems that inform the amount of raw materials, supplies or final products have readily available. Updated each time you sell an item or use raw materials to create and to know what you available for the following day or week. This type of system allows ordering products in advance, so you have everything you need at all times.
1.2 STATEMENT OF THE PROBLEM * How can the proposed system monitor the sales inventory of the transaction * How can the proposed system provide an accurate sales computation * How can the proposed system make a better sales record for each order transaction
1.3 SYSTEM OBJECTIVES * To develop a Sale and Inventory System for Graph Image Paint Center that will give solutions to the problems encountered in their manual business processes. * To avoid excess inventory and stock outs by using the sales inventory system * To produce appropriate reports of the sales
1.4 SYSTEM SCOPE AND LIMITATION
Scope:
* records the customers’ order transactions * generate the customers’ order transaction report. * view the previous sales record * can add, edit, search or delete orders to be delivered * print a receipt * can view inventory record in daily basis * determines the lead point of reorder Limitations: * limited in cash-based payment * doesn’t accept a credit card payment * cannot perform the crediting of the custom
II. Company Background Graph Image Paint Center is located at Salcedo Rosario, Cavite that sells different kinds of paint and painting materials. The store is owned by Mr. Gary Palima and Armie Palima. The business operates every Mondays to Saturdays from 8am to 5pm. The company is doing their annual inventory manually.
2.1 Organizational Chart
Gary Palima
Armie Palima
OWNER
Alice Saqui
CASHIER
Mark Villegas
Salesman
2.4 ORGANIZATIONAL FUNCTIONS
1.1 RATIONALE OF THE STUDY
Inventory systems are tracking systems that inform the amount of raw materials, supplies or final products have readily available. Updated each time you sell an item or use raw materials to create and to know what you available for the following day or week. This type of system allows ordering products in advance, so you have everything you need at all times.
1.2 STATEMENT OF THE PROBLEM * How can the proposed system monitor the sales inventory of the transaction * How can the proposed system provide an accurate sales computation * How can the proposed system make a better sales record for each order transaction
1.3 SYSTEM OBJECTIVES * To develop a Sale and Inventory System for Graph Image Paint Center that will give solutions to the problems encountered in their manual business processes. * To avoid excess inventory and stock outs by using the sales inventory system * To produce appropriate reports of the sales
1.4 SYSTEM SCOPE AND LIMITATION
Scope:
* records the customers’ order transactions * generate the customers’ order transaction report. * view the previous sales record * can add, edit, search or delete orders to be delivered * print a receipt * can view inventory record in daily basis * determines the lead point of reorder Limitations: * limited in cash-based payment * doesn’t accept a credit card payment * cannot perform the crediting of the custom
II. Company Background Graph Image Paint Center is located at Salcedo Rosario, Cavite that sells different kinds of paint and painting materials. The store is owned by Mr. Gary Palima and Armie Palima. The business operates every Mondays to Saturdays from 8am to 5pm. The company is doing their annual inventory manually.
2.1 Organizational Chart
Gary Palima
Armie Palima
OWNER
Alice Saqui
CASHIER
Mark Villegas
Salesman
2.4 ORGANIZATIONAL FUNCTIONS