Step : Calculate the estimated total manufacturing overhead cost for each departmentChange the total fixed manufacturing overhead cost for the Milling Department in Data area back to $ keeplng all of the
other data the same as in the original example. Consider a new Job, Job with the following characteristics:
In your worksheet, enter this new data In the cells for Job
What is the new selling price for Job
Without changing the data for the Job from requirement above, what is the selling price for Job if the total number of machine
hours In the Assembly Department Increases from machinehours to machinehours?
Restore the total number of machinehours In the Assembly Department to machinehours. And keep the job data the same
as It was in Requirement What is the selling price for Job if the total number of direct laborhours in the Assembly Department
decreases from direct laborhours to direct laborhours?
Step : Calculate the predetermined overhead rate in each department
Milling
Assembly
Total manufacturing overhead
Total machinehours or direct laborhours
Predetermined overhead rate per machinehour or direct laborhour
Step : Calculate the amount of overhead applied from both departments to Job