Hello all,
I require a little help with forecasting the 'cost' per day based on a timeline.
I have created a project timeline which each row (task) has a start and end date.
Each task has a value (cost).
Each task requires a 20% deposit, 4 weeks before the start date.
The remaining 80% cost needs to be distributed evenly to the amount of workdays between the start date and end date.
So, if a task costs $1,000 and starts on 01/01/2023 and finishes on 01/20/2023, there are 21 network days between these dates.
I need 20% so $200 to be paid 4 weeks before the start date. and then $800 to be divided by 21 working days. equating to $38.10
I need the $38.10 to be shown on each workday (network day).
Ultimately, the goal is to calculate how much each day is costing based on totality of the tasks within the project.
I have attached a screenshot of my timeline. The timeline uses conditional formatting to show when each task is active.
If you need anymore information to help solve my problem, let me know.
I require a little help with forecasting the 'cost' per day based on a timeline.
I have created a project timeline which each row (task) has a start and end date.
Each task has a value (cost).
Each task requires a 20% deposit, 4 weeks before the start date.
The remaining 80% cost needs to be distributed evenly to the amount of workdays between the start date and end date.
So, if a task costs $1,000 and starts on 01/01/2023 and finishes on 01/20/2023, there are 21 network days between these dates.
I need 20% so $200 to be paid 4 weeks before the start date. and then $800 to be divided by 21 working days. equating to $38.10
I need the $38.10 to be shown on each workday (network day).
Ultimately, the goal is to calculate how much each day is costing based on totality of the tasks within the project.
I have attached a screenshot of my timeline. The timeline uses conditional formatting to show when each task is active.
If you need anymore information to help solve my problem, let me know.