In: Accounting
The administrative offices and manufacturing plant of Billings Tool
& Die share the same building. The following information (in
$000s) appears in the accounting records for last year:
  
| Administrative costs | $ | 1,658 | |
| Building and machine depreciation (75% of this amount is for factory) | 900 | ||
| Building utilities (90% of this amount is for factory) | 1,310 | ||
| Direct labor | 845 | ||
| Direct materials inventory, December 31 | 14 | ||
| Direct materials inventory, January 1 | 10 | ||
| Direct materials purchases | 3,630 | ||
| Factory supervision | 481 | ||
| Finished goods inventory, December 31 | 69 | ||
| Finished goods inventory, January 1 | 55 | ||
| Indirect factory labor | 915 | ||
| Indirect materials and supplies | 679 | ||
| Marketing costs | 879 | ||
| Property taxes on building (85% of this amount is for factory) | 800 | ||
| Sales revenue | 12,916 | ||
| Work-in-process inventory, December 31 | 25 | ||
| Work-in-process inventory, January 1 | 32 | ||
| 
 | 
|||
Required:
Prepare an income statement with a supporting cost of goods sold statement. (Enter your answers in thousands of dollars (i.e., 234,000 should be entered as 234).)
| A | |||||||
| PRODUCT COST($000) | Selling & Administration Costs($000) | ||||||
| Administrative costs | 1,658 | Administrative cost | 1,658 | ||||
| Building and machine depreciation (75% of this amount is for factory) | 900 | Manufacturing Overhead | 675 | Administrative Expenses | 225 | (Manufacturing overhead=(0.75*900) | |
| Building utilities (90% of this amount is for factory) | 1,310 | Manufacturing Overhead | 1179 | Administrative Expenses | 131 | (Manufacturing overhead=(0.9*1310) | |
| Direct labor | 845 | Direct Labor cost | 845 | ||||
| Direct materials inventory, December 31 | 14 | Direct Material cost | 3,626 | Direct Material=Beginning Inventory + Purchase - Ending Inventory(10+3630-14) | |||
| Direct materials inventory, January 1 | 10 | ||||||
| Direct materials purchases | 3,630 | ||||||
| Factory supervision | 481 | Manufacturing Overhead | 481 | ||||
| Finished goods inventory, December 31 | 69 | ||||||
| Finished goods inventory, January 1 | 55 | ||||||
| Indirect factory labor | 915 | Manufacturing Overhead | 915 | ||||
| Indirect materials and supplies | 679 | Manufacturing Overhead | 679 | ||||
| Marketing costs | 879 | Selling Expenses | 879 | ||||
| Property taxes on building (85% of this amount is for factory) | 800 | Manufacturing Overhead | 680 | Administrative Expenses | 120 | (Manufacturing overhead=(0.85*800) | |
| Sales revenue | 12,916 | ||||||
| Work-in-process inventory, December 31 | 25 | ||||||
| Work-in-process inventory, January 1 | 32 | ||||||
| Total | 9,080 | 3,013 | |||||
| Work in process transferred to Finished goods Inventory: | |||||||
| A | Beginning Work in Process | 32 | |||||
| B | Add:Direct Material | 3,626 | |||||
| C | Add:Direct Labor | 845 | |||||
| D | Add:Manufacturing Overhead | 4609 | (675+1179+481+915+679+680) | ||||
| E | Less:Ending Work in process | 25 | |||||
| F=A+B+C+D-E | Work in process transferred to Finished goods Inventory | 9,087 | |||||
| COST OF GOODS SOLD STATEMENT | |||||||
| G | Beginning Finished goods inventory | 55 | |||||
| H | Add:Transferred from Work in process | 9,087 | |||||
| I | Less: Ending Finished goods inventory | 69 | |||||
| J=G+H-I | Cost of goods sold | 9,073 | |||||
| INCOME STATEMENT | |||||||
| Figures in ($ 000) | |||||||
| Sales Revenue | 12,916 | ||||||
| Cost of goods sold | 9,073 | ||||||
| Gross Profit | 3,843 | ||||||
| Selling & Administrative expenses | 3,013 | ||||||
| Operating Income | 830 | ||||||