Excel Data Cleaning Specialist
Budget: $10 – $20 AUD
I need to update attached spread sheet. The Approve Budget figures on the advance tab has been input but the formula needs to be fixed. Also on the advance tab, The DEC, JAN, FEB advance columns should be updated based on those numbers.
Firstly, on the Approved Budget of the advance tab, the indirect cost column is wrong because $72,000 of the $82,000(other) should not count towards indirect cost. That needs to be adjusted. This will make the 15% indirect amount show correctly.
Once that is correct. The advance column for the Dec, Jan, & Feb should be updated. This is a 12 month template so each of the advance months should be 1/12 of total from the Approve budget column.
When you are calculating the indirect cost for each month most of the boxes will update but remember the "OTHER" column should be adjusted. 1/12 of $72000 should not count against the indirect cost.
Firstly, on the Approved Budget of the advance tab, the indirect cost column is wrong because $72,000 of the $82,000(other) should not count towards indirect cost. That needs to be adjusted. This will make the 15% indirect amount show correctly.
Once that is correct. The advance column for the Dec, Jan, & Feb should be updated. This is a 12 month template so each of the advance months should be 1/12 of total from the Approve budget column.
When you are calculating the indirect cost for each month most of the boxes will update but remember the "OTHER" column should be adjusted. 1/12 of $72000 should not count against the indirect cost.