Field descriptions: MRP calculation justification

This page describes the fields for the MRP calculation justification page. The fields in each section are listed in alphabetical order.

Field Description
Calculation date The MRP calculation request generation date.
Calculation user The Sage Distribution and Manufacturing Operations user that requested the MRP calculation.
Companies

The parent company or companies included in the MRP calculation request.

Blank if Sites are listed.

Description

The MRP calculation result reference.

From item
To item

The range of items to be manufactured or bought in included in the MRP calculation request.

If the From item and To item are the same item code, the single named item only was included in the MRP calculation request.

Blank if all items and components of all released items are included in the MRP calculation request.

Period in weeks

The number of full weeks included in the MRP calculation forecast.

Monday is the first day of the week. If the Start date is not a Monday, the number of days from the Start date up to and including the first Sunday is calculated as 1 week.

Sites

The production site or production sites included in the MRP calculation request.

Blank if Companies are listed.

Start date

The date the starting stock level of each item is established and the weekly buckets determined.

Status

The MRP calculation status.

Completed: The MRP calculation is complete for the requested Start date.

In progress: The Start date is in the future. The MRP calculation is not yet complete.

Details grid

Field Description
Company ID

The parent company code.

Company name

The parent company name.

First suggestion date The date of the first generated suggestion.
Item ID

The code of the item to be manufactured or bought in.

Item name

The item name to be manufactured or bought in.

Preferred process

The method the MRP calculations recommend you use to replenish stock to meet the demand.

Purchasing: The suggested replenishment method is a purchase order.

Production: The suggested replenishment method is a work order.

Site ID

The production site code.

Site name

The production site name.

Item-site replenishment and transaction graph

Displayed when you select an item link in the Details grid.

Item-site replenishment rules

Field Description
Batch quantity

For manufactured items: The number of items to produce in a single batch run. The figure is the optimal size of the production batch.

For purchased items: The number of items to purchase in a single "lot". The figure is the most cost effective order quantity.

The item needs to be made or purchased in multiples of the batch quantity.

Economic order quantity

The minimum reorder quantity as a multiple of the Batch quantity.

The item needs to be made or purchased in multiples of the batch quantity.

This quantity is used in the standard cost calculation.

Frequency

The value of the horizontal axis in the stock projections and safety level graph.

Day: Display each date included in the MRP calculations from the MRP calculation request generation date.

Week: Display the date of each Monday included in the MRP calculations.

Item

The item to be manufactured or bought in.

Period in weeks

The number of full weeks included in the MRP calculation forecast.

Monday is the first day of the week. If the Start date is not a Monday, the number of days from the Start date up to and including the first Sunday is calculated as 1 week.

Preferred process

The method the MRP calculations recommend you use to replenish stock to meet the demand.

Purchasing: The suggested replenishment method is a purchase order.

Production: The suggested replenishment method is a work order.

Production lead time

For manufactured items, the average number of days it takes between placing an order for the item, producing it, then receiving it into stock.

Purchase lead time

For purchased items, the average number of days it takes between placing a purchase order for the item and the receipt of the goods.

This is the default value that is applied if a lead time has not been entered for a specific supplier.

Safety stock The amount of stock needed to protect against unforeseen circumstances such as non-delivery and damaged stock.
Site

The site the item is stored at or managed from.

Start date

The date the starting stock level of each item is established and the weekly buckets determined.

Legend

Field Description
Horizontal axis

The date or week when the stock is due to move.

If Frequency is Day: The stock projections are daily from the MRP calculation request generation date.

If Frequency is Week: The stock projections are weekly on a Monday from the Monday of the week of the MRP calculation request generation date.

Projected stock The results of the projected stock movements for the stock item in chronological order, beginning from the earliest transaction included in the MRP calculation forecast.
Safety level

The results of the projected stock safety level needed to protect the stock item against unforeseen circumstances such as non-delivery and damaged stock in chronological order, beginning from the earliest transaction included in the MRP calculation forecast.

Vertical axis

The projected stock quantity.

Transactions and suggestions

Field Description
Bucket

The bucket or week number included in the MRP calculations.

The MRP calculation request criteria Start date and Period in weeks determine the weekly buckets.

Document number The demand transaction document number.
Document type

The type of demand included in the MRP calculations that creates the suggestion. Demand can be from any of the following:

Starting stock

Sales order

Sales quote

Work order components and raw materials

A blank line is the supply order when a suggestion has been generated.

Safety stock is also a demand and is included in the MRP calculations, however, as safety stock is not a "transaction" it's not displayed.

Due date

The date of demand included in the MRP calculations that creates the anticipated production or the suggested replenishment date.

Supply and demand transactions with a due date in the past are set to the MRP calculation request Start date and appear in the first weekly bucket.

Quantity

The quantity from the demand transaction or the quantity generated for the supply transaction.

Starting stock is calculated from the total quantity of Accepted stock on the MRP calculation request Start date.

A generated suggestion is rounded up to the item-site Batch quantity.

Suggestion Selected if a suggestion has been generated.