Read Cerfully- ONLY MBA , INFORMATION SYSTEM, COMPUTER SCIENCE, BUSINESS background Message me please

2015 Inventory Management System Proposal For By A&G Associates Composed of Austin Garrett and Danny Arevalo Inventory Management System | A&G Associates Table of Contents Executive Summary ................................ ................................ ................................ ................................ ....... 3 Purpose: ................................ ................................ ................................ ................................ .................... 4 Case Background ................................ ................................ ................................ ................................ ........... 5 Company Information ................................ ................................ ................................ ............................... 3 Background of the Company ................................ ................................ ................................ .................... 3 Project Plan ................................ ................................ ................................ ................................ ................... 5 Business Problem ................................ ................................ ................................ ................................ ...... 6 Problem Statement Matrix ................................ ................................ ................................ ....................... 7 Problem, Opportunities, Objectives and Constraints Matrix: ................................ ................................ .. 8 Project Scope ................................ ................................ ................................ ................................ ............ 9 System Objectives ................................ ................................ ................................ ................................ ... 10 Proposition and Justification ................................ ................................ ................................ ................... 11 System Modeling ................................ ................................ ................................ ................................ ........ 13 Process Modeling ................................ ................................ ................................ ................................ .... 14 Logical for Current System ................................ ................................ ................................ .................. 14 Proposed System Outline for Inventory Management @ Anodizing Industries ................................ . 20 Proposed System Outline for Inventory Management @ Anodizing Industries ................................ . 27 Data Modeling ................................ ................................ ................................ ................................ ........ 34 Entity Relationship Diagra m ................................ ................................ ................................ .............. 34 Data Dictionary ................................ ................................ ................................ ................................ ... 35 Candidate Tech Solutions ................................ ................................ ................................ ............................ 37 Candidate Systems - Solutions Matrix ................................ ................................ ................................ .... 38 Feasibility Analysis ................................ ................................ ................................ ................................ ...... 39 TOES Analy sis. ................................ ................................ ................................ ................................ ........ 40 Candidate Solution 1: inFlow Inventory Management System ................................ ............................ 40 Candidate Solution 2: Microsoft Access ................................ ................................ ................................ 41 Feasibility Analysis Matrix ................................ ................................ ................................ ..................... 44 Cost Benefit Analysis and Return on Investment ................................ ................................ ....................... 45 Candidate 1 inFlow Inventory Management System ................................ ................................ ............ 46 Candidate 2 Custom System using Microsoft Access ................................ ................................ ............ 50 Critical Success Factors ................................ ................................ ................................ ............................... 53 Risk Management ................................ ................................ ................................ ................................ ....... 54 Inventory Management System | A&G Associates Proposed Solution ................................ ................................ ................................ ................................ ....... 55 System Design ................................ ................................ ................................ ................................ ............. 57 Input ................................ ................................ ................................ ................................ ....................... 58 Output ................................ ................................ ................................ ................................ .................... 58 Hardware and Software ................................ ................................ ................................ ....................... 58 Software ................................ ................................ ................................ ................................ .................. 59 System Interface ................................ ................................ ................................ ................................ ..... 60 Implementation Schedule ................................ ................................ ................................ ........................... 62 Implementation Schedule ................................ ................................ ................................ ...................... 63 Gant t Chart ................................ ................................ ................................ ................................ ............. 63 PERT Chart ................................ ................................ ................................ ................................ ............... 64 Conversion Plan ................................ ................................ ................................ ................................ ...... 65 Recommendations ................................ ................................ ................................ ................................ ...... 66 Presentation ................................ ................................ ................................ ................................ ................ 68 Inventory Management System | A&G Associates Executive Summary Inventory Management System | A&G Associates Purpose: To implement an inventory management system that will store and update inventory, track the location of each product, and manage the inventory reorder point for Anodizing Industries. As requested by Anodizing Industries, we will replace the curren t file processing system that Anodizing Industries is utilizing, which is outdated by today’s standards and is causing inventory related problems within the organization. The proposed system will provide enormous benefits to the performance of Anodizing In dustries as a whole, and will continue to provide benefits as the company continues to grow and expand. After in depth research and analysis, we at A&G Associates have provided two solutions that would benefit Anodizing Industries. The first possible solut ion is a commercial off -the -shelf software (COTS) called inFlow. Our second possible solution is a custom software that will be built from scratch using Microsoft Access. Both solutions will fix the main problem of Anodizing Industries, but both have diffe rent costs and benefits. The first proposed solution , inFlow, will fulfill the client’s requirements for the most part. The system can record and update inventory, and keep track of the inventory reorder point. However, as it is a COTS, it cannot be easily customized to fulfill specific needs of the company. As mentioned by our clients at Anodizing Industries, the ability to track physical storage within the warehouse is a necessary feature. This system cannot accomplish this task, however, the convenience and practicality of using a COTS should not be overlooked. A benefit of using a COTS is that it is already built so it can implemented almost instantly, as opposed to a custom built system which take time develop. The second proposed solution is a handmad e system built from scratch using Microsoft Access. As this is handmade software, it is fully customizable and able to meet the needs of Anodizing Industries. It will be able to record and update inventory, keep track of the inventory reorder point and tra ck physical storage within the warehouse. The system will create a designated storage system that will notify the employee of the exact location of a particular item. A benefit of this solution is that it better meets the needs of the company because of t he ability to customize any feature that is desired. It would be made with an easy to use interface that will make it as easy as possible for employees to use. We at A&G Associates have decided for Anodizing Industries to implement the custom made system. This system will be completed in less than 17 weeks and will cost around $19,863 with a return on investment of 168.84%. Although it is evident that the COTS software was a better buy ($10,277 with a ROI of 419.27% but has a limited amount of storage inve ntory in the software’s could), we have decided to elect this solution since the company is exampling by the year 2018.

