Computerized Sales and Inventory System for Anthony’s General Merchandise Essay Sample
Many people use computing machines in their day-to-day lives. Some use it for minutess. some use it for educational intents and others use it for informations storage. Though it might sound unneeded but in some instances when hive awaying a file for such a large company. can you pull off it decently? Forming. happening a file. etc. With computing machines. it can assist you simplify the procedure of hive awaying and pull offing the files you need for future usage and do determination files easier than the manual procedure. Computerized Gross saless and Inventory System is a merchandise of human cognition with a usage of engineering so why non utilize engineering as an advantage and benefit ourselves.
This proposed system aims to buoy up plants and work out the jobs affecting rigorous and complex recording and computations. Anthony’s General Merchandise & A ; Construction Supply is still under the manual method since the concern started back in April 2000. The concern is located foremost at Riverside so they transferred to Road BHS near Quezon City Polytechnic University. It is a household owned concern by Mrs. Herminia Baguino. They have 1 teller. 3 gross revenues individuals. 2 drivers. 4 bringing work forces. 1 staff that is in charge of the warehouse. The teller is the individual who keeps the money in their money box. the gross revenues individual are those who talks to the clients and responsible in supplying the customers’ needs. The driver and bringing work forces are those workers who are responsible for the bringing of the points to the clients.
1. 1 Statement of the Problem
General Problem:
How to Design and Develop a Computerized Gross saless and Inventory System for Anthony’s General Merchandise and Construction Supply that will better their concern operation? Anthony’s General Merchandise and Construction Supply is working under manual method which sometimes causes client dissatisfaction because of the slow procedure on how they transact to their clients and the happening of some mistakes that are non expected. With this manual method. the individual in charge of stock list is holding a difficult clip because he needs to look into the points repeatedly and they don’t even monitor the termination of the points and they besides experienced loss of of import records. Specific Problem:
* How to plan and develop a faculty that will supervise the points accurately in re-order and critical degree? Anthony’s General Merchandise & A ; Construction Supply encountered troubles in supervising points that are in re-order degree and critical degree. points that need to be replenished. This sometimes consequences in some points to be out of stocks. In their current system they don’t have critical degree and re-order degree because they merely do it by looking at their show shelves to gauge the figure of points that needs to be purchased from their providers.
* How to plan and develop a faculty that will bring forth a purchase order? Anthony’s General Merchandise & A ; Construction Supply encountered troubles in doing a purchase list because they made their purchase order through appraisals. That there are some cases where some points are doubled. and of import points that is needed to be purchased are non included. so the director will compose it on a piece of paper. This affects the operation of their concern because of the erroneous appraisal of their stock list. * How to plan and develop a faculty that will heighten the manual calculation of the sum purchased and so issues an official reception? Anthony’s General Merchandise & A ; Construction Supply usage reckoner. pen and paper to calculate the entire sum of points that the client purchased.
In treating the gross revenues dealing they need to cipher twice to recheck if the sum is accurate and everything has to be written ensuing to a long waiting line. Because of their current written procedure. it may ensue in trouble in ciphering the gross revenues dealing undertakes in their concern. The waiting clip for a client is excessively long which may besides ensue in less net income in the concern. * How to plan and develop a faculty that will bring forth dependable gross revenues study and stock list study? Anthony’s General Merchandise & A ; Construction Supply are sing job in bring forthing their gross revenues and stock list studies that consequences to an inaccurate gross revenues and stock list control. It is a long procedure when they are making their topographic point checking of day-to-day sold points and when it comes to stock list of the points in the shop and warehouse. Sometimes they encountered misplaced logbooks and legers where their of import informations are recorded. These incidents may take to incorrect studies that affect their operation and determinations refering to their concern. 1. 2 Current State of the Problem
Inventory
The director told us that they do non carry on their stock list hebdomadally in the shop. alternatively they do it monthly and the same with the warehouse. When it comes to stock list. the stock raiser or the individual in charge in the storage room will number the points on manus and the points in their warehouse. the stock raiser will number it repeatedly to avoid mismatch of the entire Numberss which takes a batch of clip to come up with accurate consequence. In making their stock list it’s non really easy particularly because they have many points in the shop and warehouse it consumes about 4 yearss to state that they already have the right consequence. they record their stock list in a logbook where there is no back-up which is a large job if something happens to their of import informations. Their gross revenues book. C transcripts of gross revenues bill and the gross revenues bill from their provider is placed in a little box over a little tabular array inside the shop which is non stored decently and prone to amendss. * Safety Stock
Anthony’s General Merchandise & A ; Construction Supply’s safety stock is 10 boxes per point all hardware supplies and for those building supply the safety stock for illustration in sand 2 elf truck is the safety stock. They kept it to their shop room and the surplus were brought to the warehouse by the stock raiser so that in instance a client would purchase many points they will be able to supply it. * Re- Order Point
Re-Order point is determined through appraisal of the director and by looking at the show shelves. If she saw that the show shelves has no more show of a peculiar point she will inquire the stock raiser to look for the point in their shop room and she will besides inquire the individual in charge in the warehouse if they still have adequate stock. * Critical degree
The critical degree is reached if the points are below three to one or below the re-order point and they experience it if the bringing is delayed. * Fast-Moving Items & A ; Slow Moving Items
Anthony’s General Merchandise & A ; Construction Supply see most of their points are fast traveling points particularly those in low monetary value but they can non precisely separate what are the most in demand to their clients because it besides depends on clients need. and the slow moving points are those points which is in high cost. Purchase Order
In fixing their Purchase Order. the director looks at the show shelves to look for the points that need to be replaced and the director will compose it on a paper. If one of their providers beads by to the shop she will merely demo the purchase list so the agent will look into the points and copy those points that they can provide. If the point left is less than 3 or one left. the director will gauge the measure of the certain point they will buy to the provider. * Agent
Is a gross revenues individual who drops by at the shop to inquire if there is something our client wants to order. sometimes the agent introduces new merchandises to the director and asks if they are willing to seek the merchandise being introduced. When the agent is at the shop the director will give the purchase list and so the agent will look into the points they can supply. After that they will present the points after one twenty-four hours and Anthony’s General Merchandise & A ; Construction Supply will pay half of the entire sum upon telling and the remainder of the payment is when the purchased points have arrived. * Phone Call Supplier
In this dealing there is no demand for a gross revenues individual. minutess can be made through phone calls. The provider will inquire if Anthony’s General Merchandise & A ; Construction Supply have adequate stock and they will take the note of the order and the agenda of bringing through telephone. In footings of payment it is ( COD ) Cash on Delivery. if the points arrived at the shop they will give the payment to one of the individual who delivered the points.
Receiving of points
In receiving of points the provider will present all the order of Anthony’s General Merchandise and Construction Supply in the shop at the exact day of the month that they agreed upon. Items will travel straight to their shop located in Road BHS near at Quezon City Polytechnic University. They do non carry on checking of points one by one they will merely accept it. And when the points was non exact on the purchased list of the director and the C transcript of the gross revenues bill from the provider they will subtract the points delivered to the figure of points that the provider were non able to follow and in footings of payment the Anthony’s General Merchandise & A ; Construction Supply uses the ( COD ) Cash on Delivery which they will pay merely the points that were delivered.
Replacement of Items
The director mentioned that they can return damaged points to their provider even after 1 twelvemonth. they merely need to demo the gross revenues bill from the provider.
Gross saless
* Walk-in Customers
Walk-in clients are those who personally bead by to the shop and buy’s something whether it is in big measure or little. The walk-in client will inquire the sales representative if they have the point so the gross revenues individual will look for the point in the show shelves. If the point being asked is available. the gross revenues individual will acquire it and compose it on the gross revenues bill. Upon having of payment the gross revenues individual will give it to the teller. * Phone-In Customers
Phone-in clients are those who ask and places their orders through phone. they will inquire for a specific point so one of the staff will look for the point. If there are still adequate stock of the point being asked by the client. the gross revenues individual will inquire the phone-in client how many points she/he will buy and if the purchased item/s are to be picked-up or to be delivered. If the points are to be delivered they will hold an understanding on when will the Anthony’s General Merchandise & A ; Construction Supply will present. The client may besides pick up the purchased point anytime between 8am to 6pm. * Replacement of Items
Anthony’s General Merchandise and Construction Supply allow replacing of points within one hebdomad upon day of the month of purchase. The client has to demo the gross revenues bill as a cogent evidence that he/she truly bought the points from the shop their shop. If it exceeds after 1 hebdomad they will no longer accept it. Replacement of points should hold the same sum or more expensive than the points to be replaced. * Returned Items
Anthony’s General Merchandise and Construction Supply don’t accepts returned points from clients they merely allow replacing of points. * Cancellation of Orders
Cancellation of orders by the client is allowed every bit long as the client will make it 2 yearss before the in agreement bringing day of the month. In some instances that was non evitable if the client cancelled his/her order upon the reaching of bringing it is allowed but so the clients will pay for the gasolene because it is deducted to their net income. The calculation of the bringing charge is based on metre. * Delivery
Anthony’s General Merchandise & A ; Construction Supply accepts bringing if the points are in big measure and they besides have bringing charges. If it is within the locality there is no charge but some instances merely like when they have a bringing to Antipolo they will bear down 1500 in Pasay 1000 and in Araneta 500. They base on the distance or with the usage of metre to avoid loss of capital it is. Generation of Reports
* Gross saless Report
This is where the teller records their gross revenues minutess every twenty-four hours. monthly and annually. * Gross saless Bill
Is what they give to the client as a transcript of a dealing that happened between Anthony’s General Merchandise & A ; Construction Supply and the client which is lesser revenue enhancement comparison to the Official Receipt. * Official Receipt
It is confidential reception the director gives it to their book keeper. When it is used as a transcript of dealing between the client and the client who bought big measure of points and the revenue enhancement is larger compared to gross revenues bill. * Inventory Report
* Logbook
This is where they record the points on manus and the points in and out. if there are damaged points there is accommodations in their record they will name it on the replaced logbook. 1. 3 Aims
1. 3. 1 General Aims
To plan and develop a Computerized Gross saless and Inventory System for Anthony’s General Merchandise & A ; Construction Supply that will better their concern operation. The advocates proposed a system that will heighten Anthony’s General Merchandise & A ; Construction Supply manual method of gross revenues and stock list and continually supervise the gross revenues study and inventory study of the concern. It will supply them accurate calculation of the points sold. supervise the stocks handiness and the merchandises that are in re-order degree and critical degree that alerts them that they need to buy merchandise instantly to their provider. The client will no longer be worried about loss of grosss. misplaced log books where their of import informations is recorded and for them to suit their client in a convenient manner because the system is user friendly and is easy to utilize.
1. 3. 2 Specific Aims
* To plan and develop a faculty that will supervise the re-order degree and critical degree of their points accurately. The advocates will make a faculty that will assist them in supervising their merchandises so that they can avoid their points in making the critical degree. It will besides demo elaborate information about the points that are running out of stocks and the merchandises on manus. This faculty will guarantee that points will no longer be out of stock in their shop room and warehouse it besides shows accurate record. * To plan and develop a faculty that will bring forth a Purchase Order.
The system will supply a faculty that will allow the user to bring forth or bring forth purchase order easy and accurately. There is no demand for them to gauge how many points they would name on their purchase list and to avoid duplicate Numberss of points. * To plan and develop a faculty that will heighten the manual calculation of sum purchased and so issues an official reception. The System will name down all the ordered points of the client as the teller enters the first missive of the points so the points starts with the same missive will look and the user will take the point as the user imperativeness the enter it will automatically calculate the entire sum of the purchased points and will straight publish a reception. This will ensue in a more accurate calculation. faster dealing and generate better income for the concern. * To plan and develop a faculty that will bring forth dependable gross revenues study and stock list studies.
Anthony’s General Merchandise and Construction Supply don’t have to look at their old records which are indecipherable. fading manus authorship and old pages of the book which are crumpled because those were non decently kept. The system allows them to recover the old records anytime that they can besides publish the studies easy. The system will publish more accurate studies which would be good in the operation of the concern
1. 3. 3 Scope and Restrictions
Scope:
* Care
This faculty is responsible for the security of the maintaining of import file. * User Level – A user degree allows adding. redacting. and disenabling user. * End User – This faculty will let the user to pull strings some private informations. * Category – This faculty will let the user to add and redact the class of a merchandise. * Unit of Measurement – This faculty will let the user to add and redact the unit of measuring. * Brand – This faculty shows and allows the user to add and redact what trade name the point is. * Minutess
* Purchase Order – This faculty will let the user to bring forth Purchase Order. * Gross saless – This faculty will manage the gross revenues procedure and so calculate the sum purchased by the client. * Replacement of Item/s – This faculty allows the authorised user to replace or alter the point. * Monitoring
* Inventory – This faculty will manage the stock list of all points in the shop. * Re- Order – This faculty will supervise and expose points that are in re-order degree. * Critical Level – This faculty will supervise and expose points that are in critical degree. * Fast Moving Items & A ; Slow
Traveling Items– This faculty will expose fast & amp ; decelerate traveling points. * Adjustment of Stocks – This faculty will let the user to set the points they have.
* Utilities – This faculty secures of import files or informations of Anthony’s General Merchandise & A ; Construction Supply. * Archiving & A ; Restoration – This faculty will let the user to maintain old files and to reconstruct old database. * Back-Up & A ; Recovery – This faculty will let the user to hold a back- up of the database if the other file was corrupted. * Audit Trail–It allows authorized user to follow out the users who used the system. * Settings –This faculty will let the accommodation of day of the month and clip where you can redact the current day of the month and clip of the system. * Reports – This faculty will be responsible for the coevals of necessary studies for Anthony’s General Merchandise & A ; Construction Supply. This faculty presents information into a clear and easy to understand study.
Reports faculty include: * Inventory – This faculty will bring forth studies sing all information about the stock list. * Items On Hand – This faculty will bring forth studies sing all merchandises that they have. * Critical Level – This faculty will bring forth studies sing all merchandises that are in critical degree. * Re-Order Point – This faculty will bring forth studies sing all merchandises that need to be re-ordered. * Fast and Slow Moving Items– This faculty will bring forth studies sing to what is fast traveling and decelerate traveling point. * Gross saless – This faculty will bring forth studies sing all information about the gross revenues of the concern. * Daily – this will bring forth day-to-day gross revenues studies.
* Weekly – this will bring forth hebdomadal gross revenues studies. * Monthly – this will bring forth monthly gross revenues studies. * Annually – this will bring forth annual gross revenues studies. Restriction
* This system does non accept recognition cards as payment.
