I am monitoring the progression of a mine shaft.
I have 2 goals each month:
- Goal 1: Progress 247 feet per month
- Goal 2: Spend roughly $133k per month. However, spend is not solely driven by the depth achieved
Thus, I’d like to monitor the "work complete %" (i.e. the mine depth). But if I only achieve 74% of depth target that month, I don’t want it to calculate 74% of the money for that month.
What would be the best or easiest way to enter these monthly tasks?
I also need the dates to shift accordingly, if the 247 feet per month target is not achieved in the previous month.