EXCEL ASSIGNMENT \#1 - MANUFACTURING OVERHEAD Estimates made at the beginning of the period Estimated direct labor hours Estimated total fixed manufacturing Estimated variable manufacturing overhead per direct labor hour Actual amounts as of the end of the period Actual total direct labor hours worked Actual total manufacturing overhead incurred * in cell b4, input the sum of 230,000+ the last 5 digits of your student 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 1. Compute total ESTIMATED manufacturing overhead Fixed manufacturing overhead Variable manufacturing overhead Total manufacturing overhead 2. Compute the predetermined overhead rate used to apply manufacturing overhead to jobs 3. Compute the total amount of overhead applied to jobs during the period 4. Compute the amount of overapplied or underapplied overhead (if overapplied, present as a positive number; if underapplied, present as a negative number) ALSO - BE SURE TO COMPLETE THE JOURNAL ENTRIES WORKSHEET PORTION OF THE