The Projected Column estimates the total final cost for an expense category by dividing your current spending by the percentage of work finished. It helps you forecast potential overages before a task is even complete. For example, if you have spent $5,000$ and the work is $50\%$ finished, your projected cost is $10,000$.
The Projected column shows the projected total amount that will be spent for that Expense Category based upon Spent to Date & % Complete.
Formula
- Projected = Spent to Date / % Complete
- Ex: 5,000 / 50% = $10,000 Projected
