Free Essay

Inventory System

In: Computers and Technology

Submitted By Odawo
Words 6438
Pages 26
Shop Inventory System

Student No: 081835 : 082232

An Information Systems Project Proposal Submitted to the Faculty of Information Technology in partial fulfillment of the requirements for the award of a Diploma in Business Information Technology
Date of Submission: 10th February, 2015

Declaration
We declare that this project has not been submitted to any other University for the award of a
Diploma in Business Information Technology.

Student Signature:
Sign: ________________________ Date: ________________________
Sign: ________________________ Date: ________________________

Supervisor’s Signature:
Sign: ________________________ Date: ________________________

Abstract
In today’s growing market many businesses are turning towards automated systems to perform their everyday tasks. Automated systems have proved to outdate the cost and time wasting processes that are done and completed by manually while providing most businesses with more accurate and reliable data. The system will handle the processes in a well-manner running on a specific time, reducing the overwhelming power of doing them manually taking note of the products diversity. It will allow the business to input their inventory and track products that are delivered and sold on a daily basis.
At the time of arrival of new ordered stock, the goods are registered into the database and are added to the list of the current inventory. The depreciating inventory can be tracked the use of devices such as; barcodes and scanners on the goods being sold. On the sales module, products are subtracted from the inventory count the moment they are sold instead of being manually done at a later time or day. This process allows data accuracy than the manual process because the exact inventory stock is known at any given time. If the inventory is under-stocked, then the system will give out a notification for more order.
Another thing is, the system will keep track of product sales. Once a transaction is made, the sales module is updated with input of new figures and then saved into the database. Reports will be generated by various users and complied for the generation of the general report to be done by the finance manager, on a weekly basis

List of Figures Figure 1: Inventory System Use Case Diagram 22 Figure 2: Inventory System Data Flow Diagram 24 Figure 3: Inventory System Entity Relationship Diagram 25

List of Tables

Table of Contents Declaration 2 Abstract 3 List of Figures 4 List of Tables 5 Chapter 1: Introduction 8 1.1 Background 8 1.2 Problem Statement 8 1.3 Aim 9 1.4 Specific Objectives 9 1.5 Justification 9 1.6 Scope/Limitations 10 Chapter 2: Literature Review 11 2.1 Introduction 11 2.2 Companies and Businesses within Kenya. 11 2.3 Methods of Keeping Data Information in Companies (SMEs). 11 2.3.1 Weighing out the Methods of Data Keeping in Companies 13 2.4 Introduction of the Inventory System to Companies 13 Chapter 3: Methodology 17 3.1 Introduction 17 3.2 Analysis 18 3.2.1 Functional Requirements 18 3.2.2 Non-Functional Requirements 18 3.2.3 Narrative 20 3.2.4 Use Case Diagram for the Proposed Inventory System 20 3.3 Design 23 3.3.1 Data Flow Diagram (DFD) 23 3.3.2 Entity Relationship Diagram (ERD) 24 3.4 System Development Tools and Techniques 25 3.4.1 Qualitative Techniques 26 3.5 Deliverables 27 3.5.1 System Modules 27 3.5.2 System Documentation 27 References 28 Appendices 30 Appendix I: Elite Tools Questionnaire 30

Chapter 1: Introduction
1.1 Background
Elite Tools Limited was started 13 years ago. It is a growing company in the field of Construction and Industrial Machinery, Lifting and Rigging equipment, Welding equipment, Tools and Instruments covering a wide sector of the Construction and Industrial sectors. They supply power tools as well as hardware of all kinds in Nairobi. The company stocks all hardware items that are commonly used in the construction and industrial sectors. It also supplies a wide range of tools and machines.
The company works on a half digitized platform whereby they outsource services and products. They use Excel for their calculations, as stock records and sales are recorded on long white boards. This has proved to be hard on the company since they have to spend whenever they outsource their services or products, thus adding up on their financial costs.
In addition to that, on the event of recording product quantities and their sales on the white boards and account books, brings about cases of inaccuracy. As man is to error, so the records may be written wrongly thus wrong records generated. Also on the white board, if by any chance someone goes and rubs some part of the working or the entire writings, a problem may occur from remembering what was written especially if it was done by another person so generating them again would be hard.

1.2 Problem Statement Elite Tools has a manual way of taking into account what happens in there, in terms of sales, inventory checks, generating weekly reports, recording product types and, quantities for supply and the stock. In case of theft or fire, the company may suffer a huge loss in sectors of accountancy as sales are manually calculated and recorded in books, weekly reports generated manually to show what activities took place i.e. what types of goods were supplied and in what quantities, what services were offered and if more goods were brought in to make more sales.
1.3 Aim
Developing a system for the company will help upgrade them from just using Excel for their calculations to having a sales module in that system, in that when an accountant inputs products’ quantities and prices it calculates in just a click of a button thus reduces labor expenses and time. Due to inconsistency loss of data in cases of theft or fire, developing this system will provide them with a backup system where data can be saved for future reference, on which it will be updated daily. All finding records activities will be done by the developed system; reducing cases of delays thus satisfying their customers not making them wait for too long.
1.4 Specific Objectives * Study the company’s way of functioning * Identify the challenges faced by the company in terms of data collection * Design an automated system for the company * Develop and implement the proposed system * To tests the system in an environment that will satisfy the functioning of the company

1.5 Justification
In terms of time management, the solution is good as it will help curb time wastage on making calculations manually by use of a calculator. The system will require data inputs i.e. products’ quantities and prices and on just a click of a button it will perform the necessary calculations. On the reports module, weekly reports can be generated without delays and inaccuracies encouraging fast decision making if there happens to be any. Also, it guarantees less time for accessing data or information once they are saved unlike retrieving information from books which takes time.
On the cost sector, there will be a reduction on labour expenses as there won’t be any need to employ accountants to generate the sales of all the product types. It will also reduce cost of data storing in that purchase of more books for recording keeping and sales documentation will be no more or will become less.
On storage, all data or information that is currently stored in the drawers or racks will be transferred to the database system that will be safely saved in the computer. Also, it will allow easy tracking down of purchases, expenses and inventory records. It will optimize security and validity of the number of supplies, sales, purchases and expenses all the time in that company. It will offer support to the Inventory Management that helps record and keep track on all materials on the basis of both quantity and value.