Therefore, this system will not only be able to handle a surge of inventory but, it will also allow the user to modify the system if any issues where to arise in the future location. Inventory Management System | A&G Associates Case Background Inventory Management System | A&G Associates Page 3 of 71 Company Information Anodizing Industries 5222 Alhambra Avenue Los Angeles CA, 90032 323 -227 -4916 Background of the Company Anodizing Industries has been serving its unique customers since 1978. The three owners/partners who compose of Eugene Golling, Sebastian Golling and Gabriel Varidi came together from a small town in Hungary an d achieved the American dream. Their vision fo r altering all sorts of metal was to create, visualize, and implement individual’s needs with the process of anodizing. Anodizing is the process of increasing the thickness of a metals oxide layer which then the metal can be fabricated and dipped (color or chrome, copper and mineral plates) . The process is very tedious work , but with the right tools and the right employees, customers are always pleased with their finished products. Anodizing Industries Services In Anodizing Industries, the main services tha t they provide is the cleaning and the oxidation of metal. The process includes dipping the customers design into a variety of chemical processes using electrolytic passivation that acts a chemical agent for finishing the product. However, due to the fact that this process takes a significant amount of time and labor , Anodizing Industries primary works with individuals , independent contractors and in some rare occasions, governmental contracts primarily the arms forces . One key aspect that Anodizing Industries is known for is that no design, or metal choosing will be turned down in order to achieve the customer’s final product. Inventory Management System | A&G Associates Page 4 of 71 Anodizing Industries Problem Due to the fact that the company has had its doors open for 37 years, the company has not adapte d to today’s technological standards. Therefore, Anodizing Industries is currently running a file process ing system within its inventory sector. This process is causing problems with not only the customers , but also with the employees who do not know the l ocation of the requested inventory. Inventory Management System | A&G Associates Page 5 of 71 Project Plan Inventory Management System | A&G Associates Page 6 of 71 Business Problem Thanks to the tour provided by Gabriel Varady, we established that Anodizing Industries is a small business with two different locations. The main location is where the offices and the staff are located in which they process the orders and attend the customers. In the second location is where the anodizing tanks and processes occur (warehous e). Therefore, by having two locations one mile away from each other, it is crucial for both locations to have the accurate information of inventory within the company. Since providi ng customer service efficiently and processing orders correctly is crucial in businesses , we at A&G Associates have recommend Anodizing Industries to implement an information system. While an alyzing the inventory process at Anodizing Industries, we came to the conclusion that this company needs an accurate count of the inventory that it currently possesses. By identifying the inventory on hand, it allows for the company to reorder stock when necessary. As of today, this comp any is currently using a file processing system, in which today’s standar d is out of date. By continuing to use this system, a lot of problems arise , which can include but are not limited to missing paperwork , parts, and over use of inventory by the employ ees. Problems: 1. When a customer submits an invoice of parts that need to be anodized, the front office has no real time count of the parts that are stored in the warehouse 2. As the invoices arrive at the warehouse, a physical count has to be conducted before allowing the front to approve the order. 3. Due to using a file processing system, human errors within inventory count occur which misleads the front office when approving orders. 4. No real way of determining when Anodizing I ndustries should reorder inventory until that specific item runs out. 5. No real system of storing the inventory by employees efficiently when processing the order. Inventory Management System | A&G Associates Page 7 of 71 Problem Statement Matrix Statement of Problem, Opportunity, and Directive Urgency Visibility Annual Benefits Priority Proposed So lution No real time count of the inventory stored in the warehouse. High High $$$ 1 Install a system that will store and update inventory as frequently as needed Physical count of inventory High High $$$ 1 Eliminate the need a for physical count when orders are placed File processing system is currently being used to count inventory High High $$$ 1 Convert file processing system into the a new system that will be exclusively digital Inadequate storage of inventory throughout the warehouse Moderate Moderate $$ 2 Install a feature in the new system that will include a location of each product per bay. A barcode system will be implemented No method to determining a reorder point of inventory High High $$$ 1 The new system will include an inventory reo rder point that will link to the supplier Inventory Management System | A&G Associates Page 8 of 71 Problem, Opportunities, Objectives and Constraints Matrix: Cause and Effect Analysis System Improvement Objectives Problem or Opportunity Cause and Effect System Objectives System Constraints File processing system FPS is causing redundant data in the front office and warehouse Eliminate FPS with new digital system A small amount of time to update the inventory level Opportunity to increase customer service By having an accurate count of inventory, customers will not have to wait for approval Implement an efficient way to provide customer service in real time The system will need to be updated regularly incase future orders increase Physical count of inventory By using a file processing sys tem, counting inventory by multiple warehouse employees will cause data inconsistence and redundancy Implement within the new system a tool that records and updates inventory by each employee with a time stamp Since Anodizing Industries employs warehouse e mployees frequently, an Employee ID will need to be implemented. Opportunity to increase foot traffic and online orders Due to accurate inventory, customers might do business somewhere which creates a decrease of revenue for the company The system will ne ed to receive and record online orders Due to online orders, determining peak hours will need to be addressed by the workers Inadequate storage of inventory within the warehouse By not having an adequate system of recording inventory placement, the wareho use is fluttered with parts all over the warehouse Implement a barcode system within the database that will show the location of the product as well as the bay number and count Due to the number of parts stored in the warehouse, the necessary equipment wil l need to be suitable to handle storage data. Employee awareness of location of each part will also be a constraint. Reorder point of inventory does not exit By not having a reorder point system, many customers are turned down due to the lack of inventory Implement within the system should notify either the supplier or the employee of when a part is low on inventory Having a direct line with a supplier could be a constraint due to competitor prices Inventory Management System | A&G Associates Page 9 of 71 Project Scope The purpose of this project is to show Anodizing Industries how an efficient system can improve and adequate count the inventory at hand. Therefore, A&G Associates will be conducting an in - depth analysis of the current inventory process to determine the right system in which to implement. A&G Associates will propose two candidate solutions in which they will both show the cost and benefits of the proposal that will benefit Anodizing Industries. Now, due to the fact that Anodizing Industries have been serving customers since 1978, we anticipate this newly system to affect some aspects when it comes to customer records. However, by creating a digital processi ng system environment, we at A&G Associates have determine the likelihood of this system to cause an increase of service to customers by:  Eliminating the current file processing system and converting it to a digital format ,  Having an adequate process es of record ing all inventory stored within the warehouse ,  Efficient and precise information of the inventory recorded sent from the warehouse to the front office in order to facilitate customer orders ,  Creating an inventory reorder point when inventory is running low and lastly ,  Facilitating inventory tracking. In addition, due to the system being fully digital, updating the system and databases will be done primary by the user unless specified otherwise. However, the main task for us at A&G is to create a solution that w ill benefit Anodizing Industries as well as choosing a system that will be cost efficient and most importantly having a simple interface for the warehouse employees to use. Inventory Management System | A&G Associates Page 10 of 71 System Objectives PIECES Framework for System Improvements The PIECES framework which i s referred to Performance, Information, Economy, Control and Security, Efficiency and Service, will be used to support and identify operational issues in which the company is currently facing as well as how to implement the newly system with a sense of urgency. Requirement Type Description Performance The digital database will allow warehouse employees to count and record inventory as it is arrives and processed. Information The informat ion that the system will store will be available to both the front office and the warehouse instantaneous . Economy Savings in cost when reordering inventory to the elimination of using paper inventory files. Control and Security In the case of losing communication to and from both loc ations, an established internet connection will be needed. If the internet connection is lost, a secondary protocol will be implemented on the system in which the system will continue and store data and update until the connection is established. Efficien cy The efficiency between the front office and the warehouse will increase due to both fronts knowing the exact count of inventory in real time . Service The use of this newly system will benefit customer service and determine when the completed order will be delivered. Inventory Management System | A&G Associates Page 11 of 71 Proposition and Justification Propos ition We at A&G are proposing for Anodizing Industries to implement a new system that will not only increase managing its current inventory , but efficiently and effectively storing the inventory. When we first evaluated the company, we determine that the current system w as out of date. The file processing system determined that many customers were b eing turned down due to the fact that this company had no idea of the inventory that it had on hand, due to the use of this system.

