Nonuniform Inputs, Weighted Average Carter Inc. had the following production and cost information for its fabrication department during April (with matenals added at the beginning of the fabrication process) 9.000 DATA Production Units in process, April 1. 50% complete with respect to conversion Units completed Units in process, April 30. -80% complete 65.800 13.000 Costs Work in proces. April 1: Materials Conversion costs Total Current costs: Materials Conversion costs Total 547.610 29,380 $78,990 $120.000 204,000 $324.000 Carter uses the weighted average method. Using formulas and cell references, perform the required analysis, and input your answers into the green cells in the Cand D columns. Use the blue entry cells (C35 D39, C47 C48) for intermediate calculations. Transfer the numeric results for the green entry cells (C30 D32, C41. C44. C49) into the appropriate fields in CNOWv2 for grading Required: 1. Carter Inc. Schedule of Equivalent Units (Weighted Average Method) Materials Conversion Formulas Materials Conversion Units completed Units in EWIP Total equivalent units Materials Conversion Materials Conversion 2 BWP costs Current costs Total costs Equivalent units Unit cost 2 Total unit cost 3 Cost of units transferred out