1.6 Scope/Limitations
Using a computerized accounting system comes with its own set of problems, such as the need to protect against data loss through power failure or viruses, and the danger of hackers stealing data. Computer fraud is also a concern, and you need to instigate a system of controls for who has access to the information, particularly customer information. If there is a security breach and data is stolen, management can be held personally liable for the loss of data. You also need to make sure that the data has been correctly entered into the system, as a mistake in data entry can throw off a whole set of data

Chapter 2: Literature Review

2.1 Introduction
This chapter is about the existing literature on the current inventory management systems not only in Kenya but also the rest of the world. This is shown in the process of picking up of an automated inventory system within companies and businesses. In the review, it starts with the viewing of how companies and businesses go about their duties both manually and digitally, the challenges faced with the manual way of keeping inventories or accounts and records to the reasons that led to picking up of an automated inventory system and finally the various inventory systems that are widespread at the moment and the advantages of these inventory systems.
2.2 Companies and Businesses within Kenya.
Companies in Kenya have grown thus bringing about motivation and a chance for establishment of new business opportunities and Small and Medium sized Enterprises (SMEs) in the region. The upcoming of these SMEs has showcased as potential avenues for job creation, especially among the youthful population as they dispel the myth that only employment can provide a source of livelihood. This being a main advantage (Business Daily, 2012) .
The company, Elite Tools, in question being an SME makes the research get narrowed down on fellow SMEs and business enterprises. In 2012, it was clear that the country faced challenges one of them being that the import bill perennially exceeded income from exports. But if the small and medium sized companies were to be nurtured and encouraged to export more of their products, they would have the potential of helping the country address the imbalance between imports and exports. One of the attributes that most of the companies share irrespective of their specialization is that they all are involved in one form of value addition or another (Business Daily, 2012). From the 2014 release of the top 100 SMEs Elite Tools is mapped as the 39th (Business Daily, 2014) .

