Production Capacity Module_Factory 2
Does anyone know how to build a calculation module in Anaplan that calculates production capacity using the formula bellow, and includes the option to check whether the factory is working on weekends:
This is the formula I am using:
Production capacity = number of machines*number of working hours*number of working days*number of shifts*line efficiency.
Usually, they work five days a week (From Monday To Friday) and 2 OR 3 shifts per day (8 hours per shift) but sometimes they work weekends, I need to create a check box for if they work the hall weekend or if it is just Sunday or Saturday. And if they work weekends, is it for 1,2 or 3 shifts. And specify if they work 1,2 or 3 shifts in workdays (From Monday To Friday).
Please advice I need to know if it is possible to do it with Anaplan and how?
After understanding your question, this is the solution I came up with:
- Calculating production capacity for weekdays (normal)
2. Calculating production capacity for weekends (normal). Here if you see i've given option of selecting weekend work option? and there is also a flexibility of adding no of weekends(1 or 2 - saturday/sunday/both) and no of shifts during those weekends
3. Then adding all to calculate Total production capacity
Hope, this resolves your issue.1