Free Essay

Mrp 2

In: Business and Management

Submitted By zachsartain
Words 381
Pages 2
Executive Summary
Facing capacity problems with two items which are manufactured in-house (the Circuit Board A and the I/O Sub C) and past due deliverables of the two item’s component parts, Judy must make decisions on how to address these issues. The accounting and finance department also requested from Judy to provide them with inventory and capital costs for each component.

Items manufactured in-house (Circuit Board A and the I/O Sub C)

Judy identified several periods which had a negative unit balance where needed capacity could not be fulfilled. Judy’s approach was to identify periods with deficiency and utilize periods which had a surplus of units to be produced. Below are the results for both Items.

Circuit Board A

| PD | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | Planned order releases | 0 | 0 | 79 | 200 | 200 | 200 | 400 | 400 | 400 | 200 | 0 | 0 | 0 | Actual Capacity (units) | | 300 | 300 | 200 | 200 | 200 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | Needed Capacity (units) | | 0 | 79 | 200 | 200 | 200 | 400 | 400 | 400 | 200 | 0 | 0 | 0 | Over/(Under) (units) | | 300 | 221 | 0 | 0 | 0 | 0 | 0 | 0 | 200 | 400 | 400 | 400 |

I/O Sub C | PD | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | Planned order releases | 0 | 425 | 986 | 986 | 1020 | 1989 | 1989 | 1989 | 1003 | 0 | 0 | 0 | 0 | Actual Capacity | | 1000 | 1000 | 1000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | Needed Capcity | | | 425 | 986 | 986 | 1020 | 1989 | 1989 | 1989 | 1003 | 0 | 0 | 0 | 0 | Over/Under | | | 575 | 14 | 14 | 980 | 11 | 11 | 11 | 997 | 2000 | 2000 | 2000 | 2000 |

As shown in the tables above, neither item has any Past Due planned order releases therefore Judy will not need to subcontract to meet the requirements.

Component parts

Judy identified that component parts all had past due planned order releases, therefore she must expedite related purchase orders. The inventory cost, capital cost, and expediting costs are provided below.

Item | Inventory and Capital Cost per Unit for all periods | Expediting Cost for Past Due Units | Resistor B | $ 35,862.75 | $ 598,500.00 | T-former D | $ 80,873.10 | $ 1,819,200.00 | Screw E | $ 22,020.44 | $ 71,100.00 | Bolt F | $ 4,400.00 | $ 21,000.00 |

Similar Documents

Free Essay

Mrp 2

...MANUFACTURING RESOURCES PLANNING What is MRP II and why it is being used Definition and History According to American Production and Inventory Control Society, MRP II can be defined as a method of the effective planning of all the resources of a manufacturing company (Higgins, Leroy and Tierney 1996). It is actually advancement or can be said as a upgrading of Material Requirement Planning System (MRP) system, which is a set of technique that uses bills of material, data and a master production schedule to calculate the requirements for materials in a manufacturing company. The MRP system was initiated in the 1960s and was spearheaded by a team of IBM innovators comprising Joe Orlicky, George Plossl and Ollie Wright who sought to create a structured methodology for planning and scheduling materials for complex manufactured products. Over the past 30 years MRP has spawned an entire industry in manufacturing and professional services. It has evolved hand in hand with technological advancements in the computer hardware industry. At the beginning, MRP systems were run on large mainframe computer costing a lot of money and required large technical staff to support them. However in the 1970s they underwent refinements that saw disparate modules get included and critical business concerns such as cost accounting and Capacity Requirements Planning get added. This gave rise to a new generation system called MRP II. Continued changes spurred by increased technological advances......

Words: 610 - Pages: 3

Free Essay

Tax in India

...Production Planning Solution Techniques Part 1 MRP, MRP-II Mads Kehlet Jepsen Production Planning Solution Techniques Part 1 MRP, MRP-II – p.1/31 Overview Production Planning Solution Techniques Part 1 MRP, MRP-II – p.2/31 Overview Material Requirement Planning(MRP) Production Planning Solution Techniques Part 1 MRP, MRP-II – p.2/31 Overview Material Requirement Planning(MRP) MRP Procedure Production Planning Solution Techniques Part 1 MRP, MRP-II – p.2/31 Overview Material Requirement Planning(MRP) MRP Procedure Issues with MRP Production Planning Solution Techniques Part 1 MRP, MRP-II – p.2/31 Overview Material Requirement Planning(MRP) MRP Procedure Issues with MRP Manufacturing Resource Planning MRP II Production Planning Solution Techniques Part 1 MRP, MRP-II – p.2/31 Overview Material Requirement Planning(MRP) MRP Procedure Issues with MRP Manufacturing Resource Planning MRP II Time driven Rough-Cut Capacity Planning Production Planning Solution Techniques Part 1 MRP, MRP-II – p.2/31 Overview Material Requirement Planning(MRP) MRP Procedure Issues with MRP Manufacturing Resource Planning MRP II Time driven Rough-Cut Capacity Planning Heuristic for Time driven Rough-Cut Capacity Planning Production Planning Solution Techniques Part 1 MRP, MRP-II – p.2/31 Overview Material Requirement Planning(MRP) MRP Procedure Issues with MRP Manufacturing Resource Planning MRP II Time driven Rough-Cut Capacity Planning Heuristic for Time driven Rough-Cut......

