MANAGE MASTER PRODUCTION SCHEDULES

Use this screen to view and maintain a master production schedule for a given part. This screen displays the results from Update Master Production Schedules screen and also allows you to create and maintain forecasts and supply orders manually. You can see the "official" MPS plan (labeled P to indicate that it is the Production plan) as well as "what-if" plans here.

On this screen, you can add, modify, or delete sales and user-defined forecasts for MPS and MRP planned parts. Costpoint uses these forecast quantities, along with other independent demand, to drive the MPS and MRP planning processes and generate planned orders and action messages as appropriate. For parts that are not MPS planned, you can create and maintain forecast information but you cannot create or maintain planned orders for that part on this screen.

You can also use this screen to add, modify, or delete planned orders for MPS planned parts. You can view and implement MPS action messages on this screen.

MPS Planning-only parts allow you to specify a forecast for a product family without knowing the exact part configuration and options that will be sold in the future. MPS Planning-Only parts are defined using a part type on the Manage Parts screen in the Product Definition module. These parts do not represent actual, physical, parts; they are used to hold combinations of different options along with the anticipated sales mix percentage for each option. This option mix information is stored in the manufacturing bill of material. For example, if you sell a computer workstation with options for different hard disks, you can define a manufacturing BOM that reflects the percentage of each hard drive you anticipate selling. For instance, if you sell 200-gigabyte hard drives three times more often than 350-gigabyte hard drives, you can set up a BOM component quantity of .75 for the 200-gigabyte hard drive and a .25 component quantity for the 300-gigabyte hard drive.

Since MPS planning-only parts are not "real" parts, you can create orders for them or store them in inventory. You can use forecasts to generate planned orders for MPS planning-only parts, but you cannot firm these planned orders—they are used only for driving MRP requirements for lower-level components and subassemblies. When sales orders are received for regular parts, you can have Costpoint consume the forecast quantities for MPS-planning only parts.

Before using this screen, you must create parts, including parts with a planning type of MPS, and define MPS plan types.

You will typically use this screen both before (to enter forecast data) and after (to view and adjust planned orders and action messages) processing the Update Master Production Schedules screen.

On this screen, you can:

Enter filter criteria in the header before clicking .

Location

Part

Enter, or click to select, the part for which you are reviewing or modifying the master production schedule.

Rev

Enter, or click to select, the part revision number (if one exists) for the part you are scheduling.

This field is disabled if the Allow Multiple Revisions for Each Item check box is not selected on the Configure Product Definition Settings screen.

U/M

This non-editable field displays the part's inventory, or default, unit of measure.

Part Security

This field is visible only if the Use Part Data Security Controls check box is selected on the Configure Product Definition Settings screen, which indicates that the part is subject to data security restrictions, as defined in the International Traffic in Arms Regulations (ITAR) or the Export Administration Regulations (EAR).

If enabled, this field displays one of the following values to indicate whether the part you are accessing is subject to part data security restrictions and whether you have the necessary authorization to access information for that part:

The features in this release relating to Part Data Security are intended to assist your company in achieving ITAR compliance. However, it is each company’s responsibility to confirm that it is meeting its obligations with respect to ITAR or other applicable requirements. Deltek does not warrant that use of this functionality will result in compliance.

Inventory Project Selection

Option

Select one of these settings from the drop-down list:

Project

If you set the Option to Single Project, Top-Level Project, or Project Planning Group, enter, or click to select, the project to include in the schedule.

Netting Group

If you set Proj Selection Option to Netting Group, use this field to enter, or click to select, the netting group of projects to include in the schedule.

MPS Plan

Enter, or click to select, the code for a "what-if" plan. Enter P (Production) for the "official" MPS Production plan

Schedule Display Option

From the drop-down list, select the schedule display setting:

Include Product Family Supply/Demand

Select this check box to combine supply and demand data (including forecasts) for all parts in the same product family. A product family includes all parts that reference the entered header part as the MPS planning part on the Manage Item Billings application in Product Definition.

