A company manufactures a product on a highly automated assembly line. Its costing system uses two cost categories, direct materials and conversion costs. Each product must pass through the Assembly Department and the Testing Department Direct materials are added at the beginning of the production process Conversion costs are allocated evenly throughout production. The company uses weighted average costing Data for the Assembly Department are: Work in process, beginning inventory Direct materials (100% complete) Conversion costs (50% complete) Costs of work in process, beginning inventory Direct matenals Conversion costs Units started duning June Units completed and transferred Work in process, ending inventory Direct materials (100% complete) Conversion costs (70% complete) Costs added during June 2009 Direct matenals costs Conversion costs REQUIRED: 250 units $180,200 $271.325 800 units 900 units 150 units $339550 $276400 (a) Prepare a production cost worksheet with supporting schedules using the weighted-average method of process costing. Click this link production cost worksheet and enter your answers. After that you should be able to save your work in the excel template and then c