Please complete in Excel

PROBLEM 4-9 Preparing a Production Report: Weighted Average Cost Method [LO4 CC12, 13, 14] Callisto Company manufactures chemical additives for industrial applications. As the new cost accountant for Callisto, you have been assigned the task of completing the production cost report for the most recent period. Callisto uses the weighted average cost method of process costing. The following information pertains to the most recent period: CHECK FIGURE Cost per EU, Materials; $9.846 Beginning WIP inventory Units started into production this period Units completed and transferred out Ending WIP inventory 16,000 units (75% complete as to materials; 70% complete as to conversion costs) 27,000 units 33,000 units 10,000 units (60% complete as to materials; 50% complete as to conversion costs) $132,000 materials; $164,000 conversion costs $252,000 materials; $440,000 conversion costs Costs in beginning inventory Current-period costs Required: Prepare a complete production report for the period using the weighted average cost method. (Round the cost per equivalent unit to three decimal places; round the costs in the cost report to the nearest dollar.)