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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!