2.3 Methods of Keeping Data Information in Companies (SMEs).
Most companies in Kenya being SMEs still operate using bookkeeping methods, accounting and record keeping. This is whereby the companies or businesses use books to keep records (Simple Alliance, 2014). Bookkeeping and accounting share two basic goals: to keep track of income and expenses, which improves chances of making a profit, and to collect the financial information necessary for filing various tax returns. There is no requirement that records be kept in any particular way. As long as records accurately reflect the business’s income and expenses, there is a requirement, however, that some businesses use a certain method of crediting their accounts the user can either choose to use accrual- or cash-based bookkeeping system, or consult with the tax advisor (Onaolapo A. A., 2014).
The bookkeeping is mainly manual whereby accountants are hired. Few companies have had the chance to of owning a bookkeeping software. The bookkeeping softwares include: QuickInvoice, WinInvoice, PerForm Pro Plus, and Timeslips and the advantages of using the software is that the company benefits by getting professional looking invoices (Simple Alliance, 2014).
Saving time pointed out the following as the most important reasons to set up a good record management: * To control the creation and growth of records to reduce operating costs. * Improve efficiency and productivity (Laughlin, 1999).
From a case study, PHNSY stores tooling, personal protective equipment (PPE), and consumable products in centrally located tool rooms. With the exception of the occasional walk and wait time to and from the waterfront tool room, getting the needed items for the task at hand was generally a simple process. Simple, that is, if you are a first shift mechanic. Because the tool room was staffed for the first shift only, getting materials was somewhat more complicated for the other shifts.
For second and third shift mechanics, this process required additional steps in the process. If the mechanic from the previous shift didn't turn over the materials to the next shift, he/she would have to submit an item request for the needed materials for the task at hand. Upon receipt of the request, the tool room would supply the materials.
There was only one problem - the materials came 24 hours later (PHNSY, 2010).
However, it was found that there could be a better way of keeping data and taking into account what happens within country by using an automated system. Thanks to technological evolution the automated inventory system/management system was introduced. But why introduce an inventory system if the companies had used the manual book and record keeping system for years?
2.3.1 Weighing out the Methods of Data Keeping in Companies
Most SMEs opt for the manual way of data entry, recording and evaluation of data, it is better when the option of the manual way is evaluated further on finding its advantages and disadvantages.
The advantages of the manual system was that; the manual system applies to any business, it is much easier to set up, can be more flexible than a computerized accounting system, it is more secure and that it is clearly cheaper. However, it is also realized that the manual system has its disadvantages that include; it is prone to human error, it takes longer to generate reports thus time wasting, the company or business records are susceptible to perils such as fire and water, the disaster recovery plans harder to implement and it is not particularly suited to environments where there are a large volume of transactions (Design, 2012).
With these results from the comparison it is visible that the disadvantages of using a manual way of data keeping is outweighing the advantages of manual method. Thus, a better idea had to be brought up so as to make data keeping and recording easier. By this I mean that the inventory system idea had to be introduced.
2.4 Introduction of the Inventory System to Companies
An inventory is the stock of items, sales and reports used in an organization. An inventory system monitors the levels of inventory and determines the timeline and quantity of orders. Companies maintain inventories of raw materials, work in development or final products for various reasons, including unpredictable raw material delivery time, allowing for production scheduling flexibility or demand variations (Sarkissian, n.d.). There are many inventory-related costs including holding, ordering and shortage costs. An effective inventory management system can minimize these costs (Sarkissian, n.d.).
There are various types of inventory systems used in the different companies however the choice of inventory system will depend on the type of work being done, the amount of goods and transactions of the company and the size of the company among other factors (Sarkissian, n.d.). The types of the inventory systems include: * Visual Inventory Systems
Visual inventory systems are the most common systems in small businesses. In these systems, the manager periodically checks the availability of various items and determines the order quantity. It works best in companies with low variety of items that can easily be ordered and replenished. This system is the least-effective system, and oversight may result in inventory shortages (Sarkissian, n.d.). * Partial Inventory Systems
A partial inventory system might be the most practical system for a small business. It relies on the 80/20 Rule. According to this rule, about 80 percent of sales value is generated by 20 percent of the items in inventory. Focusing efforts on the 20 percent of items helps reduce the costs and complexity of inventory management (Sarkissian, n.d.). * ABC Method
The ABC method focuses efforts on the small percentage of items that generate the majority of the firm's sales. The inventory is divided into three major categories based on the value of items. The A category represents the highest-value items in the inventory. B and C items account for the moderate- and low-value items, respectively. Managers minimize total inventory costs by dividing time and effort spent on items based on their value (Sarkissian, n.d.). * Multi-Period Inventory Systems
There are two types of multi-period inventory systems: fixed-order quantity models and fixed-time period models. In the fixed-order quantity model, an inventory item is ordered when the stock of the item reaches a specific reorder level. Demand for items, cost per unit, ordering costs, and lead time and holding costs are considered when determining the reorder level. In the fixed-time period model, orders are placed at the end of a specific time period, such as a week or month. It works by counting inventory and placing orders periodically. It works best in situations when vendors make routine visits to customers and take orders for their complete line of products (Sarkissian, n.d.). * Just-in-Time Inventory Systems
Managers now believe that holding inventory masks other problems such as poor quality and bad supply chain management. Reducing inventory will expose these hidden problems so that they can be solved. A just-in-time inventory system tries to maintain no extra raw materials or work in progress. Supplies arrive “just in time” for production. Holding costs, employees and space needed to manage the inventory is reduced in this way (Sarkissian, n.d.).
From a case study, PHNSY decided to address the situation of time wastage by getting back to basics. The senior personnel started by interviewing the mechanics about the barriers put in place that harm productivity. What they uncovered was the need to improve access to consumable materials, tools, and drawings. The first step in removing these barriers was to address the accessibility and accountability for the consumable materials. Consumables are commonly used items such as paint brushes, batteries, washers, nuts, and gloves. PHNSY looked to WinWare, Inc., the makers of CribMaster to provide a solution. CribMaster is the name of the inventory system that was to be applied in PHNSY (PHNSY, 2010).
2.4.1 Why Use an Inventory System
Every company needs an inventory management system. Whether you are in wholesale, retail, service or virtually any other industry, you have to keep track of your products. Here are five reasons why it is so important to use business inventory software: * Prevent goods from spoiling and expiring.
If one has too many goods within the storage/ warehouse, he/she might find that the goods are either damaged, expired or even stolen without their knowledge. This risk depends on the type of industry one is and the size of the industry. With large companies and businesses, the damage may be larger than the income within the company thus recording great losses that can lead to company closure. * Prevent disappointing customers.
On the other end of the inventory spectrum, if the company has few goods to store and sell then the business faces a whole new level of risk. This is seen whereby the customers will expect good processing, packaging and delivery to be fast but if the service delivery is not impressive to the customer then the customer will opt to leave and cancel the order. This shows the how much an inventory system will be needed. * Stop wasting time.
Manual inventory management can be time-consuming. Speed is vital in a business environment. How fast you reorder products, deliver customer orders and update your inventory records could build or destroy your business. Scanning product barcodes and setting up automatic reorder points can save time by streamlining complex processes. * Foresee (look into the future).
You cannot afford to be purely reactionary in your inventory management. One needs to start planning for the future and apply innovation. Try to track down n note down the trends ahead of time by monitoring social media channels for mentions of certain products and looking at historical records to spot seasonal upticks in sales. Also do research on other similar companies, check what they have been doing and how they have been able to counter attack any obstacles. * It proves to be cost-effective.
This is whereby an automated inventory system can be implemented. This is because the system ca do multiple duties simultaneously and accurately. This can seem to be expensive at the point of purchase however, you realize that the system gets to be cheap. By this, we mean that the system gets to do the duties of multiple workers who you will no longer need and the money for their pay can be applied elsewhere.eg, the money can be used for business upkeep.
From the above, it can be easily derived that an automated system can get to be a better idea as compared to a manual system of bookkeeping and record keeping.
From a case study, although the system was recently implemented in September 2009, PHNSY has realized immediate and positive results on their operation. Stock-outs in their consumable materials have been greatly reduced. The min/max feature on the software ensures optimum inventory levels by sending an email alerting someone when replenishment is needed.
More importantly from the mechanics point of view, they enjoy having the right material at the right time 24 hours a day, 7 days a week. This has allowed them to do their job regardless of which shift they are working and allowed PHNSY to control material usage all at the same time. (PHNSY, 2010)

