|
|
|
|
|
This report is a transaction report. Report Information.
Select the “Master Production Schedule” link under the “DP Reports”.
The “Master Production Schedule” page appears.
Enter the following field in the “Report Filters” group box:
|
Business Unit |
Use the drop-down list box to select the business unit. Mandatory. The system populates the values from the “CIM Model” business component. The system displays the login BU by default on launch of the p age. |
|
Plant |
Use the drop-down list box to select the valid plants where the items are identified. The system retrieves the warehouse organization units. The system displays “Blank” by default on launch of the page. |
|
From Date |
The starting date in the range of dates from which you want to view the master production schedule details. If this field is left blank, then the system displays current date by default. |
|
To Date |
The ending date in the range of dates from which you want to view the master production schedule details. Mandatory. |
|
Time Interval |
Use the drop-down list box to select the time interval in which you want to view the master production schedule details. Mandatory. You can select from “Daily”, “Weekly”, “Monthly” or “Yearly”. The system displays “Daily” by default on launch of the page. |
|
Matl. Planner |
Use the drop-down list box to select the material planners. The system retrieves the values from the “Organization Model” business component. The system displays “Blank” by default on launch of the page. |
|
Warehouse Code |
The code identifying the warehouse in which the item is identified. |
|
Plg. Group |
The code identifying the planning group. |
|
Item Code |
The code identifying the item. |
Click the “Generate Report” pushbutton to view the details of the material planner, which will help in developing and managing the master production schedule.
Based on the specification in the report filter, the system generates the report.
If the planning group field is specified, then the system generates master production schedule by planning group report. If the item code is specified, then the master production schedule by item code report is generated.
The system ensures that at least one of item code or planning group is specified. If both the fields are left blank, then the system displays an error message.
Based on the time interval selected, the system displays the report with the interval bucket. In case if the time interval selected is “Month”, then the time intervals should be in months with the first interval will be past due that is., displays data for all periods before “From Date”. The second interval will be “From Date” and third interval date as “sum of from date and time interval option”.
Based on the conditions specified in the filter criteria, the system displays the following:
Safety Stock – For the selected material planner, the system searches all the items in the item-warehouse planning parameters. If the items exist, then the safety stock of all the items appearing in more than one warehouse are calculated and displayed. If a specific warehouse is defined, then the safety stock restricted to the specified warehouse is displayed.
Sales Forecast – Displays the sum of all the orders (demands) in disposition having “Production Forecast” order category for which the due date falls in the period. The quantity represents the total quantity of the sale forecasts demanded for the item in a period.
Customer Orders – Displays the sum of all the orders (demands) in disposition having “Sale Order” order category for which the due date falls in the period. The quantity represents the total quantity of the sale orders for the item in a period.
Explode Demand – Displays the sum of all the orders (demands) in disposition having “Hierarchy Orders” order category for which the due date falls in the period. The quantity represents the exploded forecast quantity.
Master Schedule – Displays the sum of all the MPS orders (receipts) in disposition for which the due date falls in the period excluding the orders having “Requested” status. The quantity represents the total MPS quantity in a period.
Projected Available – Displays the quantity for each period. For the first period, total demand for the period is deducted from (on hand and total MPS quantity). For the next periods, total demand for the period is deducted from (last period projected balance and total MPS quantity).
Available To Promise (ATP) – Displays the quantity for each period. For the first period, actual firm demands for the period is deducted from (on hand and total MPS quantity). For the next periods, actual firm demands for the period is deducted from total MPS quantity. If the ATP quantity is negative then the quantity is reduced from the previous periods until a positive balance exists in the previous periods or the ATP quantity of the current period becomes “zero”. Finally, the system displays the cumulative ATP quantity.
Master Production Schedule – An Overview
This report gives a picture to the material planner about developing, managing and controlling the Master Production Schedule (MPS). The MPS consists of sales forecasts, customer orders, exploded demands and master schedules. Projected available balance quantity and the quantity available to promise are calculated. The calculations are used to assist the master scheduler. The projected available balance calculation displays the projected stock build-up or depletion to the master scheduler. The available to promise displays the new customer orders that can be promised for delivery based on the current MPS.
This page allows you to set the criteria to generate a report for a set of items or planning groups. You can generate a master production schedule for the selected business unit. The plant or the warehouse where the MPS items are identified can also be set as a part of the criteria. You must select the time interval as “Daily”, “Monthly”, “Weekly” or “Yearly” based on which the MPS is generated. You must also specify the planning group or the item along with the range of start and end dates that also form a part of the criteria.
The MPS report is depicted in form of a graphical representation and the corresponding details are listed in form of a report. The report represents periodwise (x-axis) and quantitywise (y-axis) graphical chart. The chart displays the total quantity of all the sales forecasts, sale orders in the form of customer orders and exploded forecasts for the items in the period. All these demands are summed up and depicted as total demand. The sum of all the MPS orders (receipts) for which the due date falls in the period and excluding the orders in “Requested” status are depicted as total supply. The on hand considers the minimum and maximum quantity along with the safety stock.
The supply quantity is the total MPS quantity based on which the Projected On Hand (POH) and Availability To Promise (ATP) quantity is calculated. The projected available quantity is calculated for the first period with respect to quantity on hand, total MPS quantity and total demands for the period and the next period with respect to last period projected balance, total MPS quantity and total demands for the period. The ATP quantity is calculated for the first period with respect to the quantity on hand, total MPS quantity and actual firm demands for the period and the next period with respect to the total MPS quantity and actual firm demands for the period. The ATP quantity is checked against the negative balance from the beginning of the period. If the negative balance exists, then the quantity is reduced from the previous periods until the ATP quantity arrives at a positive balance or becomes “zero”. The above process continues for all the periods with negative ATP quantity. Finally, the system displays the cumulative ATP quantity with respect to current period ATP and previous period cumulative ATP. You can view the corresponding statistical information of the MPS displayed below the graphical chart representation. All the transactions are displayed for the business unit.