Question

In: Accounting

A consulting firm has two departments, Corporate and Government. Computer support is common to both departments....

A consulting firm has two departments, Corporate and Government. Computer support is common to both departments. The cost of computer support is $13.11 million. The following information is given:

Gigabytes of Storage Number of Consultants
Corporate 92,200 135
Government 64,000 160

Required:

What is the cost allocation if fixed computer costs of $9.90 million are allocated on the basis of number of consultants and the remaining costs (all variable) are allocated on the basis of the number of gigabytes of storage used by the department? (Do not round intermediate calculations. Enter your answers in thousands of dollars.)

Corporate Government
Fixed
Variable
Total

Solutions

Expert Solution

Answer:

Allocation of Cost of Computer Support – Fixed Cost:
Cost allocated to Corporate Department = $9,900,000 * 135 / (135 + 160)
Cost allocated to Corporate Department = $9,900,000 * 135 / 295
Cost allocated to Corporate Department = $4,530,508

Cost allocated to Government Department = $9,900,000 * 160 / (135 + 160)
Cost allocated to Government Department = $9,900,000 * 160 / 295
Cost allocated to Government Department = $5,369,492

Total Cost of Computer Support = $13,110,000
Total Fixed Computer Cost = $9,900,000
Total Variable Computer Cost = $13,110,000 - $9,900,000
Total Variable Computer Cost = $3,210,000

Allocation of Variable Cost of Computer Support:
Cost allocated to Corporate Department = $3,210,000 * 92,200 / (92,200 + 64,000)
Cost allocated to Corporate Department = $3,210,00 * 92,200 / 156,200
Cost allocated to Corporate Department = $1,894,763

Cost allocated to Government Department = $3,210,000 * 64,000 / (92,200 + 64,000)
Cost allocated to Government Department = $3,210,00 * 64,000 / 156,200
Cost allocated to Government Department = $1,315,237

Corporate

Government

Fixed

4,530,508

5,369,492

Variable

1,894,763

1,315,237

Total

6,425,272

6,684,728


Related Solutions

