Job & Capacity Planning

Version: As of version 16.03

Purpose

Material requirements planning (MRP) is a production planning, scheduling, and inventory control system used by companies to manage their manufacturing processes. MRP systems are designed to ensure Raw Materials are available for production and to ensure Finished Goods are available for delivery to customers. In addition, MRP helps companies maintain the lowest possible material and product levels, plan manufacturing activities, and manage delivery schedules. MRP looks at the demand for items, based on Sales Orders, production Jobs, or reorder points, and projects the usage of intermediates and Raw Materials based on that demand and the active default Bills of Materials for all items.

There are three distinct ways in DEACOM to satisfy material demand for an item:

Make - Accomplished through creating a new Job for that item.
Buy - Accomplished through creating a new Purchase Order for that item.
Transfer - Accomplished through creating an Inter-Company Transfer for that item.

MRP aggregates all supply and demand to provide a single view of expected inventory levels. The table below shows what makes up supply and demand.

Supplies	Demands
On Hand Reserved Issued QC Purchase Orders Jobs Inter-Company Transfers	Sales Forecasts Indirect requirements Job requirements

Optimizing product availability

DEACOM’s MRP approach is to provide a filtered list of only those items requiring action by the user. These items include those that are purchased from outside suppliers and Subassemblies that are components of other items produced internally, as well as Finished Goods. The MRP functionality calculates demand based on scheduled Sales Orders, scheduled production Jobs, and indirect requirements. Indirect requirements are defined as the quantity of materials required to satisfy suggestions for the displayed item in the Bill of Materials. As an example, a Raw Material used to make a Finished Good will have an indirect demand showing in MRP if a Sales Order for the Finished Good is entered. Production Jobs are not required in order to see the material requirements for a specific Raw Material because DEACOM takes scheduled Sales Orders into consideration when calculating MRP.

Comparing Instant vs. Time-Phased MRP

In DEACOM, the MRP transaction provides a benefit to users by offering two different views of the supply and demand for items.

Instant MRP - A single bucket (which may be run “wide open” or filtered for a specific date range) that displays all the supply and demand for items including unscheduled Purchase Orders, Jobs, and Sales Orders, even if they do not have a due date assigned. This approach may be useful for troubleshooting or high-level analysis. The ability to add additional fields to the grid for quick sorting and filtering may be a plus.
Time Phased MRP - Multiple time buckets (days, weeks, and months) based on the due dates assigned to Purchase Orders, Jobs, and Sales Orders in the system. This approach is critical to ensure that incoming material receipts and production orders are scheduled to occur on time. This approach is also useful when dealing with items requiring a significant lead time.

In an Instant MRP report, the overall status of all items is visible. In this view, it is also possible to have several different views by leveraging any of the four Instant MRP reports. Each report may have a different default setting or grid layout.

In a Time Phased MRP report, there is a much different view. With the choices selected on the pre-filter, the grid may only showing items that require attention. In addition to what items need Jobs, the user sees when they need to take action

Using MRP in DEACOM

The typical method for running MRP is from the Inventory > MRP menu however, DEACOM also provides buttons to run MRP on the Sales Order, Job, and the View BOM forms.

When viewing a Job, the "Job MRP" button is available.
When viewing a Sales Order, the "Order MRP" button is available.
When viewing a Bill of Materials, the "BOM MRP" button is available.

While there are some valid use cases for running MRP directly from a Sales Order, Job, or even a BOM, a typical path for daily activities would be to run MRP from the Inventory menu. The steps necessary to run MRP reports are included below followed by sections dealing with the fields available on MRP forms and the definition of what type of information is contained in the various MRP report columns. The focus for this page is production, not purchasing.

Security and Configuration

Security / Permissions See your system administrator for security access.

Configuring for MRP in the Item Master

any item that needs to be taken into consideration when using MRP needs to be setup properly on the Item Master record within DEACOM via Inventory > Item Master. Item Master setup includes:

