Please help with excel sheet E3-5 .........What if problem

Exercise 3-5 Unit Reconciliation During August, Panama Paint Company engaged in manufacturing cans of paint, with the following information concerning its production: Cans of paint completed Cans in production at August 1 Beginning units complete with respect to material Beginning units complete with respect to conversion costs Cans started during August 90,000 850 75% 50% 95,000 Required How many units were in Work in Process at the end of August? Units in beginning work in process units started during August units to account for 850 95,000 95,850 units completed units in ending work process total units accounted for 90,000 5,850 95,850 Exercise 3-8 Cost Reconciliation During December, Western Solvent engaged in manufacturing containers of solvent. The following information concerns its production: Units completed Units in ending work in process Ending units complete with respect to labor and overhead Ending units complete with respect to material Costs incurred during December: Material cost Labor cost Manufacturing overhead cost Cost per equivalent unit: Material Labor Manufacturing overhead 40,000 10,000 30% 100% $ 260,000 120,000 161,000 $ $ $ 6.00 3.00 4.00 Required Calculate the amount of material cost, labor cost, and overhead cost in beginning Work in Process inventory. Materials - equivalent units: Units completed Units in ending work in process Total units accounted for 40,000 10,000 50,000 Material cost per equivalent unit: 260,000 Labor - equivalent units: Units completed Units in ending work in process Total units accounted for 40,000 10,000 50,000 Labor cost per equivalent unit: 120,000 Overhead - equivalent units: Units completed Units in ending work in process Total units accounted for 40,000 10,000 50,000 Overhead cost per equivalent unit: 161,000 100% 100% + 50,000 100% 30% + 43,000 100% 30% + 43,000 40,000 10,000 50,000 40,000 = $ 6.00 = $ 3.00 = $ 4.00 40,000 3,000 43,000 9,000 40,000 3,000 43,000 11,000 Problem 3-1 Comprehensive Problem, One Department Regal Polish manufactures a single product in one department and uses a process costing system. During May, the following production activity occurred: Units in process at May 1 Beginning units complete with respect to material Beginning units complete with respect to conversion costs Units started during May Units in process at May 31 Ending units complete with respect to material Ending units complete with respect to conversion costs Cost Information Direct material Direct labor Overhead Total Beginning Work in Process 11,000 100% 60% 105,000 5,100 100% 70% Costs Added in May $4,000 200 300 $4,500 $ 76,040.00 8,957.60 10,002.30 $ 94,999.90 Required a. Calculate the cost per equivalent unit for each of the three cost items and in total. Materials - equivalent units: Units in beginning work in process Units started during May Units to account for Units completed Units in ending work in process Total units accounted for Labor - equivalent units: Units in beginning work in process Units started during May Units to account for Units completed Units in ending work in process Total units accounted for 11,000 105,000 116,000 110,900 5,100 116,000 100% 100% 110,900 5,100 116,000 100% 70% 110,900 3,570 114,470 11,000 105,000 116,000 110,900 5,100 116,000 Overhead - equivalent units: Units in beginning work in process Units started during May Units to account for 11,000 105,000 116,000 Units completed Units in ending work in process Total units accounted for 110,900 5,100 116,000 100% 70% 110,900 3,570 114,470 Costs: Beginning Work in Process Material Labor Overhead Total Costs Added in May Equivalent Units Total $ 4,000.00 $ 76,040.00 $ 80,040.00 200.00 8,957.60 9,157.60 300.00 10,002.30 10,302.30 $ 4,500.00 $ 94,999.90 $ 99,499.90 116,000 114,470 11,470 Cost Per Equivalent Unit = $ 0.69 = $ 0.08 = $ 0.09 b. Calculate the cost of units completed in May and the cost of ending Work in Process. Cost of completed units: 110,900 $ 0.86 = $ 95,374.00 $ $ $ 0.69 0.08 0.09 = = = $ Cost of items in ending work in process: Material Labor Overhead Total 5,100 3,570 3,570 $ 3,519.00 285.60 321.30 4,125.90 c. Reconcile the sum of the two costs in part b to the sum of beginning Work in Process and costs added in May. Beginning work in process Cost added Total cost to account for Cost of items completed Cost of ending work in process Total cost accounted for 4,500 94.999.90 99,500 95,374 4,126 99,500 Problem 3-7 Production Cost Report, Missing Data Classic 50s Flooring produces linoleum flooring. Below is a partial production cost report for the Mixing Department. In the report, a unit is a gallon of linoleum cement (a mixture of linseed oil, pine resin, and wood flour). Production Cost Report Mixing Department June Quantity Reconciliation Units in beginning WIP Units started Units to account for Units completed Units in ending WIP Material Conversion costs Units accounted for 700 2,700 3,400 2,300 1,100 100% 70% Cost per Equivalent Calculation Cost Beginning WIP Cost incurred during June Total Units Units completed Equivalent units, ending WIP Total Cost per equivalent unit 3,400 Material Labor Overhead Total $ 475 $ 1,200 $ 2,400 $ 4,075 4,125 11,610 23,830 39,565 $ 4,600 $ 12,810 $ 26,230 $ 43,640 $ 2,300 1,100 3,400 1.35 $ Required Fill in the missing data (items a through l). (a) & (b) Units in beginning work in process Units started during June Units to account for 700 2,700 3,400 Units completed Units in ending work in process Total units accounted for 2,300 1,100 3,400 2,300 2,300 770 770 3,070 ### 4.17 $ 8.54 $ 14.07 (c) through (h) Material Units completed Units in ending WIP Total units accounted for 2,300 1,100 3,400 100 100 Conversion 2,300 1,100 3,400 100% 70 Overhead Total (i) through (l) Material Total costs Equivalent units Unit cost $ $ 4,600 $ 3,400 1.35 $ Labor 12,810 $ 26,230 3,070 ### 4.17 $ 8.54 $ 14.07 2,300 770 3,070