wSimplifying assumptions: All work is equally weighted where 1 day equals 1 unit ofwork. Daily work accomplished is NOT a function of daily cost.
There is a lot of busy work on this slide. The schedule information is on the top. This typically comes from any planning software like Primavera or Project. Resource allocation and costing can also result from running one of the industry standard software suites. This is an example using Excel to display the required operations.
1. The Bar Chart shows which tasks are active on which days and the daily cost rates.
2. The cost per day can be computed directly. The %/day follows.
3. The total work per day is not easy to obtain. For planning purposes, you could assume that work is a function of cost as modified by some weighting factor. In this case we assumed that they were independent.