Words: 7576 - Pages: 31

Premium Essay

Material Requirement Plannin

...Gallego Material Requirements Planning (MRP) Material Requirements Planning (MRP) is a computer-based production planning and inventory control system. MRP is concerned with both production scheduling and inventory control. It is a material control system that attempts to keep adequate inventory levels to assure that required materials are available when needed. MRP is applicable in situations of multiple items with complex bills of materials. MRP is not useful for job shops or for continuous processes that are tightly linked. The major objectives of an MRP system are to simultaneously: 1. Ensure the availability of materials, components, and products for planned production and for customer delivery, 2. Maintain the lowest possible level of inventory, 3. Plan manufacturing activities, delivery schedules, and purchasing activities. MRP is especially suited to manufacturing settings where the demand of many of the components and subassemblies depend on the demands of items that face external demands. Demand for end items are independent. In contrast, demand for components used to manufacture end items depend on the demands for the end items. The distinctions between independent and dependent demands are important in classifying inventory items and in developing systems to manage items within each demand classification. MRP systems were developed to cope better with dependent demand items. The three major inputs of an MRP system are the master production......

Words: 2977 - Pages: 12

Free Essay

Economic

...Keywords: enterprise resource planning, ERP Learning Outcome: Describe the process and applications of enterprise resource planning (ERP) 2) Companies that fully customize their ERP implementation reap the greatest rewards from such systems since they can continue to use the same processes to which all employees are accustomed. Answer: FALSE Reference: Enterprise Resource Planning Difficulty: Moderate Keywords: enterprise resource planning, ERP implementation Learning Outcome: Describe the process and applications of enterprise resource planning (ERP) 3) A firm's existing, older information system is called a "legacy system." Answer: TRUE Reference: Enterprise Resource Planning Difficulty: Moderate Keywords: enterprise resource planning, legacy system 4) Material requirements planning (MRP) is a computerized information system developed specifically to aid in managing dependent demand inventory and scheduling replenishment orders. Answer: TRUE Reference: Material Requirements Planning Difficulty: Easy Keywords: material requirements planning, MRP 5) A materials requirements planning (MRP) explosion occurs when the system is bombarded with too many orders to schedule at one time. Answer: FALSE Reference: Material Requirements Planning Difficulty: Easy Keywords: material requirements planning, MRP explosion 6) A parent is any item manufactured from one or more components. Answer: TRUE Reference: Material Requirements......

Words: 9434 - Pages: 38

Free Essay

Mrp(Manufacturing Resource Planning)

..._______________________ ------------------------------------------------- Topic: MRP II (Manufacturing Resource Planning) ------------------------------------------------- 19th October Contents Executive summary 2 Introduction and background of MRP II 3 Implement in Manufacturing Industry 6 SWOT Analysis of MRP II System 8 Conclusion 9 Recommendations (Next generation of MRP II system) 11 Reference: 13 Executive summary The purpose of this report is to illustrate what MRP II is, what features it provides, and what benefit the manufacturers could get from it as well as the existent issues in MRP II system. The research also demonstrates how MRP II was implemented in manufacturing industry by studying a case of successful implementation of MRP II software. Introduction and background of MRP II MRP II is Manufacturing Resources Planning for short. It is defined as a man machine application system for the effective planning of all resources of all manufacturing company. From the global optimal point of view, using scientific method to plan, organize, control and coordinate all the manufacturing resources and all the links of operation of enterprises effectively and reasonably is what the MRP II concerned about. The purpose of using the MRP II system is to achieve continuous and balanced production and minimize the various items in the inventory. Eventually it......

Words: 2537 - Pages: 11

Free Essay

Effectiveness of Material Requirenents Planning

