Can you complete this accounting problem?

HORNGREN'S ACCOUNTING -- Tenth Edition E20-25 Cool Spring Company produces premium bottled water. In the second department, the Bottling Department, conversion costs are incurred evenly throughout the bottling process, but packaging materials are not added until the end of the process. Costs in beginning Work-in-Process Inventory include transferred in costs of $1,800, direct labor of $500, and manufacturing overhead of $430. February data for the Bottling Department is provided Requirements 1. Prepare a production cost report for the Bottling Department for the month of February. 2. Prepare the journal entry to record the cost of units completed and transferred out. 3. Post all transactions to the Work-in-Process InventoryBottling T-account. What is the ending balance? Solution: Requirement 1 UNITS COOL SPRING COMPANY Production Cost ReportBOTTLING DEPARTMENT Month Ended February 28, 2015 Equivalent Units Whole Transferred In Direct Conversion Units Materials Costs COSTS Transferred In Direct Materials Debit Conversion Costs Total Costs Credit Requirement 2 Date Accounts and Explanation Requirement 3 Chapter 20: Process Costing Work-in-ProcessBottling Page 1 of 2 Cool Spring Company Work-in-process inventory - bottling Month Ended February 28,2015 Dollars Transferred Direct Units In Materials Beginning Inventory Feb.1 (40% Complete 5000 Production Started 165000 Transferred out 150000 Ending Inventory Feb. 28 (70% Complete) 20000 $1,800 132500 $30,400 Direct Labor $500 33100 Manufacturing Overhead Total Costs $430 23370 $2,730 219370