Therefore, by implementing the proposed system that we at A&G have proposed will not only increase customer awareness, it will also improve inventory management. The proposed system will capture and record its current inventory as well as new inventory that is being ordered. In additio n, t he system will also create and or implement storage bay locations, increase accurate inventory count, set a reorder point of inventory and s ustain updated information available for customers who place orders online. As the business continues to grow an d keeps its doors open to customers, changes need to be implemented in order for Anodizing Industr ies to remain at the top of its competitors. Choice We have compared and evaluated multiple propositions of the type o f system that will be implemented . Out o f all the possible propositions and contenders that would be suitable for Anodizing Industries , we have decided on two possible candidates that will fulfill the client’s needs . The processed that we used to determine these two propositions were (1) how eff ectively the system was going operate, (2) cost and benefits of using the system, (3) we had to make sure that the system was easy to use, and lastly (4) due to the company having satisfied repeat customers thro ugh the years, the company needed a system th at could co nvert its current file system into the new system correctly. Inventory Management System | A&G Associates Page 12 of 71 Justification By implementing our proposed system, the efficiency and functionality of Anodizing Industries will increase exponentially, as well as cater to customers who place orders online. Continuing to use an outdated and subpar processing system would be detrimenta l to the ability to compete with other competitive companies in the industry. The practicality of using a file processing system has since long passed, the future is in the digitization and automation of this task. The inventory management system that we at A&G Associated have proposed, will fix current inventory problems, as well as increase the overall efficiency of the current processes at Anodizing Industries. It will also accommodate growth and expansion within the company with ease. Overall, the just ification of using our proposed system is that the benefits heavily outweighs the costs . Inventory Management System | A&G Associates Page 13 of 71 System Modeling Inventory Management System | A&G Associates Page 14 of 71 Process Modeling Logical for Current System System: Inventory Mana gement System @ Anodizing Industries Entities : Vendor Input Output - Inventory - Order Request - Invoice -Payment Task/Process Data Store: 1.1 Receive Vendor R equest D1: Order File 1.2. Physically Count Inventory D2: General Ledger 1.3. Submit Order 2.1 Receive Shipment 2.2 Receive Vendor Invoice 2.3 Send Payment 3.1 File Invoice 3.2 Update General Ledger 1.0 Inventory 2.0 Receiving 3.0 Update Inventory Management System | A&G Associates Page 15 of 71 CONTEXT DIAGRAM OF INVENTORY SYSTEM FOR ANODIZING INDUSTRIES VENDOR 0 Inventory Management System Invoice Payment Order Request Inventory Request Inventory Management System | A&G Associates Page 16 of 71 LEVEL – 0 DFD OF INVENTORY MANAGEMENT @ ANODIZING INDUSTRIES VENDOR 1.0 2.0 3.0 Inventory Receiving Update D2 General Ledger D1 Order File Update Order Information New Inventory Requested Payment Update Transaction Information Inventory Management System | A&G Associates Page 17 of 71 LEVEL -1 DFD FOR 1.0 INVENTORY OF INVENTORY SYSTEM @ ANODIZING INDUSTRIES (2.0) VENDOR 1.3 Submit Order 1.2 Physical Inventory count 1.1 Receive Vendor Request Order Information Order Information Order Order Form Update D1 Oder File Inventory Management System | A&G Associates Page 18 of 71 LEVEL -1 DFD FOR RECEIVING @ ANODIZING INDUSTRIES VENDOR 2.2 2.3 2.1 Vendor Invoice Send Payment Receive Shipment D2 General Ledger Payment Order Shipment Information Process Invoice Information (3.0) Inventory Management System | A&G Associates Page 19 of 71 LEVEL – 1 DFD FOR 3.0 UPDATE @ ANODIZING INDUSTRIES 3.1 File Invoice (2.0) 3.2 Update General Ledger D2 General Ledger Invoice Invoice Copy Inventory Management System | A&G Associates Page 20 of 71 Proposed System Outline for Inventory Management @ Anodizing Industries (Logical ) System: Inventory Management System @ Anodizing Industries Entities : Vendor Input Output - Inventory Request - Order Request - Invoice -Payment Task/Process Data Store: 1.1 Receive Vendor Request D1: Order File 1.2 Check Inventory Status D2: General Ledger 1.3 Create Order D3: Inventory File 1.4 Submit Order D4: Inventory Status 1.5 Update Vendor File D5: Vendor File 2.1 Receive Shipment 2.2 Update Order File 2.3 Update Inventory File 2.4 Update Inventory Status 3.1 Receive Vendor Invoice 3.2 Send Payment 3.3 File/Store Invoice 3.4 Update General Ledger 4.1 Create Inventory Bay 4.2 Update Inventory Status 1.0 Inventory 2.0 Receiving 3.0 Payment 4.0 Inventory Bay Inventory Management System | A&G Associates Page 21 of 71 CONTEXT DIAGRAM OF INVENTORY SYSTEM FOR ANODIZING INDUSTRIES VENDOR 0 Inventory Management System Invoice Payment Order Request Inventory Request Inventory Management System | A&G Associates Page 22 of 71 LEVEL – 0 DFD FOR INVENTORY M ANAGEMENT @ ANODIZING INDUSTRIE S VENDOR 1.0 2.0 3.0 Inventory Receiving Payment Inventory Request Order Shipment Payment Invoice 4.0 Inventory Bay D3 Inventory File D4 Inventory Status D4 Inventory Status D1 Order File Update Update D3 Inventory File D4 Inventory Status D5 Vendor File D1 Order File Update Update Update D2 General Ledger Store Update Update Inventory Management System | A&G Associates Page 23 of 71 LEVEL -1 DFD FOR 1.0 INVENTORY OF INVENTORY SYSTEM @ ANODIZING INDUSTRIES VENDOR 1.3 Create Order 1.2 Inventory Status 1.1 Receive Vendor Request Order Form 1.4 Submit Order 1.5 Update Vendor File D4 Inventory Status D1 Order File D5 Vendor File Update Update Status Form Form Form Form Inventory Management System | A&G Associates Page 24 of 71 LEVEL -1 DFD FOR 2.0 RECEIVING OF INVENTORY SYSTEM @ ANODIZING INDUSTRIES VENDOR 2.2 2.3 2.1 Update Order File Update Inventory File Receive Shipment Order Shipment Packing Slip Packing Slip (3.0) 2.4 Update Inventory Status D1 Order File D3 Inventory File D4 Inventory Status Information Order File Inventory Management System | A&G Associates Page 25 of 71 LEVEL -1 DFD FOR 3.0 PAYMENT OF INVENTORY SYSTEM @ ANODIZING INDUSTRIES VENDOR 3.4 Update General Ledger 3.3 Store Invoice Receive Vendor Invoice Send Payment 3.1 3.2 (4.0) Invoic e Invoice Information Payment Information Copy of Invoice Payment D3 Inventory File D2 General Ledger Update Update Inventory Management System | A&G Associates Page 26 of 71 LEVEL -1 DFD FOR 4.0 INVENTORY BAY OF INVENTORY SYSTEM @ ANODIZING INDUSTRIES 4.1 Create Inventory Bay 4.2 Update Inventory Status D5 Vendor File D3 Inventory File D4 Inventory Status Update Inventory Management System | A&G Associates Page 27 of 71 Proposed System Outline for Inventory Management @ Anodizing Industries (Physical ) System: Inventory Management System @ Anodizing Industries Entities : Vendor Input Output - Inventory Request - Order Request - Invoice -Payment Task/Process Data Store: 1.1 Receive Vendor Request D1: Order File 1.2 Check Inventory Status D2: General Ledger 1.3 Create Order D3: Inventory File 1.4 Submit Order D4: Inventory Status 1.5 Update Vendor File D5: Vendor File 2.1 Receive Shipment 2.2 Update Order File 2.3 Update Inventory File 2.4 Update Inventory Status 3.1 Receive Vendor Invoice 3.2 Send Payment 3.3 File/Store Invoice 3.4 Update General Ledger 4.1 Create Inventory Bay 4.2 Update Inventory Status 1.0 Inventory 2.0 Receiving 3.0 Payment 4.0 Inventory Bay Inventory Management System | A&G Associates Page 28 of 71 PHYSICAL CONTEXT DIAGRAM OF INVENTORY SYSTEM FOR ANODIZING INDUSTRIES VENDOR 0 Inventory Management System (Database System) Electronic Form : Inventory Request Electronic Form : Invoice Check : Payment Electronic Form : Order Request Inventory Management System | A&G Associates Page 29 of 71 LEVEL – 0 PHYSICAL DFD FOR INVENTORY MANAGEMENT @ ANODIZING INDUSTRIES VENDOR 1.0 2.0 3.0 Inventory (Back Office) Receiving (Back Office) Payment (Front Office) Electronic Form:

