Student Name: Exercise 4-11 Comprehensive Exercise; Second Production Department- Weighted-Average Method Special instruction: Complete Exercise 4-11 using Microsoft Excel. Details for how to complete this exercise can be found in the sections on learning objectives 2, 3, 4, and 5 in Chapter 4 of your textbook Scribners Corporation produces fine papers in three production departments Pulping, Drying. and Finishing. In the Pulping Department, raw materials such as wood fiber and rag cotton are mechanically and chemically treated to separate their fibers. The result is a thick slurry of fibers, In the Drying Department, the wet fibers transferred from the Pulping Department are laid down on porous webs, pressed to remove excess liquid, and dried in ovens. In the Finishing Department, the dried paper is coated, cut, and spooled onto reels. The company uses the weighted-average method in its process costing system. Data for March for the Drying Department follow; Percent Complete Units Pulping Conversion Work in process inventory, March 1 5,000 100% 20% Work in process inventory, March 31 8.000 100% 25% Pulping cost in work in process inventory, March 1 $4,800 Conversion cost in work in process inventory, March 1 $500 Units transferred to the next production department 157,000 Pulping cost added during March $102,450 Conversion cost added during March $31,300 No materials are added in th: Department. Pulping cost represents the costs of the wet fibers transferred in from the Pulping Department. Wet fiber is processed in the Drying Department in batches; each unit in the above table is a batch and one batch of wet fibers produces a set amount of dried paper that is passed on to the Finishing Department. Required: 1. Compute the Drying Department's equivalent units of production for pulping and conversion in March. 2. Compute the Drying Department's cost per equivalent unit for pulping and conversion i March 3. Compute the Drying Department's cost of ending work in process inventory for pulping conversion, and in total for March. 4. Compute the Drying Department's cost of units transferred out to the Finishing Department for pulping, conversion, and in total in March. 5. Prepare a cost reconciliation report for the Drying Department for March. lih 39 Ah Rmyggim