Development of an inventory management system

Development of an strain centeringing transcription baseThis project is on the see and memorialiseing of an entry every(prenominal) everywheresight constitution which is comp geniusnt smash of the supply- compass Management. This strategy entrust attempt to solve issues with current origin solicitude organisations in order to give headachees a ruin competitive edge.The literature review leave provide a flesh out overview ab come in size up c ar why vexation need to manage their memorandum, benefits and objectives of enrolment precaution and best approach shot pattern in register counsel. It will go on to further discuss what record solicitude ashes is all to the highest degree, a detailed ex platformation of the benefits, future of roll management dusts and talk about success of catalogue management system.In the review, various factors for implementing economical behave-taking management systems were tendencyed in order to understand fully how to design and develop a softw atomic number 18 consequence for a company that would provide the best go and effectual solution to their current problems. The report similarly discussed some challenges faced by approximately line management system in providing businesses with an effective solution.As part of the literature review, a case study was carried out on Sahad Stores, a distri plainlyion company in Nigeria and a detailed investigation into their existing system was accomplished highlighting the problems of the current system. Based on knowledge gained from the literature review, a proposed solution was presented to sever the issues with the companys current system of stemma management. stock-take MANAGEMENTAn memorial is basically a detailed list of all the full points in derivation. pedigree consists of raw materials, work-in-process and finished goods. In todays highly competitive market, businesses need to swear an appropriate level of stock to meet the customer brings at any time. Inventory management is part of the supply chain management.Over the past years, the concept of supply chain management SCM has been given a consider fitted attention. This is an orgasm to view the supply chain as a whole rather than as a set of separate processes (Weele, 2002). Mentzer, Dewitt, Keebler, Min, Nix, Smith and Zacharia defined Supply chain management SCM as the doctrinal and strategic coordination of the traditional business operations. The main(prenominal) aim of supply chain management SCM is to emend the wide term performance of each firm as sound as the whole supply chain (Mentzer, Dewitt, Keebler, Min, Nix, Smith and Zacharia, 2001). Inventory management involves system and processes of maintaining the appropriate level of stock in a w arho physical exertion (Barcodes, 2010). These activities includes calling necessary stocktaking demandments, and creating substitution processes, tracking and monitoring the usage of ev ents/stock, reconciling arsenal balances as considerably as reporting stock status.(Barcodes , 2010). It is basically the process of streamlinedly curtailling the keep down of stock in order to avoid excess gillyflower. Reliable catalogue management will therefore minimise the approach associated with list (Barcodes, 2010).Inventory management involves a wide scope of processes ranging from blood line forebode , replenishment, demand forecasting as salutary as quality management (Wikipedia, 2009).Objectives and benefits of stock-take managementAccording to Stylus Systems, The 3 main objectives in inventory management atomic number 18 (Stylus, 2008)To reduce inventory investiture or comprise which is one of the some important goals of any business. Balancing the woo of retention inventory with the benefits gained from it is vital to the successes of an government activityTo provide improved customer satisfactionTo increase gross revenue and profits realised fro m effective inventory management which therefore improve overall business intersectionivityBenefits of inventory managementIn a report by Stylus, he highlighted the following as some of the benefits of inventory management (Stylus, 2008)Inventory management systems disregard patron reduce the time to respond to changing market demand of harvest-times and sewer overhaul control excess stockIMS provide a means for business to in effect manage or control their inventoryIMS helps businesses to constantly analyse their business processes such as sales and buy in order to make efficient inventory decisionsStylus systems also reported that inventory management systems IMS ordure provide total insight on stock transactionsStylus systems also utter that IMS nates provide give on knowledge on inventory which might lead to increased sales and efficient customer services.Development in inventory managementPresently, there are two major(ip) approaches to inventory managementMaterials requirement planning (MRP) MRP is simply a management system in which sales are converted into loads by sub-unit and time. In this system, orders are scheduled to a greater extent closely thereby reducing inventory and making delivery times shorter and more predictable (Hedrick, 2003). MPR review order quantities sporadically and as such allow rules of order only what is currently needed. This helps keep inventory levels very low.Just-in-Time (JIT) JIT approach come acrosss that a business should only keep inventory in the mightily meter at the amend time with the right quality (David, 2004) .Most organizations adapt to this system to coalesce inventory management for a more competitive advantage (Kaynak, 2005). It eliminates inventories rather than optimize them.Why keep InventoryInventory refers to a detailed list of all the points in store or wareho lend oneself. According to Inman, Inventory refers to the percentage points that are stored in warehouses or distribution centres in excess of what the store needs (Inman, 2010).The following are the reason why business keeps more inventory than they currently need (Inventory Management, 2010).Meet Demand this ensures that customers get the product or item that they want when they want it. Keep Operations running When for example shapers run out of stock to fabrication certain product, the whole production process or operations will be halted and thus manufacture of the finished product. In order to prevent this, most manufacturers purchase excess inventory.Lead time When a shop or a factory places an order for a particular item, the period of time among the order placements and when the order is received is known as lead time. Business therefore should have hands on inventory during the lead time in order to keep its operations running.Hedge This involves safekeeping inventory against inflation in bell of products. This allows the buyer to buy at a lower price than when the price increases.Quantit y Discount Quantity discount refers to reduction in price of an item when purchase in spate. This al guidances influences most businesses to buy more than it needs which might lead to excess inventory.Smoothing Requirements businesses sometimes acquire access inventory for products that have unpredictable demands in order to meet demand.According to Edwars property (Silver, 2008), inventory management involves knowing the following QuestionsThe size of replenishment order that will be postulateThe time this order will be placedAnd finally how frequent inventory records should be analysed out duplicate practice in inventory managementIn an effort to maximise their return on investiture (ROI) and avoid excess inventory, legion(predicate) businesses invest a fortune in inventory management systems.In a report by Philip woodlouse (Slater, 2009), he stated that most of these systems fails to render expected services and rather pull up stakes in excess inventory. This is be pass wa ter software product can only optimise the values it has and non what it could be and as a result, it neglects some important external influences like changes in the management process. He stated that Worlds best practice inventory management demands that the inventory management system is optimised not alone the inventory. Inventory management therefore goes beyond software system and as stated by Philip Slater (Slater, 2009) inventory management involves combination of know-how, process and reporting that collectively provide a means of increase availability while minimizing cash investment. In the report, he stated five level of worlds best practice inventory management that when fully implemented, can enable businesses to reduce their inventory investment or monetary value. These levels areAd Hoc this level require less control as inventory is expensed when purchased on an as needed basis and utilise immediately.Storage this level involves the storage of items for use and n ot strictly controlled. Here, inventory is expensed when purchased. This approach tends to increase total expenditure as items are purchased in economic quantities and discourage review and development due to lack of controlCapitalisation This approach entails the use of software solution to control inventory and provide good availability. Unfortunately, most businesses use their software loosely for counting and accounting.Software Optimisation at this level, inventory is capitalised and the levels of stock are optimised based on a risk/return algorithm. Software solution can automatically adjust stock levels based on the history of demand and supply but these level are not trusted by most business because they believe the supply and demand may not represent demonstrable usageSystem Optimisation At this level, all factors influencing inventory investment are reviewed periodically. The main purpose of inventory management is to minimise overall cash investment without increasing risk. This according to Philip Slater is the worlds best practice in inventory management (Slater, 2009).Capitalisation and system optimisation goes hand-in-hand. For an effective system, the management is therefore required to possess the know-how, measures, policy development, and reporting required to share the business to level 5 (System Optimization) and not just the software alone(Slater, 2009).INVENTORY CONTROLAccording to business link in an article, an organisation has an efficient inventory control only when they have the right amount of stock in the right place and at the right time (Business link, 2006). Inefficient Inventory control can leads slower sales and disappointed customers.Inventory control basically deals with reducing the total cost of inventory. Inventory control is very relevant for businesses, especially businesses dealing with a large variety of products. As site by Hossein Arsham, Inventory management or control can be employ to streamline warehouse p rocesses in order to track orders and shipment (Arsham, 2006). Other important applications of inventory management systems are in manufacturing, shipping, and receiving. As stated by Arsham, there are three main factors in inventory control decision making process (Arsham, 2006).The cost of holding the stock this is the cost associated carrying inventory over time and involves having items in storage. This includes interest, taxes, insurance, spoilage, breakage and warehousing cost like light, rent.The cost of placing an order this is the cost of ordering and receiving inventory which include shipping cost, preparing invoices, determine how much is needed and moving goods.The cost of shortage this cost involves what is lost if the stock is insufficient to meet all demand. This normally happens when demand exceeds the supply of inventory on hand.MerchantOS argued that the easiest way of life to manage inventory is with a computer inventory management system (Merchant, 2010). The sy stems below help to reduce the time spent in managing inventoryPoint-of-sale terminals this system updates stock level automatically and provide a more error free sales transactionBarcodes and barcode readers which proved a way to effectively input inventory and stock takes faster into the systemJob costing and inventory systems which are systems that also automatically update stock counts as orders are being make.Electronic Supplier product catalogs allows the use of electronic devices like CD/DVDs to record inventory data.These systems ensure accurate inventory records by dint of the use of electronic and wireless technologies that provide error free data. These systems are very efficient in that theyKeep only up-to-date records of items and remove all sold items from the systemIt is possible to Review stock reports periodically to check the products status and identify low demand products.Periodically check record to ensure the level of accuracy of the system and to check agains t physical stock quantities.Methods of Inventory ControlThere are some(prenominal) method of inventory control which include (Hedrick, 2010)Visual control this is apply to determine if surplus inventory is required through visual examination. This method is mostly use in small businesses and may not require any records.Tickler control this is the physical counting of small portion of the inventory on a regular basis.Click Sheet Control this involves the recording of items as they are used on a sheet of paper and used for reorder purposesStub control mostly used by retailers and allow managers have certain control of prices.Today, the growth of businesses has provided a necessity to develop a more complicated and highly analytical form of inventory management. The above inventory management systems became demanding and inefficient. As a result, computer systems to control inventory was introduced. These systems includePoint-of-sale terminals this stores information of each item t hat is used or sold.Off-line point-of-sale terminals this pass arounds sales information directly to the suppliers computer system. The supplier thusly uses this information to ship necessary items automatically to the retailersThe last method for inventory control is carried out by an external agency. As sited by Floyd Hedrick, it involves removal of unwanted products from stock which can be returned to the manufacture. This however has to go on after an agreement and frequent scheduled visit by the manufacturers representative to the large retailer in order to record stock count and writes the reorder (Hedrick, 2010).The main aim of the above systems was to provide a more efficient system that will be able to identify the cost of each inventory (Hedrick, 2010). According to the report, two main control values are usedThe Economic order quantity (EOQ) that is the size of the orderThe reorder point which is the lowest quantity that a stock or an item can be before more quantity i s ordered.The Economic Order Quantity (EOQ) is a recipe that is used mainly for calculating the annual cost for ordering an item. It is widely used by most businesses and involves the actual cost of placing an order, the cost of carrying inventory as well as the annual sales rate. (Hedrick, 2010).INVENTORY MANAGEMENT SYSTEMSAn Inventory management system is a system that automates all the processes involved in inventory management. These system are a vital part of any successful business and is basically used to efficiently track inventory using both hardware and software withalls. The qualitys of inventory tracked with an inventory management system includes almost any type of quantifiable products like clothing, household products, regimen, as well as equipment (Barcodes inc, 2010 ). These inventory management systems can influence the overall readiness of a companys performance resulting in profits. An overview of the whole system is as shown in the diagram belowThe diagram above show an over view of the whole inventory management system indication how numerous branches. It shows how the inventory management system manages inventory, sales as well as Employee information.Through the end of 1980s, sales and accounting related modules were the main focus of majority of software solution for retailer, manufacturers, and wholesalers. During the early 1990s, many another(prenominal) distributors began to notice the relevance of an effective way of controlling and managing their largest investment of corporate assets which is inventory. This lead to the development of comprehensive inventory management modules and systems by several software companies (Schreibfeder, 2009).Presently, many businesses rely on modern inventory management systems to automate and integrate all lookings their business operations from order management, shipping management, billing systems, to inventory control all in one software package (Schreibfeder, 2009).Tim Cosby reported tha t, inventory management systems must have ability to track sales and availability, communicate with suppliers in near real-time and receive and incorporate other data like seasonal worker demand (Cosby, 2007). This means that the system must tell the storeowner for example when its stock level is low so as to reorder and how much to purchase.Information technology provided a way to convert sales and purchasing into a strategic business operation. Businesses now are faced with the challenge of finding out how to use these technologies to gain value and competitive advantage. Inventory management system can deliver these advantages (Stylus Systems, 2008).Modern inventory management systems now depend on barcodes, and potentially RFID systems to enable automatic identification of objects. According to a case study at Wal-Mart, for products selling among 1 and 15 units a day, RFID was able to trim back Out of Stocks by up to 30% (Mathieu, 2007).In order to record an inventory transact ion accurately, the inventory management system uses abarcode scanneror RFID reader to identify products automatically, and then collects additional information on the specific product from the operators via fixedwireless terminals, or mobile computers (Mathieu, 2007). Mathieu defined RFID (RadioFrequencyIdentification) as a data collection technology that uses electronic tags also known as electronic label to store data and can be used to identify items just like bar codes.The main difference between RFID and bar codes is that RFID uses wireless technology to transmit information into the system and can be inserted within packages and does not have to be close to the scanner. On the other hand, barcodes require line of sight and closure to the scanner for information to be read.As stated by Mathieu, RFID tagged cartons rolling on a conveyer belt can be read many times faster than bar-coded boxes (Mathieu, 2007).Large software companies like IBM, Microsoft, SAP, and Oracle have alre ady intentional effective inventory management systems for large businesses. These software solutions cost thousands to millions of dollars. They have now turned to focus on smaller businesses. nigh of the popular inventory (supply chain) management systems produced by Microsoft include Great Plains and Solomon, which are now joined together and called Microsoft Dynamics GP (Quittner, 2008).Implementing effective inventory management systemsInventory management is very relevant for todays businesses in order to ensure quality control in businesses which presently is centred mostly on customer satisfaction. Inefficient inventory control or management can therefore cause customer dissatisfaction when they run out of stock of an item the customer needs. In order to avoid this, most businesses are unbidden to invest large amount of money in acquiring an effective and efficient inventory management systems.A good inventory management system will be able to alert the retailer when it i s time to reorder. It is also an important way automatically tracking moving inventory.An efficient inventory management system helps to minimize the risk of error. For example, if a business orders large quantity of goods, and speculate 10,000 are missing. Manual counting each goods is likely to result in error but these errors can be avoided using an automated inventory management system. In retail stores, an inventory management system can also be used to track theft of retail merchandise, providing valuable information about store activities (Schreibfeder, 2009).Inventory management systems must be designed to reflect and support companys strategic plan as well as adapt to market changes due to worldwide marketing or untested technology. It should also provide relevant information to efficiently monitor inventory movements, coordinate and integrate inborn processes like accounting or billing, manage people and equipment and communicate with customers.According to Invatol, inv entory management system must be able to integrate the following processes in order to ensure continuity between functions (Invatol, 2003)Sales Forecasting this requires the system to provide necessary information to coordinate business operations effectively and manage equipment and people. It should allow managers to make accurate and real time decisions.Sales and Operations planning inventory management should control or handle fluctuations in market demands and lead timeCompanys Strategic goals alliance with company strategy is an important aspect of the business and necessary for its success and therefore inventory management should be designed to align with the companys strategic goal and market demand. carrefourion and materials requirement planning inventory system s should provide a balance of demand and supply at a minimised cost, inventory level and work load to achieve customer satisfaction.These processes however vary from business to business depending on how the busi nesses carry out its processes, and on the market demand.Benefits of using Inventory management systemsAs cited by David Essex (Essex, 2009), he stated that the following are some of the advantages that businesses achieve while using inventory management softwareBusinesses get faster return on investment (ROI) which is as a result of lower carrying cost.Inventory software can provide accurate up-to-date information about inventory thereby change sales forecasts.Replenishment Planning. This means that Inventory management software can notify businesses the safest time to defy order without affecting customer satisfaction and cost.It also proved the ability to separate safety stock according to customer satisfaction and profitability.Increased salesIt can also encourage sales mental faculty to promote products without running out of stock by improving inventory visibility (Essex, 2009).Successful Inventory management systemsFor any successful business, inventory management must be a critical aspect of its business. The most important aspect of an efficient inventory management is to achieve accurate data in terms of figures and facts and to implement policies to protect this information (Inventory Management, 2007).A successful inventory management system will provided businesses with proper inventory control that reduces overall operating cost leading to customer satisfaction as well as give a competitive advantage. As sited by Alan Smith, a well-structured inventory management system should be able to adjust to an existing system (Smith, 2009)Success in manufacturing industry entails producing the right products, in the right quantities, at the right time, with good quality, and at a price the customer is willing to pay.Success in the manufacturing industry requires producing the right products, in the right quantities, at the right time, with good quality, and at a price the customer is willing to pay. The flexibility to respond to compliance standards and the ever-changing needs of customers, such as providing real-time visibility into global operations, is also imperative for success. Meeting these demands requires the ability to make loyal decisions based on accurate data.Successful inventory management has to do with balancing the cost of keeping inventory with the benefits gained from inventory. Some of the reasons for inventory management include (Hedrick, 2003)Obtaining lower prices by purchasing products in bulkKeeping stock low just enough to meet demand and avoid excess inventoryMaintaining a wide range of stockIncreasing inventory turnover or return on investmentHaving adequate inventory on hand so as to provide reliable customer servicesHowever, the degree of success in addressing these issues varies within the functionality of inventory as well as the type of business.A successful inventory management system will accelerate the process of tracking and removing from inventory those items that needed by customer. This pro cess minimises the lead-time for order fulfilment (Merchantos, 2010).Ideally, in order to avoid late re-order times, inventory software should be able to adjust the order quantity and delivery lead time to match that of the suppliers performance.Future of Inventory Management SystemsDuring the late 1990s, there was a large amount of businesses investing in integrated order and inventory system which were basically designed to reduce the amount of inventories as well as manage stock level (replenish stock). There were a wide range of system consolidation options based on the business needs and financial ability (Gale Group, 2002).However, these stand-alone systems do not integrate well with each other. In 1996, a study by the International Mass Retail tie-in (IMRA), concluded that stand alone warehouse Management System (WMS) for example which perform only various(prenominal) business operations will become obsolete because of their lack of integration well with other systems (Gal e Group, 2002).Presently, organisations can no longer compete effectively in isolation of their suppliers and other entities. The future success of many businesses depends on the co-ordination and co-operation of efforts, thereby making supply Chain management important. JIT and VMI are the two of the philosophies that have been used to update supply chain relationships and management (David, 2004).The trend now in inventory management is to strives to improve not just specific aspect of the supply chain but system-wide (the entire supply chain) efficiency through automatic replenishment programs (ARPs) like the vendor managed inventory (VMI). In this system, the vendors are responsible for inventory replenishment or restocking of inventory for their retailers. They get retailers warehouse or point of sale information and use it to track retailers inventory thereby placing the whole responsibility for inventory management of the shoulders of the vendors (Gale Group, 2002). Popular A utomatic replenishment programs (ARP) includes continuous replenishment planning (CRP) and vendor managed inventory (VMI). CRP and VMI are similar but differ in the sense that VMI also decides what and when to ship. some other widely used ARP is the efficient consumer response (ECR) used within the marketplace industry and quick response (QR) programs which are common in the apparel industry (Daugherty, Myers, Matthew, Autry and Chad, 1999).Future inventory management systems will be able to integrate all business processes for the whole supply chain. Another future development would be the use of RFID with GPRS to track inventory.ANALYSING INVENTORY ADJUSTMENTSInventory Adjustment as the invoke implies is implemented as a stock adjuster with the main objective of synchronising the system with the actual stock on hand.According to Jon Schreibfeder, in a case study with a large food distributor, he stated that the company began a program to achieve effective inventory management. As part of the program, they were cycle counting products and entering inventory valuation reserves as they find any miss match between the quality of a product in their warehouse and the inventory maintained by their computer system (Schreibfeder, 2009). In his analysis, Schreibfeder stated that the company was able to adopt a system that improved their future inventory accuracy that is methods of treatment stock in order to prevent additional stock discrepancies. They did this by conservatively analysing the reasons for inventory adjustments (Schreibfeder, 2009). This I believe was because most inventory adjustments are the result of problems encountered in the normal handling of materials.The reason to make inventory Adjustments are basically the same for most businesses irrespective of the systems and operative methodologies they are using but the way these inventory adjustments are made will affect the inventory cost differently. The main reasons why inventory adjustments are required are (Schreibfeder, 2009)Some of the products in inventory are damaged or spoiled and therefore cannot be soldMaterial is missing from inventoryProduct in inventory might be out-dated or cannot be sold because it has been in inventory for too longMore products available in the inventory than is recorded in the systemThe remaining inventory in stock is less than the quantity a customer will normally buySome inventory management system like FoodConnex implement inventory adjustment modules. According to FoodConnex, inventory adjustment can be categorized as follows (Solutions, 2009)Stock Quantity Adjustments as a result of spoilage, damage, theft, samples. These are adjustments made when stock in a store or warehouse is removed from the warehouse or store for a known reason (Solutions, 2009).Quality Adjustment due to a Receiving Error. The adjustments are made when the quantity entered as received into the system was incorrect. This will result in the re-calculation of the av erage cost of that item (Solutions, 2009).Cost Adjustment due to a Receiving Error when the cost of an item is entered incorrectly this will require inventory adjustment. This will also cause the average cost of the item to be re-calculated (Solutions, 2009).Based on the information presented, every inventory adjustment should be considered as an opportunity for businesses to improve which can result to greater corporate profitability.Challenges of Inventory management systemsSeveral inventory management systems now include many new features designed to help distributors effectively manage their inventory. However, after implementing such systems, many businesses still bear to face the same challenges they experience with their old system. These challenges include (Schreibfeder, 2000)Stock-out and lost salesInaccurate On-hand and available-for-sale quantities in their systems disappointing return on investments from inventory