Inventory Request Electronic Form: Order Product:

Shipment Check : Payment Form: Invoice 4.0 Inventory Bay (Back Office) D3 SQL Server: ______ Inventory File D4 SQL Server: ______ Inventory …………. Status D4 SQL Server:

Inventory Status D1 SQL Server: …… Order File Update Update order D3 SQL Server: ______ Inventory File D4 SQL Server: - ______ Inventory Status D5 SQL Server: …………. Vendor File D1 SQL Server: ……….. Order File Update Order Update Inventory Update Inventor y D2 SQL Server: ______ General Ledger Update : Store Update : G/L Update : Status Inventory Management System | A&G Associates Page 30 of 71 LEVEL -1 PHYSICAL DFD FOR 1.0 INVENTORY OF INVENTORY SYSTEM @ ANODIZING INDUSTRIES VENDOR 1.3 Create Order 1.2 Inventory Status 1.1 Receive Vendor Request Electronic Form: Order Form 1.4 Submit Order 1.5 Update Vendor File D4 SQL Server: ______ Inventory Status D1 SQL Server: ……….. Order File D5 SQL Server: Vendor File Update:

Vendor Update:

Order Read: Status Form Form Form Form Inventory Management System | A&G Associates Page 31 of 71 LEVEL -1 PHYSICAL DFD FOR 2.0 RECEIVING OF INVENTORY SYSTEM @ ANODIZING INDUSTRIES VENDOR 2.2 2.3 2.1 Update Order File Update Inventory File Receive Shipment Form: Order Shipment Packing Slip Packing Slip (3.0) 2.4 Update Inventory Status D1 SQL Server: Order File D3 SQL Server: Inventory File D4 SQL Server: Inventory Status Information Update:

Oder File Inventory Management System | A&G Associates Page 32 of 71 LEVEL -1 PHYSICAL DFD FOR 3.0 PAYMENT OF INVENTORY SYSTEM @ ANODIZING INDUSTRIES VENDOR 3.4 Update General Ledger 3.3 Store Invoice Receive Vendor Invoice Send Payment 3.1 3.2 (4.0) Electronic Form: Invoice Invoice Information Payment Information Copy of Invoice Check:

Payment D3 SQL Server: Inventory File D2 SQL Server: General Ledger Update:

Inventory Update:

G/L Inventory Management System | A&G Associates Page 33 of 71 LEVEL -1 PHYSICAL DFD FOR 4.0 INVENTORY BAY OF INVENTORY SYSTEM @ ANODIZING INDUSTRIES 4.1 Create Inventory Bay 4.2 Update Inventory Status D5 SQL Server: Vendor File D3 SQL Server: Inventory File D4 SQL Server: Inventory Status Read: Vendor Information Read : Inventory Information Update:

Inventory Status Inventory Management System | A&G Associates Page 34 of 71 Data Modeling Entity Relationship Diagram Inventory Management System | A&G Associates Page 35 of 71 Data Dictionary VENDOR _Table Attribute Type Size Description Authorization Vendor_ID Numeric 10 Identifier Manager Vendor_Name Text 15 Vendors Name Manager Vendor_Address Text 20 Vendors Address Manager Vendor_Phone Numeric xxx -xxx -xxxx Vendors Phone Number Manager Product_ID Numeric 6 Identifier Manager INVENTORY _Table Attribute Type Size Description Authorization Inventory_ID Numeric 10 Identifier Inventory User Inventory_Name Text 25 Inventory Name Inventory User Inventory_Description Text 25 Description of Inventory Inventory User Inventory_Quantity Numeric xxxxx Quantity on Hand Inventory User InventoryBay_Number Text & Number 4 AA -XX Inventory User Product_ID Numeric 6 FK Identifier Manager PRODUCT _T able Attribute Type Size Description Authorization Product_ID Numeric 6 Identifier Manager Product_Code Numeric 9 Bar Code of Product Manager Product_Name Text 15 Name of Product Manager Product_Description Text 30 Description of Product Manager Vendor_ID Numeric 10 Identifier Manager Invoice_Number ORDER _Table Attribute Type Size Description Authorization Order_ID Numeric 6 Identifier Product Manager Inventory Management System | A&G Associates Page 36 of 71 Order_Date Date MM/DD/YYYY Date of order placed Product Manager Order_Quantity Numeric Xxxxx Number of quantity shipped Product Manager Order_Shipped Date MM/DD/YY Date the order shipped Product Manager Vendor_ID Numeric 10 FK Identifier Manager GENERAL LEDGER _Table Attribute Type Size Description Authorization GeneralLedger_Number Numeric 7 Identifier Finance Manager Check_Number Numeric 5 Check Number Finance Manager Issue_Date Date MM/DD/YYYY Date Issued Finance Manager Payment_Received Date MM/DD/YYYY Received Payment Finance Manager Invoice_Number Numeric 8 FK Identifier Manager INVOICE_Table Attribute Type Size Description Authorization Invoice_Number Numeric 8 Identifier Manager Invoice_Date Date MM/DD/YYYY Date of Invoice Manager Invoice_Balance Currency 6 Balance of Invoice Manager Payment_Method Currency $xxxxxxx.xx Check Manager Product_ID Numeric 6 FK Identifier Manager INVENTORY_BAY Table Attribute Type Size Description Authorization Invoice _Number Numeric 8 Identifier Manager Bay_Location Text & Number 00AA00 Location of Bay Warehouse Manager Quantity_On_Hand Numeric Xxxxxx Quantity on Hand Warehouse Manager Reorder_Point Numeric 20 Low Inventory reorder Point Warehouse Manager Product_ID Numeric 6 FK Identifier Manager Inventory Management System | A&G Associates Page 37 of 71 Candidate Tech Solutions Inventory Management System | A&G Associates Page 38 of 71 We , at A&G Associates, have been searching for alternative solutions for Anodizing Industries to implement. By identifying more than one candidate, Anodizing Industries can compare and contrast the benefits, the type of software that they will be needing as well as input/output devices. The two possible candidate solutions that we at A&G Associates have chosen are inFlow , whi ch is a commercial off -the -self software (COTS) and a custom built database built from scratch by using Microsoft Access. To determine the characteristic of both candidates, we have created a Candidate Systems -Solution Matrix . Candidate Systems - Solutions Matrix Characteristics Candidate 1 - inFlow Candidate 2 - Microsoft Access Portion of System - inFlow will allow for the warehouse department to input current and new inventory flow. - Microsoft Access will be able capture all the requirements that Anodizing Industries needs. Benefits - Online Ordering - Input Inventory in Digital Form - Barcoding - Create Invoices - Update Vendors - Sales and Purchase Orders - The system will be able to be online and offline - Fully customizable - Onetime fee - Ea sy to use - No modifying preset software Servers and Workstations - Main Central Rack Server - 3 workstations . - Main Central Rack Server - 3 Workstations Software tools needed - inFlow license software - SQL Server - Microsoft OS - Internet Connection - Visual Basics - Internet Explorer - Microsoft Access Toolkit Application Software Packaged Solution Custom Built Solution Method of Data Processing Client Client Output Devices and Implications - WPL304 Desktop Barcode Printer - C2660dn Printer (2) - Monitor - WPL304 Desktop Barcode Printer Station (2) - C2660dn Printer (2) - Monitor Input Devices and Implications - Keyboard - Mouse - (4) DT90 Mobile Computer - Keyboard - Mouse - (4) DT90 Mobile Computer Storage Devices and Implications - Software Cloud Storage - 1TB Internal Server Storage - 500 GB Solid State Drive - Secured Cloud Storage Inventory Management System | A&G Associates Page 39 of 71 Feasibility Analysis Inventory Management System | A&G Associates Page 40 of 71 TOES Analysis. In order to eliminate any biases among choosing candidate solutions, we must first analyze each candidate solutions feasibility. In order to do that , we have implanted TOES analysis in which we can then eliminate any premature decision makings when choosing the preferred candidate.

In addition, TOES analysis stands for Technical, Operational, Economic and Sche dule Feasibility. Candidate Solution 1: inFlow Inventory Management System Technical Feasibility This system has been highly reco mmended by current users who maintain a small to medium level of inventory. The platform has been designed to meet the needs of all clients in mind which has created multiple drawbacks. For example, due to the fact that inFlow is a COTS system, there is no way of customizing the syst em. If there needs to be any customization done or if th ere is any questions regarding toward the system, then an appointment has to be set in order for a technician to come out and alter it. This creates not only a loss of time but also accrues an extra expense. This program is based on a web based client system in which they do offer a 24/7 online support in case any problems arise which is a good service to have . Operational Feasibility inFlow ’s inventory management system will fulfill the client’s requirements in many ways. For example, this system will record and update all inventory that is stored in the system as well as create a low inventory reorder point. In addition, it will also create and update any vendor ’s information along with generati ng graphical displays of inventory levels. However, due to the fact that Anodizing Industries is specifically requiring some sort of barcode location for physical storage within the wareh ouse, this program does not offer that option. This is due to the lac k of Inventory Management System | A&G Associates Page 41 of 71 not being able to alter the program. Other than that one requirement, this program does me et the rest of the requirements of Anodizing Industries. Economic Feasibility Since Anodizing Industries carri es hundreds of inventory levels ranging from small (bolts) to large items (sheet metal designs), inFlow charges primary on the amount of inventory the client has. Due to the amount of inventory, the best edition for this company is the Premium Edition , a onetime price of $799 per license. There is also an optional mainten ance plan that cost $199 annually . This maintenance plan keeps the system up to date which we highly recommend of purchasing. For every year that passes, $199 is being charged automatically. This cost can increase dramatically as the years accumulate. The devices that the system will be using are; three basic workstations ( which include monitor, keyboard, mouse ), one printer , and a barcode scanner with printer combo. This complete package cost prima rily around $10,277 . Schedule Feasibility inFlow is a web based software system, so after the client downloads the software, it can be used right away. There is no need of waiting for a long period of time to use the system. Candidate Solution 2: Microsoft Access Technical Feasibility This software package was developed to accommodate quick learners just like the employees at Anodizing Industries. Therefore, this candidate solution was chosen as a top contender. By using Microsoft Access as its main development platform, we are able to build an d construct the system from scr atch in which we can then incorporate all the requirements that are needed for the inventory management system. This system will allow to not only store current and incoming Inventory Management System | A&G Associates Page 42 of 71 inventory, but it wil l also create a design ated storage system that will notify the employee of the exact location of that particular item. In addition, this system environment will be created as easy as possible so that all employees will be able to access and use it without any hesitation.

