Master Production Schedule By Item

This page allows you to plan for the MPS items/planning groups. Tell me more

Select the “Master Production Schedule - By Item” link under the “Supply Chain Planning“ business component.

The “Master Production Schedule - By Item” page appears.

Enter the following:

Item Code	The code identifying the item for which MPS is to be run. If the item is specified, then it should be valid in the item master for the Organization Unit and should be in “Active” status from “Item Administration” business component. The system checks whether the item is planned at MPS level.
	Press <enter> key.
	The item code cannot be left blank. If it is left blank, then the system displays an error message. The system checks whether the item and variant is specified, if specified, then it should exist in the item master for the Organization Unit from “Item Administration” business component. If the item and the variant are specified, then the item should be planned at the MPS level as defined in the “Item Administration” business component. If the item is not planned at MPS level, then the system displays an error message.
	Help facility available.
Variant Code	The code or number identifying the variant of the item. If the variant is specified, then it should be valid in the item master for the Organization Unit from “Item Administration” business component.
	Press < enter > key.
	The variant code cannot be left blank. If it is left blank, then the system displays an error message. The system checks whether the item and variant is specified, if specified, then it should exist in the item master for the Organization Unit from “Item Administration” business component. If the item and the variant are specified, then the item should be planned at the MPS level as defined in the “Item Administration” business component. If the item is not planned at MPS level, then the system displays an error message.

The system displays the following:

Desc.	The description for the combination of item/item variant.
	Zoom facility available.

Enter the following:

Plg. Group	The code identifying the planning group for which Mater Production Schedule is to be done. If the planning group is specified, then it should be valid in the planning group master for the login Business Unit and should in “Active” status from “Item Administration” business component
	Help facility available.
Matl. Planner	Use the drop-down list box to select the material planners defined in the control unit for which the login user has at least “View” access permission. The system retrieves the material planners in ascending order. The system displays “First Value” by default on launch of the page.

Click the “Get” pushbutton to retrieve the item/planning group details.

Both the item and planning group should not be entered, you can enter either the item code or the planning group. If both are left blank or entered, then the system displays an error message. The system checks for the validity of item/planning group on the current date.

The system displays the following:

Desc.	The description of the planning group.
	Zoom facility available.
On Hand	The physical stock of the item in the inventory before the start of the first period.
Total WIP	The total work in progress quantity. The quantity represents the sum of all the MRP work orders having status greater than or equal to “Released” for the MPS planning horizon and also the quantity which is pending for production or pending for receipt into inventory. The system also considers any past due orders.
Total MPS Qty.	The total MPS quantity. The quantity represents the sum of all the MPS work orders that are having status greater than or equal to “Accepted” and less than “Released” and all MRP work orders with pending quantity are considered for the MPS planning horizon. The system also considers any past due orders.
Prodn. UOM	The production unit of measure of the item. The system converts all the quantity to production UOM from UOM component.
Planning Level	Indicates the level of planning either at Business Unit, Organization Unit or warehouse level.
Business Unit	The business unit at which planning is done. It Indicates that the planning level is at business unit.

Enter the following:

Release For MRP	Select the check box to release the MPS orders for MRP. Either all MPS orders (If release completely option is selected) or only the orders belong to the Release up to Period can be released. The system leaves the box “Unchecked” by default on launch of the page. If MPS for planning group, then this option should not be checked.
Release Option	Use the drop-down list box to select the release options. You can select from “Complete” or “Partial”. The system displays “Complete” by default on launch of the page.
Release Upto	Use the drop-down list box to select the release period end dates. The system takes the MPS Planning Horizon and MPS period defined for the planning group/item/variant and splits the MPS Horizon into periods in dates. The system populates with all the period end dates. The first period is always a past due i.e. contains data for all periods before the current period. The second period is the current period, where always the period end date is shown. The period start date is the period start based on anchor date in “Item Manufacturing Information” and current date. The first period end date is the anchor date added to the MPS period. The second period end date is the first period end date added to the MPS period. This continues until the period end date is less than the current date and MPS planning horizon. For example, If the anchor date is defined as “01/01”, the planning horizon and period is set as “30 Days” and “5 Days” respectively. If the current date is “08/01”, then the release periods are “Past due < 05/01”, “10/01”, “15/01”, “20/01”, “25/01”, “30/01”, “04/02” and “09/02”.

