last 5 diggits of student id are 09782

2:54 LTE Excel Problem #1 - Job Order Costi... ACCTG 231-SPRING 2021 EXCEL PROBLEM 1 Due Wednesday, September 15 at 11:59 pm The purpose of the excel problems is for students to use an excel spreadsheet to solve a short accounting application related to material covered in class. Information for the Morrison Company is given below and is also entered into the accompanying spreadsheet that you will use to complete this assignment. . NOTE: one of the variables, estimated direct lahor hours. will include the last 5 digits of your WSU ID number in order to provide a unique solution for each student. One half of the points for this problem are for correct accounting (ie, correctly computed amounts) and one half are for a working spreadsheet that will correctly recompute amounts when the grader changes one of the variables in column B. . Therefore it is important that everything entered into the highlighted boxes answering questions 1-5 are based on formulas or cell references, rather than numbers 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 250,000 + the last 5 digits of your WSU student ID) 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 ft.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, enter the last 5 digits of your WSU student ID into cell B1 and (S150,000 plus the last 5 digits of your WSU ID) into cell B4. G Dashboard Calendar To Do Notifications Inbox 2:54 LTE Excel Problem #1 - Job Order Costi... highlighted boxes answering questions 1-5 are based on formulas or cell references, rather than numbers 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 250,000 + the last 5 digits of your WSU student ID) 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 fi.e. cost of goods sold prior to adjusting for over- or under-applied overhead) was S4.890,000 REQUIRED Using the spreadsheet provided, input formulas in the (highlighted) cells to compute the amounts indicated. Before answering questions, enter the last 5 digits of your WSU student ID into cell B1 and (S150,000 plus the last 5 digits of your WSU ID) into cell B4. 1. (I point) Compute total estimated manufacturing overhead. 2. (1 point) Compute the predetermined overhead rate used to apply MOH to jobs. 3. (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 S. (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 Bis changed 1888 D Dashboard Calendar To Do Notifications Inbow Last 5 digits of your student number Estimates made at the beginning of the period Estimated direct labor hours Estimated variable manufacturing overhead per direct labor hour $2.40 Estimated total fixed manufacturing overhead $280,000 Actual amounts as of the end of the period Actual total manufacturing overhead incurred $700,000 2 Actual total direct labor hours worked 210,000 Unadjusted cost of goods sold $4,890,000 3 * In cell b4, input the sum of $250,000 + the last 5 digits of your student numb 4 1. Compute total manufacturing overhead estimated at the beginning of the period Fixed manufacturing overhead 40 Variable manufacturing overhead 00 Total manufacturing overhead 2002. Compute the predetermined overhead rate used to apply manufacturing overhead to jobs 000 3. Compute the total amount of overhead applied to jobs during the period amb 4. Compute the amount of overapplied or underapplied overhead ilfoverapplied, present as a positive number: It underapplied, present as a negative number) 5. Compute the new balance in cost of goods sold after adjusting for over-or under applied overhead, 500 2:54 LTE Excel Problem #1 - Job Order Costi... ACCTG 231-SPRING 2021 EXCEL PROBLEM 1 Due Wednesday, September 15 at 11:59 pm The purpose of the excel problems is for students to use an excel spreadsheet to solve a short accounting application related to material covered in class. Information for the Morrison Company is given below and is also entered into the accompanying spreadsheet that you will use to complete this assignment. . NOTE: one of the variables, estimated direct lahor hours. will include the last 5 digits of your WSU ID number in order to provide a unique solution for each student. One half of the points for this problem are for correct accounting (ie, correctly computed amounts) and one half are for a working spreadsheet that will correctly recompute amounts when the grader changes one of the variables in column B. . Therefore it is important that everything entered into the highlighted boxes answering questions 1-5 are based on formulas or cell references, rather than numbers 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 250,000 + the last 5 digits of your WSU student ID) 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 ft.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, enter the last 5 digits of your WSU student ID into cell B1 and (S150,000 plus the last 5 digits of your WSU ID) into cell B4. G Dashboard Calendar To Do Notifications Inbox 2:54 LTE Excel Problem #1 - Job Order Costi... highlighted boxes answering questions 1-5 are based on formulas or cell references, rather than numbers 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 250,000 + the last 5 digits of your WSU student ID) 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 fi.e. cost of goods sold prior to adjusting for over- or under-applied overhead) was S4.890,000 REQUIRED Using the spreadsheet provided, input formulas in the (highlighted) cells to compute the amounts indicated. Before answering questions, enter the last 5 digits of your WSU student ID into cell B1 and (S150,000 plus the last 5 digits of your WSU ID) into cell B4. 1. (I point) Compute total estimated manufacturing overhead. 2. (1 point) Compute the predetermined overhead rate used to apply MOH to jobs. 3. (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 S. (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 Bis changed 1888 D Dashboard Calendar To Do Notifications Inbow Last 5 digits of your student number Estimates made at the beginning of the period Estimated direct labor hours Estimated variable manufacturing overhead per direct labor hour $2.40 Estimated total fixed manufacturing overhead $280,000 Actual amounts as of the end of the period Actual total manufacturing overhead incurred $700,000 2 Actual total direct labor hours worked 210,000 Unadjusted cost of goods sold $4,890,000 3 * In cell b4, input the sum of $250,000 + the last 5 digits of your student numb 4 1. Compute total manufacturing overhead estimated at the beginning of the period Fixed manufacturing overhead 40 Variable manufacturing overhead 00 Total manufacturing overhead 2002. Compute the predetermined overhead rate used to apply manufacturing overhead to jobs 000 3. Compute the total amount of overhead applied to jobs during the period amb 4. Compute the amount of overapplied or underapplied overhead ilfoverapplied, present as a positive number: It underapplied, present as a negative number) 5. Compute the new balance in cost of goods sold after adjusting for over-or under applied overhead, 500