Last Saturday sale ($) (1) 5,000 : Cell C1 Last Sunday sale ($) (2) 7,000 : Cell
Question:
Last Saturday sale ($) (1) 5,000 : Cell C1 Last Sunday sale ($) (2) 7,000 : Cell C2 Total for the weekend (3) = (1) + (2) 12,000 : Cell C3 Formula should be clearly displayed. Amount, $ to be typed in, for 5,000 and 7,000, for cells C1 and C2. Amount, $ is not to be typed in for 12,000 for cell C3. The formula in C3 should be =+C1+C2 in the Excel file or use the Autosum function in Excel Once 5,000 and 7,000 are typed onto cells C1 and C2, then 12,000 would automatically appear in cell C3.
QUESTION: Mixing Department has gathered the following information for June 2022:
Units of beginning work in process ……………………………… 20,000
Units started into production during the month of June with 40,000 Units of ending work in process…………………………………… 25,000
Percentage of completion of conversion costs of ending work in process…. 40% $
Cost of opening work-in-process: Direct materials (100% complete) …………………….. $10,000
Conversion cost (partially complete) $24,000 $ Costs incurred in the month of June:
Direct materials………………………………………………….. $80,000
Conversion costs………………………………………………… $57,000
Required: Prepare a Production Cost Report for Mixing Department for June 2022. Formula is to be clearly shown.