Forecast Phasing with Adjustment Issue
I have a module that I am trying to do a phasing
(a) Forecast Amount: have an even spread amount as (current best guess) and Total spending amount for FY23 is 22,000.
(b) In the Adjustment Line: I want to enter an adjustment for certain months with a new amount (Due to the knowledge of certain month will incur more spend). And balancing figure is -500
(c ) In the Target Adjustment Line: I want to put the balancing figure in this case -500 and I want to put it in December amount also I want my total to result to 22,000.
(d) In the Total Line: I want to add my forecast amount + Adjustment to result to 22,000 for FY23.
What is the best way / workaround to achieve this?
Any suggestion will be really helpful.
Attached is the copy of the excel