# Production capacity per month  Hi all,

How can I use the Time dimension in Anaplan to calculate my factory's production capacity for a given month, taking into account the different number of shifts worked on weekdays versus weekends? I want to calculate the production capacity as follows:

Production capacity = (Number of working days in the month * Number of shifts on weekdays) + (Number of working weekends in the month * Number of shifts on weekends) * Number of working hours per shift * Number of machines * TRS.

•  Hi @SAtrane,

1. If you keep the formula the same it will work i.e. NOT (WEEKDAY(Days) = 6 OR WEEKDAY(Days) = 7 OR Holidays) OR Worked On weekends because here we are including if the person has worked on weekends or not.
2. I have made changes as per the French calender. Hope that helps
3. You can do the same just by ticking the following line item: Worked On weekends It will get updated automatically as per the formula. Also, update the formula for the Number of working weekends in the month: IF Worked On weekends THEN 1 ELSE 0. The numbers will be updated.

Below is the module with Lineitem, format and formula Time scale is Day

Time_filter

Line Item

Format

Formula

Working Week Days

Boolean

NOT (WEEKDAY(Days) = 6 OR WEEKDAY(Days) = 7 OR Holidays) OR Worked On weekends

Worked On weekends

Boolean

Number of working weekends in the month

Number

IF Worked On weekends THEN 1 ELSE 0

Number of working days in the month

Number

IF Working Week Days THEN 1 ELSE 0

Days

Date

START()

WeekDay

Number

WEEKDAY(Days)

DAY

Text

IF WeekDay = 1 THEN "lundi" ELSE IF WeekDay = 2 THEN "mardi" ELSE IF WeekDay = 3 THEN "mercredi" ELSE IF WeekDay = 4 THEN "jeudi" ELSE IF WeekDay = 5 THEN "vendredi" ELSE IF WeekDay = 6 THEN "samedi" ELSE "dimanche"

Holidays

Boolean

Working Dates

Date

IF Working Week Days THEN Days ELSE BLANK

•  I would suggest using two different modules.

1. To input the required details with time summary as Day.

2. To Perform the calculation with time summary as Month.

In the first Module, No of Working Days in a Month, No. of working weekends in a Month can be calculated at the day level.

These values can then be brought to the second module at the monthly level and be used for Calculation. The no of modules may differ as well based on the approach taken.

•  Thank you for responding, but could you provide more explanation? I didn't quite understand your previous answer.

•  Hi, @SAtrane Please find below the screenshot of both modules.

1. Time Filter. Check the Time Scale for both the model

2.

Please let me know if anything needs to be added or did I understand your requirement right.

•  edited April 13

•  