Mrp: Intergrated Business System
Essay Preview: Mrp: Intergrated Business System
Report this essay
Service Request: MRP System
CIS 319: Computers and Information Processing
TABLE OF CONTENTS
Page
INTRODUCTION
PROBLEM STATEMENT
Business Requirements
Inventory Tracking
Service Tracking
Accounting
Sales Orders
Purchasing Orders
User-Friendly
Production Manufacturing
Solution Design
Cost Analysis
Implementation & Testing
Training
REFERENCES
Appendix A: Riordan Manufacturing AS-IS Diagram
Appendix B:
TO-BE Diagram
Appendix C: Sales Order Processing
Appendix D:
Solution Design
Appendix E:
Gant Chart
Appendix F: Implementation Budget
Appendix G:
Return on Investment
Appendix H:
Connectivity
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:
Control the types and quantities of materials they purchase.
Plan which products are to be produced and be able to meet current and future customer demand, all at the lowest possible cost.
Creates a Master Scheduler, calculating the estimated times of production
Reduce the duplicity of entering information
Process purchase orders, and track order history
Plan the shop workload and spot droughts and traffic in advance
Generate sales commissions.
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 demand of raw materials from our competitors. In order to lower the material costs and stay competitive in the industry, it is necessary to re-evaluate the quality, cost, and the efficiency of our current suppliers, and browse though other local suppliers to obtain a qualified list of them. With our new MRP system installed, we are capable to retrieve and analyze the efficiency and variable cost of each supplier, which will enhance our accuracy in selecting suppliers.
As our warehouse inventory data indicates there is an average of 15% overstock of finished products, such as fans, plastic bottles, and the reasons are revealed as:
Current inaccurate tracking system: Using the requested MRP system to centralize the inputs and outputs, this will alert our inventory department for the proper adjustment of ordering raw materials and maintain the lowest level of our inventory.
Peak and off-season forecasts: The current system uses a 3-year historic record to generate future orders. This method creates inaccurate orders as result of the rapid market demand changes. A new system will be able to track the consumption of the finished products periodically and generate the order accordingly.
SERVICE TRACKING
One of the most