...PROPOSAL Research Title Effectiveness of Material Requirements Planning (MRP) framework within manufacturing cooperatives based in Polokwane Municipality Area Presented by Phetola Cyprian Mogale Student Number: 113904 Postal Address P.O. Box 507 Polokwane Ladanna 0704 Contact Numbers Work 015 297 6632 Cell 082 906 2746 Email address: mogalep@libsa.co.za Date submitted: 12 April 2012 Proposal for dissertation submitted in partial fulfilment of the degree Masters in Business Administration at the Mancosa Management College of Southern Africa TABLE OF CONTENTS i CONTENT PAGE 1. Introduction 4 2. Research Context: Background 4 3. Research Problem 6 4. Aim of the Study 7 5. Research Objectives 7 6. Research Questions 7 7. Significance of the Study 8 8. Literature Review 9 9. Research Design and Methodology 12 9.1 Research Methodology 12 9.2 Sampling Strategy 13 9.3 Data Collection Instruments 14 9.4 Data Analysis 15 9.5 Pilot Study 15 10. Ethical Considerations 15 11. Chapter Organization 16 12. Proposed Time-Table 17 13. Bibliography 18 LIST OF TABLES TABLE 1.1 SAMPLE SIZE 13 LIST OF ACRONYMS ii CRP Capacity Requirements Planning DTI Department of Trade and Industry EOQ Economic Order Quantity ERP Enterprise Resource......

Words: 6238 - Pages: 25

Premium Essay

Managerial Application of Information Technology

...Does a MRP system provide value to an organization? IS535: Managerial Applications of Information Technology Dr. Mario Missakian TABLE OF CONTENTS PAGE Proposal a. Does a MRP system provide value to an organization 4 i. Value added by MRP system 4 b. The problem 4 i. Frequent Back Orders 4 ii. High Inventory Levels 4 c. Benefits of MRP System 5 i. How will ABC, Inc. benefit 5 d. High Level Approach 6 i. Assessment of resources and costs ii. Presentation to Management 6 e. Audience 6 i. Who will benefit 6 ii. How the beneficiaries will benefit 6 iii. The role of senior management in the implementation 6 Milestone 1 a. Business problem relooked 7 i. Problems facing ABC 7 b. Company background 7 ii. ABC’s business 7 iii. ABC’s current state 7 c. Discussion of business issue 8 i. Why MRP Implementations Fail 8 ii. Risks associated with implementation 8 d. Benefits of Solving the problem 8 i. Benefits From Good Design 8 ii. Benefits From Correct Implementation 8 e. Initial business/Technical Approach 9 i. Implementation Approach 9 ii. Management Commitment Required 9 f. High Level Solution 9 i. Requirements and Design 9 ii. Specific Functions 9 Milestone 2 a. Implementation 10 i. Configuration 10 ii. Integration 10 iii. User Education 10 b. ...

Words: 3853 - Pages: 16

Premium Essay

Business

...Displaying MRP Data The objective of MRP is to ensure that the correct quantities of component parts are available at the proper time to produce finished products according to the master production schedule. This section describes how that is done for items that appear immediately below the finished product in the product structure tree diagram. The information obtained from bills of materials, inventory records, and the master schedule can be shown together in the diagram of Figure 9.15, which is the table commonly used to calculate and display MRP information. Figure 9.15: Table for MRP The table in Figure 9.15 illustrates time periods across the top. These represent time periods for planning purposes, or time buckets. The time buckets correspond to the master product schedule, which is usually set in weeks. The purpose of using these time periods is to state the total quantity requirements for component parts and materials needed during each time bucket. This process of stating requirements by time bucket is often called time phasing. The first row in Figure 9.15 is labeled gross requirements. Gross requirements represent the total quantity needed of a particular item in each time bucket, based on the master production schedule and the bill of materials, regardless of current inventory of that item. The second row, scheduled receipts, shows whether any orders for that item have been placed previously, but not yet received. Entries in this row indicate when the order...

Words: 1873 - Pages: 8

Premium Essay

Erp and Mrp System

...ERP system has evolved over the past thirty years. When it comes to the development of ERP, we need to review the MRP system. Generally, MRP processes specifically involve planning the use of materials necessary for manufacturing business products, so MRP is also a common function contained within an ERP [1]. ERP is an updated manufacturing resource system; it grew out of MRP II systems with relational database management, graphical user interface, and client and server architecture. In the system, the kinds of products and services offered by a company drive operation strategy. Products and services can be classified into make-to-order, make-to-stock. The MTO strategy only manufactures the end product once the customer places the order, while the MTS method forecasts demand to determine how much stock should be produced [2]. For example, Global bike incorporated produces some bikes after it received a sales order from its customers. These finished goods are used to meet customers’ need, they pertain to MTO strategy. On the other side, in the long production run, GBI may also forecast demands on the basis of sales, then produce bikes to put into inventory before customers place orders. It is an example of implement of MTS. Both MRP and ERP have their advantages and disadvantages. MRP helps to standardize business processes by offering automated methods for many areas of the business. Standardization leads to easily repeated processes and a platform for improving those......