The system displays the following:

MPS Period

The period based on which the release dates are split.

Enter the following:

MPS Option	Use the drop-down list box to select the MPS options. You can select from “All Sources” or “By Sources”. The system displays “All Sources” by default on launch of the page.
	All Sources – indicates that the MPS is generated for all warehouse valid for the material planner.
	By source – indicates that release for MRP would be executed only from the "Edit MPS by Source" Screen.
Plan Online	Select the check box to execute the master production schedule by item immediately. Otherwise it will be executed as a batch process. The system leaves the box “Checked” by default on launch of the page.

The system displays the following in the “MPS Details” multiline:

Period	Indicates the period intervals. The system displays “Past Due” in the first row of the multiline and adds all the demands and supplies before first Period and displays in the respective columns.
Item Forecast	The item forecast that represents the sum of the demands with order identified as production forecast whose due date falls in the period.
Exploded Forecast	The exploded forecast that represents the sum of the demands with order identified as hierarchy orders whose due date falls in the period.
Actual Demand	The actual demand quantity represents the sum of the demands with order as identified other than production forecast or hierarchy orders whose due date falls in the period.
Total Demand	The total demand quantity represents the sum of the item forecast and exploded forecast and actual demand for the period.
Projected Balance	The inventory balance projected into the future. It is the running sum of on-hand inventory minus demands plus scheduled receipts and planned orders. The projected balance quantity for the first period represents the difference between (the sum of on hand and total MPS qty for the period) and total demand for the period. For the second period onwards it represents the difference between (the sum of last period's projected balance and total MPS qty for the period) and the total demand for the period.
ATP	The ATP quantity is the uncommitted portion of a company’s inventory and production, maintained in the master schedule to support customer order promising. The ATP quantity is the uncommitted inventory balance in the first period and is normally calculated for each period in which an MPS receipt is scheduled. In the first period, ATP equals on-hand inventory minus customer orders that are due and overdue. In any period containing MPS scheduled receipts, ATP equals the MPS minus customer orders in this period and all subsequent periods before the next MPS scheduled receipt. A negative ATP generally reduces prior period(s) ATP.

Enter the following:

Total MPS Qty.

The total MPS quantity that represents the sum of MPS orders or receipts excluding “Requested” status orders in MPS whose due date falls in the period.

Partial Release Qty.

Indicates the quantity partially released. If the quantity is specified, then the sum of the partial release quantity and MRP released quantity should be less than or equal to the total MPS qty for the period. The system checks the value in release option field. If release option is "Partial", then the system retrieves the partial release quantity specified in the respective period and that is the quantity to be released in each period. If release option is "Complete", then the quantity to be released in each period is determined as the difference between the total MPS quantity in the period and the MRP released quantity in the period.

The system displays the following:

MRP Released	The MRP released quantity represents the sum of receipt quantity already released from the MPS to the MRP for the period.
Suggested Orders	The suggested order quantity represents the sum of the order or receipt quantity suggested by MRP in the period and in status “Requested” at the MPS. If suggested order quantity is less than the projected balance quantity for the period, then the system sets the suggested order quantity as projected balance quantity of the period.

Click the “Accept Suggested Orders” pushbutton to accept the suggested orders.

The system checks if new details are specified in planning group/item/variant and material planner. If specified, then the corresponding other details is retrieved by the system. For each period, the order quantity on the MPS orders in status “Requested” is moved to status “Firmed” and this order status change is effected from the “Work Order Management” business component.

Click the “Save MPS” pushbutton to save the master production schedule by items.

The system retrieves the release upto period for releasing the MPS orders to MRP. If release upto selected is less than or equal to the last period for which the MRP release quantity is greater than zero, then the system displays an error message. For the current period, the system retrieves the sum of the quantity of MPS orders where the status is greater than or equal to “Accepted” and less than “Released” across all the warehouses for which the material planner is valid. The system retrieves the “Difference in Quantity" as the difference between the current total MPS quantity specified and the sum of the already existing MPS order quantity for the current period.

The system modifies or reduces any existing order for which the status is greater than or equal to “Accepted” and less than “Released' in the MPS for the item/planning group Organization Unit in the current period to the extent of the "Difference in Quantity" i.e. the quantity reduced. If the pending quantity where the Difference in Quantity is less than zero still exists, then the system reduces the quantity or deletes the order on the MRP orders for the item/planning group Organization Unit having status less than “Released” in the current period to the balance quantity. The MRP Released quantity will also be reduced to the extent of the MRP order reduced/deleted. If the MPS option is "All sources" and further if "Release for MRP" check box is checked, the system invokes the MRP release function and releases the MPS details for MRP. If the release option “Complete” is selected then the system retrieves all the MPS Orders for the planning group/item/variant in all the periods else the system retrieves only the orders to the period selected in Release Upto field. For the quantity to be released in each period, the system creates a new work order in MRP. The new work order in MRP would be in status “Firmed”.

The request creation, deletion and order release are done immediately if the plan online field is checked. Otherwise they are executed in batch process.

To proceed, carry out the following

Select the “Edit MPS By Source” link at the bottom of the page to modify the MPS source details.

Select the “View Rough Cut Capacity Plan” link at the bottom of the page to view the rough-cut capacity plan details.

Select the “Upload/Download MPS” link at the bottom of the page to view the uploaded or downloaded MPS details.

Select the “Edit Work Order” link at the bottom of the page to modify the work order details.

Select the “View RCCP Exceptions” link at the bottom of the page to view the rough-cut capacity plan details.

Select the “Analyze Supply demand” link at the bottom of the page to view the supply details.

Select the “Analyze Item Plan” link at the bottom of the page to view demand details.

Select the “Inquire Company Stock” link at the bottom of the page to free stock information.

Select the “View Item – Manufacturing Information” link at the bottom of the page to view the manufacturing information of the item.

Master Production Schedule By Item – An overview

Master production schedule (MPS) defines for the short-run planning horizon (typically 6 months to 1 year in length) the production and purchase plans for the items/planning groups. It represents what the company plans to produce expressed in specific configurations, quantities, and dates. The major objectives of Master Production Schedule are to maintain the desired level of customer service, to make the best use of resources and to keep inventories at the desired level. The master schedule takes into account the forecasts, actual demand, the production plan, and other important considerations such as backlog, availability of material, availability of capacity, management policies and goals, etc.

In make-to-stock environments, fulfillments of the master schedule leads to the creation of stock ready to satisfy future orders. In make-to-order, the master schedule is really a schedule of final manufacturing work, since when the stock is produced, it is immediately and directly transferred to the customer for whom it has been made. You can plan for the requirements of the item by checking it against the stock on hand, work in progress and can plan at organization unit level or business unit level. The MPS is prepared based on various demands like dependant, independent and actual demands displayed in the multiline. The planner also suggests some orders to be considered during planning. The MPS orders are released to the MRP based on the release dates calculated for each of the MPS periods. For example, if the anchor date is “01/03”, the MPS horizon is “30 days”, MPS period is “5” and the current date is “08/03”, then the release periods are indicated as follows -> “Past due less than 5/03”, “10/03”; “15/03”, “20/03”, “25/03”, “30/03”, “04/04” and “09/04”.

You can display the quantity of the end products during each MPS period of the planning horizon in the multiline. The total MPS quantity to be released to the MRP can be specified and can also specify the quantity to be partially released to the MRP during the period. The whole process can be executed in online or batch mode. In online mode, you can accept the orders immediately. In batch mode, you can execute the orders as and when required. The system accepts and saves the MPS created for the selected item/planning group.