Equal splitting of PIRs

[Former Member]

Hi Experts,

We are using flexible planning in our project to plan the sales. The plan will be for monthly quantity for each material in a plant. Once the plan is finalized, we will transfer to demand management.

The requirement is when I transfer the monthly quantities, system should split this quantity equally to weekly buckets. For example, if the monthly quantity for a mateial is 100MT, when I transfer, system should show this quantity equally split into four weeks. i.e W1: 25. W2: 25, W3: 25 & W4: 25.

I did the standard configs for automatic split in SPRO but still its not getting splitted.

Request your expert advice here.

Regards

Prathib

[Dsk]

Hi ,

can u eloborate what config you have done !

reg

dsk

[Former Member]

Hi Satheesh,

In SPRO I defined the period split function and strategy. Assigned the period split to MRP group and MRP group to material.

I dont know whether I missed something in the config.

Regards

Prathib

[Dsk]

Hope the below one helps you :

Define period split for automatic split

The period split determines the type of period split for automatically splitting the planned independent requirements. Automatic splitting is only possible if the planned independent requirements were created using a reference.

You must make sure that the following three steps have been carried out before you can automatically split the independent requirements:

1. Maintain the period split for the automatic splitting.

2. Assign period split to reference type or to MRP group (in the workstep "Assign version and split for automatically splitting the reference" or "Assign period split to MRP group").

3. Create planned independent requirements using a reference that has been allocated a period split in the above step.

The system proceeds as follows when automatically splitting planned independent requirements:

Weekly requirementsare automatically split, whereby the system first reads the entry in the column "W in T". The number of weeks entered in this field is split into daily quantities. Thus, the system creates daily quantities.

Monthly requirements are automatically split, where the system first reads the entry in column "W in D". The number of weeks entered in this field is split into daily quantities. Then the system reads the entry in the column "No.of weeks" and creates the number of weekly quantities entered here.

Moreover, you can assign a distribution function. This means that you can define the percentage of the quantity that is to be produced according to a certain percentage of the production time depending on the period to be split.

Activities

Maintain the period split for the automatic split.

Further notes

The allocation of the reference type is mafe in step "Allocate version and split for automatic split of the reference".

Note that the period split for automatic splitting is maintained independently of the plant. The distribution strategy in the period split, on the other hand is plant-specific. If you want to control the automatic split using the MRP group, the distribution strategy and the MRP group must both be valid in the same plant.

reg

dsk

[Former Member]

Hi Satish,

Thanks for the reply. I had already done these confiigurations. But the issue is the monthly quantity is splitted in to 5 weeks and the split quantities are not equal. I transferred a quantity of 100 from sales but this is getting splitted as 14, 23, 22, 23,18.

I dont know from where system is selecting such a ratio to split and 5 weeks for splitting.

Request your inputs.

Thanks & Regards

Prathib

[Dsk]

Kindly check if the number of workdays are equal for all the 5 weeks ! My assumption

1. Total Qty / No of workdays in the month = Avg req /day

2. No of workday in week * Avg reQ / day .

check if this works in this fashion.

reg

dsk

[Dsk]

Hi ,

check for the distribution strategy . this will have the influence !

reg

dsk

[Former Member]

Hi Satish,

Thanks a lot. I could solve the issue when i analysed based on your inputs. In distribution strategy, I had maintained the distribution type as 01 instead of 02. So I changed to 02. In addition to this, I created a new distribution function with 4 positions of 25, 50 75 and 100.

This solved the issue. Now system is automatically splitting the quantity to 4 equal quantities.

Thanks a lot once again for your inputs.

Regards

Prathib