Work Center formula based on input quantity

[former_member534210]

Hi Gurus,

I have a task of a production order whose duration is related to the quantity of an item of a BOM (alluminium separation from no-ferrous metal scrap).

For example I can produce 700 Kg of A and 300 Kg of waste W starting from 1000 kg of K with a duration of 4 hours. I can produce 600 Kg of A with more waste (i,e, 400Kg) using the same quantity of K with the same duration of 4 hours. If I use 800 Kg of K I could produce 700 Kg of A with 100 Kg of waste W with a duration of 3 hours.

At the end the duration of the task is: quantity of K (BOM item) * time unit.

Have You some hint to create a work center formula in order to model the duration of the task?

Thank You.

[svs_sap]

Hi Sergio,

An attempt to discuss the option here, and not to suggest any end solution. Thought for your problem statement. Observation from your statement:

1. It looks like, whenever the product "A" is produced by consuming component "K" - definitely their is a waste component "W"

2. You have not mentioned which production type you are using in your case - let's assume you are using CO11N to confirm the order (Discrete Manufacturing)

In such case: Better to go with standard planned activity formulae to produce base quantity of product "A":

Planned Operation activity time = Machin time * Operation quantity / Base quantity / Operation splits

While confirming the order:

1) take first case: Your yield quantity = 700Kg ; Scrap = 300 Kg & component K = 1000 Kg and planned time = 4 hours ( for base quantity of 1000 Kg of product "A")

2) take second case: Your yield quantity = 600Kg ; Scrap = 400 Kg & component K = 1000 Kg and planned time = 4 hours ( for base quantity of 1000 Kg of product "A")

3) take third case: Your yield quantity = 700Kg ; Scrap = 100 Kg & component K = 800 Kg and planned time = 3.2 hours ( for base quantity of 1000 Kg of product "A") where you can modify the actual hours = 3 hours during confirmation.

No need of formula based on input quantity it seems. Please check the suggestion if fits.

Best Regards,

Sharat