please show work in excel, thanks :)

Required information [The following information applies to the questions displayed below.) Clopack Company manufactures one product that goes through one processing department called Mixing. All raw materials are introduced at the start of work in the Mixing Department. The company uses the weighted average method of process costing. Its Work in Process T-account for the Mixing Department for June follows (all forthcoming questions pertain to June): ? June 1 balance Materials Direct labor Overhead June 30 balance Work in Process-Mixing Department 30,000 Completed and transferred to Finished Goods 142,840 91,500 109,000 ? The June 1 work in process inventory consisted of 4,800 units with $17,140 in materials cost and $12,860 in conversion cost. The June 1 work in process inventory was 100% complete with respect to materials and 60% complete with respect to conversion. During June, 37,300 units were started into production. The June 30 work in process inventory consisted of 8,000 units that were 100% complete with respect to materials and 50% complete with respect to conversion. 6. What is the cost of beginning work in process inventory plus the cost added during the period for materials? Total cost of materials 13. What is the amount of conversion cost transferred to finished goods? (Round your intermediate calculations to 2 places.) Conversion cost transferred to finished goods 14. Prepare the journal entry to record the transfer of costs from Work in Process to Finished Goods. (If no entry is required for a transaction/event, select "No journal entry required" in the first account field.) 15-a. What is the total cost to be accounted for? 15-b. What is the total cost accounted for? a. Total cost to be accounted for b. Total cost accounted for b