Mrp - Intergrated Business System

Service Request: MRP System

CIS 319: Computers and Information Processing

TABLE OF CONTENTS

Page

INTRODUCTION 3

PROBLEM STATEMENT 3

Business Requirements 4

Inventory Tracking

Service Tracking

Accounting

Sales Orders

Purchasing Orders

User-Friendly

Production Manufacturing

Solution Design 9

Cost Analysis 10

Implementation & Testing 12

Training 13

REFERENCES 16

Appendix A: Riordan Manufacturing AS-IS Diagram 17

Appendix B: TO-BE Diagram 18

Appendix C: Sales Order Processing 19

Appendix D: Solution Design 20

Appendix E: Gant Chart 21

Appendix F: Implementation Budget 22

Appendix G: Return on Investment 23

Appendix H: Connectivity 24

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