Cepeda Corporation has the following cost records for June 2017 Indirect factory labor $5,220 Factory utilities $510 Direct materials used 22,340 Depreciation, factory equipment 1,720 Work in process, 6 1 17 3,750 Direct labor 42,990 Work in process, 6 30 17 4,570 Maintenance, factory equipment 1,980 Finished goods, 6 1 17 5,210 Indirect materials 2,920 Finished goods, 6 30 17 8,430 Factory managers salary 3,470 Prepare a cost of goods manufactured schedule for June 2017 CEPEDA CORPORATION Cost of Goods Manufactured Schedule For the Year Ended June 30, 2017June 30, 2017For the Month Ended June 30, 2017 Cost of Goods ManufacturedDepreciation, Factory EquipmentDirect LaborDirect Materials UsedFactory Managers SalaryFactory UtilitiesIndirect LaborIndirect MaterialsMaintenance, Factory EquipmentManufacturing OverheadTotal Cost of Work in ProcessTotal Manufacturing CostsTotal Manufacturing OverheadWork in Process, June 1Work in Process, June 30Finished Goods, June 1Finished Goods, June 30 $ Cost of Goods ManufacturedDepreciation, Factory EquipmentDirect LaborDirect Materials UsedFactory Managers SalaryFactory UtilitiesIndirect LaborIndirect MaterialsMaintenance, Factory EquipmentManufacturing OverheadTotal Cost of Work in ProcessTotal Manufacturing CostsTotal Manufacturing OverheadWork in Process, June 1Work in Process, June 30Finished Goods, June 1Finished Goods, June 30 $ Cost of Goods ManufacturedDepreciation, Factory EquipmentDirect LaborDirect Materials UsedFactory Managers SalaryFactory UtilitiesIndirect LaborIndirect MaterialsMaintenance, Factory EquipmentManufacturing OverheadTotal Cost of Work in ProcessTotal Manufacturing CostsTotal Manufacturing OverheadWork in Process, June 1Work in Process, June 30Finished Goods, June 1Finished Goods, June 30 Cost of Goods ManufacturedDepreciation, Factory EquipmentDirect LaborDirect Materials UsedFactory Managers SalaryFactory UtilitiesIndirect LaborIndirect MaterialsMaintenance, Factory EquipmentManufacturing OverheadTotal Cost of Work in ProcessTotal Manufacturing CostsTotal Manufacturing OverheadWork in Process, June 1Work in Process, June 30Finished Goods, June 1Finished Goods, June 30 Cost of Goods Manufactured Depreciation, Factory Equipment Direct Labor Direct Materials Used Factory Managers Salary Factory Utilities Indirect Labor Indirect Materials Maintenance, Factory Equipment Manufacturing Overhead Total Cost of Work in Process Total Manufacturing Costs Total Manufacturing Overhead Work in Process, June 1 Work in Process, June 30 Finished Goods, June 1 Finished Goods, June 30 $ Cost of Goods Manufactured Depreciation, Factory Equipment Direct Labor Direct Materials Used Factory Managers Salary Factory Utilities Indirect Labor Indirect Materials Maintenance, Factory Equipment Manufacturing Overhead Total Cost of Work in Process Total Manufacturing Costs Total Manufacturing Overhead Work in Process, June 1 Work in Process, June 30 Finished Goods, June 1 Finished Goods, June 30 Cost of Goods Manufactured Depreciation, Factory Equipment Direct Labor Direct Materials Used Factory Managers Salary Factory Utilities Indirect Labor Indirect Materials Maintenance, Factory Equipment Manufacturing Overhead Total Cost of Work in Process Total Manufacturing Costs Total Manufacturing Overhead Work in Process, June 1 Work in Process, June 30 Finished Goods, June 1 Finished Goods, June 30 Cost of Goods Manufactured Depreciation, Factory Equipment Direct Labor Direct Materials Used Factory Managers Salary Factory Utilities Indirect Labor Indirect Materials Maintenance, Factory Equipment Manufacturing Overhead Total Cost of Work in Process Total Manufacturing Costs Total Manufacturing Overhead Work in Process, June 1 Work in Process, June 30 Finished Goods, June 1 Finished Goods, June 30 Cost of Goods Manufactured Depreciation, Factory Equipment Direct Labor Direct Materials Used Factory Managers Salary Factory Utilities Indirect Labor Indirect Materials Maintenance, Factory Equipment Manufacturing Overhead Total Cost of Work in Process Total Manufacturing Costs Total Manufacturing Overhead Work in Process, June 1 Work in Process, June 30 Finished Goods, June 1 Finished Goods, June 30 Cost of Goods ManufacturedDepreciation, Factory EquipmentDirect LaborDirect Materials UsedFactory Managers SalaryFactory UtilitiesIndirect LaborIndirect MaterialsMaintenance, Factory EquipmentManufacturing OverheadTotal Cost of Work in ProcessTotal Manufacturing CostsTotal Manufacturing OverheadWork in Process, June 1Work in Process, June 30Finished Goods, June 1Finished Goods, June 30 Cost of Goods ManufacturedDepreciation, Factory EquipmentDirect LaborDirect Materials UsedFactory Managers SalaryFactory UtilitiesIndirect LaborIndirect MaterialsMaintenance, Factory EquipmentManufacturing OverheadTotal Cost of Work in ProcessTotal Manufacturing CostsTotal Manufacturing OverheadWork in Process, June 1Work in Process, June 30Finished Goods, June 1Finished Goods, June 30 Cost of Goods ManufacturedDepreciation, Factory EquipmentDirect LaborDirect Materials UsedFactory Managers SalaryFactory UtilitiesIndirect LaborIndirect MaterialsMaintenance, Factory EquipmentManufacturing OverheadTotal Cost of Work in ProcessTotal Manufacturing CostsTotal Manufacturing OverheadWork in Process, June 1Work in Process, June 30Finished Goods, June 1Finished Goods, June 30 Cost of Goods ManufacturedDepreciation, Factory EquipmentDirect LaborDirect Materials UsedFactory Managers SalaryFactory UtilitiesIndirect LaborIndirect MaterialsMaintenance, Factory EquipmentManufacturing OverheadTotal Cost of Work in ProcessTotal Manufacturing CostsTotal Manufacturing OverheadWork in Process, June 1Work in Process, June 30Finished Goods, June 1Finished Goods, June 30 AddLess Cost of Goods ManufacturedDepreciation, Factory EquipmentDirect LaborDirect Materials UsedFactory Managers SalaryFactory UtilitiesIndirect LaborIndirect MaterialsMaintenance, Factory EquipmentManufacturing OverheadTotal Cost of Work in ProcessTotal Manufacturing CostsTotal Manufacturing OverheadWork in Process, June 1Work in Process, June 30Finished Goods, June 1Finished Goods, June 30 Cost of Goods ManufacturedDepreciation, Factory EquipmentDirect LaborDirect Materials UsedFactory Managers SalaryFactory UtilitiesIndirect LaborIndirect MaterialsMaintenance, Factory EquipmentManufacturing OverheadTotal Cost of Work in ProcessTotal Manufacturing CostsTotal Manufacturing OverheadWork in Process, June 1Work in Process, June 30Finished Goods, June 1Finished Goods, June 30 $ LINK TO TEXT Prepare an income statement through gross profit for June 2017 assuming sales revenue is $88,010 CEPEDA CORPORATION Income Statement (Partial) For the Month Ended June 30, 2017June 30, 2017For the Year Ended June 30, 2017 Cost of Goods Available for SaleCost of Goods ManufacturedCost of Goods SoldFinished Goods, June 1Finished Goods, June 30Gross ProfitSales RevenueDepreciation, Factory EquipmentDirect LaborDirect Materials UsedFactory Managers SalaryFactory UtilitiesIndirect LaborIndirect MaterialsMaintenance, Factory EquipmentManufacturing OverheadTotal Cost of Work in ProcessTotal Manufacturing CostsTotal Manufacturing OverheadWork in Process, June 1Work in Process, June 30 $ Cost of Goods Available for SaleCost of Goods ManufacturedCost of Goods SoldFinished Goods, June 1Finished Goods, June 30Gross ProfitSales RevenueDepreciation, Factory EquipmentDirect LaborDirect Materials UsedFactory Managers SalaryFactory UtilitiesIndirect LaborIndirect MaterialsMaintenance, Factory EquipmentManufacturing OverheadTotal Cost of Work in ProcessTotal Manufacturing CostsTotal Manufacturing OverheadWork in Process, June 1Work in Process, June 30 Cost of Goods Available for SaleCost of Goods ManufacturedCost of Goods SoldFinished Goods, June 1Finished Goods, June 30Gross ProfitSales RevenueDepreciation, Factory EquipmentDirect LaborDirect Materials UsedFactory Managers SalaryFactory UtilitiesIndirect LaborIndirect MaterialsMaintenance, Factory EquipmentManufacturing OverheadTotal Cost of Work in ProcessTotal Manufacturing CostsTotal Manufacturing OverheadWork in Process, June 1Work in Process, June 30 $ Cost of Goods Available for SaleCost of Goods ManufacturedCost of Goods SoldFinished Goods, June 1Finished Goods, June 30Gross ProfitSales RevenueDepreciation, Factory EquipmentDirect LaborDirect Materials UsedFactory Managers SalaryFactory UtilitiesIndirect LaborIndirect MaterialsMaintenance, Factory EquipmentManufacturing OverheadTotal Cost of Work in ProcessTotal Manufacturing CostsTotal Manufacturing OverheadWork in Process, June 1Work in Process, June 30 Cost of Goods Available for SaleCost of Goods ManufacturedCost of Goods SoldFinished Goods, June 1Finished Goods, June 30Gross ProfitSales RevenueDepreciation, Factory EquipmentDirect LaborDirect Materials UsedFactory Managers SalaryFactory UtilitiesIndirect LaborIndirect MaterialsMaintenance, Factory EquipmentManufacturing OverheadTotal Cost of Work in ProcessTotal Manufacturing CostsTotal Manufacturing OverheadWork in Process, June 1Work in Process, June 30 AddLess Cost of Goods Available for SaleCost of Goods ManufacturedCost of Goods SoldFinished Goods, June 1Finished Goods, June 30Gross ProfitSales RevenueDepreciation, Factory EquipmentDirect LaborDirect Materials UsedFactory Managers SalaryFactory UtilitiesIndirect LaborIndirect MaterialsMaintenance, Factory EquipmentManufacturing OverheadTotal Cost of Work in ProcessTotal Manufacturing CostsTotal Manufacturing OverheadWork in Process, June 1Work in Process, June 30 Cost of Goods Available for SaleCost of Goods ManufacturedCost of Goods SoldFinished Goods, June 1Finished Goods, June 30Gross ProfitSales RevenueDepreciation, Factory EquipmentDirect LaborDirect Materials UsedFactory Managers SalaryFactory UtilitiesIndirect LaborIndirect MaterialsMaintenance, Factory EquipmentManufacturing OverheadTotal Cost of Work in ProcessTotal Manufacturing CostsTotal Manufacturing OverheadWork in Process, June 1Work in Process, June 30 Cost of Goods Available for SaleCost of Goods ManufacturedCost of Goods SoldFinished Goods, June 1Finished Goods, June 30Gross ProfitSales RevenueDepreciation, Factory EquipmentDirect LaborDirect Materials UsedFactory Managers SalaryFactory UtilitiesIndirect LaborIndirect MaterialsMaintenance, Factory EquipmentManufacturing OverheadTotal Cost of Work in ProcessTotal Manufacturing CostsTotal Manufacturing OverheadWork in Process, June 1Work in Process, June 30 $

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jul 24, 2024

