Online Sales and Inventory Essay

1.1BACKGROUND OF THE STUDY car supply or auto split dealers are stores which sells variety of elevator car parts. Some auto supply companies to a fault offers services like car repairs or maintenance and even a car wash. railcar supply has a lot of result 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 are more into car accessories (car alarm system, central lock, sound systems, vinyl, etc.) or tires and mugs selling. Big scale companies tend to give birth only of these. JTU gondola fork up is a culture medium scale family that sells car parts for performance and maintenance of the car. It has been running around 5 years since it was ceremonious January 2008.JTU Auto Supplys 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 being a taxi dri ver before, He got interested and came up lots of ideas somewhat different car parts that make him successfully established JTU Auto Supply. JTU Auto Supplys main colors are red and discolor because the colors are striking, attractive, and visible. The owner likewise 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 tag line Tapat sa Presyo.JTU Auto supply has five physical branches around Cavite located at Pag-asa subdivision which is its main branch, Buhay na tubig, along Molino road near SM Molino, Along Aguinaldo passage and Salitran. Each branch is dependent on their main branch at Pag-asa. They go out varieties of products and selling five main product lines. These are replacement parts, performance, accessories, fluids and chemicals, and tools. T he uses of these for the fomite are for maintenances or performances. Under replacement parts implys air conditioning, battery and accessories, belts and hoses, personify, trim and mirrors, brakes, charging and starting, engine parts, cooling, heating, exhaust fuel, emission, ignition, transmission, wiper and lot more. Under performance includes body styling comp binglents, oil, sealers, and additives, tuners, safety equipment and more. If you go for accessories it includes chrome, dress up, exterior and interior and in like manner 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 windshield wash, A/C chemicals, antifreeze, de-icers, cleaners, brakes, battery chemicals, fuel system, 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 thousand each product line that they have. The main goal of the JTU business is to give its customers 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 call of save upy of products.They have free delivery fee and can deliver products within 13-15 kilometer radius from its branches for 10-20 minutes. They pacify offer free delivery beyond the said distance but JTU Auto Supply cannot 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 some operational pro blems and transaction flaws. The problems of the company that they often encountered are more often than not in the sales and breed. JTU Auto Supply manually encodes large amount of items in their inventory. Manually affords sales reports from the receipts or sales invoices they have. They also manually go outs and track the inventories in every branches through with(predicate) phone calls, texting or even visiting. This may cause inconvenience in their part especially now that the company starts to grow more.They store their data into Microsoft Excel and open 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 specification of the product is hard to find, having lots of practical models in just a single part. Mainly in there free delivery, customers go out not be able to see the product itself and causes a lot of misunderstanding or mistakes on the products they runed.1.2STATEMENT OF THE PROBLEMJTU Auto Supply has five physical stores, all of the branches including the main branch are manually introduce, and checking the be items and sold items on each 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 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 al so 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 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 litre 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 Obj ectivesThe 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 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 assemblage information that will be needed 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 will be functional and much help 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 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 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 will kick upstairs 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 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 similar study to JTU Auto Supply Online Sales and In ventory System. The study can serve as the reference in creating the reenforcement 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 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 substance abuser has an account to the website. The proposed will have a built-in shopping cart for the list of orders of the customers. Customers can 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 guar anteed only if the location 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 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 fiat and delivery of the ordered items. The system will provide an account for administrators of the JTU Auto Supply 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 admin istrator to administrator account from one branch to another.