Warehouse

If you selected the Plan Warehouse Separately check box (on the Corporate Settings block of the Configure Material Requirements Planning Settings screen), Costpoint plans supply and demand records separately for each warehouse. This field is hidden if the Plan Warehouse Separately check box is not selected.

If the Plan Warehouse Separately check box is selected, you can optionally enter a warehouse for which you want to see inventory, supply and demand data. If you do not specify a warehouse, then inventory, supply, and demand from all warehouses displays.

On-Hand Quantity

This field displays the total inventory quantity from all on-hand locations for the specified part, project and warehouse criteria. If you selected the Include Product Family Supply/Demand check box, it includes on-hand inventory from other parts in the same product family.

Other Inventory Quantity

This field displays the total inventory quantity from all in-inspection, reinspection, and shipping locations for the specified part, project, and warehouse criteria. If you selected the Include Product Family Supply/Demand check box, it includes on-hand inventory from other parts in the same product family.

If the Incl MRB as Available Inventory check box is selected on the Configure Production Control Settings screen, this number includes MRB (Materials Review Board) location inventory as well.

Execute

Click to load the master production schedule for the criteria entered above.

Schedule

Date

For all display options, there may also be row with Past Due in the Date field. This represents all open supply and demand quantities that are due or needed prior to the current date.

For all display options, there may also be a row with Future in the Date field. This represents all open supply and demand due/needed past the Total Weekly MPS Display Horizon field on the Configure Master Production Scheduling Settings  screen.

Open Sales Forecast Qty

This field displays the sum of open, unconsumed, sales forecast quantity needed for the given part/projects/warehouse/MPS plan, within the specified date/period. If the Include Product Family Supply/Demand check box is selected, it includes open sales forecast quantities from other parts in the same product family.

Sales Order Demand Qty

This field displays the sum of open (not issued) sales order inventory demand for the given part/projects/warehouse, due to be shipped within the specified date/period. If the Include Product Family Supply/Demand check box is selected, it includes open sales order quantities from other parts in the same product family.

If the Pending Sales Orders check box in the Include as Demand group box on the Configure Material Requirements Planning Settings screen is selected, this field includes quantities from sales orders with a status of Pending, In-Approval, and Approved. If the check box is not selected, only approved sales orders are included in the calculation.

Open UDF Forecast Qty

This field displays the sum of open, user-defined forecast quantity needed for the given part/projects/warehouse/MPS plan, within the specified date/period. If the Include Product Family Supply/Demand check box is selected, it includes open user-defined forecast quantities from other parts in the same product family.

The actual column label depends on what is entered in the User-Defined Forecast Label field on the Configure Master Production Scheduling Settings  screen; if that field is not populated, this column is hidden.

Other Demand Qty

This field displays the sum of open (not issued) non-sales order, inventory demand for the given part/projects/warehouse, within the specified date/period. If the Include Product Family Supply/Demand check box is selected, it includes open requirement quantities from other parts in the same product family.

Other demand includes inventory requirements for manufacturing orders and reservations. If the Pending Inventory Requests check box is selected in the Include as Demand group box on the Configure Material Requirements Planning Settings screen, this field includes quantities from unapproved inventory requests. If the check box is not selected, inventory requests are not included in the calculation.

Planned Order Rqmt Qty

This field displays the sum of requirement quantities for all non-firmed planned orders for the given part/projects/warehouse/MPS plan, within the specified date/period. If the Include Product Family Supply/Demand check box is selected, it includes planned order requirement quantities from other parts in the same product family.

If you did not select the Include Product Family Supply/Demand check box and the part is defined as a MPS planning-only part, this column is hidden, as planned order requirements do not apply to MPS planning-only parts.

Total Demand Qty

This field displays the sum of the Open Sales Forecast Qty, Sales Order Demand Qty, Open UDF Forecast Qty, Other Demand Qty, and Planned Order Rqmt Qty fields for this row.

Firmed Supply Qty

