Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I have answered number 1(a), (b) and (c) in the spreadsheet attached, now need assistance in finding 2, 3 and 4. 1. Ash County's organizational
I have answered number 1(a), (b) and (c) in the spreadsheet attached, now need assistance in finding 2, 3 and 4.
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 information technology support to each of those departments. Table 5.3 shows the data for the deputy county manager overseeing the public works departments (trans- portation, facilities, solid waste, and stormwater control). Allocate the cost of the deputy's orga- nization based on full-time equivalent employees (FTEs). (a) What is the pool? (b) What is the base? (c) How much should be allocated to each department? 2. In the scenario in assignment 1, the deputy county manager wants the cost allocation to be redone using expenditures as the base. What are the new cost allocations? TABLE 5.3 3. In the scenario in assignment 1, the deputy county manager is still concerned with creating equity in the distri- Ash County: Deputy County Manager bution of the costs of the organization. Additional information of Public Works has been collected to increase the accuracy of the allocation. Expenditures FTES Each area under the supervision of the deputy county man- Deputy County Manager $ 250,000 2 ager has tracked the time it spent providing services to each Human Resources $ 800,000 9 of the departments during the most recent month, as shown Information Technology $ 3,525,000 32 in Table 5.4. Use this additional information to produce a Transportation $ 37,525,813 275 direct allocation for the deputy's organization. Facilities $ 28,451,254 150 Solid Waste $ 8,752,486 24 4. The deputy county manager asks you to create a sim- Stormwater Control $ 35,248,125 ple table showing the total cost allocation to each depart- ment using the three models you have developed. Prepare a one-page memo to the deputy county manager explaining the differences among the models, your recommended method, and why you recommend it. 412 Ash County: Deputy County Manager of Public Works Ependitures FTES Allocation Deputy County Manager $ 250,000 2 $ 253,435.13 Human Resources $ 800,000 9 $ 1,140,458.08 Information Technology $ 3,525,000 32 $ 4,054,962.05 Transportation $ 37,525,813 275 $ 34,847,330.14 Facilities $ 28,451,254 150 $ 19,007,634.62 Solid Waste $ 8,752,486 24 $ 3,041,221.54 Stormwater Control $ 35,248,125 412 $ 52,207,636.43 Total $ 114,552,678 904 $ 114,552,678.00 base pool^ 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 information technology support to each of those departments. Table 5.3 shows the data for the deputy county manager overseeing the public works departments (trans- portation, facilities, solid waste, and stormwater control). Allocate the cost of the deputy's orga- nization based on full-time equivalent employees (FTEs). (a) What is the pool? (b) What is the base? (c) How much should be allocated to each department? 2. In the scenario in assignment 1, the deputy county manager wants the cost allocation to be redone using expenditures as the base. What are the new cost allocations? TABLE 5.3 3. In the scenario in assignment 1, the deputy county manager is still concerned with creating equity in the distri- Ash County: Deputy County Manager bution of the costs of the organization. Additional information of Public Works has been collected to increase the accuracy of the allocation. Expenditures FTES Each area under the supervision of the deputy county man- Deputy County Manager $ 250,000 2 ager has tracked the time it spent providing services to each Human Resources $ 800,000 9 of the departments during the most recent month, as shown Information Technology $ 3,525,000 32 in Table 5.4. Use this additional information to produce a Transportation $ 37,525,813 275 direct allocation for the deputy's organization. Facilities $ 28,451,254 150 Solid Waste $ 8,752,486 24 4. The deputy county manager asks you to create a sim- Stormwater Control $ 35,248,125 ple table showing the total cost allocation to each depart- ment using the three models you have developed. Prepare a one-page memo to the deputy county manager explaining the differences among the models, your recommended method, and why you recommend it. 412 Ash County: Deputy County Manager of Public Works Ependitures FTES Allocation Deputy County Manager $ 250,000 2 $ 253,435.13 Human Resources $ 800,000 9 $ 1,140,458.08 Information Technology $ 3,525,000 32 $ 4,054,962.05 Transportation $ 37,525,813 275 $ 34,847,330.14 Facilities $ 28,451,254 150 $ 19,007,634.62 Solid Waste $ 8,752,486 24 $ 3,041,221.54 Stormwater Control $ 35,248,125 412 $ 52,207,636.43 Total $ 114,552,678 904 $ 114,552,678.00 base pool^Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started