A consulting firm has two departments, Corporate and Government. Computer support is common to both departments....
A consulting firm has two departments, Corporate and Government. Computer support is common to both departments. The cost of computer support is $14.24 million. The following information is given: Gigabytes of Storage Number of Consultants Corporate 95,400 130 Government 47,600 165 Required: What is the cost allocation if fixed computer costs of $10.23 million are allocated on the basis of number of consultants and the remaining costs (all variable) are allocated on the basis of the number of gigabytes of...
Austin Partners provides management consulting services to government and corporate clients. Austin has two support departments...
Austin Partners provides management consulting services to government and corporate clients. Austin has two support departments —administrative services​ (AS) and information systems (IS)—and two operating departments—government consulting​ (GOVT) and corporate consulting​ (CORP). For the first quarter of 2013​, Austin's cost records indicate the​ following: SUPPORT OPERATING AS IS GOVT CORP Total Budgeted overhead costs before any interdepartment cost allocations $690,000 $1,800,000 $7,325,000 $12,550,000 $22,365,000 Support work supplied by AS (budgeted head count) --- 20% 52% 28% 100% Support work supplied...
Boston Partners provides management consulting services to government and corporate clients. Boston has two support Departments...
Boston Partners provides management consulting services to government and corporate clients. Boston has two support Departments —administrative services​ (AS) and information systems (IS)—and two operating departments—government consulting​ (GOVT) and corporate consulting​ (CORP). For the first quarter of 2013​, Boston's cost records indicate the​ following: SUPPORT OPERATING AS IS GOVT CORP Total Budgeted overhead costs before any interdepartment cost allocations $630,000 $3,000,000 $8,725,000 $12,470,000 $24,825,000 Support work supplied by AS (budgeted head count) 0 20% 48% 32% 100% Support work supplied...
Phoenix Partners provides management consulting services to government and corporate clients. Phoenix has two support departments—administrative...
Phoenix Partners provides management consulting services to government and corporate clients. Phoenix has two support departments—administrative services (AS) and information systems (IS)—and two operating departments—government consulting (GOVT) and corporate consulting (CORP). For the first quarter of 2017, Phoenix’s cost records indicate the following: Allocation of Administrative Services on dollar amount ranking is $150,000 Allocate the support divisions’ costs to the operating divisions using the direct method. Allocate the support divisions’ costs to the operating divisions using the step-down method. Start...
Yozamba Technology has two divisions, Consumer and Commercial, and two corporate service departments, Tech Support and...
Yozamba Technology has two divisions, Consumer and Commercial, and two corporate service departments, Tech Support and Purchasing. The corporate expenses for the year ended December 31, 20Y7, are as follows: Tech Support Department $1,372,800 Purchasing Department 438,000 Other corporate administrative expenses 779,000 Total corporate expense $2,589,800 The other corporate administrative expenses include officers’ salaries and other expenses required by the corporation. The Tech Support Department charges the divisions for services rendered, based on the number of computers in the department,...
Grael Technology has two divisions, Consumer and Commercial, and two corporate service departments, Tech Support and...
Grael Technology has two divisions, Consumer and Commercial, and two corporate service departments, Tech Support and Purchasing. The corporate expenses for the year ended December 31, 20Y7, are as follows: Tech Support Department $ 510,300 Purchasing Department 60,500 Other corporate administrative expenses 580,000 Total corporate expense $1,150,800 The other corporate administrative expenses include officers’ salaries and other expenses required by the corporation. The Tech Support Department charges the divisions for services rendered, based on the number of computers in the...
Yozamba Technology has two divisions, Consumer and Commercial, and two corporate service departments, Tech Support and...
Yozamba Technology has two divisions, Consumer and Commercial, and two corporate service departments, Tech Support and Purchasing. The corporate expenses for the year ended December 31, 20Y7, are as follows: Tech Support Department $473,100 Purchasing Department 75,600 Other corporate administrative expenses 555,000 Total corporate expense $1,103,700 The other corporate administrative expenses include officers’ salaries and other expenses required by the corporation. The Tech Support Department charges the divisions for services rendered, based on the number of computers in the department,...
E-books, an online book retailer, has two operating departments—corporate sales and consumer sales—and two support departments—human...
E-books, an online book retailer, has two operating departments—corporate sales and consumer sales—and two support departments—human resources and information systems. Each sales department conducts merchandising and marketing operations independently. E-books uses number of employees to allocate human resources costs and processing time to allocate information systems costs. The following data are available for September 2017: Support Departments Operating Departments Human Resources Information Systems Corporate Sales Consumer Sales Budgeted costs for each department $72,700 $234,400 $998,270 $489,860 Budgeted Number of Employees...
Horton Technology has two divisions, Consumer and Commercial, and two corporate support departments, Tech Services and Purchasing.
Divisional Income Statements with Support Department AllocationsHorton Technology has two divisions, Consumer and Commercial, and two corporate support departments, Tech Services and Purchasing. The corporate expenses for the year ended December 31, 20Y7, are as follows:Tech Services Department$858,000Purchasing Department304,000Other corporate administrative expenses500,000Total expense$1,662,000The other corporate administrative expenses include officers’ salaries and other expenses required by the corporation. The Tech Services Department allocates costs to the divisions based on the number of computers in the department, and the Purchasing Department allocates...
Anders Company has two producing departments - Cutting and Sewing - and two support departments -...
Anders Company has two producing departments - Cutting and Sewing - and two support departments - Maintenance and General Factory (GF). Anders provided the following information on the four departments: Maintenance General Factory Cutting Sewing Direct overhead costs $10,000 $270,000 $56,400 $75,000 Machine hours 459 2,000 9,000 9,000 Square footage 2,500 3,418 5,000 8,500 The company does not break overhead into fixed and variable components. The bases for allocation are maintenance - machine hours; general factory - square feet. 1....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT