Skip to Content Former Member

### formulas in pp

Dear all

pl. ex. use of formulas in PP ( IN WC, routing during scheduling) how they do calculation ?

thanks

Raj

##### Add comment
10|10000 characters needed characters exceeded

### 4 Answers

• Former Member
Aug 17, 2007 at 05:23 AM

Hi raj

we have to use formulas in the workcentre to calculate following data in costing,scheduling and capacity planning:

Costs for operations

Execution times for production orders

Internal processing times for networks and maintenance orders

Capacity requirements.

To calulate cost of the operations we have to define formulas in costing Tab.

1.based on this formuals, time required to complete the each operation in the routing is calculated , using standard values in routing

2.system uses, this time and activity type which u have already assigned in casting Tab , to calculate cost.

3.before that u have assigned activity type to cost center, where u have defined the value for operation like 100 Rs/Hour.

SCHEDULING FORMULA:

let say example,

suppose one opretaion has following standard values,

Machine time : 6 Mins

operation qty : 10 Nos

base qty of the operation : 1 nos

for scheudling u have to define the formula in the workcenter scheduling tab.

Formula= machine time * operation qty/ base qty of operation.

= 6*10/1 = 60 Mins.

so cost of the operation is 100 Rs.

what i have given is for example, like wise u can use standard formula or u can create your own formaula.

To create work center formula GOTO SPRO -> OP17,OP21

reward the points if it helps to clear ur doubt

regards

pradeep

##### Add comment
10|10000 characters needed characters exceeded
• Former Member
Aug 17, 2007 at 06:37 AM

eg : To calculate capacities in work centre

1) setup formula : SAP005 (setup x operation splits)

2) Processing formula : SAP006 ( Machine x operation quantity/ base quantity)

3) teardown formula : SAP007 (labor x operation quantity/ Base quantity)

Formulas for scheduling in Work centre

1) Setup formula : SAP001( Setup)

2) Processing formula : SAP002 (machine x operation quantity/base quantity/operation splits)

3) Teardown formula : SAP003 (labour x operation quantity/base quantity/operation splits)

and so on these were just examples of predefined formulas in SAP. It takes the values from the data that you have maintained in the routing.

##### Add comment
10|10000 characters needed characters exceeded
• Former Member
Aug 16, 2007 at 01:53 PM

Hi, Hope this will help you.

Formula

Direct Labour = ( afru-smeng / afvv-bmsch ) * afvv-vgw01 * 60.

Setup = afvv-vgw02 * 60.

Machine Time = ( afru-smeng / afvv-bmsch ) * afvv-vgw03 * 60.

Regards.

.

##### Add comment
10|10000 characters needed characters exceeded
• Former Member
Aug 17, 2007 at 08:50 AM

Please reward points if answers are helpful

##### Add comment
10|10000 characters needed characters exceeded