Sales Inventory Thesis

CHAPTER I

PROJECT OVERVIEW

PROJECT BACKGROUND
OBJECTIVES OF THE PROJECT
STATEMENT OF WORK

PROJECT OVERVIEW
Computerization of process makes the work more convenient and Information Technology plays a big role in business and economy. Information Technology provides ways and making the best solutions that aid complains to their operations and future investments, leading to their success. Technology innovate business processes and paving the way to new heights of development improving the flow or ways of business is to be done. Most importantly, technology in combination with the principles of business applicants, data communications, shapes the future for decades to come.
Point-of-Sales system offers a wide selection of features to improve control of your business and save time spent on inventory, purchasing and accounting. Point of sale (POS) systems is electronic systems that provide businesses with the capability to retain and analyze a wide variety of inventory and transaction data on a continuous basis. POS systems have been touted as valuable tools for a wide variety of business purposes, including refining target marketing strategies; tracking supplier purchases; determining customer purchasing patterns; analyzing sales (on a daily, monthly, or annual basis) of each inventory item, department, or supplier; and creating reports for use in making purchases, reorders, etc. Basic points of sale systems currently in use include standalone electronic cash registers, also known as ECRs; ECR-based network systems; and controller-based systems. All function essentially as sales and cash management tools, but each has features that are unique.
At the inventory control, the computer keeps the store's inventory, so the POS terminals attached to it automatically update inventory with every sale or return. In multi-store environments the person at the POS station can check stock in other stores if this store is out of stock. The central office knows at all times how many stock each store has. On Inventory Analysis, the system knows at what rate each item is selling at all times, making it easy to decide what quantity to reorder. Trends can be identified to reduce buying mistakes. In multi-store environments the central office can see the differences in item movement from store to store, making it easy to account for local or regional preferences.

PROJECT BACKGROUND The dawn of the new age opens new doors leading to the brave new world of Information Technology. In almost everything that we do every day, it is safe to say that the benefit that we harness in tapping the potential of technology is priceless. Those tasks that were almost impossible to accomplish during the previous generations can now be done in the most efficient ways possible. Having access to the Internet increases man’s knowledge base and accelerates the speed of transactions in the business world as well. That is why there is no doubt that the most important invention that man has made is the computer. The urge of owning a computer system drifted from being a ‘want’ to a ‘need’. The market for laptops and desktop computers has grown to the extent that prices that were once sky-high have dropped low, which allowed almost every household to own their own computer units. The availability of computer parts and hardware has expanded that computer hardware shops sprouted like mushrooms in malls and other business areas. Microstar International is one of the most reputable brands in the world of computing. It was established in August 1986 in Jhonghei, Taipei by 5 founders – Joseph Hsu, Jeans Huang, Frank Lin, Kenny Yu, and Henry Lu. MSI concentrated on developing and manufacturing computer mainboards and graphics cards in the beginning. In 1987, the company produced the world's first overclockingmotherboard. MSI has also expanded into mainland China, opening its Baoan Plant in Shenzhen in 2000 and establishing research and development facilities Kunshan in 2001. In 1995, MSI kicked off its diversified business operation strategy, starting from the motherboard and video card industries and extending into consumer electronics. Currently its portfolio includes notebooks, communication devices, barebone systems, servers/workstations, multimedia, industrial computing, and others. Upon renovation of the ayala, the idea of opening stores sporting specific brands has been conceived. Thus, on March 9, 2009, Jonathan Khinghon, the company’s president, established the MSI Concept Store. The store offered product lines from MSI that includes notebook computers and other components. MSI Concept Store at SM North EDSA Annex is affiliated with PC City and PC Xpert Zone, two of the biggest names in local computer sales and distribution industry. However, like any other trade, the MSI Concept Store has its own internal problems. The group found out that store still employs the manual system in conducting their sales and inventory operations that is why the group intends to provide a solution to enhance the services and hasten the transaction processes for the company.

ORGANIZATIONAL CHART FIGURE 1 :MICROSTAR INTERNATIONAL (MSI) Organizational Chart

OBJECTIVES OF THE PROJECT
GENERAL OBJECTIVE The general objective of this project is to develop a computerized sales and inventory system which also makes use of a barcode scanner to hasten the sales transactions and improve the monitoring of stocks in the inventory to ensure the high quality services of PC Zone’s MSI Concept Store located at ayala
SPECIFIC OBJECTIVES
The specific objectives of the project are the following:
• To design a system that will incorporate all functions and specifications such as generating sales reports efficient tracking of incoming and outgoing inventory goods, printing sales and service receipts and monitoring and all Return Merchandise Authorization (RMA) services.
• To test and evaluate the acceptability of the system by gathering feedback from technical experts and prospective users to determine the accuracy, functionality, reliability and usability of the system.
• To develop a system that will deliver accurate results and minimize the percentage of erroneous outputs like statistical discrepancies in the inventory reports and as well as sales reports.
• To develop a system that will efficiently handle all transactions to further hasten the speed of sales resulting in larger profit for the company.
STATEMENT OF WORK
SCOPE OF THE PROJECT
The project was designed specifically for the MSI Concept Store at SM North Annex EDSA. It was intended to automate the way the products are monitored in the inventory, providing automation of the traditional way of checking the items in the storage room by imploring the use of barcode scanners. The barcode reading technology purpose was to identify each item having different items codes. This was ensured that no duplicate entries will be inserted in the inventory. The system was capable of generating daily, weekly, monthly, quarterly and annual reports so that the administrators was able to verify the sales transactions that the company acquired for the specific period of time. The system has also run with a minimum of two computers connected in a local area network only. The system was capable of running in a computer unit with minimal requirements of at least 1.6GHZ of processing speeds 1GB of physical memory, 40GB of storage space. The project was able to run on Windows XP operating systems with Microsoft.NET Framework 3.5 installed. The system was also capable of monitoring the Return Merchandise Authorization services conducted by company to provide after sales service to consumers who purchased defective items, which are still covered under the one-year warranty period. The system also produced printed receipts for every transaction conducted by the company.
LIMITATIONS
The study is only for the exclusive use of the shop manager and the cashier thus a login module was provided. The system was only implemented in the MSI Concept Store in SM North Edsa Annex branch. The group only provided support by until the whole software development has finished. This was in form of debugging, providing software updates and operation tutorials for the users of the system and as well as customization options for the preference of the users.
LIST OF DELIVERABLES
• DEPLOYMENT PLAN o INSTALLATION PLAN
 The researchers were responsible for the implementation of the system. This includes the installation of the software to the company’s system unit to run the system in their desired state. o TRAINING MANUAL
 This is the manual and instructions that were used for teaching the sales representatives and all the staffs that would be using the system. o USERS MANUAL
 This is the reference that the user would be looking up to if they have questions regarding the system