Cepeda Corporation has the following cost records for June 2017. Indirect factory labor $5,220 Factory utilities $510 Direct materials used 22,340 Depreciation, factory equipment 1,720

Cepeda Corporation has the following cost records for June 2017.

Indirect factory labor	$5,220	Factory utilities	$510
Direct materials used	22,340	Depreciation, factory equipment	1,720
Work in process, 6/1/17	3,750	Direct labor	42,990
Work in process, 6/30/17	4,570	Maintenance, factory equipment	1,980
Finished goods, 6/1/17	5,210	Indirect materials	2,920
Finished goods, 6/30/17	8,430	Factory managers salary	3,470

Prepare a cost of goods manufactured schedule for June 2017.

CEPEDA CORPORATION Cost of Goods Manufactured Schedule For the Year Ended June 30, 2017June 30, 2017For the Month Ended June 30, 2017
Cost of Goods ManufacturedDepreciation, Factory EquipmentDirect LaborDirect Materials UsedFactory Managers SalaryFactory UtilitiesIndirect LaborIndirect MaterialsMaintenance, Factory EquipmentManufacturing OverheadTotal Cost of Work in ProcessTotal Manufacturing CostsTotal Manufacturing OverheadWork in Process, June 1Work in Process, June 30Finished Goods, June 1Finished Goods, June 30			$
Cost of Goods ManufacturedDepreciation, Factory EquipmentDirect LaborDirect Materials UsedFactory Managers SalaryFactory UtilitiesIndirect LaborIndirect MaterialsMaintenance, Factory EquipmentManufacturing OverheadTotal Cost of Work in ProcessTotal Manufacturing CostsTotal Manufacturing OverheadWork in Process, June 1Work in Process, June 30Finished Goods, June 1Finished Goods, June 30		$
Cost of Goods ManufacturedDepreciation, Factory EquipmentDirect LaborDirect Materials UsedFactory Managers SalaryFactory UtilitiesIndirect LaborIndirect MaterialsMaintenance, Factory EquipmentManufacturing OverheadTotal Cost of Work in ProcessTotal Manufacturing CostsTotal Manufacturing OverheadWork in Process, June 1Work in Process, June 30Finished Goods, June 1Finished Goods, June 30
Cost of Goods ManufacturedDepreciation, Factory EquipmentDirect LaborDirect Materials UsedFactory Managers SalaryFactory UtilitiesIndirect LaborIndirect MaterialsMaintenance, Factory EquipmentManufacturing OverheadTotal Cost of Work in ProcessTotal Manufacturing CostsTotal Manufacturing OverheadWork in Process, June 1Work in Process, June 30Finished Goods, June 1Finished Goods, June 30
Cost of Goods Manufactured Depreciation, Factory Equipment Direct Labor Direct Materials Used Factory Managers Salary Factory Utilities Indirect Labor Indirect Materials Maintenance, Factory Equipment Manufacturing Overhead Total Cost of Work in Process Total Manufacturing Costs Total Manufacturing Overhead Work in Process, June 1 Work in Process, June 30 Finished Goods, June 1 Finished Goods, June 30	$
Cost of Goods Manufactured Depreciation, Factory Equipment Direct Labor Direct Materials Used Factory Managers Salary Factory Utilities Indirect Labor Indirect Materials Maintenance, Factory Equipment Manufacturing Overhead Total Cost of Work in Process Total Manufacturing Costs Total Manufacturing Overhead Work in Process, June 1 Work in Process, June 30 Finished Goods, June 1 Finished Goods, June 30
Cost of Goods Manufactured Depreciation, Factory Equipment Direct Labor Direct Materials Used Factory Managers Salary Factory Utilities Indirect Labor Indirect Materials Maintenance, Factory Equipment Manufacturing Overhead Total Cost of Work in Process Total Manufacturing Costs Total Manufacturing Overhead Work in Process, June 1 Work in Process, June 30 Finished Goods, June 1 Finished Goods, June 30
Cost of Goods Manufactured Depreciation, Factory Equipment Direct Labor Direct Materials Used Factory Managers Salary Factory Utilities Indirect Labor Indirect Materials Maintenance, Factory Equipment Manufacturing Overhead Total Cost of Work in Process Total Manufacturing Costs Total Manufacturing Overhead Work in Process, June 1 Work in Process, June 30 Finished Goods, June 1 Finished Goods, June 30
Cost of Goods Manufactured Depreciation, Factory Equipment Direct Labor Direct Materials Used Factory Managers Salary Factory Utilities Indirect Labor Indirect Materials Maintenance, Factory Equipment Manufacturing Overhead Total Cost of Work in Process Total Manufacturing Costs Total Manufacturing Overhead Work in Process, June 1 Work in Process, June 30 Finished Goods, June 1 Finished Goods, June 30
Cost of Goods ManufacturedDepreciation, Factory EquipmentDirect LaborDirect Materials UsedFactory Managers SalaryFactory UtilitiesIndirect LaborIndirect MaterialsMaintenance, Factory EquipmentManufacturing OverheadTotal Cost of Work in ProcessTotal Manufacturing CostsTotal Manufacturing OverheadWork in Process, June 1Work in Process, June 30Finished Goods, June 1Finished Goods, June 30
Cost of Goods ManufacturedDepreciation, Factory EquipmentDirect LaborDirect Materials UsedFactory Managers SalaryFactory UtilitiesIndirect LaborIndirect MaterialsMaintenance, Factory EquipmentManufacturing OverheadTotal Cost of Work in ProcessTotal Manufacturing CostsTotal Manufacturing OverheadWork in Process, June 1Work in Process, June 30Finished Goods, June 1Finished Goods, June 30
Cost of Goods ManufacturedDepreciation, Factory EquipmentDirect LaborDirect Materials UsedFactory Managers SalaryFactory UtilitiesIndirect LaborIndirect MaterialsMaintenance, Factory EquipmentManufacturing OverheadTotal Cost of Work in ProcessTotal Manufacturing CostsTotal Manufacturing OverheadWork in Process, June 1Work in Process, June 30Finished Goods, June 1Finished Goods, June 30
Cost of Goods ManufacturedDepreciation, Factory EquipmentDirect LaborDirect Materials UsedFactory Managers SalaryFactory UtilitiesIndirect LaborIndirect MaterialsMaintenance, Factory EquipmentManufacturing OverheadTotal Cost of Work in ProcessTotal Manufacturing CostsTotal Manufacturing OverheadWork in Process, June 1Work in Process, June 30Finished Goods, June 1Finished Goods, June 30
AddLess : Cost of Goods ManufacturedDepreciation, Factory EquipmentDirect LaborDirect Materials UsedFactory Managers SalaryFactory UtilitiesIndirect LaborIndirect MaterialsMaintenance, Factory EquipmentManufacturing OverheadTotal Cost of Work in ProcessTotal Manufacturing CostsTotal Manufacturing OverheadWork in Process, June 1Work in Process, June 30Finished Goods, June 1Finished Goods, June 30
Cost of Goods ManufacturedDepreciation, Factory EquipmentDirect LaborDirect Materials UsedFactory Managers SalaryFactory UtilitiesIndirect LaborIndirect MaterialsMaintenance, Factory EquipmentManufacturing OverheadTotal Cost of Work in ProcessTotal Manufacturing CostsTotal Manufacturing OverheadWork in Process, June 1Work in Process, June 30Finished Goods, June 1Finished Goods, June 30			$