On the General tab:
- Define a "Scrap %" - Defines the scrap percentage for this item and allows users to define the material used to complete the Job versus the final amount actually produced. For more information, refer to the Utilizing Scrap Factors page.
On the Properties tab:
- Check the "Include in MRP" flag
- Check other MRP Job flags as desired - Split MRP Jobs By Job Quantity, Create Separate MRP Job. For more information on these flags, refer to the definitions available on the Item Master page.
On the MRP tab:
- Define items as desired. Information on the MRP tab is used when running MRP reports in the system. If running MRP for a specified facility and facility-specific MRP information is present in the Facilities tab and set as active, MRP will use the information on the Facilities tab instead. If MRP is run without specifying a facility, or the facility specified does not have MRP information loaded, the information on the item master MRP tab is used. The table contained in the Item Master page has details regarding the fields available on the MRP tab and an example is detailed below.
On the Facilities tab:
- Optional; the facility tab on the item master allows companies to manage inventory in multiple locations as well as offering the ability to configure MRP options that will apply to this specific facility when MRP reports are filtered by facility.

Example: Splitting MRP Jobs and the Job Minimum/Maximum fields

The below example illustrates the use of the job minimum and job maximum fields.

Example 1:

MRP suggested quantity to satisfy demand = 10,000 units
Job Minimum field = 1,500
Job Maximum field = 3,000
“Split MRP jobs by job quantity” flag is checked for this item.

If using the “Create Job” or “Auto Job” button the system will create four jobs for 3,000 – 3,000 – 2,500 – 1,500 (the last job size is set to the minimum and the difference is subtracted from the second to last job).

Example 2:

MRP suggested quantity to satisfy demand = 10,000 units
Job Minimum field = 0
Job Maximum field = 3,000
“Split MRP jobs by job quantity” flag is checked for this item.

If using the “Create Job” or “Auto Job” button the system will create four jobs for 3,000 – 3,000 – 3,000 – 3,000 (total is 12,000 because no minimum is set).

Note: The “Split MRP Jobs By Job Quantity” and “Create Separate MRP Job” flags may be used together when desired.

Configuring a Part's Item Master

Any item that needs to be taken into consideration when using MRP needs to be setup properly on the Item Master record within DEACOM. Generally, this means entering values in fields and checking off flags as appropriate, but users also have the option to configure Facility-specific MRP options on a part-by-part basis. The Facilities tab contains almost all of the same fields that are listed on the MRP tab.

Navigate to Inventory > Item Master > select a Part from the pre-filter > click "Modify".
On the MRP tab, fill in values for the fields listed.
1. Min Quantity 1 / Min Quantity 2 - These represent your minimum stock level, otherwise known as Safety Stock. This inventory is to cover those times when you would run out of inventory due to higher than expected demand or insufficient planning. MRP will attempt to never let you drop below this stock level. Having two figures allows you to define different min levels for high demand season vs lower demand season. You select which minimum to consider each time you run MRP. Optional.
2. Max Quantity 1 / Max Quantity 2 - These represent your maximum stock level. Typically set in conjunction with a minimum level. With a maximum level set, whenever MRP triggers a suggestion, it will suggest enough supply to bring you to up to your Max. Optional.
3. Incremental Job Quantity - If you have an incremental Job Qty set, MRP calculate demand and then round up to the next increment. When working in conjunction with a Max, MRP will suggest enough supply increments to meet or exceed your max.
4. Job Minimum - If there is a Job Min, any suggestion will be rounded up to at least the job minimum qty.
5. Job Maximum - Typically used to limit a job to the maximum size that can be handled by a batch tank or vessel.
6. MRP Groups - The feature is designed so that when the "Create Job" button is used in MRP all items belonging to the group will be added to the same production job. An example might be Bulk red paint along with 5 gallon, 1 gallon, quart, and pints.
On the Properties tab, check off flags for MRP options as desired.
1. Include in MRP - Items without this property are ignored by MRP
2. Split MRP Jobs by Job Qty - Once MRP calculates total demand, it will split it into multiple jobs with a max size of the Job Maximum
3. Create Separate MRP Job - When selecting multiple suggestions on the MRP report and creating jobs, items with this property set will appear on their own Job.
4. Include Subassemblies in MRP Jobs - This is used to create multi-line jobs. It can be used for combining bulk jobs and their packaging Jobs for example.
Navigate to the Facilities tab. If, when running MRP, Facility-specific options for this item should be used, click "Add" to setup new Facility specifications or select and existing Facility and click "Modify".
1. On the General tab, check off the "Use Reorder Points" flag. Note: If the use flags option is not checked or a Facility is not selected on the MRP pre-filter, the system will fall back on the settings defined on the base Item Master.
2. Fill in the reorder points fields ("Min Quantity 1" through "Lead Minutes") as desired then save and exit the Edit Item Facility form.
Once all information has been entered on the Edit Item Master form, click "Save" and "Exit" to commit the changes and close the form.

