Question: Please help with the equation to determine allocation by time tracking in part 4: Exercise 5.4 Type your name here, Last Name First Ash County

Please help with the equation to determine allocation by time tracking in part 4:

Exercise 5.4 Type your name here, Last Name First Ash County Deputy County Manager - Public Works Allocation by Allocation by Allocation by FTE Expenditure Time Tracking Grade Text Answer Transportation $ 1,461,236.93 $1,561,049.46 Facilities S 797,038 $1,183,553.69 Solid Waste S 127,526 $ 364,097.73 Stormwater Control S 2,189,199 S 1,466,299 S 4,575,000 4,575,000TABLE 5.4 Ash County: Deputy County Manager of Public Works, With Time-Tracking Information Time Tracking Information Expenditures FTEs Deputy HR IT Deputy County Manager $ 250,000 Human Resources $ 800,000 Information Technology $ 3,525,000 32 Transportation $ 37,525,813 275 15% 35% 25% Facilities $ 28,451,254 150 15% 18% 30% Solid Waste $ 8,752,486 24 55% 2% 20% Stormwater Control $ 35,248,125 412 15% 45% 25% 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!

Instructions for Emailing Homework - Please follo 1. Do NOT send your homework to my email address. Excel homework must be emailed to huxleyqba time and due date shown on the homework. Late homework...

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...

According to the PMBOK Guide, "the WBS is a deliverable-oriented hierarchical decomposition of the work to be executed by the project team, to accomplish the project objectives and create the...

Answer the following questions: Attached screenshots is for question 3. I have put the page number on the screenshots. 11:18 AM Sun Mar 5 . . . @ 96%...

1. Ash County's organizational structure includes one county manager and three deputy county managers. Each of the deputies oversees a handful of departments and provides human resource support and...

Part I you are asked to use the introductory sentence about the tax payer and complete paragraph items 14 and 16. You will also use item 18 for needed Social Security numbers. Do not do additional...

Risk Register Workbook Instructions This template is to be used for identifying risks and creating plans for how to avoid them (negative risks) or how to m managing them throughout the project. The...

Please read carefully the description of the case study that follows. SUMMARY ELK County Maine has been awarded a federal grant to build a modest pediatric medical center. The grant also paid for the...

I am hoping someone could help me out. Can you please tell me what formula you calculated and used for the below exercise to get the totals in part 3 for the time tracking allocation cost below with...

Howell Corporation produces an executive jet for which it currently manufactures a fuel valve; the cost of the valve is indicated below: Cost per Unit Variable costs Direct material.............. $...

The balance sheet of Goldstein Management Consulting, Inc. at December 31, 2013, reported the following stockholders equity: Stockholders Equity Paid- In Capital: Common Stock $ 10 Par Value; 200,000...

11. Either Lindbergh crossed the Atlantic and Edison invented the telephone or both Nixon resigned the presidency and it is false that Edison invented the telephone. Write the following compound...

Hugo decides to buy his Christmas gifts on Black Friday. To simplify his life, he is giving his 10 closest friends scarves for Christmas and everyone else Christmas cards. Hugo is willing to pay up...