Production Capacity Module_Factory 2

SAtrane
SAtrane
in Modeling

Hi,

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?

Best Answer

  • HimanshuRaj
    HimanshuRaj
    Answer ✓

    Hi @SAtrane

    After understanding your question, this is the solution I came up with:

    1. Calculating production capacity for weekdays (normal)
    1.PNG

    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

    2.PNG

    3. Then adding all to calculate Total production capacity

    Hope, this resolves your issue.

Categories