LINK TO TEXT

Prepare an income statement through gross profit for June 2017 assuming sales revenue is $88,010.

CEPEDA CORPORATION Income Statement (Partial) For the Month Ended June 30, 2017June 30, 2017For the Year Ended June 30, 2017
Cost of Goods Available for SaleCost of Goods ManufacturedCost of Goods SoldFinished Goods, June 1Finished Goods, June 30Gross ProfitSales RevenueDepreciation, Factory EquipmentDirect LaborDirect Materials UsedFactory Managers SalaryFactory UtilitiesIndirect LaborIndirect MaterialsMaintenance, Factory EquipmentManufacturing OverheadTotal Cost of Work in ProcessTotal Manufacturing CostsTotal Manufacturing OverheadWork in Process, June 1Work in Process, June 30		$
Cost of Goods Available for SaleCost of Goods ManufacturedCost of Goods SoldFinished Goods, June 1Finished Goods, June 30Gross ProfitSales RevenueDepreciation, Factory EquipmentDirect LaborDirect Materials UsedFactory Managers SalaryFactory UtilitiesIndirect LaborIndirect MaterialsMaintenance, Factory EquipmentManufacturing OverheadTotal Cost of Work in ProcessTotal Manufacturing CostsTotal Manufacturing OverheadWork in Process, June 1Work in Process, June 30
Cost of Goods Available for SaleCost of Goods ManufacturedCost of Goods SoldFinished Goods, June 1Finished Goods, June 30Gross ProfitSales RevenueDepreciation, Factory EquipmentDirect LaborDirect Materials UsedFactory Managers SalaryFactory UtilitiesIndirect LaborIndirect MaterialsMaintenance, Factory EquipmentManufacturing OverheadTotal Cost of Work in ProcessTotal Manufacturing CostsTotal Manufacturing OverheadWork in Process, June 1Work in Process, June 30	$
Cost of Goods Available for SaleCost of Goods ManufacturedCost of Goods SoldFinished Goods, June 1Finished Goods, June 30Gross ProfitSales RevenueDepreciation, Factory EquipmentDirect LaborDirect Materials UsedFactory Managers SalaryFactory UtilitiesIndirect LaborIndirect MaterialsMaintenance, Factory EquipmentManufacturing OverheadTotal Cost of Work in ProcessTotal Manufacturing CostsTotal Manufacturing OverheadWork in Process, June 1Work in Process, June 30
Cost of Goods Available for SaleCost of Goods ManufacturedCost of Goods SoldFinished Goods, June 1Finished Goods, June 30Gross ProfitSales RevenueDepreciation, Factory EquipmentDirect LaborDirect Materials UsedFactory Managers SalaryFactory UtilitiesIndirect LaborIndirect MaterialsMaintenance, Factory EquipmentManufacturing OverheadTotal Cost of Work in ProcessTotal Manufacturing CostsTotal Manufacturing OverheadWork in Process, June 1Work in Process, June 30
AddLess : Cost of Goods Available for SaleCost of Goods ManufacturedCost of Goods SoldFinished Goods, June 1Finished Goods, June 30Gross ProfitSales RevenueDepreciation, Factory EquipmentDirect LaborDirect Materials UsedFactory Managers SalaryFactory UtilitiesIndirect LaborIndirect MaterialsMaintenance, Factory EquipmentManufacturing OverheadTotal Cost of Work in ProcessTotal Manufacturing CostsTotal Manufacturing OverheadWork in Process, June 1Work in Process, June 30
Cost of Goods Available for SaleCost of Goods ManufacturedCost of Goods SoldFinished Goods, June 1Finished Goods, June 30Gross ProfitSales RevenueDepreciation, Factory EquipmentDirect LaborDirect Materials UsedFactory Managers SalaryFactory UtilitiesIndirect LaborIndirect MaterialsMaintenance, Factory EquipmentManufacturing OverheadTotal Cost of Work in ProcessTotal Manufacturing CostsTotal Manufacturing OverheadWork in Process, June 1Work in Process, June 30
Cost of Goods Available for SaleCost of Goods ManufacturedCost of Goods SoldFinished Goods, June 1Finished Goods, June 30Gross ProfitSales RevenueDepreciation, Factory EquipmentDirect LaborDirect Materials UsedFactory Managers SalaryFactory UtilitiesIndirect LaborIndirect MaterialsMaintenance, Factory EquipmentManufacturing OverheadTotal Cost of Work in ProcessTotal Manufacturing CostsTotal Manufacturing OverheadWork in Process, June 1Work in Process, June 30		$