Words: 622 - Pages: 3

Premium Essay

Factor Markets: with Emphasis on the Labour Market

... so does the demand for skilled computer workers. When demand for a seller’s product rises, the seller needs to decide how much more of a factor to buy. Marginal revenue product and marginal factor cost are relevant to this decision. Marginal Revenue Product The additional revenue generated by employing an additional factor unit, such as one more unit of labour. E.g. Firm employs one more unit of a factor and total revenue rises by $20, hence MRP of the factor equals $20. MRP can be calculated in two ways: MRP = △TR/ △Quantity of the factor Or MRP = MR x MPP Where TR = total revenue, MR = marginal revenue, and MPP = marginal physical product. The MRP Curve Is the Firm’s Factor Demand Curve MRP curve is downward sloping (Exhibit 2). Why? MRP can be calculated as MRP = MR x MPP and with regard to MPP, the marginal physical product of a factor, and, according to the law of diminishing marginal returns, eventually the MPP of a factor will diminish. Because MRP is equal to MR x MPP and because MPP will eventually decline, MRP will eventually decline too. Value Marginal Product VMP is equal to the price of the product multiplied by the MPP of the factor: VMP = P x MPP For example, if P = $10 and MPP = 9 units, then VMP = $90. VMP can be said to be a measure of the value that each factor unit adds to the firm’s product or simply as MPP measured in dollars. Why does a firm want to know the VMP of a factor? Because it helps in deciding how many units of the......

Words: 2885 - Pages: 12

Free Essay

Operations Management

...installing a Materials Requirement Planning (MRP) System to the XYZ Company. The most pertinent questions in the problem are, How will it be done?, How much will be its cost? And what action will be needed to lead this project into success? IV. Objectives Short-range Objective - To set up the new system in order to have a smooth flow of production and avoid interruption. Long-range Objective – To be able to upgrade equipment which will help fit to the new system. V. SWOT Analysis STRENGTHS | WEAKNESSES | * Has workers with expertise in using company’s equipment & following the system * High availability of raw materials * Near to target market | * Poor manufacturing system * Inefficient use of resources * Higher percentage of employee turnover & scrap/waste | OPPORTUNITIES | THREATS | * Possible development of the production system * Affordability in the cost of production | * Breakdown of existing system * Competitors build stronger relationship with other customers | VI. Alternative Courses of Action * ACA# 1: Execute Materials Requirement Planning System. Advantages: Reduce the levels of inventory. Minimize the holding cost Disadvantages: Execution of the system will be at high cost. . High risk on the accuracy rate of information. There will be increase in training cost. * ACA# 2: Replacement of the whole......

Words: 810 - Pages: 4

Free Essay

Mô HìNh Mrp

...IX HOẠCH ĐỊNH NHU CẦU VẬT LIỆU I. HỌACH ĐINH NHU CẦU NGUYÊN VẬT LIỆU 1- Kỹ thuật MRP(Material Requirement Planning) là một công cụ tính tóan nhu cầu MRP là một kỹ thuật ngược chiều quy trình công nghệ để tính nhu cầu nguyên vật liệu. Nó bắt đầu từ số lượng và thời hạn yêu cầu cho những sản phẩm cuối cùng đã được xác định trong kế hoạch tiến độ sản xuất chính, đểø xác định nhu cầu các chi tiết, các bộ phận cần có để đáp ứng kế hoạch tiến độ sản xuất chính. Phương pháp này xác định số lượng, thời gian cần có các bộ phận, chi tiết và thời gian cần đặt hàng để chúng sẵn sàng khi cần đến. Đầu tiên MRP được xem như là công cụ kiểm soát tồn kho, cung cấp các báo cáo cho biết các bộ phận chi tiết nào cần phải đặt hàng, khi nào đặt hàng và hoàn thành đơn hàng. Khi sử dụng thuật ngữ này, kỹ thuật MRP chỉ là kỹ thuật tính toán nhu cầu nguyên vật liệu cho các bộ phận sán phẩm hoàn thành, không bao hàm việc sử dụng các thông tin ngược để theo dõi tiến độ thực tế các đơn hàng cũng như việc điều chỉnh các đơn hàng cho phù hợp với thực tế. 2- MRP là một hệ thống kiểm soát và hoạch định Lôgic của MRP cho phép sử dụng rộng rãi hệ thống máy tính cung cấp thông tin cho hoạch định và kiểm soát cả nguyên vật liệu lẫn năng lực sản xuất để chế tạo sản phẩm. Logic MRP được mở rộng và trở thành bộ phận then chốt của hệ thống thông tin phục vụ hoạch định, kiểm soát sản xuất và mua sắm . Thông tin mà MRP cung cấp rất có ích trong việc hoạch định tiến độ vì nó xác định những ưu tiên......