Note: for information on any of the fields mentioned above, refer to the appropriate tab's section in the Item Master page.

Adding MRP Groups

MRP Groups are used to group together items that share similar characteristics. This feature is designed so that when the "Create Job" button is used within MRP, all items belonging to the group will be added to the same Production Job. This feature should not be used if the "Create separate MRP job" flag is checked on the Item Master Properties tab. Once created, MRP Groups can be assigned on the Item Master MRP tab (discussed below).

Note: If all items are selected and the "Create Job" button is used, all items without an MRP Group will be placed together on a single Job.

Configuring System defaults

Navigate to Inventory > Options > Inventory tab.
1. Enter a value in the "MRP Decimals" field to dictate how many decimals the system should use when displaying results in MRP.
2. Select a specific pre-filter to use in MRP via the "BOM MRP Pre-Filter" field.
3. Save all changes and exit the form.
Navigate to Purchasing > Options.
1. Select whether Purchase Orders entered through MRP should be created as Requisitions or regular Purchase Orders via the "MRP Order Type" field.
2. Save all changes and exit the form.
Navigate to Sales > Options.
1. On the Order Entry tab, select how Sales Orders should be entered using MRP via the "MRP Order Type" field.
2. On the Scheduling tab, select a specific pre-filter to use in MRP via the "SO MRP Pre-Filter", "SO MRP Show All", and "SO MRP Facility" fields.
3. Save all changes and exit the form.
Navigate to Production > Options > Other tab.
1. Select a specific pre-filter to use in MRP via the "Job MRP Pre-Filter" and "Job MRP Show All" fields.
2. Save all changes and exit the form.

Related Processes

Procedures

Saving MRP pre-filters

As with many pre-filter forms, DEACOM provides the ability to save the field settings. For example, if one user is tasked with running MRP to create production Jobs but not responsible for creating Purchase Orders, the settings should probably be changed so that the pre-filter defaults to manufactured items only. There may also be different settings used for Subassemblies versus Finished Goods. To save MRP pre-filter settings:

Navigate to Inventory > MRP.
Enter the settings and values to be saved.
Click the "Settings" button then, on the Settings form, click "Add".
Enter a Name for the saved settings, such as "Production - Finished Good MRP".
In the "Save For" field, determine if the pre-filter will be saved for only the current user or all users.
Checking the "Default" flag will use these settings automatically whenever the form is opened.
Click "Save" and close the Edit Saved Pre-Filter form.

Typically, when MRP is run directly from a Sales Order, Job, or BOM, the user will be presented with the Instant MRP results grid. If saved MRP pre-filters have been created and are available for all users, they may be used as default views for several Production Options fields. To set these defaults, navigate to Production > Options > Other tab and select the desired records in the "SO MRP Pre-Filter", "Job MRP Pre-Filter", and "BOM MRP Pre-Filter",

Viewing the MRP report form

Once MRP pre-filter selections have been made, clicking the "View" button generates the report. The MRP results screen is comprised of four main areas.

