Last 5 digits are 09782

ACCTG 231 - Fall 2021 Excel Problem 2 The purpose of the ACCTG 231 excel problems is to provide students practice using an excel spreadsheet to solve short accounting problems related to material covered in class. Information for the Door Company is given below and also entered into the accompanying spreadsheet that you will use to complete this assignment. One variable, cost of materials included in beginning work-in-process, will be determined by the last 5 digits of each student's WSU ID number. Door Company manufactures one product using a weighted average process costing system. For the current period: Beginning work-in-process (WIP) inventory consisted of 50,000 units with a total cost of $158,000. The $158,000 included materials costs of (use the last 5 digits of your student ID). with the remainder being conversion costs. As of the beginning of the period, the beginning WIP units were 35% complete with regard to materials and 25% complete as to conversion costs). During the period an additional 200,000 units were started into production and costs added during the period were $560,000 of materials and $225,000 of conversion costs. Ending work-in-process consisted of 65,000 units that were 60% complete with regard to materials and 30% complete with regard to conversion costs. Required Compute the following, in the spaces indicated in the provided spreadsheet: 1. Compute the number of units completed and transferred out of WIP. (1 point) 2. Compute equivalent units of production for materials and for conversion costs (1 point) Compute the costs per equivalent unit for materials and for conversion costs. (1 point) 3. 4. Assign costs to units completed and transferred out and to units remaining in ending WIP inventory (1 point) Complete the Cost Reconciliation Report presented in the spreadsheet. (1 point) 5. 6. Spreadsheet correctly recomputes when the number of units of beginning WIP is changed (5 points) D F G H 1 M N 0 P Q 5 2 Information: 1 Compute the number of units completed and transferred out to the Balong Department 1 point) 4 Units: Beginning Work in Process 50.000 Ending Work in Process 65,000 7 Units started during the period 200.000 Percentage completion Materials Conversion 2 Compute equivalent units of production for material and for conversion costs (I point Materials Conversion Units completed Ending w Total Compute the costs per equivalent or for materials and for conversion cost (po Material Con 3 11 12 Beginning Work in Process 35N 25 Ending Work in Process COM 309 1 19 Cost Beginning Work in Process Materials Conversion VALUEI 12 Costs added during the period 560,000 225,000 18 tits of your student number when you enter studenti in cel, an amount wiewice 16 with the theme 16 and 16 $35.000 # Align costs to unite completed and tranferred to the banking department and found in die werkprocess (1 point Units completed and transferred to Baling Ending work in prece Complete the cost recension Report and below 1 point Costs to be accounted for Cost often WP costs added during the period Total costs to be accounted for Costs accounted for Cost of entre Cost of units transferred out Tocat costs accounted for n 34