Ex. 2
Cepeda Corporation has the following cost records for June
2018
Indirect factory labor $ 4,500 Factory utilities $ 400
Direct materials used 20,000 Depreciation, factory equipment
1,400
Work in process, 6/1/18 3,000 Direct labor 40,000
Work in process, 6/30/18 3,800 Maintenance, factory equipment
1,800
Finished goods, 6/1/18 5,000 Indirect materials 2,200
Finished goods, 6/30/18 7,500 Factory manager’s salary 3,000
.
Instructions
a. Prepare a cost of goods manufactured schedule for June
2018.
b. Prepare an income statement through gross profit for June 2018
assuming sales revenue is $92,100.
a. | Cepeda Corporation | ||
Cost of Goods Manufactured Schedule | |||
Work in Process Inventory, 6/1/18 | $3,000 | ||
Direct Materials Used | $20,000 | ||
Direct Labor | $40,000 | ||
Manufacturing Overhead | $13,300 | ||
Total manufacturing costs | $73,300 | ||
Total Cost of work in process inventory | $76,300 | ||
Less: Work in Process Inventory, 6/30/18 | $3,800 | ||
Cost of goods manufactured | $72,500 | ||
Working | |||
Total Manufacturing Overhead | |||
Indirect factory labor | $4,500 | ||
Factory utilities | $400 | ||
Depreciation, factory equipment | $1,400 | ||
Maintenance, factory equipment | $1,800 | ||
Indirect materials | $2,200 | ||
Factory manager’s salary | $3,000 | ||
$13,300 | |||
b. | Cepeda Corporation | ||
Income Statement (Partial) | |||
Sales Revenue | $92,100 | ||
Cost of goods sold | |||
Finish goods inventory, 1/1 | $5,000 | ||
Cost of goods manufactured | $72,500 | ||
Cost of goods available for sale | $77,500 | ||
Less: Finish goods inventory, 31/1 | $7,500 | ||
Cost of Goods Sold | $70,000 | ||
Gross Profit | $22,100 | ||
Ex. 2 Cepeda Corporation has the following cost records for June 2018 Indirect factory labor $...
E14.12 (LO 3) Cepeda Corporation has the following cost records for June 2020. Prepare a cost of goods manufactured schedule and a partial income statement. > Excel Indirect factory labor Direct materials used Work in process, 6/1/20 Work in process, 6/30/20 Finished goods, 6/1/20 Finished goods, 6/30/20 $ 4,500 20,000 3,000 3,800 5,000 7,500 Factory utilities Depreciation, factory equipment Direct labor Maintenance, factory equipment Indirect materials Factory manager's salary $ 400 1,400 40,000 1,800 2,200 3,000 Instructions b. Prepare an...
*Exercise 10-12 (Part Level Submission) Cepeda Corporation has the following cost records for June 2017 Indirect factory labor Direct materials used Work in process, 6/1/17 Work in process, 6/30/17 Finished goods, 6/1/17 Finished goods, 6/30/17 $4,500 20,000 3,000 3,800 5,000 7,500 Factory utilities Depreciation, factory equipment Direct labor Maintenance, factory equipment Indirect materials Factory manager's salary $400 1,400 40,000 1,800 2,200 3,000 *(a) Prepare a cost of goods manufactured schedule for June 2017. CEPEDA CORPORATION Cost of Goods Manufactured Schedule...
E14.12 (LO 3) Cepeda Corporation has the following cost records for June 2020. Prepare a cost of goods manufactured schedule and a partial income statement Excel Indirect factory labor Direct materials used Work in process, 6/1/20 Work in process, 6/30/20 Finished goods, 6/1/20 Finished goods, 6/30/20 $ 4,500 20,000 3,000 3,800 5,000 7,500 Factory utilities Depreciation, factory equipment Direct labor Maintenance, factory equipment Indirect materials Factory manager's salary $ 400 1,400 40,000 1,800 2,200 3,000 Instructions a. Prepare a cost...
Cepeda Corporation has the following cost records for June 2020. Indirect factory labor $4,600 Factory utilities $410 1.500 Direct materials used 21,000 Depreciation, factory equipment 41,000 Work in process. 6/1/20 Work in process, 6/30/20 3,100 Direct labor 3.900 Maintenance, factory equipment 1.810 Finished goods, 6/1/20 Finished goods, 6/30/20 5.100 7,600 Indirect materials Factory manager's salary 2,100 3,100 Prepare a cost of goods manufactured schedule for June 2020. CEPEDA CORPORATION Cost of Goods Manufactured Schedule
Cepeda Corporation has the following cost records for June 2020. Indirect factory labor $4,760 Factory utilities $470 Direct materials used 22,680 Depreciation, factory equipment 1,540 Work in process, 6/1/20 3,540 Direct labor 42,930 Work in process, 6/30/204,880 Maintenance, factory equipment 1,850 Finished goods, 6/1/20 5,940 Indirect materials 2,820 Finished goods, 6/30/20 7,940 Factory manager's salary 3,120 (a) Prepare a cost of goods manufactured schedule for June 2020. CEPEDA CORPORATION Cost of Goods Manufactured Schedule Save for Later
Cepeda Corporation has the following cost records for June 2020. Indirect factory labor $5.330 Factory utilities $440 Direct materials used Work in process, 6/1/20 22,580 3,910 Depreciation, factory equipment Direct labor 1,640 42,770 Work in process, 6/30/20 Finished goods, 6/1/20 Finished goods, 6/30/20 4,680 5,510 ,270 Maintenance, factory equipment Indirect materials Factory manager's salary 1,940 2.430 3.210 8 Prepare a cost of goods manufactured schedule for June 2020. CEPEDA CORPORATION Cost of Goods Manufactured Schedule
Cepeda Corporation has the following cost records for June 2020. Indirect factory labor $5,150 Factory utilities $500 Direct materials used 22,360 Depreciation, factory equipment 1,620 Work in process, 6/1/20 3,480 Direct labor 42,170 Work in process, 6/30/20 4,620 Maintenance, factory equipment 2,000 5,660 Indirect materials 2,600 Finished goods, 6/1/20 Finished goods, 6/30/20 7,680 Factory manager's salary 3,340 Prepare a cost of goods manufactured schedule for June 2020. CEPEDA CORPORATION Cost of Goods Manufactured Schedule $ We were unable to transcribe...
Cepeda Corporation has the following cost records for June 2020. Indirect factory labor $5,540 Factory utilities $420 Direct materials used 22,490 Depreciation, factory equipment 1,760 41,640 Work in process, 6/1/20 Work in process, 6/30/20 3,340 4,470 Direct labor Maintenance, factory equipment 1,890 5,620 Indirect materials 2,530 Finished goods, 6/1/20 Finished goods, 6/30/20 8,410 Factory manager's salary 3,300 Prepare an income statement through gross profit for June 2020 assuming sales revenue is $87,990. CEPEDA CORPORATION Income Statement (Partial)
Cepeda Corporation has the following cost records for June 2020. Indirect factory labor Direct materials used Work in process, 6/1/20 Work in process, 6/30/20 Finished goods, 6/1/20 Finished goods, 6/30/20 $4,750 21,330 3,400 4,540 6,090 8,470 Factory utilities Depreciation, factory equipment Direct labor Maintenance, factory equipment Indirect materials Factory manager's salary $440 1,590 42,300 1,900 2,140 3,360 Prepare a cost of goods manufactured schedule for June 2020. CEPEDA CORPORATION Cost of Goods Manufactured Schedule For the Year Ended June 30,...
Cepeda Corporation has the following cost records for June 2017 Indirect factory labor Direct materials used Work in process, 6/1/17 Work in process, 6/30/17 Finished goods, 6/1/17 Finished goods, 6/30/17 $5,400 21,100 3,860 3,980 6,050 7,930 Factory utilities Depreciation, factory equipment Direct labor Maintenance, factory equipment Indirect materials Factory manager's salary $460 1,620 41,620 1,990 2,910 3,960 CEPEDA CORPORATION Cost of Goods Manufactured Schedule Prepare an income statement through gross profit for June 2017 assuming sales revenue is $88,030. CEPEDA...