Chapter 3: Methodology
3.1 Introduction
A methodology is a systematic, theoretical analysis of the methods applied to a field of study. (Irny & Rose, 2005)
The system’s development will be applied through waterfall methodology. Reasons being; a waterfall model is seen as a linear sequential flow, in which our progress will be seen flowing steadily downwards through the phases of the software development. This means that, in order to proceed to the next phase the previous phase must be completed. This gives us a clear guide on making a plan and time schedule for the entire development process. (Benington, 1983)
It is easy to manage due to the rigidity of the model-each phase has specific deliverables and a review process, curbing mix-ups during the development process. (What is waterfall model-advantages, disadvantages and when to use it?)
Each phase is discrete and team members involved in a stage ensures the perfection of the stage before delivering to the next phase. Thus waterfall process ensures greater project output. (BitMascot ltd, 2011)
Easy to explain to the user the system’s structure approach as it provides a very well structure approach and it is easier to measure progress by reference to clearly defined and identifiable milestones in the development progress. (Smart Method Limited, 2006-2011)
Progress is easily measured, as the full scope of the work is known in advance. All works out well if the plan chart is well drawn to run throughout the development process at its specific period of time.
A lot of emphasis is laid on paperwork in this method as compared to the newer methods. When new workers enter the project, it is easier for them to carry on the work from where it had been left. The newer methods don’t document their developmental process which makes it difficult for a newer member of the team to understand what step is going to follow next. The Waterfall Model is a straight forward method and lets one know easily what stage is in progress. (Wordpress & Atahualpa, 2015)
Development moves from concept, through design, implementation, testing, installation, troubleshooting, and ends up at operation and maintenance. Each phase of development proceeds in strict order. (SDLC Waterfall Model-TutorialPoints.com, 2014)
Waterfall development process tends to be more secure because it is so plan oriented. For example, if a designer drops out of the project it is not a huge problem, as the Waterfall method requires extensive planning and documentation. A new designer can easily take the old designer’s place, following the development plan without a problem.
3.2 Analysis
Software requirements analysis is the process of determining user expectations for the new or modified product. (TechTarget, 2006-2015)
The system is comprised of both functional and non-functional requirements.
3.2.1 Functional Requirements
Functional requirements are statements of services the system should provide, how the system should react to particular inputs and how the system should behave in particular situations. (Requirements Engineering, n.d.) There are several functions that are include in the system to satisfy the needs of the customers. Some of these are as follows:
The proposed system is intended for inventory and sales purposes. Thus, it will perform different processes included both in the inventory and sales modules. It will be able to monitor the supply of certain items: addition of newly ordered goods to the current stock and also, subtraction of sold goods from the current stock.
As a result, the company will be able to track items or supplies that are running out of stock and thus prepare an order. It can also monitor staff’s orders and purchases from different suppliers.
3.2.2 Non-Functional Requirements
These are constraints on the services or functions that specifies criteria that can be used to judge the operation of a system, rather than specific behaviors. Often applies to the system as a whole rather than individual features. (Wikimedia Foundation, Inc., 2015)
3.2.2.1 Performance Requirement
The system would require the hardware and software specification stated below to maximize its performance. If the specified requirements are not provided by the company, the system will not satisfy the company’s expectation on the system.
Aside from the software and hardware specification, the system also requires a user that is capable of navigating the system well. It is not necessary that the user types very fast, even if it is just the average speed as long it can manage the system well. (linkedln Corporation, 2015)
3.2.2.2 Hardware and Software Requirements
Software Requirement
The system requires either Windows 2000 or other windows higher than Windows XP.
Hardware Requirements;
Main Power supply or Backup Power Supply
Monitor
Keyboard
Mouse
Minimum of 16GB Hard disk or higher
200 Memory or higher
Intel Pentium 4
A Printer
3.2.2.3 Service Requirement
The system will provide limited access for security purposes, so only persons with correct usernames and passwords can have access to the system. These people will be the only ones to enjoy the services that the system will provide such as performing inventory functions, adding and subtracting sales from the sales module and generation of reports.
3.2.2.4 Control and Security Requirement
Need for proper security and control over the data is necessary in creating and developing a system. Its aim is to curb issues of unauthorized data manipulation and data loss. A unique username and password will be provided to authorize personnel in the company. This will appear at the start-up of the system. Through these constraints, the company will have total control over the confidential data or information.
3.2.2.5 Information Requirement
The specific inputs are required by the system in order to perform its functions well. Some information is necessary to gain to provide and to gain desired output. Information like staff names, addresses, contacts are required by the system to recognize the authorize persons that can use the system in the company. Item ID, item name, item code name and other information about the item is necessary. Staff ID, name, position, designated room are also needed. There should be unique identifier of each item, staff, and supplier because the identifier will be the one that will set a difference among all other data. Most of the data are stored in the system itself, but some of it kept manually for the purpose of the company. (linkendln Corporation, 2015)
3.2.3 Narrative
For one to have access to log into the system, he must be a user to do with necessary password to do so. The system will have accessible slots for the following ; the administrator (maintains database-backs up and restores), inventory database(maintains database too and reports impending expiry of the database, sales person (enters a new order), accountant (inputs orders in terms of price and quantity), inventory supervisor (tracks stocks and reports to the inventory manager), inventory manager (prints an inventory report and re-stocks the inventory), senior accountant (sees what is done by the accountant and does a financial report), finance manager ( sees the report from the senior accountant and generates a general report on sales), warehouse worker or supervisor(views goods information, adds new goods, maintains goods category information, issues stocks up request to the inventory manager and orders too).
3.2.4 Use Case Diagram for the Proposed Inventory System
UML Use case diagram for the proposed inventory system is as shown below. The various participants or actors, the corresponding use case and the dependencies are shown in the table below.
Table 1: Inventory System Use Case relationship Actor | Corresponding use case | Dependencies | Administrator | * Database backup * Update database | Update database <<extend>> database backup whereby the backup only happens when need be or after a week or so. | Inventory Manager | * Generate reports * Record sales * Update database | Record sales <<include>> generate reports as it simultaneously <<include>> update database. With sales being recorded in the general company records they are also included in the final reports which are updated in the company database. | General/warehouse worker | * Record stock * Record new goods * Record expiry date of goods | Record stock <<include>> generate reports via the inventory manager.Record new goods <<include>> generate reports whereby any new good within the company is put into the company database via the inventory manager.Record new goods <<extend>> record expiry dates of goods. | Customer | * Buy goods. | |

From the data generated above the use case diagram below was generated.

Figure 1: Inventory System Use Case Diagram

3.3 Design
Design is the process of defining the architecture, components, interfaces, and other characteristics of a system or component" and "the result of [that] process (Owens, 2011).
Below are the data flow diagrams and entity relationship diagrams that show how the system works and how the actors relate to the system.
3.3.1 Data Flow Diagram (DFD)
This is a diagram that shows how data processes flow simultaneously within the system.
The application used in creating the diagram below is Visual Paradigm.
The diagram below shows a detailed explanation of what runs through the system and how data should flow. The customer approaches the business and makes an order with a motive of buying goods. A warehouse worker will attend to the customer and will sell goods to the customers. This will be recorded in the sales accounts by the inventory manager. The warehouse worker will so record any new goods within the business and also record the expiry date of goods to prevent good spoilage and then put it down in the report. The information is the sent to the manager who keeps the general report. Another duty of the warehouse worker is to record the stock amount and put it in the report.
The inventory manager generates the final report and then updates the database.
The system administrator updates and backs-up the database.

Figure 2: Inventory System Data Flow Diagram
3.3.2 Entity Relationship Diagram (ERD)
This is a diagram that shows the relationships between the various entities within the inventory system.

Figure 3: Inventory System Entity Relationship Diagram
3.4 System Development Tools and Techniques
The proposed inventory system will need various applications and tools that will be used in the development of the software. The tools will be categorized differently as per the stage.
Table 2: Inventory System tools required and reasons. Tool | Reason | Visual Studio 2008 | This will be for the coding of the program using C++ programming language. It will also be used in the attaching of the code to the desired interfaces. | Visual Basic | This will be used for the creation of some of the interfaces. | MYSQL | Used for the creation of the system database. |

3.4.1 Qualitative Techniques
In the proposed inventory system, qualitative tools and techniques were used.
This includes the methods of data research that were used in the research of this system. The following methods include questionnaire, interview and online research.
In the questionnaire method the following questionnaire was generated (in the appendices).
Under the interview method, we were able to get one on one answers as directed by the questionnaire above. Clearly, information is both delivered and understood better when both parties are talking face to face. By this, we mean that however much a questionnaire was provided, an interview was what we preferred. Over the interview, we used the questions from the questionnaire to retrieve helpful information. The interview was done with Mr. Harun Kimani, the IT specialist in Elite Tools Limited.
The online research was simply when the information within the research being generated from the internet websites for example www.google.com.
3.5 Deliverables
The deliverables in the proposed system will include various system modules that will be included and a simple documentation.
3.5.1 System Modules
The inventory system module includes the following:
Table 3: Inventory System Modules Module | Links/Aspects | Relations | Inventory | Count stockAdjust stockAdd new product | Product typeProduct prices | Reports | Inventory/stock reportSales report | Product typeProduct pricesProduct profits | Sales | New orderProcess orderInvoice orderNew customer | Product typeProduct priceProduct order amount | Vendor information | Receive stockPay stock orderVendor name | Product typeProduct list | Employee/Worker | Employee nameSales conductionCheck stock | Product sale amountProduct priceProduct type |

3.5.2 System Documentation
The following system documentation will be used in the proposed inventory system.
System documentation requirements will include the System roles and types, System inventory, and the Network topology.
The system documentation should follow the templates and best practices for the Elite Tools initial manual system. This will be able to help in the step by step development of the proposed automated inventory system. This will help minimize any forthcoming challenges.
Under the system roles and types, the properties within include what the system should do and how it should function. This includes the storage, networking and other services that will support the functioning of the system.
Under the system inventory there is the hardware inventory and the software inventory. The documentation provides the general environment of the Inventory system. This will include the network and the security within the system.

References
Benington, H. D. (1983, October 1). "Production of Large Computer Programs". IEEE Annals of the History of Computing (IEEE Educational Activities Department), 5(4), 350-361. doi:10.1109/MAHC.1983.10102
BitMascot ltd. (2011). Waterfall Software Development Approach-Prons and Cons. Retrieved from BitMascot: http://www.bitmascot.com/blog/2011/10/16/waterfall-software-development-approach-pros-and-cons/
Business Daily. (2012, October 28). SMEs play a crucial role in Kenyan economy. Retrieved from Business Daily: http://www.businessdailyafrica.com
Business Daily. (2014). Top 100 Companies. Retrieved from Kenya Top 100 MId Sized Companies: http://eastafricatop100.com/
Design, E. W. (2012). Manual Accounts System. Retrieved from Accounts Man: http://www.accountsman.com/
Irny, S., & Rose, A. (2005). "Designing a Strategic Information Sytems Planning Methodology for Malaysian Institutes of Higher Learning (isp- ipta), Issues in Information System. VI.
Laughlin, R. ,. (1999). Financial Accounting Method and Meaning. London: Van Nostrand Reinhold. linkedln Corporation. (2015). Online Supply Inventory System-SlideShare. Retrieved from slideshare: http://www.slideshare.net/rokista/online-supply-inventory-system linkendln Corporation. (2015). Online supply inventory system - SlideShare. Retrieved from slideshare: http://www.slideshare.net/rokista/online-supply-inventory-system
Onaolapo A. A., A. T. (2014, January). The Analysis of the impact of Accounting Records. International Journal of Academic Research in Business and Social Sciences, IV, 1-17. Retrieved from www.hrmars.com/journal
Owens, T. (2011, September 11). Programmers. Retrieved from Stack exchange: http://programmers.stackexchange.com/
PHNSY. (2010). Inventory Management System Keeps Pearl Harbour Mission Ready. Retrieved from CribMaster: www.cribmaster.com
Requirements Engineering. (n.d.). Retrieved from http://www.cs.ccsu.edu/~stan/classes/CS530/Notes14/04-Requirements.html
Sarkissian, A. (n.d.). An introduction to inventory systems. Retrieved from azCentral A Ganett Company: http://yourbusiness.azcentral.com/
SDLC Waterfall Model-TutorialPoints.com. (2014). Retrieved from Tutorialspoint: http://www.tutorialspoint.com/sdlc/sdlc_waterfall_model.htm
Simple Alliance, K. L. (2014). Small Business Book Keeping and Record Keeping. Retrieved from SME Toolkit Kenya: http://kenya.smetoolkit.org/kenya/en/content/en/53877/Small-Business-Bookkeeping-and-Record-Keeping
Smart Method Limited. (2006-2011). Waterfall Development Methodology-Learn Access VBA. Retrieved from Waterfall Development Methodology: http://learnaccessvba.com/application_development/waterfall_method.htm
TechTarget. (2006-2015). What is requirements analysis - SearchSoftwareQuality. Retrieved from TechTarget: http://searchsoftwarequality.techtarget.com/definition/requirements-analysis
What is waterfall model-advantages, disadvantages and when to use it? (n.d.). Retrieved from ISTQB EXAM CERTIFICATION: http://istqbexamcertification.com/what-is-waterfall-model-advantages-disadvantages-and-when-to-use-it/
Wikimedia Foundation, Inc. (2015, February 9). Non-functional requirement-Wikipedia, the free encyclopedia. Retrieved from Wikipedia: http://en.wikipedia.org/wiki/Non-functional_requirement
Wordpress & Atahualpa. (2015). Waterfall Model. Retrieved from Waterfall Model: http://www.waterfall-model.com/

Appendices
Appendix I: Elite Tools Questionnaire
1. Does your company own an information system? If yes:- a) How long have you had it? b) What type of information system is it? c) What functional area does it cover?
2. Is this information being applied in all your outlets around and if it is so, how is the head office connected to branches? 3. How does the use of this information system affect the company? a) Internally b) Externally
4. Acknowledging that Elite Tools Limited was ranked 25th in the Top 100 SMEs, did the information system in use at the moment help out in reaching this point?
5. Does the information system have impact on your decision making this? If so, please explain how.
6. To what depth or extent does the company rely on the information system and whether the above system has got a bearing on the financial and accounting aspects of the organization?

