I will share a copy of the MS Project file that is currently in use with selected freelancer, which has several Custom Fields.
TASK #1
- Create one new Custom Date Field. Title will be 'Indicative Materials Bill Date'. The date should be automatically calculated as one-month before the 'Estimated Start' date.
TASK #2
- Adjust calculation in 'Client Item Rate' to ensure that no error is created if the 'Item Qty' field is completed or not.
TASK #4
- Create one new Custom Cost Field. Title will be 'Indicative Labour Value'. The value should be calculated as 50% of the 'Client Item Total'.
TASK #3
- Create cashflow forecast as an Excel xlsx export, showing month by month. This should use the 'Estimated Start' and 'Estimated Finish' dates.
- The cashflow forecast will be the 'Indicative Materials Value' in the Indicative Materials Bill Date (see Task #1), plus the sum('Client Item Rate'-'Indicative Labour Value') in the current month.
Please let me know if there are any clarifications needed
About the recuiterMember since May 20, 2018 Navin Kumar
from Podkarpackie, Poland