Theref ore, the system will eliminate any complex technical assistance. However, if any assistance is needed to either operate or modify the system, then A&G Associate s will more than happy to answer any questions that may arise in the near future . Operational Feasibility By building a system from the bottom up, we are able to capture all of the inventory problems that Anodizing Industries is facing. Due to the lack of using a physical file processing system, redundant and outdated information is currently being used to track accurate inventory. Therefore, by using this proposed system, we can eliminate the use of paper and store all of the inventory information onto a database system. This system will allow to input any information of the current Inventory Manag ement System as well as input new information. In addition, this will facilitate the task of not only employees determining when a specific inventory is low but also ease clients when ordering products to be anodized. There will no longer be customer s that have to wait to determine if the business has the necessary amount of inventory on hand. This proposed solution will also facilitate the use of printing reports when ordering new inventory. All of these operational tasks and more can be achieved by using this system. Economic Feasibility For this proposed company, we at A&G Asso ciates are pricing the system for a onetime fee of $19,863 . This will also include a onetime fee of $109 for the software Microsoft Access per user/license (only one needed). The i nput and output devices that will be needed include three workstations ( which include a simple monitor, keyboard and mouse), one rack server, two Inventory Management System | A&G Associates Page 43 of 71 printers, and a minimum of two hand held inventory scanners with printers. Although the price seems high, all of the items that we have mentioned and described below, are up to date on today’s technological standards which means that no future upgrade will be necessary within 5 to 6 years. In addition, if the system requires any sort of technical or database alter ations, a $40 -$50 fee will be applied if a system designer is required. This price is negotiable depending on the severity of the change. Schedule Feasibility In order to create this system, we are proposing a 15 day work schedule in which this system will be started and completed by the due date. Within those 15 days our main tasks include; sitting down with the client and listening to their needs, drawing up a blueprint of the proposed system, communicate and work with a system developer (in house) to start the process, the developer wi ll test the system , and lastly implement the system. After th e system has been approved by the developer we will implement the software and run the system as a beta platform . By doing this, it will allow us to determine if there needs to be any necessary changes. W e will spend two full days running alpha and beta testing’s thoroughly. If any extra day is needed, we will not charge the client for that additional day. Our goal is to have this system implemented at full cap acity. It should be noted that 15 days should be a reasonable time period to create this system. Inventory Management System | A&G Associates Page 44 of 71 Feasibility Analysis Matrix Feasibility Criteria Weight Candidate 1 Candidate 2 Technical Feasibility 20% - Must invest in the appropriate package system depending on the amount of inventory at hand. - Easy to use since its developed for non - technical efficient users - Must require a system that has new components since this candidate runs primarily runs of maximum CPU speed. - Requires the same components as Candidate two. -The current staff is not familiar with similar systems as this one, therefore the need of new hardware is required. For example the use of inventory tracking equipment will be needed which include hand held computer with printer combo, a server, and workstations. -Required to conduct small training session for the system. Score: 85 Score: 100 Operational Feasibility 40% - COTS system which will not be able to modify its contents as easily as Candidate two. - Supports some operational functions but not all of the required. - Since the system is built from scratch it is easily able to accommodate any changes. -Fully supports all operational functions that is needed and desired in the future. Score: 75 Score: 95 Economic Feasibility 30% - Cost to Develop:

Approximately $10,277 - Payback Period: Less than 1 year - Net Present Value:

Approximately $221,360.15 - See Page: - Cost to Develop:

Approximately $19,863 - Payback Period: Less than 1 year - Net Present Value:

Appr oximately $192,878.50 - See Page: Score: 90 Score: 80 Schedule Feasibility 10% Instantly Less than 3 weeks Score: 95 Score: 85 Ranking 100% 86.75 90 Inventory Management System | A&G Associates Page 45 of 71 Cost Benefit Analysis and Return on Investment Inventory Management System | A&G Associates Page 46 of 71 The implementation of the Cost Benefit A nalysis is used to determine strengths and weaknesses of all possible alternative solutions in regards to software and hardware. In addition, by calculating total implementation costs, we can determine how much the client is going to invest on the new syst em. This allows us to define which candidate solutions are feasible. Return on Investment compares the lifetime profitability of both alternative solutions. By using this method we can calculate the relationship between the amount being invested and the amount received from that initial investment. To calculate the percentage of both Candidate Solutions we used the following formula: (Estimated Lifetime Benefits – Estimated Lifetime Costs) / Estimated Lifetime Costs . Candidate 1 inFlow Inventory Managemen t System Cost Benefit Analysis: InFlow software, being a web based application, has minimal cost during the development phase.

