Question: A B C D E F G H K L M N P Q R S EXCEL ASSIGNMENT #1 - MANUFACTURING OVERHEAD Estimates made at

 A B C D E F G H K L M

A B C D E F G H K L M N P Q R S EXCEL ASSIGNMENT #1 - MANUFACTURING OVERHEAD Estimates made at the beginning of the period 1. Compute total ESTIMATED manufacturing overhead Estimated direct labor hours 207,225 Fixed manufacturing overhead Estimated total fixed manufacturing $350,000 Variable manufacturing overhead Estimated variable manufacturing overhead per direct labor hour $2.25 Total manufacturing overhead Actual amounts as of the end of the period Actual total direct labor hours worked 240,000 2. Compute the predetermined overhead rate used to apply manufacturing overhead to jobs Actual total manufacturing overhead incurred 905,000 3. Compute the total amount of overhead applied to jobs during the period * in cell b4, input the sum of 200,000 + the last 5 digits of your student number 4. Compute the amount of overapplied or underapplied overhead (if overapplied, present as a positive number; if underapplied, present as a negative number) BE SURE ALL AMOUNTS ENTERED INTO THE GRAY BOXES ARE FORMULAS. ONE HALF OF THE POINTS FOR THIS ASSIGNMENT ARE BASED ON YOUR SPREADSHEET CORRECTLY RECALCULATING WHEN THE GRADER CHANGES THE NUMBER OF DIRECT LABOR HOURS ALSO - BE SURE TO COMPLETE THE JOURNAL ENTRIES WORKSHEET PORTION OF THE

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!