I could use some help answering this with the attached spreadsheet: Glassman Company acculated the following data for 2019:Milling Department manufacturing overhead$484,000Finishing Department manufacturing overhead$260,000Machine hours used Milling Department10,000 Finishing Deparment2000Labor hours used Milling Department1000 Finishing Department1000 Assume that manufacturing overhead for Glassman Company above consisted of the following activities and costs: Setup (1000 setup hours)$288,000Production scheduling (400 batches)$60,000Production engineering (60 change orders)$180,000Supervision (2000 direct labor hours)$56,000Machine maintenance (12,000 machine hours)$168,000 Total activity costs$752,000The following additional data were provided for Job 845:Direct materials costs$7000Direct labor cost (5 milling direct labor hours; 35 finishing direct labor house)$1000Setup hours5 hoursProduction scheduling1 batchMachine hours used (25 milling machine hours; 5 finishing machine hours)30 hoursProduct engineering3 change ordersProblems:a) Calculate the cost per unit of activity driver for each activity cost category.b) Calculate the cost of Job 845 using ABC to assign overhead costs.c) Calculate the cost of Job 845 using the company-wide overhead rate based on machine hours calculated.d) Calculate the cost of Job 845 using a machine hour departmental overhead rate for the Milling Department and a direct labor hour overhead rate for the Finishing Department. |Activity cost calculations:Set up costProduction scheduling costProduction engineering cost|Supervision costMachine operating costinclude the formula hereaDirect materialsDirect laborManufacturing overhead costbTotal Job 845 costTotal Job 845 costTotal Job 845 cost

Answered: Image /qna-images/answer/a9769388-598f-4eea-8199-b2fa32bcdf3e.jpg

Answered: |Activity cost calculations: Set up…

Survey of Accounting (Accounting I)

8th Edition

ISBN:9781305961883

Author:Carl Warren

Publisher:Carl Warren

Chapter10: Accounting Systems For Manufacturing Operations

Section: Chapter Questions

Problem 5SEQ: When using job order costing for a professional service business, the primary product (service)...

See similar textbooks

Related questions

Question

100%

I could use some help answering this with the attached spreadsheet:

Glassman Company acculated the following data for 2019:

Milling Department manufacturing overhead	$484,000
Finishing Department manufacturing overhead	$260,000
Machine hours used
Milling Department	10,000
Finishing Deparment	2000
Labor hours used
Milling Department	1000
Finishing Department	1000

Assume that manufacturing overhead for Glassman Company above consisted of the following activities and costs:

Setup (1000 setup hours)	$288,000
Production scheduling (400 batches)	$60,000
Production engineering (60 change orders)	$180,000
Supervision (2000 direct labor hours)	$56,000
Machine maintenance (12,000 machine hours)	$168,000
Total activity costs	$752,000

The following additional data were provided for Job 845:

Direct materials costs	$7000
Direct labor cost (5 milling direct labor hours; 35 finishing direct labor house)	$1000
Setup hours	5 hours
Production scheduling	1 batch
Machine hours used (25 milling machine hours; 5 finishing machine hours)	30 hours
Product engineering	3 change orders

Problems:

a) Calculate the cost per unit of activity driver for each activity cost category.

b) Calculate the cost of Job 845 using ABC to assign overhead costs.

c) Calculate the cost of Job 845 using the company-wide overhead rate based on machine hours calculated.

d) Calculate the cost of Job 845 using a machine hour departmental overhead rate for the Milling Department and a direct labor hour overhead rate for the Finishing Department.

|Activity cost calculations:
Set up cost
Production scheduling cost
Production engineering cost
|Supervision cost
Machine operating cost
include the formula here
a
Direct materials
Direct labor
Manufacturing overhead cost
b
Total Job 845 cost
Total Job 845 cost
Total Job 845 cost

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 5 steps with 5 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Financial Reporting in Hyperinflationary Economies

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.

Similar questions