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. Example
I have an order for 80 items. The Batch quantity is 50. The Economic order quantity is 200. I need to make or buy 4 batches of the item for the order to be economically viable. |
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. Example
I have an order for 80 items. The Batch quantity is 50. The Economic order quantity is 200. I need to make or buy 4 batches of the item for the order to be economically viable. 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. |