Question: Can you please explain the formula for the allocation tracking by time please of the below: Exercise 5.3 To show the cell checking, put a
Can you please explain the formula for the allocation tracking by time please of the below:
| Exercise 5.3 | To show the cell checking, put a check here: | x | Exercise 5.4 | Please enter your name on the first page | ||||||||||||||||||
| Ash County Deputy County Manager - Public Works | Percent Correct (this page) | 0% | Ash County Deputy County Manager - Public Works | |||||||||||||||||||
| Time Tracking Information | Grade in Points (All Sheets) | 0.000 | Prepare a one page memo to the Deputy County Manager explaining the differences and your recommended method and why you recommend it. | |||||||||||||||||||
| Expenditures | FTEs | Deputy | HR | IT | Alloc Deputy | Alloc HR | Alloc IT | Total Alloc | Allocation by FTE | Allocation by Expenditure | Allocation by Time Tracking | |||||||||||
| Deputy County Manager | $ 250,000 | 2 | Grade Text Answer | Enter Text Answer Here | ||||||||||||||||||
| Human Resources | $ 800,000 | 9 | ||||||||||||||||||||
| Information Technology | $ 3,525,000 | 32 | ||||||||||||||||||||
| Transportation | $ 37,525,813 | 275 | 15% | 35% | 25% | Transportation | ||||||||||||||||
| Facilities | $ 28,451,254 | 150 | 15% | 18% | 30% | Facilities | ||||||||||||||||
| Solid Waste | $ 8,752,486 | 24 | 55% | 2% | 20% | Solid Waste | ||||||||||||||||
| Stormwater Control | $ 35,248,125 | 412 | 15% | 45% | 25% | Stormwater Control | ||||||||||||||||
| 100% | 100% | 100% | ||||||||||||||||||||
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