For example, during the development phase, the only costs that the company will incur are purchasing the s oftware directly from t he developer which cost $799 per client, setting up the system at $200 (4 hours @ $50 per hour), and providing a small employee training session for the reduce price of $120. Since the company is currently using a file processing system and their input and output systems are not up to date, we are implementing a new setup of components. This includes 3 workstations that will be located in the clients choosing, a server located in an empty closet (where all the wires will be managed) , and most importantly a pair (4) of mobile pc ’s (inventory scanners) with printer combo that will capture and store the data to the system. However, since this candidate solution is a web based system, there is a $199 software update fee (annually) in which it updates the system with the latest patches and updates. The total de velopment cost amounts to $10,277. Inventory Management System | A&G Associates Page 47 of 71 Return on Investment: The proposed candidate has a return of investment of 419.61% which is more than the proposal of candidate two but has the similar payback period of less than one year . Since this system does not have to involve multiple personnel for developing /altering the system, this causes the return of investment to be high. The projected annual cost savings amounted to $53,400 which represents the effectiveness of the system. For clarification issues, we have de termined to use the same cost saving amount as a base price in order to eliminate any biases among the two candidates. By using this system, the client and the vendor will be able to communicate efficiently as well as provide the necessary documentation fo r potential clients. However, it should be noted that although this candidate solution has a high ROI rate, we should not focus primarily on that primary number since our main goal for the client is to have the best efficient system that is needed to handl e the company’s future tasks. Candidate 1: inFlow Cost Development Costs Personnel: 1 = System Setup ( 4 Hours @ $50 per hour) $200.00 10 = Employee Training ( 1 hour @ 12 per hour) $120.00 Software $799.00 New Hardware & Software 3 = ABS Workstations $1 ,800.00 4 = DT90 Mobile PC and Printer Combo $6,660.00 1 = HP Server $499.00 Software Update $199.00 Total Development Cost $10,27 7.00 Annual Cost Savings $53,400.00 Net Present Value $10,277. 00 Return on Investment 419.61 % Payback Period <1 Year Inventory Management System | A&G Associates Page 48 of 71 Inventory Management System | A&G Associates Page 49 of 71 $(10,277.00) $38,082.71 $82,026.74 $121,980.69 $158,316.97 $191,354.79 $221,360.15 $(50,000.00) $- $50,000.00 $100,000.00 $150,000.00 $200,000.00 $250,000.00 Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Payback Analysis Inventory Management System | A&G Associates Page 50 of 71 Candidate 2 Custom System using Microsoft Access Cost Benefit Analysis: The total development cost for this particular candidate increased due to the fact that we are not using a COTS system. Therefore, more personnel was needed which include a system programmer. In addition, we have included a small employee training program that will teach the employees on how to use the system effectively. The rate for this training is at $12 per hour since the trainin g group consist of only 10 indiv iduals. Since th e company does not have up to date components , we are implementing a newer system that will handle the database efficiently (similar situation as Candidate 1) . This system and hardware package includes new wo rkstations, printers, necessary software and most importantly handheld mobile pc with printer that will capture and store the inventory in the appropriate bay. Therefore, the development cost for this candida te solution totaled to $19, 863. See Chart Below Return on Investment: This proposed candidate has projected a return of investment of 168.84% which is less than candidate one but has the same initial payback period of less than 1 year . The reason why this candidate has a low ROI compared to the previ ous candidate is due to creating a system from scratch. As stated earlier, using a COST system will facilitate the in ventory process but there is little to no chance of altering the software without calling for technical support . The projected annual cost savings was computed to $53,400 which represents how efficiently and effectively the system will capture and store the necessary inventory. Therefore this will allow for vendors to communicate more efficiently with the company as well as providing greater customer service to potential future clients. However, due to the fact that this candidate has so many add -ons during its development phase , which is causing a low ROI, we have considered this candidate as our main impleme ntation for Anodizing Industries. Inventory Management System | A&G Associates Page 51 of 71 Candidate 2: Microsoft Access Cost Development Costs Personnel: 2 System Analysts (100 hours/ea @ $50/hour) $10,000.00 Programmer (Labor = 17Hours *$50 /hour) $675.00 10 = Employee Training ( 1 hour @ 12 /hour) $120.00 New Hardware & Software 3 = ABS Workstations $1,800.00 4 = DT90 Mobile PC and Printer Combo $6,660.00 1 = HP Server $499.00 Microsoft Access Software (per client) $109.00 Software Update $0 Total Development Cost $19,863 .00 Annual Cost Savings $53,400.00 Net Present Value $19,863 .00 Return on Investment 168.84 % Payback Period <1 Year Inventory Management System | A&G Associates Page 52 of 71 $(19,863.00) $25,041.60 $65,433.00 $102,081.80 $135,343.90 $165,524.50 $192,878.50 $(50,000.00) $- $50,000.00 $100,000.00 $150,000.00 $200,000.00 $250,000.00 Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Payback Analysis Inventory Management System | A&G Associates Page 53 of 71 Critical Success Factors In order to determine the most reliable candidate solution for Anodizing Industries to implement, we have created a list of critical success factors. A critical success factor are a set of goals that the system will have to implement effectively in order to be determined as the chosen solution.

In order for these success factors to be implemented, we have must meet the requirements of the clie nt. The first success factor is to have a system that will adapt to the growth of the company. As the company increases, more inventory will be needed which means the system has to be able to capture and store it. The company currently has two location s, but by the year 2018 , it will accrue another facility. Knowing that, the system will have to be able to transfer accurate information among the different sites. The second factor is for the system to have a user interface that ev ery employee will be able to use. Not overcomplicating the system is an important key factor. If by any means the system user interface is complicated , then we should address the issue before investing our full efforts into completing it . In addition, the system user interface should also be created with peace of mind when updating/removing inventory, printing the necessary files for vendors and primarily being able to update the system without relying on the systems automatic updates. The third critical success factor is to have all employees of both locations to start using the system. The use of the file processing system is not efficient especially within inventory management. In addition, the use of paper can be misplaced and or lost w hich can cause data discrepancy. By leaving the legacy system behind and adapting the new system, inventory management will effectively and efficiently be achieved. Inventory Management System | A&G Associates Page 54 of 71 By addressing these three critical success factors, we at A&G Associates are able to fina lize our candidates and decide on the chosen candidate system. Risk Management The use of risk management is to asses, minimize , and most importantly prevent any accidental loss to the business at hand. By doing this procedure, we are able to identify any problem areas and address the issue by reducing or eliminating the risk to the business before it becomes a threat . Area Risk Conditions Risk Consequences Probability Scope Not defining and or updating the scope efficiently and or effectively. Cost but most importantly delaying the schedule of delivery. 10% Employee Resistance Employees are not willing to change/adapt to the new system . Low company morale and high employee turnover . 40% Cost The new system might be too expensive to implement . Drop the new system and continue with using legacy system. 25% Hardware & Software Not being attentive to the new hardware and software in the facility. Damaging the system which can cost money to replace and loss of time due to stoppage of operations. 10% User I nterface A complex user interface might cause problems. Drop/suspend the system. 5% Time Miscalculation of the required time. The biggest factor would be cost since the business at hand is waiting for the system. 15% Inventory Management System | A&G Associates Page 55 of 71 Proposed Solution Inventory Management System | A&G Associates Page 56 of 71 Anodizing Industries has had its doors open for more than 20+ years and since then it has never turned down either a single customer or a project that was categorized as an “impossible task”.

