answer_2

xlsx

School

Sukkur Institute of Business Administration, Sukkur *

*We aren’t endorsed by this school

Course

6275

Subject

Management

Date

Nov 24, 2024

Type

xlsx

Pages

Uploaded by ministats

Bridget Brown Jackson (a) What is the pool? (b) What is the base? (c) How much should be allocated to each department? Table 5.3 Ash County: Deputy County Manager of Public Works Deputy County Manag Human Resourc Information Technolo Transportati Faciliti Solid Wa Stormwater Cont Table 5.4 Ash County: Deputy County Manager of Public Works, With Time-Tracking Information Deputy County Manag Human Resourc Information Technolo Transportati Faciliti Solid Wa Stormwater Cont 5.1. Ash County’s organizational structure includes one county manager and three deputy county managers. Each of t deputies oversees a handful of departments and provides human resource support and information technology suppor to each of those departments. Table 5.3 shows the data for the deputy county manager overseeing the public works departments (transportation, facilities, solid waste, and stormwater control). Allocate the cost of the deputy’s organization based on full-time equivalent employees (FTEs). 5.2. In the scenario in assignment 5.1, the deputy county manager wants the cost allocation to be redone using expenditures as the base. What are the new cost allocations? 5.3. In the scenario in assignment 5.1, the deputy county manager is still concerned with creating equity in the distribution of the costs of the organization. Additional information has been collected to increase the accuracy of the allocation. Each area under the supervision of the deputy county manager has tracked the time it spent providing services to each of the departments during the most recent month, as shown in Table 5.4. Use this additional information to produce a direct allocation for the deputy’s organization.

Table 5.5 Boomtown: Parks, Fire, and Water Departments Table Indirect Cost Grou Faciliti City Adm Departme Pa F Wa x 5.4. The deputy county manager asks you to create a simple table showing the total cost allocation to each departmen 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. 5.5. Boomtown is preparing a cost analysis of three departments: Parks, Fire, and Water. To comply with accuracy standards in allocating indirect costs, Boomtown will employ the step-down method of cost allocation. There are two indirect cost groups that are allocated: city administration and facilities. Costs for facilities are allocated first, and then costs for city administration are allocated. Using the data in Table 5.5, prepare the cost allocation using direct cost as the base and determine the full cost of the departments.

Expenditures FTEs $250,000 2 $800,000 9 $3,525,000 32 $37,525,813 275 $28,451,254 150 $8,752,486 24 $35,248,125 412 Expenditures FTEs Deputy HR IT $250,000 2 $800,000 9 $3,525,000 32 $37,525,813 275 15% 35% 25% $28,451,254 150 15% 18% 30% $8,752,486 24 55% 2% 20% $35,248,125 412 15% 45% 25% 100% 100% 100%

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Direct Cost $5,212,544 $1,475,241 $15,025,842 $45,218,534 $35,248,612

Exercise 5.1 To show the cell checking, put a check here: x Ash County Deputy County Manager - Public Works Percent Correct (this page) 100% Grade in Points (All Sheets) 2.750 Expenditures FTEs Deputy County Manager $ 250,000 2 Human Resources $ 800,000 9 Information Technology $ 3,525,000 32 Transportation $ 37,525,813 275 31.94% $ 1,461,236.93 Facilities $ 28,451,254 150 17.42% $ 797,038.33 Solid Waste $ 8,752,486 24 2.79% $ 127,526.13 Stormwater Control $ 35,248,125 412 47.85% $ 2,189,198.61 Pool: Expenditures to be allocated $ 4,575,000 Base: FTE 861 Check 1 1 1 1 1 1 1 1 1

Exercise 5.2 Type your name here, Last Name First Ash County Deputy County Manager - Public Works Expenditures FTEs Deputy County Manager $ 250,000 2 Human Resources $ 800,000 9 Information Technology $ 3,525,000 32 Transportation $ 37,525,813 275 34.12% $ 1,561,049.46 Facilities $ 28,451,254 150 25.87% $ 1,183,553.69 Solid Waste $ 8,752,486 24 7.96% $ 364,097.73 Stormwater Control $ 35,248,125 412 32.05% $ 1,466,299.11 Pool: Expenditures to be allocated $ 4,575,000 Base: Expenditures $ 109,977,678 k 1 1 1 1 1 1 1 1 1

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Exercise 5.3 To show the cel Ash County Deputy County Manager - Public Works Time Tracking Information Expenditures FTEs Deputy HR IT Alloc Deputy Deputy County Manager $ 250,000 2 Human Resources $ 800,000 9 Information Technology $ 3,525,000 32 Transportation $ 37,525,813 275 15% 35% 25% $ 37,500 Facilities $ 28,451,254 150 15% 18% 30% $ 37,500 Solid Waste $ 8,752,486 24 55% 2% 20% $ 137,500 Stormwater Control $ 35,248,125 412 15% 45% 25% $ 37,500 100% 100% 100% $ 250,000 1 1 1 1 1

ll checking, put a check here: x Exercise 5.4 Type your name h Percent Correct (this page) 100% Ash County Deputy County Manager - Public Wor Grade in Points (All Sheets) 2.750 Alloc HR Alloc IT Total Alloc $ 280,000 $ 881,250 $ 1,198,750 Transportation $ 1,461,237 $ 144,000 $ 1,057,500 $ 1,239,000 Facilities $ 797,038 $ 16,000 $ 705,000 $ 858,500 Solid Waste $ 127,526 $ 360,000 $ 881,250 $ 1,278,750 Stormwater Control $ 2,189,199 $ 800,000 $ 3,525,000 $ 4,575,000 $ 4,575,000 Check 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Allocation by FTE

here, Last Name First rks Grade Text Answer $ 1,561,049 $ 1,198,750 $ 1,183,554 $ 1,239,000 $ 364,098 $ 858,500 $ 1,466,299 $ 1,278,750 $ 4,575,000 $ 4,575,000 1 1 1 1 1 1 1 1 1 1 Prepare a one page m and your recommende Allocation by Expenditure Allocation by Time Tracking Memorandum To: Deputy Manager From: Accounting Supervisor Date: December January 13, 2021 Subject: Cost Allocation Models The first table for cost allocation uses the number of employees in Resources, Information Technology (IT), Transportation, Facilities, more employees will be allocated more money. It is important to m personnel which equates to a large allocation of fund. Conversely, personnel giving that department a smaller allocation (Accounting Table two is expenditure costs, the department with higher expen that expenditures for office supplies and the other small items tha expenditure, however, the materials and supplies borrowed by oth taken which adds to Transportations expenditures. The third table, time allocation is put into a dollar amount. This effi schedules to ensure that the proper amount of time is allocated fo time. Looking at the three models, I feel the third cost allocation, time w reduce stress and procrastination, and is easier to track than supp Reference Cost Allocation Methods. (2020, December 18). In Accounting Too https://www.accountingtools.com/articles/cost-allocation-method

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

memo to the Deputy County Manager explaining the differences ed method and why you recommend it. n the following departments Deputy County Manager, Human Solid Waste, and Stormwater Control. Departments that have mention some department will have a large number of low wage other departments may have a small contingent of higher paid g Tools, 2020). nditures may bear the brunt higher costs. What is important is at add over time are accounted for. Transportation has the highest her department are done so without charging them for what was fficient method allows managers to assign tasks to staff and set or a certain project. All in an effort to maximize the dollar value of would be most effective. Managing time can improve efficiency, ply expenditures. ols. Retrieved from ds.html

Type your name here, Last Name First Exercise 5 Indirect Cost Groups Direct Cost Base Allocation Subtotal Facilities $ 5,212,544 City Admin $ 1,475,241 $ 0 $ 79,301.84 $ 1,554,542.84 Departments Parks $ 15,025,842 $ 0 $ 807,716.75 $ 15,833,558.75 Fire $ 45,218,534 $ 0 $ 2,430,730.15 $ 47,649,264.15 Water $ 35,248,612 $ 0 $ 1,894,795.26 $ 37,143,407.26 $ 96,968,229 $ 5,212,544.00 Check 1 1 1 1 1 1 1 1 1 1 1 1 1 1

To show the cell checking, put a check here: x Percent Correct (this page) 100% Grade in Points (All Sheets) 2.750 Base Allocation Subtotal 15.74% $ 244,607.65 $ 16,078,166.39 47.35% $ 736,118.43 $ 48,385,382.58 36.91% $ 573,816.76 $ 37,717,224.03 $ 100,626,230.16 $ 1,554,542.84 1 1 1 1 1 1 1 1 1 1 1

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

3 Total Points Available Item Grade Weight x A mark here 0.25 Base Points (for trying this exercise) 0.25 Manual Points 2.5 Points to be graded 100% Percent all sheets 2.5 Graded Points 0 Problem 4 Text Memo 0.25 2.75 Initial Grade 0.25 0.24 Minimum Earned Points 0.49 Threshold 2.75 Grade Grade Table A 100% B 90% 78 C 80% 78 D 70% F 0%

e makes the numbers in the grade calculation visible.

answer_2

Related Documents