question

Eduardo avatar image
0 Likes"
Eduardo asked Eduardo commented

Is there a way to show states' costs individually in the financial analysis?

I want to do a more detailed analysis regarding the costs but I have a problem since the financial analysis shows me the sum of the states for the amount of time and the same thing happens with the quantity per entry, the same thing happens when I export to analyze it in an excel.flexsim-2023-update-2-escenario-1fsm-22-04-2024-5.pnganalisis-financiero-pregunta-excel-22-04-2024-5-28.png

Is it possible to individually display the costs of the statements that were entered in the financial analysis properties as shown in the first image?

FlexSim 23.2.1
financial analysis
flexsim-2023-update-2-escenario-1fsm-22-04-2024-5.png (44.4 KiB)
analisis-financiero-pregunta-excel-22-04-2024-5-28.png (9.0 KiB)
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

1 Answer

·
Felix Möhlmann avatar image
1 Like"
Felix Möhlmann answered Eduardo commented

I don't think so.

Your best bet might be to use a state gantt chart and add a cost table to the model. Then aggregate the amount and duration of states from the state gantt's Statistics Collector and multiply them by the costs in a Calculated Table.

custom-cost-analysis-fm.fsm


custom-cost-analysis-fm.fsm (645.8 KiB)
· 1
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Eduardo avatar image Eduardo commented ·

Thank you very much for your help, I really appreciate it

0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.