Information Morrison Company applies manufacturing overhead to jobs using direct labor hours as its activity base. As of the beginning of the period, Morrison estimated total fixed manufacturing overhead for the period to be $280,000, variable manufacturing overhead to be $2.40 per direct labor hour and total direct labor hours to be (the sum of 150,000 + 16812). As of the end of the period, Morrison determined that actual manufacturing overhead incurred was $700,000 and actual direct labor hours worked were 210,000. Finally, the period's unadjusted cost of goods (i.e. cost of goods sold prior to adjusting for over-or under-applied overhead) was $4,890,000. REQUIRED Using the spreadsheet provided, input formulas in the (highlighted) cells to compute the amounts indicated. Before answering questions, 16812 into cell B1 and ($150,000 plus 16812) into cell 04. 1. (1 point) Compute total estimated manufacturing overhead. 2. (1 point) Compute the predetermined overhead rate used to apply MOH to jobs. 3. (1 point) Compute the total amount of overhead applied to jobs during the period. 4. (1 points) Compute over- or under-applied MOH, indicating whether overhead is over or under applied as directed on the spreadsheet. 5. (1 point) Compute the new balance in cost of goods sold after adjusting for over- or under-applied overhead. 6. (5 points) Spreadsheet correctly recomputes answers when a variable in column B is changed. 16812 Estimates made at the beginning of the period Estimated direct labor hours Estimated variable manufacturing overhead per direct labor hour Estimated total fixed manufacturing overhead $2.40 $280,000 Actual amounts as of the end of the period Actual total manufacturing overhead incurred Actual total direct labor hours worked Unadjusted cost of goods sold $700,000 210,000 $4,890,000 *in cell b4, input the sum of $250,000+the last 5 digits of your student number 1. Compute total manufacturing overhead estimated at the beginning of the period 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) 5. Compute the new balance in cost of goods sold after adjusting for over-or under-applied overhead