Module 04 assignment – cost allocation

Blue Inc.’s copy department does all of the photocopying for the marketing and human resources departments. Blue Inc. budgets the following costs for the coming year based on 5,000,000 copies:

Salaries and wages (fixed)

$60,000

Employee Benefits (fixed)

$8,000

Paper (variable $.01 per copy)

$50,000

Toner (variable $.01 per copy)

$50,000

Depreciation (fixed)

$10,000

Utilities (fixed)

$4,000

Total

$182,000

The copy department’s costs are allocated to the marketing and human resources departments based on $.037 per copy.

If actual copies made are 4,800,000 what are the costs allocated to each department assuming the marketing department requested 2,500,000 copies and HR requested 2,300,000 copies.

What are the problems with using one allocation rate for the copy department’s costs?

Devise a better allocation system based on pooling costs. Show how the costs would be allocated based on your new system.

Present your computations in this Excel spreadsheet with the answer to each of the requirements on a separate tab.

Submit your completed assignment by following the directions linked below. Please check the Course Calendar for specific due dates. 

Save your assignment as a Microsoft Excel document. (Mac users, please remember to append the “.xlsx” extension to the filename.) The name of the file should be your first initial and last name, followed by an underscore and the name of the assignment, and an underscore and the date. An example is shown below:

Jstudent_exampleproblem_101504

Need Help? Click here for complete drop box instructions.