In: Accounting
An incomplete cost of goods manufactured schedule is presented
below for Cepeda Manufacturing Company for the year ended December
2020:
Complete the cost of goods manufactured schedule for Cepeda
Manufacturing Company.
| CEPEDA MANUFACTURING COMPANY Cost of Goods Manufactured Schedule For the Year Ended December 31, 2020 |
|||||||
| Work in process (1/1) | $210,000 | ||||||
| Direct materials | |||||||
| Raw materials inventory, (1/1) | $ | ||||||
| Raw materials purchases | 167,000 | ||||||
| Total raw materials available for use | |||||||
| Less: Raw materials inventory (12/31) | 18,000 | ||||||
| Direct materials used | $189,000 | ||||||
| Direct labour | |||||||
| Manufacturing overhead | |||||||
| Indirect labour | 15,000 | ||||||
| Factory depreciation | 36,800 | ||||||
| Factory utilities | 68,000 | ||||||
| Total manufacturing overhead | 119,800 | ||||||
| Total manufacturing costs | |||||||
| Total cost of work in process | |||||||
| Less: Work in process (12/31) | 80,400 | ||||||
| Cost of goods manufactured | $550,100 | ||||||
| CEPEDA MANUFACTURING COMPANY | |||
| Cost of Goods Manufactured Schedule | |||
| For the Year Ended December 31, 2020 | |||
| Work in process (1/1) | 2,10,000 | ||
| Direct materials | |||
| Raw materials inventory, (1/1) | 40,000 | ||
| Raw materials purchases | 1,67,000 | ||
| Total raw materials available for use | 2,07,000 | ||
| Less: Raw materials inventory (12/31) | 18,000 | ||
| Direct materials used | 1,89,000 | ||
| Direct labour | 1,11,700 | ||
| Manufacturing overhead | |||
| Indirect labour | 15,000 | ||
| Factory depreciation | 36,800 | ||
| Factory utilities | 68,000 | ||
| Total manufacturing overhead | 1,19,800 | ||
| Total manufacturing costs | 4,20,500 | ||
| Total cost of work in process | 6,30,500 | ||
| Less: Work in process (12/31) | -80,400 | ||
| Cost of goods manufactured | 5,50,100 | ||
| Raw materials inventory= Direct material used+ Raw materials inventory - Raw materials purchases | |||
| Raw materials inventory= 189000+18000-167000 | |||
| Raw materials inventory= 40000 | |||
| Direct labour = Total manufacturing costs - Total overhead - Direct materials used | |||
| Direct labour = 420500-119800-189000 | |||
| Direct labour = 111700 | |||
| Total manufacturing costs = Total cost of work in process - Work in process | |||
| Total manufacturing costs = 630500-210000 | |||
| Total manufacturing costs =420500 | |||
| Total cost of work in process = Cost of goods manufactured + Work in process | |||
| Total cost of work in process = 550100+80400 | |||
| Total cost of work in process = 630500 |