Create a production report for the month ended 9/30/18 using T- Accounts for units and dollars first.
| Units Costs Screen Shot 2018-03-22 at 1.25.09 PM- Beginning Work-in-Process Inventary Started in Production in September Total to Account For Q Search 18,000 View Zoom Highlight Rotate Markup Search 14,000 Completed and Transferred to Finishing Department during September Ending work-in-Process Inventory (25% complete for direct materials, SO% complete for conversion costs Total Accounted For includes $4,000 dieect maserials and 32,000 conversion costs Go to textbook Summary Problem pps. 1100-1101 Review problem and solution. 2. Use the same information to create a production report for the month ended 9/30/18 using Excel formulas and cell references. I recommend that you setup T-accounts for units and dollars first 3. Refer to the DEMOS Ch. 20 file in MODULE Chapter 20- exercise 20-19, Be sure to click on numbers to "see Excel formulas and cell references ) 4,00 5& 0o0/15,00 UP-04D par LUP e 50% em let 2.000 EUP 32.03016000 EUP 200 per EUP 14OO3 EUP $2.00 per EUP-528,000 11,000 EUP 10 40 per EuP-5400 8.000 55,E28,000 33,603 Complete a production cost report for the Mixing Departiment for the month of Scpecmber 2018 no desemine the cost of the units completed and transferred our the cost of the ending Work-in-Process Inventory-Mixing, Assume Santa Fe Paints uses the weghied-average method. ceLeaning Objoctives 2 and 3) 2,000 EUP . $200 per tur-34,000 Solution The Miring Deparamens transferred 14,000 anis with a cost of $33,600 o th Finishing Department in Sepeember. The ending balance in Work in Process SANTA FE PAINTS Month Ended September 20, 2018 Equivalent Units Materiels Converon > Check Your Understanding 20-2 Units to account for Tetel units to aceount fer This problem extends Check Your Lndesstanding 20-1 into a sccond department Finishing Daring Sepacmbs, Santa Fe Paiserts the follouing in is Finishing Units acoounted tor 14,000 Completed and trarsferred e Ending werk-in-proces 1000 .000 Total units accounted for Beginning work-in-Process Inventory 20% complete for drect materials; 70% complete for conversion costs) Transferred in from Mixing Depsrtment during September Completed and trensferred out to Firished Goods inventory during September .nding work-in-Pracru Inventory (30% complete for drect materials; R0% complete or conversion costs) 14,000 units Costs to account for 1,000 units Ceats added during period Total costs to account for Divided by: Total EUP Cost per equhelent unit 38.000 Wark-in-Process Inventory, August 31 (transferred in costs, $11,400, drect materials costs, 51,000, conversion costs, $1,80 Transferred in from Mixing Department during September (see Summary Problem t) Cirect materials added during September Corwersion costs added during September 14,200 13,600 5,360 24,300 Costs accounted for Completed and transferred out Ending work-in-process 4400 Total costs accounted for s 32.000
