Schedule Labor Now that the cost information is in place, divvying up the staff time is the next step in calculating the budgeted cost of work over the work scheduled in Excel.

To solve this problem, Excel allows conditional calculations so that you can calculate the normal rate for up to 40 hours worked and then a higher amount for overtime hours worked.