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 materials Conversion costs Units started during June Units completed and transferred Work in process, ending inventory Direct materials (100% complete) Conversion costs (70% complete) Costs added during June 2009 Direct materia's 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 casting