Similar Documents

Premium Essay

Inventory System

...Pamplona Tres,Las Piñas City Title: Computerized Inventory System Subject: Software Engineering Author: Bautista,Jan Royette L. Calim,Michellle Lumbang,Matt Andrew Degree: 2nd year student Date Started: January 2016 Date completed: Objective of the Study The general objective of the study is to develop a computerized inventory system that will make the owners inventory system easier and comfortable for the benefits of the company. And to identify a minimum stock level to keep detailed records with a good inventory system. Scope and Limitation The Computerized Inventory System provides a good quality system that can organize the food inventory system easier than manual of the system. The Inventory keeper of the company can handle the security of their inventory using the system provides. The system we provided is limited because it only keeps or stores the inventory record. Easily deletes the data in the system. The other limitation is that an employee might enter data incorrectly, introducing inaccurate information that can compromise decision-making. Output of the study A computerized inventory system can manage the stocks of their inventory if it is low count or a big count of food supply. The system can be also use for keeping the previous data of the food inventory. Stores the food stocks and manage inadequate and......

Words: 4399 - Pages: 18

Premium Essay

Inventory System

...Inventory System Background of the Study Effective inventory management is an important part of a manager’s job. Managers are tasked to make consistent, reliable, and timely decisions under the challenges of uncertainty, pressure, and lack of information. It is often that managers do not have enough time or information to make a perfect decision but they are forced to solve problems using resources within their control. Effective inventory control requires managers to ensure inventories of the right items in the correct quantities. When an organization overstocks, money is wasted since procuring, storing, and accounting for unneeded items require time, space, and money which could have been used on more critical assets. Likewise, when understocking occurs the organization will more likely to only partly meet their mission or possibly not meet the mission at all. Also, a weak inventory control system is more prone to errors and fraud. Statement of the Problem 1. How can our system generate quality use for the user? 2. Is our proposed system effective in processing needed reports? 3. How can our system guarantee the safety of the information stored? 4. How can our system reduce servile works for the staff involved in the type of field of work? Objectives of the Study This study tries to improve, introduce, and develop the use of inventory system for the ASIA GOLD CORPORATION. The system reduces work for the staff can make inputting of data at easier and......

