P-M:3-33A. Preparing a production cost report, beginning WIP, no costs transferred in; journal entries (Learning Objectives 2, 3, 5) Roan Paper Co. produces the paper used by wallpaper manufacturers. Roan's four-stage process includes mixing, cooking, rolling, and cutting. On March 1, the Mixing Department had 300 rolls of paper in process. During March, the Mixing Department completed the mixing process for those 300 rolls and also started and completed the mixing process for an additional 4,200 rolls of paper. The department started but did not finish the mixing process for an additional 500 rolls, which were 20% complete with respect to both direct materials and conversion work at the end of March. Direct materials and conversion costs are incurred evenly throughout the mixing process. The Mixing Department compiled the following data for March: Chapter M:3 Using Excel Using Excel to prepare a production cost report Salish Cratt Beers provides the following information for the Molting Department for the month of August 2024 : Requirements Complete a production cost report for the Malting Department for the month of August 2024 to determine the cost of the units completed and transferred out, and the cost of the ending Work-in-Process inventory. Assume Salish Craft Beers uses the weighted-average method. Excel skils 1. Enter numbersinto cells. 2. Createformulas. 3. Format the cells requiring dollar signs. 4. Format the cells requiring a single underline and cells requiring double underlines. Requirement 2 1. Prepare a production cost report for the Mixing Department for March. The company uses the weighted-average method. 52. Joumalize all transactions affecting the company's mixing process during March. Assume labor costs are accrued and not yet paid. ution: Requirement 1 P-M:3A-38A. Preparing a production cost report, first department, with beginning WIP; journal entries; FIFO method (Learning Objective 7) Appendix 3A Work Problem P-M:3-33A using the FIFO method. The Mixing Department beginning work in process of 300 units is 40% complete as to both direct materials and conversion costs. Round equivalent unit of production costs to four decimal places. Round all other costs to the nearest whole dollar. 1. Cost per EUP for CC $1.3895 ROAN PAPER COMPANY Production Cost Report-MIXING DEPARTMENT Month Ended March 31, 20XX Equivalent Units Direct Conversion UNITS Whole Materials Costs Requirement 2 ROAN PAPER COMPANY Production Cost Report-MIXING DEPARTMENT Month Ended March 31, 2024 Requirements 1. Prepare a production cost report for the Mixing Department for March. The company uses the weighted-average method. Cost per EUP for CC $1.45 2. Journalize all transactions affecting the company's mixing process during March. Assume labor costs are accrued and not yet paid