Online Sales and Inventory Essay

1.1BACKGROUND OF THE education car go forth or gondola come outs dealers argon neckcloths which sells variety of car parts. Some auto come out companies as well offers function like car repairs or forethought and dismantle a car wash. gondola supply has a lot of crossroad line to sell with its either for the performance side (brake fluid, coolant, radiator, engine belts, oil filters, clutch disc, hoses) or the physical side (paintjob, tires, mugs, lights). Some stores atomic number 18 more into car accessories (car alarm governing body, central lock, sound systems, vinyl, etc.) or tires and mugs selling. long scale companies tend to have all of these. JTU elevator car add on is a culture medium scaled familiarity that sells car parts for performance and chief(prenominal)tenance of the car. It has been running around 5 years since it was established January 2008.JTU car provides name was derived from the initials of Jessie T. Uy who is the owner of the come wit h. From the experience of its owner, Jessie T. Uy of being a hack writer driver before, He got interested and came up lots of ideas about contrastive car parts that make him successfully established JTU gondola Supply. JTU Auto Supplys principal(prenominal) colors argon red and xanthous 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 compare to other medium scaled auto supply companies because they are keen on having a certain image. They are clean, organized, and has a good structure. An impression to the buyers in proving their check off line Tapat sa Presyo.JTU Auto supply has five physical commencementes around Cavite set(p) at Pag-asa subdivision which is its main branch, Buhay na tubig, along Molino road practiced SM Molino, Along Aguinaldo Highway and Salitran. Each branch is dependent on their main branch at Pag-asa. They stomach varieties of overlaps and selling five main product lines. These are replacement parts, performance, accessories, fluids and chemicals, and tools. The uses of these for the vehicle are for maintenances or performances. on a lower floor replacement parts includes air conditioning, battery and accessories, belts and hoses, soundbox, trim and mirrors, brakes, charging and starting, engine parts, cooling, heating, eradicate fuel, emission, ignition, transmission, wiper and lot more. Under performance includes body 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 need 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 windscreen wash, A/C chemicals, antifreeze, de-icers, cleaners, brakes, battery chemicals, fuel system, gasket markers, remover, sealers, grease, l ubes, adhesives, paint, body repair, maintenance chemicals, break detectors and oils. Mr. Jessie T. Uy mentioned that they have approximately 15,000 products all-in-all and over a thousand individually product line that they have. The main goal of the JTU business is to give its customers a cartel and confidence to buy its products and services. To prove to its customers that JTU Auto Supply is depend satisfactory, clean, consistent and honest. For the future, they cute 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 sum offering to the customers, a great services in terms of livery of products.They have free delivery fee and underside deliver products inwardly 13-15 kilometer radius from its branches for 10-20 minutes. They still offer free delivery beyond the said distance but JTU Auto Supply tailnot guarantee the metre of delivery. It comes to proponents interest that they never sop upn a medium scale auto supply have grown this fast yet still having almost operative fusss and transaction flaws. The problems of the company that they often encountered are mostly in the gross revenue and pedigree. JTU Auto Supply manually encodes large amount of particular propositions in their ancestry. manually generates sales reports from the receipts or sales invoices they have. They also manually checks and tail the inventories in both branches with phone cry outs, texting or even visit. This whitethorn cause inconvenience in their part especially now that the company starts to grow more.They store their information into Microsoft Excel and open source package much(prenominal) as Quickbook that may cause some security problems in terms to the employees working inside the company. There is a possibility to substitute the reports and confidential data. A problem observed is that when it comes to compa tibility and specification of the product is disenfranchised to find, having lots of possible models in just a single part. principally in there free delivery, customers provide not be able to see the product itself and causes a lot of mis attending or mistakes on the products they valueed.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 sold items on distributively branches inventory 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 offset the large amount of items on the Microsoft Excel which is inconvenient. As of now, they already have app roximately 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 knowing 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 founds 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 litre of brake fluids, the employee allow accept the order and deduct on their stores inventory but individual 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 global ObjectivesThe proposed JTU Auto Supply Online sales and inventory system aims to develop and provide JTU Auto Supply an Online Sales and Inventory system.1.3.2 Specific Objectives1.3.2.1 Conduct an hearing 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 information that go forth be needed in growing 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 entrust be functional and much jock for the company.1.3.2.6 Evaluate and test the system and help in maintaining the system.1.4SIGNIFICANCE/JUSTIFICATION1.4.1 To management.JTU Auto Supply go away be able to use the online sales and inven tory system because it pass on fix the problems encountered by the employees. These problems particularly are the manual checking and 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 allow for advertise them further through the website to attract more customers. 1.4.2 To customers.The customers would benefit from the proposed system due 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 wish 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 developed and will understand more the programming language that will be used. The study will also help them to u nderstand the process of transactions and real problems in real world business.1.4.4 To future researchers.The study will be recyclable to the future researchers who will conduct a similar study to JTU Auto Supply Online Sales and Inventory 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 Inventory 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 compensations. 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 user has an account to the website. The proposed will have a built-in shopping cart for the list of orders of the customers. Customers c an confirm and cancel their orders through shopping cart. Once the order is confirmed, the item will be delivered.The coverage of its delivery is limited only 13-15 km radius of their branches. 15-20 minutes of delivery is guaranteed only if the location is covered in the 13-15km radius. Directions and contact information of JTU Auto Supply are also include 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 sold 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 Sup ply to control and maintain the system process such as adding, editing, and deleting items on the inventory database. For the communication of each branch, the proposed system will also provide message box or e-mail for the administrator to administrator account from one branch to another.