Pena Corporation

Pena Corporation incurred the following costs while manufacturing its product.
Materials used in product $108,000 Advertising expense $46,000
Depreciation on plant 69,000 Property taxes on plant 19,000
Property taxes on store 8,400 Delivery expense 30,000
Labor costs of assembly-line workers 114,000 Sales commissions 39,000
Factory supplies used 32,000 Salaries paid to sales clerks 60,000


Work-in-process inventory was $14,100 at January 1 and $17,000 at December 31. Finished goods inventory was $68,000 at January 1 and $56,600 at December 31.

Compute the following:

Cost of goods manufactured $
Cost of goods sold $

Answer is in excel.