CIS 319: Computers and Information Processing
TABLE OF CONTENTS
PROBLEM STATEMENT 3
Business Requirements 4
Solution Design 9
Implementation & Testing12
Appendix A: Riordan Manufacturing AS-IS Diagram17
Appendix B:TO-BE Diagram18
Appendix C: Sales Order Processing19
Appendix D:Solution Design20
Appendix E:Gant Chart21
Appendix F: Implementation Budget22
Appendix G:Return on Investment 23
In 2000, Riordan Manufacturing completed its expansion plan by relocating the entire fan manufacturing operation from Pontiac, Michigan to Hangzhou China. The Pontiac, Michigan facility was retooled to manufacture custom plastic parts. The Research and Development for Riordan is headquartered in San Jose, California. Plastic beverage containers are produced at its plant in Albany, Georgia. The company has seen healthy steady growth with a double-digit profit annually. Key market industries have become international, requiring businesses to adopt strategies to support global exchanges in manufacturing and production techniques.
In order to continue as a prominent leader in the plastic manufacturing industries, Riordan Industries must re-evaluate and trim down unnecessary costs. Riordan manufacturing would like to reduce raw materials and finished goods inventory costs. In Our initial analysis, our management team has assessed the current systems structure and concluded that to resolve rising material requirements and current cost issues an evaluation is necessary for development of a Material Requirements or Planning (MRP) system to track and manage raw materials and a finished product inventory structure across all plants. We would like to execute software and support systems to properly support and maximize our human capital productivity in all Riordan locations.
With our current system, inventory tracking is done through warehouse managers by checking and auditing daily consumptions. Managers in three different locations communicate via e-mails, sending the production and consumption reports, to headquarters that make order adjustment decisions through raw materials suppliers. During the peak or slow season, we need to calculate what type of raw materials needs to be ordered for each location. How many items and quantity of raw materials can be estimated for our US and overseas factory. When are these raw materials required, and when the finished products can be delivered?
The MRP system is to simultaneously meet three objectives. First, the system ensures materials and products are available for production and delivery to customers. The system maintains the lowest possible level of inventory. MRP plans manufacturing activities, delivery schedules and purchasing activities.
Examples of what the MRP system can do for Riordan are:
1.Control the types and quantities of materials they purchase. 2.Plan which products are to be produced and be able to meet current and future customer demand, all at the lowest possible cost. 3.Creates a Master Scheduler, calculating the estimated times of production 4.Reduce the duplicity of entering information
5.Process purchase orders, and track order history
6.Plan the shop workload and spot droughts and traffic in advance 7.Generate sales commissions.
8.Export data into forecasts for special management reports and analysis. INVENTORY TRACKING
Based on our management analysis report, the rising raw materials cost is generated though increased transportation related costs and higher...