Background: Planning Profile Maintenance
Use the Planning Profile Maintenance (MPM) program to enter a planned order, change the quantity ordered, move the due date, and break a planned order into multiple orders. See Road Map for work flow.
This topic has these subtopics:
|
Periods
Planning Profile Maintenance displays the demand (sales, forecast, and other requirements) and supply (quantity on hand, planned orders, and released orders) for an item. The program displays the up to 50 periods based on the item's Planning period field in the Branch Item Maintenance (IMB) program.
ATP and Projected On-Hand Quantities
The program calculates Available To Promise (ATP) and projected on-hand quantities based on demand and supply, including released manufacturing orders as well as planned orders and purchase requisitions created by the Finished Goods Planning (MFP) and Material Requirements Planning (MRP) programs.
Each time you run the program, Planning Profile Maintenance recalculates an item's gross requirements and availability. Unlike Material Requirements Planning, the program does not create planned orders or rescheduled them. You can use Planning Profile Maintenance to supplement Finished Goods Planning and Material Requirements Planning. A message on the report may no longer be true because circumstances have changed.
Unconsumed Forecast
If sales orders do not equal the forecast quantity for a period, forecast is not consumed. If you selected the Consume component forecast with release? option in the System Options Maintenance (XM) program (Manufacturing Options), unconsumed forecast for a component is when manufacturing order requirements do not equal the forecast. Click Peg demand to see consumed and unconsumed forecasts for each period.
The periods that display are based on the Planning period field of the item's record in the Branch Item Maintenance (IMB) program.
It is used to spread the forecast quantity evenly over the forecast period. For example, a forecast spread of 5 would spread the forecast evenly within the period every 5 shop days. This would effectively simulate weekly forecasts without needing to forecast by weeks. You can set forecast spread to any number; for example, enter 1 for daily increments or 10 for bi-weekly increments.
What if you forecast by the year? Spread forecast first determines a number of increments to place between the start and end dates when a larger forecast period (in this example, a year) is divided into smaller increments. The number of shop days between the starting and ending dates is divided by the spread forecast.
The system first calculates the number of spread forecast increments between the start and end dates of the forecast period. The number of shop days is then divided by the spread forecast. The integer of the resulting number is the number of spread forecast increments. For example, if the forecast period is a year and the Spread forecast is 21:
Forecast period: January 1, yyyy through December 31, yyyy
Days difference: 365 days - 103 non-work and weekend days = 262
Spread forecast: 21
Spread forecast increments: INT(262 / 21=12.47619) = 12
A second calculation uses the number of spread forecast increments to determine the forecast quantity for each increment. An accumulated floating point calculation then balances the spread quantity evenly throughout the increments.
For example, if the forecast quantity is 160:
Period |
Forecast quantity |
Calculation |
1 |
14 |
160 / 12 = 13.33333 TEMPQTY = 13 FLOAT = 0.33333 + 0 IF FLOAT GT 0 TEMPQTY = 13 + 1 FLOAT = (0.33333 - 1) = -0.66667 |
2 |
13 |
160 / 12 = 13.33333 TEMPQTY = 13 FLOAT = 0.33333 + (-0.6667) = - 0.33334 |
3 |
13 |
160 / 12 = 13.33333 TEMPQTY = 13 FLOAT = 0.33333 + (-0.33334) = -0.00001 |
4 |
14 |
|
5 |
13 |
|
6 |
13 |
|
7 |
14 |
|
8 |
13 |
|
9 |
13 |
|
10 |
14 |
|
11 |
13 |
|
12 |
13 |
|
Total |
160 |
|
Planned Orders
Planning Profile Maintenance allows you to enter plan orders for an item in the context of its demand. Then you can release planned manufacturing orders with the Order Release Selection (MRR) program.
Demand
Planning programs look at open orders. When you receive a manufacturing order into finished goods, these programs consider it to be closed. Therefore, when you click Peg demand, the manufacturing order for a component is no longer listed when you:
Click No for the Do you want to pick the remaining components? prompt in Receiver Maintenance (IRC).
Select R for the Process excess/short components option in the System Options Maintenance (XM) program (Manufacturing Options) for your manufacturing branch.
However, the Inventory Status Inquiry (ISQ) program shows committed quantities for this component until you manually pick the quantity required with the Material Usage Maintenance (MUA) or Material Issues and Adjustments (IMI) program.