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 $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 storage used by the department?

Solutions

Expert Solution

Total Fixed costs = $10,230,000

Total Variable costs = ($14,240,000 - $10,230,000) = $4,010,000

Fixed cost allocation of customer support cost

Fixed costs are allocated on basis of number of consultants.

Total number of consultants = 130 + 165 = 295

Fixed cost allocated to Corporate = $10,230,000 * 130 / 295 = $4,508,135.59

Fixed cost allocated to Government = $10,230,000 *165 / 295 = $5,721,864.41

Variable cost allocation of customer support cost

Variable costs are allocated on basis of no. of gigabytes of storage

Total number of Gigabytes of storage = (95,400 + 47,600) = 143,000

Variable costs allocated to Corporate = $4,010,000 * 95,400 / 143,000 = $2,675,202.80

Variable costs allocated to Government = $4,010,000 * 47,600 / 143,000 = $1,334,797.20

Variable Cost Fixed Cost Total Cost
Corporate $2,675,202.80 $4,508,135.59 $7,183,338.39
Government $1,334,797.20 $5,721,864.41 $7,056,661.61
Total $4,010,000 $10,230,000 $14,240,000

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