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 cost 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.
| Indirect Cost Groups | Direct Cost | Base | Allocation | Subtotal | Base | Allocation | Subtotal |
| Facilities | $ 5,212,544 | ||||||
| City Admin | $ 1,475,241 | ||||||
| Departments | |||||||
| Parks | $ 15,025,842 | 15.74% | |||||
| Fire | $ 45,218,534 | 47.35% | |||||
| Water | $ 35,248,612 | 36.91% | |||||
| 100.00% |
1.Statement Showing Allocation of Indirect cost group to Department and total cost. Amount in $
| Particular |
Dept Parks |
Dept Fire |
Dept Water |
Indirect Tax Group Facilities |
Indirect Tax Group City Admin |
Ratio | Basis | Total |
| Direct Cost Before Allocation | 15025842 | 45218534 | 35248612 | 5212544 | 1475241 | 102180773 | ||
| Allocation | ||||||||
| Facility | 781882 | 2345645 | 1824390 | (5212544) | 260627 | wn-1 | Direct cost | 5212544 |
| City Admin | 273226 | 821933 | 640709 | (1735868) | wn-2 | Direct cost | 1735868 | |
| Total Cost | 16080950 | 48386112 | 37713711 | |||||
WN-1 allocation of cost of Facility
Total Direct Material Cost except Facility =5212544+15025842+45218534+35248612
=100705532
Ratio=5.00:15.00:45.00:35.00
WN-2 allocation of cost of City Admin
Total Direct Material Cost except City Admin =15025842+45218534+35248612
=95492988
ratio=15.74:47.35:36.91
Boomtown is preparing a cost analysis of three departments: Parks, Fire, and Water. To comply with...
The London Private Hospital has 3 patient services departments – Adult Medicine, Obstetrics and Paediatrics. It also has 3 patient support departments – administration, Facilities and Finance. The revenues of the three patient services departments are: Adult medicine $12 million Obstetrics $6 million Paediatrics $2 million The direct costs of all 6 departments are: Adult medicine $6 million Obstetrics $3.6 million Paediatrics $1.2 million Administration $1 million Facilities $4.4 million Finance $1.8 million Direct costs of the support departments are...
St. Benedict Hospital has three primary revenue producing departments (Inpatient, Outpatient, Clinic) with the following revenue and cost projections. In order to better determine the departments’ overall true cost and profit margin, management wants to allocate service department costs as overhead allocations to these departments. PROJECTED REVENUES AND COSTS PER DEPARTMENT Revenues Inpatient Services $18,500,000 Outpatient Services 32,000,000 ...
Dunnes Stores has two service department, Advertising and Administration, and two operating departments, Hardware and Automotive. Sales, COGS, and direct expenses are given below. Complete the following table, including allocation of $220,000 of indirect costs. Indirect costs are allocated on the basis of square footage:... Advertising Department:750 square feet, Administration Department:1,500 square feet, Hardware Department: 3,000 square feet, Automotive Department: 9,750 square feet Dunnes Stores Revenues and Expenses Y/E December 31, 2018 Service Departments Operating Departments Totals Advertising Admin Hardware...
The Sendai Co., Ltd., of Japan has budgeted costs in its various departments as follows for the coming year Factory Administration Custodial Services Personnel Maintenance Machining overhead Assembly-overhead Total cost $ 533,800 102,568 68,774 151,718 1,851,536 761,704 $3,470, 100 The company allocates service department costs to other departments in the order listed below. Department Factory Administration Custodial Services Personnel Maintenance Machining Assembly Square Total Teet of Direct Number of Labor Space Labor- Machine Employees Hours Occupied Hours Hours - 6,500...
Company has prepared department overhead budgets for
budgeted-volume levels before allocations as follows:
Management has decided that the most appropriate inventory costs
are achieved by using individual department overhead rates. These
rates are developed after support-department costs are allocated to
operating departments. Bases for allocation are to be selected from
the following:
Support departments:
Building and grounds
$56,000
Personnel
1,140
General plant administration
14,040
Cafeteria: Operating loss
300
Storeroom
6,244
$77,724
Operating departments:
Machining
$34,000
Assembly
49,000
83,000
Total for...
The Sendai Co., Ltd., of Japan has budgeted costs in its various departments as follows for the coming year: Factory Administration Custodial Services $ 640,680 103,274 Personnel 31,056 148,590 1,391,860 510,140 Maintenance Machining-overhead Assembly-overhead Total cost $2,825,600 The company allocates service department costs to other departments in the order listed below. Square Feet of Direct Total Number of Labor- Space Labor- Machine- Bours Department Employees Hours Occupied Hours 32 13 Factory Administration Custodial Services Personnel 5,700 3,600 8,100 52,900 14,100...
The Sendal Co., Ltd., of Japan has budgeted costs in its various departments as follows for the coming year, Factory Administration Custodial Services Personnel Maintenance Machining-overhead Assembly-overhead Total cost $1,614,315 143,440 46,502 129,983 1,313,880 232,480 $2,880,680 The company allocates service department costs to other departments in the order listed below. Department Factory Administration Custodial Services Personnel Maintenance Machining Assembly Square Total Feet of Direct Number of Labor Space Labor- Machine- Employees Hours Occupied Hours Hours 25 9,600 15,400 3,500 12,400...
The Sendai Co., Ltd., of Japan has budgeted costs in its various departments as follows for the coming year: Factory Administration Custodial Services 480,760 116,260 45,602 Personnel Maintenance 141,258 Machining-overhead Assembly-overhead Total cost 874,528 1,181,192 $2,839,600 The company allocates service department costs to other departments in the order listed below. Square Feet of Total Labor- Direct Number of Labor- Machine- Space Employees Hours Occupied Hours Department Factory Administration Custodial Services Hours 8,600 3,600 8,600 16,000 60,000 112,000 180,00 20,000 227,000...
The Sendai Co., Ltd., of Japan has budgeted costs in its various departments as follows for the coming year: Factory Administration $ 350,700 Custodial Services 122,425 Personnel 56,830 Maintenance 116,045 Machining—overhead 1,210,800 Assembly—overhead 1,074,200 Total cost $ 2,931,000 The company allocates service department costs to other departments in the order listed below. Department Number of Employees Total Labor- Hours Square Feet of Space Occupied Direct Labor- Hours Machine- Hours Factory Administration 26 — 7,600 — — Custodial Services 13 9,300...
The Sendai Co. Ltd. of Japan has budgeted costs in its various departments as follows for the coming year Factory Administration Custodial Services Personnel Haintenance Machining-overhead Assembly-overhead Total cost 819,840 98,337 26,356 170, SSS 1,126,484 618, 226 12,859,600 The company allocates service department costs to other departments in the order listed below. Department Factory Administration Custodial Services Personnel Maintenance Machining Assembly Square Total Feet of direct Number of Labor Space Labor Machine Employees Hours Occupied Hours Hours 5,500 11 15,900...