Online Sales and Inventory Essay

1.1BACKGROUND OF THE STUDY machine confer or auto part dealers ar investment companys which sells variety of car parts. about auto supply companies likewise offers service like car repairs or maintenance and even a car wash. motorcar supply has a lot of product line to sell with its either for the execution side (brake fluid, coolant, radiator, engine belts, oil filters, clutch disc, hoses) or the forcible side (paintjob, tires, mugs, lights). Some stores argon more into car accessories (car alarm corpse, central lock, effectual dusts, vinyl, etc.) or tires and mugs marketing. Big master companies tend to have all of these. JTU gondola run is a medium scaled company that sells car parts for performance and maintenance of the car. It has been running around 5 years since it was found January 2008.JTU Auto hand overs name was derived from the initials of Jessie T. Uy who is the owner of the company. From the experience of its owner, Jessie T. Uy of organism a taxi dr iver before, He got interested and came up a good deal of ideas about antithetical car parts that make him successfully set up JTU Auto Supply. JTU Auto Supplys main color ins are red and yellow because the colors are striking, attractive, and visible. The owner also likes the color red because he has Chinese blood. JTU Auto Supply is different shtupvass to former(a) medium scaled auto supply companies because they are shrill on having a certain image. They are clean, organized, and has a good structure. An vox populi to the acquireers in proving their tag line Tapat sa Presyo.JTU Auto supply has five material ramificati whizzs around Cavite located at Pag-asa subdivision which is its main secernate, Buhay na tubig, along Molino road near SM Molino, Along Aguinaldo Highway and Salitran. Each branch is dependent on their main branch at Pag-asa. They provide varieties of products and selling five main product lines. These are replacement parts, performance, accessories, f luids and chemicals, and tools. The uses of these for the vehicle are for maintenances or performances. below replacement parts includes air conditioning, battery and accessories, belts and hoses, personify, sheer and mirrors, brakes, charging and starting, engine parts, cooling, heating, exhaust fuel, emission, ignition, transmission, wiper and lot more. Under performance includes bole styling components, oil, sealers, and additives, tuners, safety equipment and more. If you go for accessories it includes chrome, dress up, exterior and interior and also for trucks.If you rent tools they have for body repair, diagnostic tools, electrical, lift equipment, gloves, work wear, safety equipment, tapes, books and manuals too. Under fluids they have windshield wash, A/C chemicals, anti discontinueze, de-icers, cleaners, brakes, battery chemicals, fuel governance, gasket markers, remover, sealers, grease, lubes, adhesives, paint, body repair, maintenance chemicals, leak detectors and oils. Mr. Jessie T. Uy mentioned that they have approximately 15,000 products all-in-all and over a honey oil each product line that they have. The main goal of the JTU business is to perish its guests a trust and confidence to buy its products and services. To prove to its customers that JTU Auto Supply is dependable, clean, consistent and honest. For the future, they wanted to be like a convenience store and to franchise its business. This impressions and trusts JTU Auto Supply gives customers an attraction to come back. The tagline Bringing services to your doorstep means offering to the customers, a great services in terms of deli very(prenominal) of products.They have free delivery fee and end deliver products within 13-15 kilometer radius from its branches for 10-20 minutes. They quiet down offer free delivery beyond the said distance but JTU Auto Supply can non guarantee the time of delivery. It comes to proponents interest that they never seen a medium scale auto supply have grown this fast yet still having many operational problems and transaction flaws. The problems of the company that they often encountered are loosely in the gross revenue and instrument. JTU Auto Supply manually encodes large bill of facts in their memorial. Manually generates sales reports from the receipts or sales invoices they have. They also manually bears and track the inventories in every branches through phone calls, texting or even visiting. This may cause inconvenience in their part curiously now that the company starts to grow more.They store their data into Microsoft Excel and reach source software such as Quickbook that may cause some security problems in terms to the employees working inside the company. There is a possibility to alter the reports and confidential data. A problem observed is that when it comes to compatibility and judicial admission of the product is hard to find, having lots of possible models in just a single part. Mainly in there fr ee delivery, customers pass on not be able to see the product itself and causes a lot of misconstrue or mis restitutions on the products they lucid.1.2STATEMENT OF THE PROBLEMJTU Auto Supply has five physical stores, all of the branches including the main branch are manually tracking, and checking the remaining items and interchange items on each branches armory is by calling, texting, and visiting each branches. Mr. Jessie T. Uy always visit and call each branches (except if he has emergency appointments) just to check updates of sales and inventory such as its needs of every branches. This is very inconvenient for his part since he has also other businesses and works to do. JTU Auto Supply also manually adds, edit, and delete the large amount of items on the Microsoft Excel which is inconvenient. As of now, they already have approximately 15,000 items but as the company grow, JTU Auto Supply is having difficulty in maintaining their inventory.The data on their company such as inventory files, sales invoice files, reports, and a like are also not secured because any person or employee can add, edit, view, and delete it on the Microsoft Excel without the permission and not discriminating of the owner. They also manually compute and generate the sales report that may lead to data inconsistencies and errors. They generate it using their copy of sales invoice. JTU Auto Supply has some problems in handling orders via telephone. In their operation they take orders what they can see physically and do not deduct it on the main inventory they have, this causes the items to run out of stocks. Example of this is when a customer calls to order a 5 pieces of 1 cubic decimetre of brake fluids, the employee provide accept the order and deduct on their stores inventory but someone came to the store and buys exactly 5 pieces of 1 litre of brake fluids. The problem is that physically, an employee sees that there are still remaining item on the stores inventory without knowing that someone has already purchased it.1.3RESEARCH OBJECTIVE1.3.1 General ObjectivesThe proposed JTU Auto Supply Online sales and inventory system aims to develop and provide JTU Auto Supply an Online Sales and stock list system.1.3.2 ad hoc Objectives1.3.2.1 Conduct an interview to identify the problems and needs of the company.1.3.2.2 Study existing system to define the company problems and needs.1.3.2.3 Gather indata formattingion that lead be take in developing proposed system.1.3.2.4 Analyze gathered information to come up with solutions and in order to design a proposed system.1.3.2.5 Create a system that give be functional and much help for the company.1.3.2.6 Evaluate and evidence the system and help in maintaining the system.1.4SIGNIFICANCE/JUSTIFICATION1.4.1 To management.JTU Auto Supply will be able to use the online sales and inventory system because it will fix the problems encountered by the employees. These problems particularly are the manual checking an d tracking of inventory from one branch to another and manual computation and encoding of sales in Microsoft Excel. The proposed JTU Auto Supply system also will further them further through the website to attract more customers. 1.4.2 To customers.The customers would benefit from the proposed system payable to its ease in making transaction, creating orders and buying through online. It is convenient for the customers to buy online and deliver it to their doors hassle-free. Customers can check the availability and price of the item they gaze to buy anytime without visiting JTU Auto Supply stores.1.4.3 To proponents.The Proponents idea and knowledge in establishing a website will become broader. Techniques and programming skills will be authentic and will understand more the programming language that will be used. The study will also help them to understand the process of transactions and real problems in real world business.1.4.4 To future researchers.The study will be useful to the future researchers who will conduct a quasi(prenominal) study to JTU Auto Supply Online Sales and caudex System. The study can serve as the reference in creating the documentation of the future studies including its format and content.1.5CONCEPTUAL FRAMEWORKInputProcessOutput1.6SCOPE OF THE STUDYThe scope of the JTU Auto Supply Online Sales and stemma system are selling and tracking its products and services through online. It features different categories of the products and services, its prices, their descriptions and modes of payments. The mode of payment is cash-on-delivery basis only. The JTU Auto Supply Online Sales and Inventory system will also allow the customers to avail its products only if the exploiter has an account to the website. The proposed will have a built-in shopping pram for the list of orders of the customers. Customers can confirm and cancel their orders through shopping cart. erst the order is confirmed, the item will be delivered.The coverage o f its delivery is particular(a) only 13-15 km radius of their branches. 15-20 minutes of delivery is guaranteed only if the berth is covered in the 13-15km radius. Directions and contact information of JTU Auto Supply are also included for those customers who wish to visit and call directly the branches. Allowing and providing a customers corner will also be included for them to post their questions, inquiries, suggestions and other important concerns regarding the services and products of JTU Auto Supply. The JTU Auto Supply Online Sales and Inventory system will also include the tracking inventory and sell products on every JTU Auto Supply branches.The Pag-asa branch which is the main branch of JTU Auto Supply will be in-charge with the online ordering and delivery of the ordered items. The system will provide an account for administrators of the JTU Auto Supply to go steady and maintain the system process such as adding, editing, and deleting items on the inventory database. F or the communication of each branch, the proposed system will also provide heart box or e-mail for the administrator to administrator account from one branch to another.