Budget Simulation Approach
I am quite new with FileMaker and would like to have your input on the approach that I should take for a Budget Simulation project I need.
Purpose is to see the occupancy and price impact on the P&L of a company that is renting rooms.
In order to explain you what I would need to do, I uploaded an example of the Excel I am using now :
Based on your experience, how should this be set up in FileMaker 13?
Thanks in advance for your input and time!
I am still stuck at this stage. Although I think now think that the "simulation" is not too complex to handle, I still could not figure out how to handle the P&L on a multiyear basis knowing that the years shown can be different for each building.
What is the best way to set this up in the database?
Thanks in advance for your help!