Production capacity per month

SAtrane · 2023-04-10T13:39:31+00:00

There was an error rendering this rich post.

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.

Thanks in advance.

Accepted answers

rishi8118

Hi @SAtrane,

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.
I have made changes as per the French calender. Hope that helps
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

All comments

rishi8118

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.

SAtrane

hi @rishi8118

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

rishi8118

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

Time Filter. Check the Time Scale for both the model

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

SAtrane

Hi @rishi8118

I appreciate your previous answer, which was very helpful. However, I have a question and I would appreciate your assistance with it.

the number of weekend days in the month. However, I need to be able to choose whether or not to work on a particular weekend day. Therefore, I would like to modify the formula so that the number of working weekend days in the month only includes the weekends on which I am working can you plz help me with that?

thanks in advance.

rishi8118

Hi @SAtrane,

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.
I have made changes as per the French calender. Hope that helps
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

SAtrane

Hi @rishi8118

Thank you for being so responsive, and for providing me with such pertinent answers, i i appreciate it.

Quick Links

Can you help?

Unanswered questions

How have you from-scratch built lot-level, geo-based Inventory Consumption?
We’re working on modeling inventory consumption at the lot level, accounting for shelf life considerations, since we need visibility into which lots may not consume—both for risk reporting and E&O analysis. Each item may have customers with different shelf life requirements. For example, item A may need 270 days for some…
How to bring Row data into Columns?
Hi, Can you help me, how can we get row data into columns using Unique ID? Per attached below first snapshot, I want to bring rountingOrder 4, RecipientName, Sent and Completed dates in 1 row as show in sanpshot 2. Do I need to create Hierarchy list and Map?
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…