MRP Part information - The first section contains information about the item, such as the Part Number, description, lead time, UOM, Minimum and Maximum stock levels, etc.
Supply vs. Demand - The next section shows how MRP calculates Supply and Demand. Values that are preceded with + are calculated as Supply while values that are preceded with – are considered Demand.
1. Note (-M) Sales and (-M) Forecast. This is used to signify that MRP will use the greater of the Forecast or the Sales figures. If there is a forecast of 1,000 pieces, but only have 800 in sales for an item for a bucket, MRP will use the greater of the two (1,000) for calculating demand. This ensures that MRP is not double-dipping.
2. QC does not have a + or – sign. Depending on the settings chosen in the pre-filter, inventory currently in QC is shown for information only. There are additional settings on the pre-filter that determine how inventory in QC will affect the Supply and Demand calculations.
3. Finally, the last entry for each item is the Suggestion. This is the result of the calculation of adding all Supply and subtracting all Demand.
Time-based information - The next section lists the time “buckets”. The number of buckets selected on the pre-filter determine how many columns are displayed along with the time frame represented by each column. The total net quantity is the sum of all the part supplies minus the sum of all the part demand (the calculation is laid out in more detail below).
1. If there is any value under 1, the system rounds the suggested value to 1.
2. The "MRP Decimals" field in Inventory > Options is available to display 0, 1, or 2 decimal places on MRP results. A description of the information in these three sections is included in the MRP page.
MRP buttons - At the top of the form, there are buttons that are used for executing the suggestions shown on the grid. These buttons can be used to provide additional details regarding selected items or to create the necessary sales, production, purchasing, and inter-company transfers to satisfy the demand for these items. For information on using these buttons, refer to the Using the "Create Job" and "Auto Job" Functions, Using the "Create PO" and "Auto PO" Functions, and Using Inter-Company Transfers pages.

Evaluating transaction dates

Several transaction dates and other fields are evaluated by MRP when calculating when what demand exists, when supplies will be available, and in what buckets suggestions should be made.

Due To Ship - The "Due To Ship" date is maintained on the Dates tab of Sales Orders and represents the date by which products must be completely finished and ready for shipment, including any packaging or shipping prerequisites. Sales Order and Forecast orders use this date to determine into which bucket the demand based on this order will be displayed. If a sales or forecast order does not have a "Due To Ship" date it will not appear in MRP unless the MRP report is run with a "Bucket Type" of “All” and starting and ending dates are not selected.
Safety Days - Safety days are maintained on the Item Master MRP tab and represent the number of days that products must be completely finished and ready for shipment before the Due to Ship date. Safety days will set the "Planned Finish" date of a Job to be earlier when a Job is created via MRP. This is the safety factor.
Lead Time - Lead time represents the total time required to manufacture an item. For make-to-order products, it is the time taken from release of an order to production and shipment. For make-to-stock products, it is the time taken from the release of an order to production and receipt into Finished Goods inventory. Lead time will set the "Planned Start" date of a Job to be earlier when a Job is created via MRP. In DEACOM, an item’s lead time determines in which bucket or time period the suggestion(s), and in certain cases the indirect requirement(s), will appear.
- Items may have Facility-specific lead times. If an item has a Facility Part Cross Reference, and the cross reference is flagged to "Use Reorder Points", creating a Job from MRP in that Facility will use the Facility lead time instead of the Item Master lead time.
- Sales Orders and Jobs that occur in the future and outside of the date range of the MRP report will have their requirements included if the lead time of the component would push it into the date range of the report.
Due to Dock - Inter-Company Transfers - Used in connection with Inter-Company Transfers only, the "Due To Dock" date defines the date the order is expected to arrive at the destination Facility and used by MRP to determine when the inventory is scheduled to arrive. If this field is left empty, the "Shipped" date is used. If the order hasn't been shipped, the "Due To Ship" date is used instead.
- Note: "Due To Dock" date may be changed after an order has been shipped, but not after its been received, via the "Modify Info" button when viewing the order in Sales > Order Reporting.

Analyzing and acting on MRP reports

When run with the default display setting of Suggested > 0, the Time-Phased MRP report contains items Suggested by MRP for action. Each column will display the information used to calculate the suggested quantity considering inventory and job minimum/maximum quantities.

Interpreting Suggestions for Finished Goods

When running an MRP report, the report assumes that you are going to take action on all the parts based on the suggested quantity. For example, if MRP suggests you purchase 1,000kg of a part in the first week of the MRP run, the on hand bucket for the subsequent week will include the suggested 1,000kg because it assumes the purchase order was created for this part. Suggestions can be ignored in the MRP report by setting the "Suggestions" pre-filter option to "Exclude". This option would exclude suggested quantities from impacting the quantity shown in the on hand bucket in future periods on the MRP report. However, this is not a best business practice and should be used sparingly by organizations. The reason why suggestions should be included is best illustrated through examples.

