In: Accounting
Superior Company provided the following data for the year ended December 31 (all raw materials are used in production as direct materials):
| Selling expenses | $ | 211,000 |
| Purchases of raw materials | $ | 267,000 |
| Direct labor | ? | |
| Administrative expenses | $ | 156,000 |
| Manufacturing overhead applied to work in process | $ | 374,000 |
| Actual manufacturing overhead cost | $ | 356,000 |
Inventory balances at the beginning and end of the year were as follows:
| Beginning of Year | End of Year | |||||
| Raw materials | $ | 57,000 | $ | 38,000 | ||
| Work in process | ? | $ | 23,000 | |||
| Finished goods | $ | 33,000 | ? | |||
The total manufacturing costs for the year were $690,000; the cost of goods available for sale totaled $725,000; the unadjusted cost of goods sold totaled $662,000; and the net operating income was $31,000. The company’s underapplied or overapplied overhead is closed to Cost of Goods Sold.
Required:
Prepare schedules of cost of goods manufactured and cost of goods sold and an income statement. (Hint: Prepare the income statement and schedule of cost of goods sold first followed by the schedule of cost of goods manufactured.)
| Superior Company | |||
| Schedule of Cost of goods Manufactured | |||
| Direct Materials | |||
| Raw Material Inventory beginning | $ 57,000 | ||
| Add: | Purchases of raw Material | $ 2,67,000 | |
| Total Raw Material available | $ 3,24,000 | ||
| Deduct: | Raw Material Inventory ending | $ 38,000 | |
| Raw Material used in production | $ 2,86,000 | ||
| Direct Labour | $ 30,000 | ||
| Manufacturing overheads applied to work in process inventory | $ 3,74,000 | ||
| Total manufacturing cost | $ 6,90,000 | ||
| Add: | Beginning work in process inventory | $ 25,000 | |
| $ 7,15,000 | |||
| Deduct: | Ending work in process inventory | $ 23,000 | |
| Cost of goods manufactured | $ 6,92,000 | ||
| Workings: | |||
| 1 | Direct Labour =Total manufacturing cost - Raw Material used in production - Manufacturing overheads applied to work in process inventory | ||
| Direct Labour = $6,90,000-$2,86,000-$3,74,000= $30,000 | |||
| 2 | Cost of goods manufactured = Cost of goods available for sale - Beginning finished goods inventory | ||
| Cost of goods manufactured = $7,25,000 - $33,000 = $6,92,000 | |||
| 3 | Beginning work in process inventory = Cost of goods manufactured + Ending work in process inventory - Total Manufacturing Cost | ||
| Beginning work in process inventory = $6,92,000 + $23,000 - $6,90,000 = $25,000 | |||
| Superior Company | |||
| Schedule of Cost of Goods Sold | |||
| Finished Goods Inventory Beginning | $ 33,000 | ||
| Cost of goods manufactured | $ 6,92,000 | ||
| Cost of goods available for sale | $ 7,25,000 | ||
| Deduct: | Finished Goods Inventory Ending | $ 63,000 | |
| Unadjusted cost of goods sold | $ 6,62,000 | ||
| Add: | Underapplied Overheads | $ 32,000 | |
| Adjusted cost of goods sold | $ 6,94,000 | ||
| Workings: | |||
| 1 | Adjusted cost of goods sold = Cost of goods available for sale - Net operating Income | ||
| Adjusted cost of goods sold = $7,25,000 - $31,000 = $6,94,000 | |||
| 2 | Underapplied Overheads = Adjusted cost of goods sold - Unadjusted Cost of goods sold | ||
| Underapplied Overheads = $6,94,000 - $6,62,000 = $32,000 | |||
| Superior Company | |||
| Income Statement | |||
| Sales | $ 10,92,000 | ||
| Deduct: | Cost of Goods Sold | $ 6,94,000 | |
| Gross Margin | $ 3,98,000 | ||
| Deduct: | Selling and Administrative Expenses: | ||
| Selling Expense | $ 2,11,000 | ||
| Administrative Expense | $ 1,56,000 | $ 3,67,000 | |
| Net Operating Income | $ 31,000 | ||
| Workings: | |||
| 1 | Gross Margin = Net Operating Income +Selling and Administrative Expenses | ||
| Gross Margin = $31,000 + $3,67,000 = $3,98,000 | |||
| 2 | Sales = Cost of Goods Sold + Gross Margin | ||
| Sales = $6,94,000 + $3,98,000 = $10,92,000 | |||