Words: 321 - Pages: 2

Premium Essay

Inventory System

...[pic] Proposal of the software Inventory Control System Today’s competitive environment is forcing companies to optimize the procurement processes and inventory levels while at the same time ensure accuracy of controls and implementation Of standard procedures for the flow of materials. However, in the absence of appropriate systems and information infrastructure, companies are finding it difficult to achieve smooth and efficient Materials planning and execution due to the following information-based limitations. If these reflect your procurement and inventory management limitations as well, then Inventory Control and Valuation System by Core Solutions has the right answers to These critical problems ICVS – providing the right solutions for an efficient materials management. All-inclusive, functionality-rich software, the Inventory Control & Valuation System (ICVS) meets all the requirements for efficient management of inventories and materials procurement function Of small to large scale organizations. ICVS caters to all activities involved in the flow of materials Right from materials requirement determination, generating purchase orders to issue and receipt Of goods. The outcome is reliable maintenance of real-time records for item-wise, location-wise Stock count and its valuation. Issues in management of material flow • Unavailability of real-time and reliable record of inventories. • Manual requirement generation for materials......

Words: 700 - Pages: 3

Premium Essay

Inventory System

...Background of the Study Effective inventory management is an important part of a manager’s job. Managers are tasked to make consistent, reliable, and timely decisions under the challenges of uncertainty, pressure, and lack of information. It is often that managers do not have enough time or information to make a perfect decision but they are forced to solve problems using resources within their control. Effective inventory control requires managers to ensure inventories of the right items in the correct quantities. When an organization overstocks, money is wasted since procuring, storing, and accounting for unneeded items require time, space, and money which could have been used on more critical assets. Likewise, when understocking occurs the organization will more likely to only partly meet their mission or possibly not meet the mission at all. Also, a weak inventory control system is more prone to errors and fraud. Statement of the Problem 1. How can our system generate quality use for the user? 2. Is our proposed system effective in processing needed reports? 3. How can our system guarantee the safety of the information stored? 4. How can our system reduce servile works for the staff involved in the type of field of work? Objectives of the Study This study tries to improve, introduce, and develop the use of inventory system for the ASIA GOLD CORPORATION. The system reduces work for the staff can make inputting of data at easier and faster generating......

Words: 363 - Pages: 2

Free Essay

Inventory Systems

...Businesses and Inventory Systems Inventory Systems Inventory systems are tracking systems designed for companies to maintain an accurate accountability of products in stock or on hand. Each time items are added or removed from inventory items on hand either decrease or increase in number. This paper will review inventory systems within Starbucks, Wal- Mart, Dell, Arby’s, and Starbucks. The paper will also provide information regarding the success of the inventory systems and if the companies are happy with the current systems. Businesses and Inventory Systems Dell is a leading global software company that manufactures desktop computers, notebook computers, network servers, work stations, and storage products. Dell uses the Just-In Time inventory system. Just-In-Time means a company can receive raw materials just in time to go into production and complete and assemble manufacturing parts just in time to ship to customers (Accounting 4 Management, 2012). The advantages of the Just-In-Time system are that it permits Dell to reduce overhead and have certainty that products are available. The Just –In-Time inventory system reduces the cost of doing business. For example, Dell does not have to spend an enormous amount of funds on the cost of warehouse storage and the customer receives the benefit of lower cost for products. The company has a high satisfaction rating because of their ability to produce products at a fast rate. The challenge includes the......