However, due to the fact that this company ha s been in the anodizing busin ess for quite some time now , the company has never shifted its focus on properly storing their inventory. Therefore, as the years started to progress and technology started to advance, the company finally decided that it was time to adapt a new system. Wit h that mind set in place, we at A&G Associates have been given the opportunity to evaluate the company and determined two possible candidates that will help Anodizing Industries in their inventory management. We have run all possible test imaginable which include determining cost, eliminating biases among the candidates and assessing any risk factors that might develop along the way. A&G Associates are proposing that the best candidate solution for inventory management at Anodizing Industries is to build a system from scratch using Microsoft Access (Candidate 2). The main justification for our decision was primarily based on the current analysis that we physically conducted on site as well as thinking ahead towards the future. In addition, since Anodizing In dustries is expanding its business by acquiring a new location site by 2018, we believe that this will create a bigger expansion of inventory as well as customers. Therefore, with the right equipment by their side, we ha ve determined this proposal will not only efficiently capture and store inventory, it will primarily merge and eliminate the current system with a new digital system. Inventory Management System | A&G Associates Page 57 of 71 System Design Inventory Management System | A&G Associates Page 58 of 71 Input The input devices that will be required are:  DT90 Mobile PC Keyboard and Mouse Output These will be the output devices required  Monitor DT90 Printer Hardware and Software Hardware The hardware that we have decided to implement in our proposal starts off with workstations. The recommended workstation that we have picked is an Intel Core i5 (4.0GHz) with 8GB of ram and a 1TB hard drive. The brand of the workstation is called ABS Compu ter Technology Inventory Management System | A&G Associates Page 59 of 71 series B5467. This workstation will handle the database system as well as provide the proper speed necessary to handle the task at hand. In addition, this workstation is a compact slim design which can be placed anywhere around the warehouse . Another piece of hardware that will be necessary is a server. The server will have the digital database in place so that the workstations can communicate simultaneously. The server must have a sufficient amount of hard drive space, so we are recommending two internal hard drives with a minimum of 1TB each with a 500 GB solid state drive. The two hard drives will perform a duplicate copy of the information ( RAID) and the solid state drive will handle/store the main system. In regards to the inputs and outputs of the system, we recommend the DT90 hand held inventory scanner with the appropriate printer. This component will be able to capture the inventory and store it in the database. Since the company already owns some printers, we recommend getting a set of two for the warehouse.

Other than these recommended components, the client is free to purchase similar items as long as it meets the requirements that are stated above . Software The software that the system is going to require is Microsoft Access. This package comes in either a standalone software or it can be combined with Microsoft suit. Microsoft suit includes Word, Excel, PowerPoint, Access and other p rograms. These programs are not required to have immediately but they will be necessary if the employees are going to be using Excel for looking up information as well as for running queries on Access . In addition, there will not be any charges for updatin g the software since it’s a Microsoft product. The workstations that we have recommended will be able to handle the software effectively . Inventory Management System | A&G Associates Page 60 of 71 System Interface In order to fully picture the system that will be implemented, we have designed a prototype design of the system. This is not the final product until the client approves it, therefore the system design can be modified to the clients liking. However, we believe that this design should be user friendly for the employees . Home Screen Inventory Management System | A&G Associates Page 61 of 71 Below are a few mock ups of the design view of Store Inventory and Generate Report Store Inventory Generate Report Inventory Management System | A&G Associates Page 62 of 71 Implementation Schedule Inventory Management System | A&G Associates Page 63 of 71 Implementation Schedule ID Task Start Finish Duration 1 Problem Analysis July 6, 2015 July 28 , 2015 16 Days 2 Requirement Analysis July 28 , 2015 August 7 , 2015 8 Days 3 Logical Design August 7 , 2015 September 4 , 2015 20 Days 4 Decision Analysis September 4 , 2015 October 1 , 2015 19 Days 5 Physical Design October 1 , 2015 November 1 , 2015 21 Days 6 Construction & Testing November 1, 2015 December 15, 2015 32 Days 7 Implementation & Delivery December 15 , 2015 December 16 , 2016 1 Days Gantt Chart 2015 ID Task Name Jul Aug Sep Oct Nov Dec Jan 1 Problem Analysis 2 Requirement Analysis 3 Logical Design 4 Decision Analysis 5 Physical Design 6 Construction &Testing 7 Implementation & Delivery Today Legend Complete Task Incomplete Task Inventory Management System | A&G Associates Page 64 of 71 PERT Chart Legend Task Scheduled Start Scheduled Finish Actual Start Actual Finish Project Initiation 7-5-2015 N/A 7-5-2015 N/A Project Analysis 7-6-2015 7-28 -15 7-6-2015 7-25 -15 Requirement Analysis 7-28 -2015 8-7-2015 7-26 -2015 8-8-2015 Implementation & Delivery 12 -15 -2015 12 -16 -2015 12 -10 -2015 12 -16 -2015 Task Scheduled Start Scheduled Finish Actual Start Actual Finish Logical Design 8-7-2015 9-4-2015 8-7-2015 9-4-2015 Construction & Testing 11 -1-2015 12 -15 -2015 11 -1-2015 12 -10 -2015 Decision Analysis 9-4-2015 10 -1-2015 9-4-2015 9-30 -2015 Physical Design 10 -1-2015 11 -1-2015 10 -1-2015 10 -30 -2015 Intertask dependency Inventory Management System | A&G Associates Page 65 of 71 Conversion Plan Before the conversion plan can begin, the proposed system has to go through a variety of testing phases. After the testing phase results in an error free environment, A&G Associates plans to convert the old file processing method using a location conversion. A location conversion is basically when the system is convert ed in one location (for this purpose, the location will be on Alhambra Ave.) using an abrupt cut -over conversion. An abrupt cut -over conversion is setting aside one specific date for when the old system is terminated and the new system goes live. The new s ystem has to run for a whole week to determine any problems that th e system might encounter (also known as beta testing). Another type of testing that will be implemented is alpha testing in which the test consist of checking for error s and omissions in re gard to end -users. The last testing phase is known as audit testing. Audit testing certifies that the system is free of errors and is ready to be placed into operation. After the beta, alpha and audit testing has been looked over and fixed (if any problems arise), we can them transfer the system to other locations. The system will satisfy the client but most importantly it will facilitate the jobs of the employees when storing inventory in the new inventory management system. In addition, s ince the company is not expanding until 2018, we will be more than happy to assist with the conversion plan of the system to the next facility once it opens . Inventory Management System | A&G Associates Page 66 of 71 Recommendations Inventory Management System | A&G Associates Page 67 of 71 The recommendations that we are about to provide are not necessary to implement right away, but they are helpful in case something goes wrong in the near future. The most basic recommendation is to purchase an external hard drive to back up necessary files.

Even though the server is configured in a RAID format, hard drives (in rare occasions) do have a tendency to malfunction. Therefore, the need to back up information is critical. The second recommendation is to update the system as frequently as possible. Even though automatic updates is enabled, it doesn’t hurt to manually look for updates. The process is fairly simple, just ma ke sure the updates are directly downloaded from either the systems update tab or the manufactures web site. The third recommendation is to modify the system by including additional fields. Remember that this system is fully customizable so if in the near future you would like to add to it, then by all means go for it. This was one of the main reasons why we chose this system especially since the business is expanding soon. Lastly, do not be afraid of altering the syste m. If in the near future you require our assistance, we will be more than willing to assist you. Just as a friendly reminder you can contact us at: A&G Associates 1738 1 st Street Los Angeles CA, 90028 [email protected] (323) 578 -5778 Inventory Management System | A&G Associates Page 68 of 71 Presentation