The main tool this week is Material Requirements Planning (MRP).
PIMS, Inc., has been manufacturing plumbing equipment since 1999. Because of the depressed economic conditions, component parts are assembled in batch runs. At any given time, each level of production has several partially assembled components. Given the following assembly and inventory information, construct a product structure diagram for the oil leak valve, and plan the order releases necessary to assemble 400 oil leak valves for period 10.
Description of the Production Process
Production of the valve begins with the base. The base is placed and secured in a housing. Ball bearings are then installed on opposing sides of the base housing. The rear base cover is fitted on and held while the front cover is secured with U-bolts. Next, the anchor assembly is connected. Finally, two sets of brackets are screwed on and the oil leak valve is checked before shipping.
Assume the use of the multiple of fixed lot sizes technique.
- First, draw a diagram of the B.O.M. for this product.
- Then, using Excel, complete the MRP record for the Oil Leak valve and all subcomponents. Use this template: MRP Assignment Week 1 (1).xlsx
- Next, consider the options for the next six months for short-range capacity planning for Oil Leak valve assemblies as discussed on pg. 218. Determine which approach allows for the lowest total cost given:
Data Beginning Inventory0Beginning Workers20St. Time Hrs. per worker per month160Max. OT Hours per worker per month40Hiring Cost per worker$4,000Layoff Cost per worker$5,000St. Time Pay per worker per hour$18OT Pay per worker per hour$25Labor Hours per unit produced10Raw Materials Cost per unit$10Holding cost per unit per month$2Shortage Cost per unit per month$5Subcontracting Cost per unit$120
4. Finally, explain what you did in this assignment with regards to MRP and Capacity Planning as if you were describing the concepts to someone unfamiliar with Operations and Supply Chain Planning.
How to Write an MRP and Capacity Planning Analysis
Introduction
Introduce Material Requirements Planning (MRP) as a planning system used to determine what materials are required, how many are needed, and when they should be ordered or produced to satisfy customer demand. Explain that MRP integrates the master production schedule, inventory records, and the Bill of Materials (BOM) to ensure that production activities are synchronized and inventory costs are minimized. State that this assignment requires developing a product structure diagram for an oil leak valve, completing MRP records using Excel, evaluating short-range capacity planning alternatives, and explaining the concepts in language understandable to individuals without an operations management background.
Section 1: Develop the Bill of Materials (BOM) Product Structure Diagram
Begin by explaining the purpose of a Bill of Materials and its role within an MRP system. Describe the BOM as a hierarchical representation of every component required to manufacture a finished product.
Explain how to carefully analyze the production process described in the assignment and identify every component used in the oil leak valve assembly. Organize the finished oil leak valve at Level 0 and place each subassembly and component beneath it according to the order in which they are assembled.
Identify the parent-child relationships among components and clearly distinguish between finished products, assemblies, subassemblies, and purchased parts. Ensure that each component appears only once at its lowest appropriate level unless the assignment specifies otherwise.
The completed product structure diagram should accurately represent the manufacturing sequence described in the case and serve as the foundation for the subsequent MRP calculations.
Section 2: Complete the Material Requirements Planning (MRP) Records
Explain that the MRP record determines when materials should be ordered or manufactured to meet production requirements while minimizing inventory costs.
Using the Excel template provided, complete the MRP records for the finished oil leak valve and every subcomponent. Calculate the gross requirements based on the production schedule requiring 400 oil leak valves in period 10. Incorporate all inventory information provided in the assignment, including beginning inventory, scheduled receipts, lead times, and lot-sizing requirements.
Apply the multiple fixed lot size technique exactly as instructed. Calculate projected available inventory, net requirements, planned order receipts, and planned order releases for every item in the BOM.
Verify that lower-level component requirements are driven by the planned order releases of their parent assemblies rather than by independent demand. Ensure that calculations flow correctly from the finished product through every level of the BOM.
Present completed Excel tables with clearly labeled rows and columns and verify that all formulas produce consistent results.
Section 3: Evaluate Short-Range Capacity Planning Alternatives
Introduce short-range capacity planning as the process of matching available production capacity with expected customer demand over the planning horizon.
Using the data provided, evaluate each available capacity planning alternative discussed in the course textbook. Depending on the textbook, these alternatives may include maintaining a constant workforce while carrying inventory, hiring and laying off employees to match demand, using overtime, subcontracting production, allowing shortages or backorders, or developing mixed strategies that combine several approaches.
Calculate all relevant production costs for each strategy using the provided data. Include regular labor costs, overtime costs, hiring expenses, layoff expenses, inventory holding costs, shortage costs, subcontracting costs, and raw material costs where applicable.
Prepare detailed Excel calculations showing the monthly workforce requirements, production quantities, inventory balances, shortages if applicable, and total costs for each alternative over the six-month planning horizon.
Compare the total costs of all alternatives and identify the strategy that minimizes total production costs while satisfying customer demand.
Explain why the selected strategy represents the most cost-effective solution based on the calculations.
Section 4: Explain Material Requirements Planning and Capacity Planning for a Nontechnical Audience
Explain Material Requirements Planning in simple language suitable for someone unfamiliar with operations and supply chain management.
Describe MRP as a planning system that works similarly to preparing a shopping list before cooking a large meal. Explain that rather than purchasing everything at once, MRP determines exactly which materials are needed, how many are required, and when they should arrive so that production proceeds efficiently without excessive inventory or shortages.
Next, explain capacity planning by comparing it to managing staffing in a busy restaurant or hospital. Discuss how managers must decide whether to hire additional workers, schedule overtime, subcontract work, or temporarily build inventory before periods of high demand.
Describe how MRP focuses primarily on materials while capacity planning focuses on available production resources such as employees, equipment, and production time. Emphasize that both systems work together to ensure products are manufactured efficiently, customer demand is satisfied, production costs are minimized, and organizational resources are used effectively.
Conclude this section by explaining how MRP and capacity planning support operational efficiency, reduce waste, improve customer service, and enhance overall supply chain performance.
Conclusion
Summarize the major findings of the assignment by explaining that successful production planning depends on accurately identifying product components, scheduling material purchases, and aligning production capacity with anticipated demand. Reinforce the importance of developing an accurate Bill of Materials because it forms the basis for Material Requirements Planning calculations. Highlight that evaluating multiple short-range capacity planning alternatives enables managers to identify the most economical production strategy while maintaining customer service levels. Conclude by emphasizing that integrating MRP with effective capacity planning allows organizations to reduce costs, optimize inventory, improve scheduling accuracy, and achieve efficient manufacturing operations.
References
Use APA 7th edition references in alphabetical order.
Include the course textbook and any additional scholarly or professional sources required by your instructor, such as operations management texts and peer-reviewed articles on Material Requirements Planning, Bill of Materials, inventory management, and capacity planning.
Last Completed Projects
| topic title | academic level | Writer | delivered |
|---|