Note: Please provide in a neat excel format (horizontal)

Jaworski Company provided the following information regarding its first year of operations:

Required: Determine the following amounts: a) Total overhead costs; b) Total product costs; c) Product cost per unit; d) Total cost of ending finished goods inventory; e) Total cost of goods sold;

$30,000 8,000 Administrative salaries Depreciation on factory equipment Indirect materials Marketing costs Salaries for factory supervisors Wages for production workers Raw materials used Research and development costs Rent on factory buildin Sales revenues Sales salaries and other selling costs 2.000 20,000 14,000 40,000 50,000 16,000 9.000 216,000 28,000 Beginning inventory Number of units produced Number of units sold 0 units 0,000 9,000