I have a sheet (Attached), where I want to change the value of the total billable hours to reach a target utilization, but it's not working properly, appreciate any pointers.
| A | B | C | E | F | G | H | I | J | K |
| From 1/7/2023 to 30/8/2023 | Working Days | Target Hours Available for Work | To be charged | ||||||
| 62 | 496 | 180 | |||||||
| Name | Total hours charged | Billable | Total Billable | Non-billable | Total Non-billable | Utilization % | Target | ||
| Dep.A | Dep.B | Dep.A | Dep.B | ||||||
ABC | 316 | 15 | 108 | 123 | 105 | 88 | 193 | 24.8% | 70% |
| Change this | Actual utilization | To get to this target |
