Understanding Master Production Schedule Preparation Steps

The Master Production Schedule (MPS) is a plan for the production of individual end items. It specifies what products are to be produced, how many, and when. Preparing an accurate MPS is crucial for effective production planning and inventory management.

Let's break down the steps provided and determine the logical sequence for preparing a master production schedule.

• (A) Obtaining the net requirement of materials: This step involves calculating the actual amount of material needed after considering what's available in inventory and what's on order.
• (B) Revising the preliminary master production schedule to accommodate the inadequacy of materials: After determining if there are enough materials (or capacity), the initial plan might need adjustments if there are shortages or other constraints.
• (C) Obtaining the specification on required production: This is usually the starting point, understanding what products are needed and in what quantities and timeframes, often based on forecasts or customer orders.
• (D) Assessing the inventory in hand and on order: This step involves checking current stock levels and incoming material shipments. This information is needed to determine net requirements.
• (E) Determining the gross requirements of materials using MRP: Using the Bill of Materials (BOM) and the required production quantity (from the MPS), the total amount of each material needed *before* considering existing inventory is calculated. This is often done using Material Requirements Planning (MRP) logic.

Sequencing Master Production Schedule Preparation

Let's arrange these steps in a logical flow for preparing an MPS:

1. The process typically starts with understanding what needs to be produced. This comes from forecasts or customer orders, leading to the required production specifications. So, step (C) Obtaining the specification on required production is the starting point.
2. Once we know what finished products to produce, we need to figure out the total amount of raw materials and components required for that production plan. This involves using the Bill of Materials (BOM) and calculating the total or gross requirements for each item, often using MRP principles. So, step (E) Determining the gross requirements of materials using MRP follows.
3. Before we can determine how much we actually need to order or produce (net requirements), we must know what we currently have available or is already scheduled to arrive. This means checking the existing inventory. Thus, step (D) Assessing the inventory in hand and on order comes next.
4. With the gross requirements calculated and the available inventory known, we can then figure out the net requirement — the difference between what is needed in total and what is already available. This is step (A) Obtaining the net requirement of materials.
5. Finally, after determining the net requirements and potential shortages or capacity issues based on these needs, the initial production plan (the preliminary MPS) might need to be adjusted or revised to make it feasible. This addresses any inadequacies found. This is step (B) Revising the preliminary master production schedule to accommodate the inadequacy of materials.

Therefore, the correct sequence of steps involved in the master production schedule preparation, based on the logical flow of production planning and material requirements, is (C), (E), (D), (A), (B).

Revision Table: Master Production Schedule Steps

Additional Information: MPS and MRP Concepts

The Master Production Schedule (MPS) and Material Requirements Planning (MRP) are key components of production planning systems.

• MPS: The MPS is the primary driver for MRP. It translates the aggregate production plan into a specific plan for individual end items. It deals with independent demand (finished goods, spare parts).
• MRP: MRP takes the MPS, Bill of Materials (BOM), and inventory data as input. It calculates the time-phased requirements for raw materials, components, and sub-assemblies (dependent demand) needed to execute the MPS. It determines when orders should be placed and when they should be received to meet the production schedule.
• Bill of Materials (BOM): A BOM is a list of raw materials, sub-assemblies, intermediate assemblies, sub-components, parts, and the quantities of each needed to manufacture an end product. It defines the structure of the product.
• Inventory Data: Accurate records of current stock levels (on hand) and scheduled receipts (on order) are essential for calculating net requirements in MRP.

The sequence (C), (E), (D), (A), (B) reflects the flow where the production plan (C) drives the calculation of total needs (E), which are then offset by what's available (D) to determine the actual material needs (A), potentially leading to adjustments in the original plan (B) if resources are insufficient.