Words: 1202 - Pages: 5

Premium Essay

Inventory Systems

...Inventory Systems Summary With the increasing demand to cut cost and increase revenues, developing the right inventory systems have become essential to compete in business. According to the Counselors to America’s Small Business, “Control of inventory, which typically represents 45% to 90% of all expenses for business, is needed to ensure that business has the right goods on hand to avoid product shortage and meet the consumer’s needs” (Counselors to America’s Small Business, p. 1). To ensure proper business practice Team A will evaluate four inventory systems and provide advantages and disadvantaged to ensure businesses can be cost-efficient, profitable, and provide for consumer’s needs. At the end of this report, a system will be suggested to meet the above criteria. Adria System Retailers are consistently faced with the challenge of properly managing their inventory to maximize profit for the company. As the second largest retailer in the United States, Target Corporation has implemented successfully an inventory system that works well for their business. Target currently uses the RFID program, also known as the radio frequency identification program. With this program, small tags are attached to each carton or pallet of merchandise delivered to the stores. “Many regard RFID tags as the new barcode to help businesses track and trace goods through the supply chain” (2011). Once the merchandise arrives at the store, the entire carton or pallet is scanned and the......

Words: 1529 - Pages: 7

Premium Essay

Inventory System

...complete functionality of how the inventory Updation takes place in the Inventory Management System for the products (both online and club) which are purchased from the eCommerce shopping site. Also this document will help you understand how the Inventory Management System is integrated with other applications in order to maintain the inventory level. 2. Overview of IMS: Global Inventory Management System is otherwise called as IMS. IMS is a single resource/entity where the inventory for all kinds of items is maintained/monitored. The different kinds of items available in the eCommerce shopping site are Online, Club and Auctions. The three important terms used in IMS are SUPPLY, DEMAND and AVAILABLE. These are the fields with which the inventory is monitored in IMS applications. SUPPLY – Overall Item Inventory available for purchase DEMAND – Ordered quantity by the customer for an item AVAILABLE – Item inventory available for purchase after the demand Let’s discuss more about these fields and the inventory updates in the following sections 3. Order Creation and Inventory Validation in IMS When an order is placed for an item from eCommerce application, immediately the inventory update happens in both Demand and Available fields in IMS application. When an item is added to shopping cart and on navigating to Shipping page, the item inventory is reserved for the ordered quantity in IMS. For example, let’s consider the item inventory as below before order......

Words: 1095 - Pages: 5

Premium Essay

Inventory System

... Inventory Valuation Overview Learning Team B Zhra Ghavam, Rochelle Ingram, Chris Staphylaris, and Glorina Tukes QRB/501 31 January 2013 Instructor: David Libhart Inventory Valuation Overview The inventory a company holds often accounts for a significant portion of all assets with a direct correlation to the balance sheet. Inventory includes assets intended for sale, assets in production, and assets that will be used for future production of goods. A company’s ending inventory can be calculated by adding the value of any beginning inventory with net purchases then subtracting the cost of goods sold. The equivalent mathematical representation is: Ending Inventory = Beginning Inventory + Net Purchases - Cost of Goods Sold (Inventory valuation, 2010). While there are numerous industry recognized standards for a valuation of inventory, three of the most common valuation systems include First-In, First-Out – FIFO, Last-In, First-Out – LIFO and Just-In-Time – JIT valuation systems. First-In, First-Out Goods processed or received by an organization are placed in holding as First-In, First-Out; this inventory system is used to track product for use and revenue gained. In the FIFO inventory valuation system, assets or inventory received first are the first ones to be......

Words: 2902 - Pages: 12

Premium Essay

System and Inventory

...customers, since they have been manageing their transactions and producing reports manually and have not manege to upgrade to a computerized system which will be a big improvement to their business operations like most successful business today. 1.2 Overview of the Current State of Technology 1.3 Project Rationale This Computerized Sales and Inventory System for (campany name)will improve their business transaction efficiency with its capability of securely compute, manage, save, back-up, restore and check critical inventory level all their business transaction information. Project Description 2.1 Problem Statement * To create a module that will always monitor the number of their products sold and stored * To create a module that will generate reports * To create a module that will maintain file in a safe storage * To create module that will store data accurately in a secure database 2.2 Proposed Research Project 2.2.1 General Problem * The company encounters problem on ordering of products. They are checking the stocks manually that can result to some confusion and inaccuracy 2.2.2 Specific Problem * The list of products information is only recorded in their logbook. 2.3 Proposed Research Project 2.3.1 General Objectives * To develop a Computerized Sales and Inventory System...

Words: 584 - Pages: 3

Premium Essay

Inventory System

...located in Pulang Lupa, Las Piňas and Marikina. The advent of new technology, most company nowadays is using computers in their transactions. Pharmacies in particular, are now making their systems computerized since that helps them minimize the time and efforts consumed by using manual system. Point-of-Sale Inventory System is one of the essential components of a successful business. It is a modern replacement for cash register in retail applications. It can help to record securely all the sales and customer’s orders and track products. A sale refers to the exchange of product or services for an amount of money or its equivalent while inventory, on the other hand, is the total amount of items and the act of counting them. A pharmacy owner must know the precise number of items in their storage areas in order to place orders and control losses up to date. Hence, computerizing both Sales and Inventory System will make an easier and faster transaction among the customers as well as monitoring the stocks of the products. Furthermore, the system also gives the person up-to-the-minute and detailed information on each item in your inventory. He/she will know exactly how much inventory comes in; is on-hand now, and where it goes. In fact, most entrepreneurs these days find that computerizing a system gives them a far wider range of information with less effort....

Words: 16309 - Pages: 66

Free Essay

Inventory System

