Sales and Inventory System
I. Introduction The study of Computerized Sales and Inventory System for Botika Sofia and General Merchandise is taken from the concept of Information System. One example is the Transaction Processing System. This chapter includes the Background of the problem, Overview of the current state of technology, Project Rationale.
1.1 Background of the Problem
Botika Sofia and General Merchandise is owned and managed by Mrs. Olivia Delos Reyes and were established on June 1, 2012 at Damballelos St. Brgy 4 Balayan, Batangas. Mrs. Olivia a pharmacist started her business life with Botika Viatrice which is located at General Trias, Cavite and she decided to open-up a new branch here in Balayan named after her youngest daughter which is “Sofia”. Botika Sofia and General Merchandise have almost 1,700 inventory items, 10 product lines and more than 10 suppliers. It has five employees: the owner and at the same time the cashier, one purchaser and three sales clerks.
They use the manual sales and inventory system in their everyday transactions. But having this kind of system they encounter problems such as computing and recording the sales per day, monitoring of the availability of products, searching the price of the certain product, adjusting the number of stocks and monitoring the expiration of the products.
To ease the problems that are being encounter by the store, the proposed Computerized Sales and Inventory system is designed to improve their every task. The proposed system will help them in computing and recording the sales per day, monitoring of the products to avoid the out-of-stock. It will also help in monitoring the expiration of the product and adjusting the number of stocks. 1.2 Overview of the Current State of Technology
In Botika Sofia and General Merchandise, they use the usual method of selling to customers. There are three sales clerks who will accommodate the customers, they will write the ordered items in a piece of paper and the cashier will
1.1 Background of the Problem
Botika Sofia and General Merchandise is owned and managed by Mrs. Olivia Delos Reyes and were established on June 1, 2012 at Damballelos St. Brgy 4 Balayan, Batangas. Mrs. Olivia a pharmacist started her business life with Botika Viatrice which is located at General Trias, Cavite and she decided to open-up a new branch here in Balayan named after her youngest daughter which is “Sofia”. Botika Sofia and General Merchandise have almost 1,700 inventory items, 10 product lines and more than 10 suppliers. It has five employees: the owner and at the same time the cashier, one purchaser and three sales clerks.
They use the manual sales and inventory system in their everyday transactions. But having this kind of system they encounter problems such as computing and recording the sales per day, monitoring of the availability of products, searching the price of the certain product, adjusting the number of stocks and monitoring the expiration of the products.
To ease the problems that are being encounter by the store, the proposed Computerized Sales and Inventory system is designed to improve their every task. The proposed system will help them in computing and recording the sales per day, monitoring of the products to avoid the out-of-stock. It will also help in monitoring the expiration of the product and adjusting the number of stocks. 1.2 Overview of the Current State of Technology
In Botika Sofia and General Merchandise, they use the usual method of selling to customers. There are three sales clerks who will accommodate the customers, they will write the ordered items in a piece of paper and the cashier will