This field displays the sum of all firmed supply orders (requisitions, purchase orders and manufacturing orders) and transfer reservations owed to the project for the given part/projects/warehouse/MPS plan, within the specified date/period. If the Include Product Family Supply/Demand check box is selected, it includes supply order quantities from other parts in the same product family.

If the Include Product Family Supply/Demand check box is not selected, and the part is defined as a MPS planning-only part, this column is hidden, as firmed orders cannot be created for MPS planning only parts.

Firmed Supply Yield Qty

If Incl Scrap/Yield % in Planning Process check box is selected on the Configure Production Control Settings screen, the firm PO and requisition quantities are multiplied by the part's yield quantity and added to the anticipated yield quantity for each open MO and the transfer reservation quantity to determine the anticipated yield quantity of the open supply orders.

If the Incl Scrap/Yield % in Planning Process check box is not selected, this column is hidden.

If the Include Product Family Supply/Demand check box is not selected, and the part is defined as a MPS planning-only part, this column is hidden, as firmed orders cannot be created for MPS planning only parts.

Planned Order Qty

This field displays the sum of all non-firmed planned order quantities for the given part/projects/warehouse/MPS plan within the specified date/period. If the Include Product Family Supply/Demand check box is selected, it includes planned order quantities from other parts in the same product family.

Planned Yield Qty

If the Incl Scrap/Yield % in Planning Process check box is selected on the Configure Production Control Settings screen, this quantity includes the sum of all non-firmed planned order yield quantities for the given part/projects/warehouse/MPS plan, within the specified date/period. If the Include Product Family Supply/Demand check box is selected, it includes planned order quantities from other parts in the same product family.

If the Incl Scrap/Yield % in Planning Process check box is not selected, this column is hidden.

Total Supply Qty

This field displays the total quantity planned to be received during the time period. It is the sum of the Firmed Supply Qty and Planned Order Qty for this row.

Total Yield Qty

This field displays the sum of the Firmed Supply Yield Qty and Planned Order Yield Qty for this row.

If the Incl Scrap/Yield % in Planning Process check box is not selected on the Configure Production Control Settings screen, this column is hidden.

Projected Available Qty

This field displays the quantity of parts available as of the given date after accounting for existing inventory, scheduled order receipts, and planned issues (including forecast quantities). A positive number indicates that there is anticipated to be excess inventory for that part as of the period end date. A negative number indicates there will be a shortage, and that all anticipated demand as of that date will not be met.

For the first row in the schedule, the Projected Available Qty is calculated by adding current on-hand and other inventory quantities, along with all projected supply order quantities for that period (Total Supply Qty). The demand quantity needed that period (Total Demand Qty) is subtracted from this sum to determine the projected available quantity.

For all subsequent rows, this quantity is calculated by taking adding all Total Supply Qty for that period to the previous period's Projected Available Qty subtracting the Total Demand Qty needed that period. If the Incl Scrap/Yield % in Planning Process check box is selected on the Configure Production Control Settings screen, the Total Yield Qty is used in place of the Total Supply Qty.

If the Include Product Family Supply/Demand check box is selected, this quantity includes inventory, supply, and demand for all parts in the product family.

This quantity is set to zero if the part is a MPS planning-only part.

Available to Promise Qty

The Available to Promise Qty represents inventory that is available for any new sales orders (or other demand) that have not yet been scheduled. The Available to Promise (ATP) quantity calculation looks only at firm demand; it does not include any forecast or safety stock quantities. If the Pending Sales Orders check box is selected in the Include as Demand group box on the Configure Material Requirements Planning Settings screen, order quantities from pending sales orders are also included.

The ATP quantity is calculated for the first row (excluding the past-due row) and is recalculated for other periods only when a new supply order is due. The ATP quantity for this row is the sum of the on-hand quantity, the other inventory quantity, the projected supply order quantities for that period (Total Supply Qty) and any past-due Total Supply Qty minus the sum of the Sales Order Demand Qty, the Other Demand Qty (not including safety stock) for the first row, the past-due row, and all subsequent rows until you come across a row where the Total Supply Qty is greater than zero (that is, that row's supply and demand quantities are not included).

That same ATP quantity displays in all subsequent rows until a row is found with a supply order due that period. For this row, the previous ATP quantity is summed with the row's Total Supply Qty. From this quantity, Costpoint subtracts the sum of the Sales Order Demand Qty and the Other Demand Qty for the current row and all subsequent rows until you come across a row where the Total Supply Qty is greater than zero to determine the new ATP.

This column is hidden if the part is a MPS planning-only part or if the Include Product Family Supply/Demand check box is selected.

Projected Available and ATP Example

Safety Stock Qty

This field displays the sum of safety stock quantities for the selected parts and projects specified on the screen's selection criteria. Safety stock quantities are defined on the Manage Parts screen in the Product Definition module.

This column is hidden if the part is a MPS planning-only part or if the Safety Stock check box is not selected in the Include as Demand group box on the Configure Material Requirements Planning Settings screen.

Orig Sales Forecast Qty

This field displays the sum of the original sales forecast quantity needed for the given part/projects/warehouse/MPS plan, within the specified date/period. It typically contains both consumed and unconsumed forecast quantities. If the Include Product Family Supply/Demand check box is selected, it includes original sales forecast quantities from other parts in the same product family.

Pending Request Qty

This number represents total quantity that have been requested within this period for inventory requests with a status of Pending.

If the Include Product Family Supply and Demand option is not selected, and the part is defined as a MPS planning-only part, or if the Include as Demand – Pending Inventory Requests check box is checked in MRP Settings, this column is hidden.

Orig UDF Fcst Qty

This quantity represents the sum of the original sales forecast quantity needed for the given part/projects/warehouse/MPS plan, within the specified date/period. It may be the same or different than the Open UDF Forecast Quantity, depending on how the forecast records were updated. If the Include Product Family Supply/Demand check box is selected, it includes original UDF forecast quantities from other parts in the same product family.

The actual column label depends on what is entered in the User-Defined Forecast Label field on the Configure Master Production Scheduling Settings screen. If the this field is not populated, this column is hidden.

Inside MPS Time Fence

If the current row's Date is within the calculated MPS time fence for this part, Y displays in this column.

The MPS time fence is determined by the MPS Time Fence Method option on the Configure Master Production Scheduling Settings screen. The number of days within the time fence can be calculated from part–specific information found on the Manage Parts screen in Product Definition, or can be specified directly in the MPS Planning Time Fence (Days) field on the Configure Master Production Scheduling Settings screen.

Inside SO Time Fence

If the current row's Date is within the defined sales order time fence for this part, Y displays in this column.

The number of days within the time fence is maintained on the Planning Details subtask of the Manage Parts screen.

Inside Part Lead Time

If the current row's Date is within the calculated lead time for this part, Y displays in this column.

The lead time, in days, is maintained on the Planning Details subtask of the Manage Parts screen.

Inside Cumulative Lead Time

If the current row's Date is within the cumulative lead time for this part, Y displays in this column. The cumulative lead time for a part is defined as the lead time required to complete the part, including purchasing and manufacturing lead times for any required components and subassemblies.

The cumulative lead time, in days, is maintained on the Planning Details subtask of the Manage Parts screen.

Subtasks

Subtask

Description

Load Forecast

Click this link to access the Load Forecast subtask.

Product Family

Click this link to access the Product Family subtask.

Part Detail

Click this link to access the Part Detail subtask.

ECNs

Click this link to access the ECNs subtask.

Forecasts

Click this link to access the Forecasts subtask.

Planned Orders

Click this link to access the Planned Orders subtask.

Action Messages

Click this link to access the Action Messages subtask.

Supply

Click this link to access the Supply subtask.

Demand

Click this link to access the Demand subtask.

Inventory  Detail

Click this link to access the Inventory Detail subtask.

Substitutes

Click this link to access the Substitutes subtask.