Impact of Suggestions on Raw Materials

MRP makes a suggestion to purchase in the first bucket (an item with zero lead time), and includes that suggestion into the on hand quantity of the first bucket. Demand in the second, third, and fourth bucket reduce that original on hand quantity (with suggestion included) to below the reorder point in the fourth bucket, so MRP makes another suggestion to purchase more in the fourth bucket. If the suggestion were not included in the first bucket’s on hand quantity, each of the four buckets would be below the reorder point, and you would get four suggestions instead of just the two.

Impact of Suggestions on Finished Goods

A finished goods example - MRP makes a suggesti to produce something in the fourth bucket. MRP then assumes that when that time comes, somee will create a job for that quantity. The raw materials needed have a three week lead time, so MRP is going to take that suggesti, explode its BOM, and include those demands as indirect requirements for the raw materials. That may or may not create suggestions for those raw materials, depending on on on-hand quantities and other demands. Without the assumption that the suggestion will be followed, when the time comes, there is no way to plan for the raw materials to be purchased, if necessary.

Impact of Suggestions on the MRP Setup

The realization that the system assumes that the suggestions will be used, as is, is critical to the way that you set up your items to create correct suggestions. If a suggestion is made in the fourth bucket to make 1000 lbs of a product, MRP makes suggestions for raw material purchases to support that future planned job. When the time comes to actually create the job, when the suggestion is either in the first or second bucket (but not four weeks in advance), if the production planner increases the job quantity, they are attempting to produce a quantity for which the raw materials have not been planned for. If they decrease the job quantity, then excess raw materials may be on hand which would not have been necessary if the original production suggestion was correct in the first place. The second situation means excess inventory, which is certainly not desirable, but the first situation results in the possible inability to produce the job, and arguments between production and purchasing as to who is at fault. The fault is in the setup of the MRP variables on the finished good, which resulted in an incorrect suggestion in the first place.

Impact of not reacting to Suggestions in a timely manner

The example above points out how last-minute changes to quantities may impact perceived MRP performance. An even larger danger is not reacting soon enough. In this scenario, MRP sees a demand cause by a Sales Order that is outside your window. MRP is aware of the lead time based on the item master and makes Purchase or Job suggestions. Since the material requirements show up as Indirect, the planner does not react to them. Later, when time has past and the demand is visible, when the Job is created there is not enough time to order the materials and/or produce the finished good. A Job is created, but MRP sees that the job won’t finish until the day after the SO is Due to Ship. MRP sees the shortfall and makes another suggestion. Creating more Purchase Orders or Jobs will not satisfy the suggestion.

Viewing details (drilling down)

Recognizing the source of the supply and demand for materials

Users can drill down to see the supporting information for the values in the rows by double clicking the appropriate value on the MRP report.

Acting on suggestions

The buttons at the top of the form may be used to view additional information or edit Item Master settings. Once the MRP report is reviewed, suggestions reviewed, and details drilled into if necessary, it is time to act on the suggestions.

Simply clicking on the Suggestions line will change it from No to Yes.
The "Select All", "Select None", "Create Job", and "Auto Job" buttons may be used to create the appropriate Jobs to satisfy demand for these items.
Once items have been selected, via double clicking or using the "Select" or "Select All" buttons, click the "Create Job" or "Auto Job" button.
DEACOM will prompt for a Facility selection and once it is confirmed, the Auto Job Setup form is displayed.
Double clicking on the item will allow the user to edit the Job information, including selecting a different Revision or updating the quantity.
Save any changes then click "Continue" to display the Job.

Once users have completed the necessary analysis or performed the necessary transactions, they may click the "Exit" button to close the report. In some cases, users may choose to leave the MRP report displayed for longer periods. In these cases, the "Refresh" button located on the DEACOM toolbar may be used to update the report without re-running the pre-filter. Keeping on top of MRP Suggestions and even running MRP iteratively with different views makes analysis easier and provides a better outcome.