Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started