Question

Madison Park Co-op, a whole foods grocery and gift shop, has provided the following data to be used in its service department cost allocations: Service Departments Operating Departments Administration Janitorial Groceries Gifts Departmental costs before allocations $190,000 $70,000 $3,860,000 $350,000 Employee-hours 500 350 2,690 160 Space occupied—square feet 1,000 1,100 9,200 800 Required: Using the step-down method, allocate the costs of the service departments to the two operating departments. Allocate Administration first on the basis of employee-hours and then Janitorial on the basis of space occupied. (Please enter allocations from a department as negative and allocations to a department as positive. The line should add across to zero. Do not round intermediate calculations. Round your answers to the nearest whole dollar amount.)

Answer 1

Answer:

Total cost Groceries department 4,103,238

Total cost Gif department 366,763

Explanation:

$\left[\begin{array}{ccccc}&Administration&Janitorial&Grocerys&Gifs\\ employee hours&&350&2690&160\\ square feet&&&9200&800\\Direct \: Cost&190000&70000&3860000&350000\\ Allocate A&-190000&20781.25&159718.75&9500\\ Subtotal&&90781.25&4019718.75&359500\\ Allocate J&&-90781.25&83518.75&7262.5\\ Total&&&4103237.5&366762.5\\\end{array}\right]$

Adminstration cost will be distributed among Janitorial, Groceries and Gifs

we add up the employee hours:

350 + 2690 +160 = 3200

Then, we cross multuply:

190,000 x 350/3200 = 20781.25

190,000 x 2690/3200 = 159718.75

190,000 x 160/3200 = 9500

we add them to their cost and then do the same for Janitorial.

9200+ 800 = 10,000

90781.25 x 9200/10000 = 83518.75

90781.25 x 800/10000 = 7262.5

giving the total cost of the operating departments.