Words: 5233 - Pages: 21

Premium Essay

Seminar 4 Discussion Questions

...eliminates and/or reduces the chance of waiting for items needed to fulfill an order (Stevenson, 2012). 9. What are some of the main advantages and limitations of MRP? Some of the main advantages of MRP are: 1.) the ability to identify specific parts and keep track of material requirements; 2.) the ability to evaluate capacity generated by a master schedule; 3.) low levels of in-process or pending inventories and determine exact unit numbers needed; 4.) the means of distributing production time; and 5.) the ability to determine the dates when orders should be released based on lead times (Stevenson, 2012). Some limitations of MRP are: 1.) MRP tried to do too much in software that cannot hold up all the time, such as dynamic, and often jumpy systems; and 2.) MRP has not operated well in various service applications (Stevenson, 2012). 15. How does the purpose of ERP differ from the purpose of MRP II? The purpose of ERP differs from the purpose of MRP II as MRP II is an expanded method for production resource planning. MRP II involved other areas of a firm in the planning process, while also enabling capacity requirements planning. ERP is a combination of financial, manufacturing, and human resources all in a single computer system. ERP is generally used for standardized record keeping, which is different from MRP II (Stevenson, 2012). Reference Stevenson, W. J. (2012). Operations Management (11th Ed). New York: McGraw-Hill/Irwin...

Words: 284 - Pages: 2

Free Essay

Invntrymgmt

...installing a Materials Requirement Planning (MRP) System to the XYZ Company. The most pertinent questions in the problem are, How will it be done?, How much will be its cost? And what action will be needed to lead this project into success? IV. Objectives Short-range Objective - To set up the new system in order to have a smooth flow of production and avoid interruption. Long-range Objective – To be able to upgrade equipment which will help fit to the new system. V. SWOT Analysis STRENGTHS | WEAKNESSES | * Has workers with expertise in using company’s equipment & following the system * High availability of raw materials * Near to target market | * Poor manufacturing system * Inefficient use of resources * Higher percentage of employee turnover & scrap/waste | OPPORTUNITIES | THREATS | * Possible development of the production system * Affordability in the cost of production | * Breakdown of existing system * Competitors build stronger relationship with other customers | VI. Alternative Courses of Action * ACA# 1: Execute Materials Requirement Planning System. Advantages: Reduce the levels of inventory. Minimize the holding cost Disadvantages: Execution of the system will be at high cost. . High risk on the accuracy rate of information. There will be increase in training cost. * ACA# 2: Replacement of the whole......

Words: 810 - Pages: 4

Premium Essay

Qawqaw12123

...ITS1622 Enterprise Resource Planning Topics covered: 1. Business Functions and Processes 2. The Development of Enterprise Resource Planning Systems 3. The Implementation of Enterprise Resource Planning System 4. Implementation Challenge Q1. Within an ERP system package, name SIX functions that will be covered in Sales and Marketing Module. (6 marks) - Pre-sales - Sales order processing - Inventory sourcing - Delivery - Handle Billing - Payment Q2. Describe how each of the SIX functions in an ERP system package contribute to overall productivity of an organization. (12 marks) Pre-sales o Tracks customer contacts: provides the customer with a price quote Sales order processing • Uses the price quote to record items to be purchased; determines the sales price: record order quantities: configures quantity discounts: checks customer credit Inventory sourcing • Checks the inventory database to see if items can be delivered on time: updates the production planning database to avoid any shortfalls Delivery • Releases documents to the warehouse: item are picked; orders are packed and shipped Bill • Uses sales order data to create an invoice: updates accounting records: increases (debits) accounts receivable Payment • Accepts payment: decreases the customer’s accounts receivable balance with the amount of payment Q3. Give TWO typical problems that are common with manual sales order entry process. (2 marks) - Incorrect pricing Incorrect credit information Q4. With reference to the......

Words: 1111 - Pages: 5