...No. 1, March 2007, pp. 138-150 Automated Inventory System Using Portable Data Acquisition Module for Bell Electronics Corporation Zarina Ira V. Bernabe Monchie C. Dela Cruz Karen K. Jao Department of Electronics and Communications Engineering De La Salle University, Manila email: ira.bernabe@yahoo.com, chie08_elx@yahoo.com, karenjao@yahoo.com, Jingel A. Tio, Antonio S. Gonzales Jr. Department of Electronics and Communications Engineering De La Salle University, Manila Email: tioj@dlsu.edu.ph, gonzalesa@dlsu.edu.ph Bell Electronics Lab Corporation situated in Calamba, Laguna is engaged in test and assembly of optoelectronics and sensor devices. The company is concentrating on its resources in metal can packaging. The second phase of the company's program is towards the development of other types of optoelectronics and sensors device packaging to support their customer requirements. In this paper, the proponents will present an Automated Inventory System using Portable Data Acquisition (PDA) module to help the company’s growing business. The PDA module is composed of barcode scanner to scan issued and received items, and a Z8F6423 Zilog microcontroller to store the information. A Product Inventory System (PIS) application program is also discussed to show how the PDA module can be interfaced with the PIS. Test results presented in this paper will show apparent improvement of company’s inventory system. 1.0 INTRODUCTION Inventory system is an effective way for monitoring and......

Words: 3213 - Pages: 13

Premium Essay

Inventory System

...Introduction An inventory system is basically a process whereby a business keeps track of the goods and material it has available. In its simplest sense it can be done manually by a count at the end of each day. In this way it is possible to keep a record of the goods coming in to the business and goods being sold. However this is only really appropriate for small businesses that do not have a lot of stock. For larger business it is more likely that a computerized system will be required. Transaction processing systems are commonly used to operate businesses. In this era, manual transactions evolved into computerized ones. Manual inventory systems turned out to be slow and inaccurate resulting to problems like running out of stocks and slow computations of product prices being bought by the customers. The degree of success of a business greatly depends upon controlling the merchandise inventory. The continuously improving and upgrading of computer usage into more powerful and useful applications has made managing business transactions a lot more efficient and easier. Today, businesses use the computer to assist in controlling and monitoring many aspects of the businesses, since manual approach in data processing could no longer meet the demands of increasing volume of transactions. Background of the Study Inventory is the term used for compiled list of goods. Inventory is important process in effective management of a business. The Company named Fast Services......

Words: 1212 - Pages: 5

Premium Essay

Inventory Systems

...Inventory Systems and Calculating Revenues, Expenses, and Income Inventory Systems and Calculating Revenues, Expenses, and Income QS 5-8A Contrasting periodic and perpetual systems Identify whether each description best applies to a periodic or a perpetual inventory system. a. Provides more timely information to managers. - Perpetual b. Requires an adjusting entry to record inventory shrinkage – Perpetual c. Markedly increased in frequency and popularity in business within the past decade. - Perpetual d. Records cost of goods sold each time a sales transaction occurs. - Perpetual Cost of goods sold = (Purchases + Beginning inventory – ending inventory) Gross Profit = (Net Sales – COGS) Net Income (Gross Profit – Expenses) a.36000 + 6000 - x = 3405042000 - x = 34050-x = -7950x = 7950 | b.x + 17050 - 2700 = 15900x + 14350 = 15950x = 1600 | c.36000 - x = 3750-x = 3750 - 36000-x = -32250x = 32250 | d.32000 + 7000 - 6600 = x32400 = x | e.5600 + 2560 - x = 56008160 - x = 5600-x = -2560x = 2560 | | | x + 7500 - 9000 = 32250x - 1500 = 32250x = 33750 | x - 32400 = 45600x = 78000 | | Journalize the following merchandising transactions for CSI Systems assuming it uses (a) a periodic inventory system and (b) a perpetual inventory system. 1. On November 1, CSI Systems purchases merchandise for $1,400 on credit with terms of 2_5, n_30, FOB shipping point; invoice dated November 1. n_30, FOB shipping point; invoice dated November 1. 2.......

Words: 310 - Pages: 2

Premium Essay

Inventory System

...THE BASIC INVENTORY SYSTEM The basic inventory problem that the firm is now facing is that Joan Glass is holding minimal stock on hand, evidently proving that she is working with the Lean inventory system. This system is a strategic method which is a credible and desirable system, but on the same note it poses profitable implications of the firm such that if excess stock needed at any given time there is none available due to decreases with in-process inventory levels and associated carrying costs thus causing major problems. With this problem the firm also faces the repercussions of additional costs and problems such as: drastic changes in transport costing; damaged materials; interrupted integration; long lead times; late supplies; unsatisfied customers; inability to build up strong working capital; inaccurate forecasting of present sales and future sales and cost of the firm. Joan is un-able to use other cheaper methods of transportation such as road and ship transportation, due to her taking upon multiple last minute orders, thus resulting in her using the Airfreight method. This method is preferred as its travel times are much quicker than most other transport methods given that she has limited time to supply to customer, with this advantage the major downfall of using this method is that is that it brings about a huge financial loss on the company (Moncka,et al,2009). “Look at these air freight bills! Here’s one for R955—more than the damn part is worth.”(President...

Words: 703 - Pages: 3

Free Essay

Inventory System

...4 local Studies: 1. Facility Inventory System Introduction: Nowadays, companies becoming more competent as time pass. Anytime from now a new strategy, technology and discoveries may come up just for them to gain much profit. The problem that will be encountered is the maintenance for the system and the consistency of it to be used for a long time. We will be using a Structured system analysis and design for our methodology. We will also use Microsoft Visual Basic 6.0 as our programming language. 2. Online Sales and Inventory System of ACME Hardware Introduction: From the very earliest moments in the modern history of thecomputer, the people and the business world have witnessed theproliferation of computer system that obliges to meet the goal of Information technology. This problems are commonly encountered on the current Salesand Inventory System of Tacloban ACME Hardware? What must be proposed to make it happen? What are the input needed to develop this type of program. We will be using Microsoft Visual Basic 6.0 develop our program and we will be using Structured System Analysis And Design for our Methodology. 3. COMPUTERIZED MANAGEMENT AND MONITORING SYSTEM FOR MONTEJO NEWSPAPER SUPPLY AND MAGAZINE DISTRIBUTOR Introduction: The used of manual processes in business has decline since the rise of computerized and automated systems. And in fact, nowadays, the use of computer-based business system has become prevalent all throughout the......

Words: 282 - Pages: 2