please make as organised as possible as the excel sheet is where i fill all that in!

The following are the operating and cost data information for January. The January 1 Beginning Work In Process - Mixing consisted of 20,000 units (30% complete) The cost for this inventory include: $20,000 of direct materials, $35,000 of direct labor, and $65,000 of factory overhead. In addition to the beginning inventory, the company started 30,000 units They incurred the following cost into Work-In-Process Inventory: $190,000 Direct materials, Direct labor, Factory overhead, $ 90,000 $125,000 During January, the company completed and transferred out 45,000 units of its product to the WIP - Bottling Department. At the end of the month, the work in process inventory consisted of 5,000 units that were 45% complete with respect to conversion cost. SHOW YOUR WORK-YOU NEED ALL OF THE WORDS ALONG WITH THE NUMBERS (USE THE EXCEL WORKSHEET PROVIDED ON BLACKBOARD TO ANSWER THIS QUESTION)-Weighted average method) You must create formulas - I showed you how to do this in class. A) Prepare the company's process cost summary for January: The report should include all of the following: a) Units to Account For and Units Accounted For b) Find Equivalent Units c) Cost to Account For d) Cost per Equivalent Unit e) Cost Accounted For B) Prepare the Journal entry for the transfer to the Bottling Department 1 Process Costing Worksheet 2 W Average method 3 4 5 6 Step 1 - Find Units to Account For 7 8 BI 9 Started/Transferred in 10 11 Total Units to Account For 12 13 14 Step 3 - Find Equivelant Units 15 16 C&TO 17 El 18 19 Total Equivelant Units 20 21 Step 4 - Cost to Account For 22 23 Beginning 24 Cost Incurred during the period 25 26 Total Cost to Account For 27 28 29 Step 5-Cost per EU 30 Divide by EU 75% Rolls 0 Transferred In Transferred In Step 2 - Units Accounted For Completed & Trans Out EI Total Units Accounted For DM DM CC-Includes DL and OH CC Totals Step 5-Cost per EU Divide by EU Cost per EU Step 6-Cost Accounted For Transferred Out Ending Inventory EU C&TO (All should be at 100%) TI+DM+CC EI TI DM CC Totals If you do not have any units transferred in Then you would not have a TI column - only would have DM and CC - Cost