What is Planning efficiency report in BW/BI?

The plan efficiency reports are needed plant wise, material wise to measure the efficiency of the planning. These are global reports whilst the information need to be collected at factory level. These reports will help a company to make more realistic plans in future and also identify impediments as to why the plan was not reached.

The first step in manufacturing process is to set up a plan for each unit. Every plant has a plan quantity for each material and resource for a given time frame say monthly or weekly.

For example, FMCG goods producer ABC decides to manufacture 100 units of soap in November month.

Once the production is done for the month, the difference between the actual and planned quantity is noted. These kind of reports are known as the plan efficiency reports.

Usually the fields required might be coming from different tables in ECC. These are brought to BW and then formulas and logic are defined to get the value of the KPIs in the reports. Generic datasource can be utilized in this case based on a view.

KPIs concerning Plan Efficiency are-

• Plan Efficiency%
• Absolute Variance%

Here Absolute variance = |Planned qty – Actual qty|

Plan Efficiency = (Absolute variance/planned qty)*100

Sample characteristics in the report can be-

• Date
• Fiscal week / month
• Order number
• Order Status
• Material
• Plant
• Planned qty
• Actual qty
• Company Code
• Material Type

This data can be fed to APO before loading to BW for doing planning at various levels or for performing complex planning sequences if required.