In: Accounting
Chaos Manufacturing had the following financial information for the year ended December 31 2019:
Inventory Balances: Beginning Ending
Work in Progress $ 90,000 $ 80,000
Finished Goods $ 77,000 $ 67,000
Raw Materials $ 10,000 $ 10,000
During the year, the budgeted and actual costs were as follows:
Note |
Budget |
Actual |
|
Raw Materials |
1 |
300,000 |
290,000 |
Labour |
2 |
540,000 |
518,000 |
Depreciation Factory Equipment |
72,000 |
72,000 |
|
Depreciation Office Equipment |
24,000 |
24,000 |
|
Building Rent |
3 |
100,000 |
100,000 |
Maintenance – Factory Equipment |
64,000 |
40,000 |
|
Utilities – Electrical |
4 |
200,000 |
180,000 |
Utilities - Gas |
5 |
100,000 |
90,000 |
Sales Commissions |
40,000 |
30,000 |
|
Advertising |
30,000 |
20,000 |
|
Shipping |
6 |
20,000 |
16,000 |
Total |
1,490,000 |
1,380,000 |
Sales for the year were $1,500,000
Note 1 – Raw material
For both budget and actual materials: 90% of raw materials are traced directly to specific jobs, and the remaining 10% of raw materials are used throughout the production process and not traced. $290,000 in materials were purchased in the year.
Note 2 – Labour
Budget: Direct Labour $300,000 + Factory Salaries $80,000 + Head Office Salaries $160,000 = $540,000
Actual: Direct Labour $270,000 + Factory Salaries $85,000 + Head Office Salaries $163,000 = $518,000
Note 3 – Building Rent
The building is shared between the factory and the administrative office. 68% of the building is related to the factory, and the remaining 32% is related to the administrative office.
Note 4 – Utilities Electrical
For both budget and actual, 90% of these costs are related to the factory, and 10% of these costs are related to the administrative office.
Note 5 – Utilities - Gas
All of the Gas is used to heat production equipment.
Note 6 – Shipping
All of the shipping costs are to ship finished goods to customers
Note 7 – Manufacturing Overhead
The manufacturer uses Normal Costing. Overhead is allocated based on Direct Labour costs. Any under/over applied overhead is allocated to Cost of Goods Sold.
Required:
1. Show the T-accounting for Manufacturing Overhead for the year
2. Prepare an income statement. You may include a schedule of Cost of Goods Manufactured and Cost of Goods Sold as separate schedules or as part of the Income Statement.
Solution : | ||||
Manufacturing Overheads | ||||
Working Note: | Budgeted | Actual | General Overheads | |
Indirect material (10%) | $30000 | $29000 | ||
Indirect Labor | $80,000 | $85,000 | ||
Factory Depreciation | $72,000 | $72,000 | ||
Building Rent - Factory (68%) | $68,000 | $68,000 | $32,000 | |
Maintainance - Factory equipment | $64,000 | $40,000 | ||
Utilitis - Electrical (90%) | $180,000 | $162,000 | $18,000 | |
Utilities - Gas (100%) | $100,000 | $90,000 | ||
Sales Commission | $30,000 | |||
Advertising | $20,000 | |||
Shipping | $16,000 | |||
Head office salaries | $163,000 | |||
Total | $594,000 | $546,000 | $279,000 | |
Predermined rate = Estimated Manufactiring overheads/Direct labor cost | ||||
= $594,000/$300,000 = 1.98 = 198% | ||||
1. Manufacturing Overhead | ||||
Indirect material | $29000 | Manyfacturing overhead | ||
Indirect Labor | $85,000 | Applied | $534,600 | |
Factory Depreciation | $72,000 | [$270,000*198%] | ||
Building Rent - Factory | $68,000 | Cost of goods sold | $11,400 | |
Maintainance - Factory equipment | $40,000 | [Balancing Figure] | ||
Utilitis - Electrical | $162,000 | |||
Utilities - Gas | $90,000 | |||
Total | $546,000 | Total | $546,000 | |
2 | ||||
Direct Material | ||||
Beginnig inventory | $10,000 | |||
Add: Purchases | $290,000 | |||
Material available for use | $300,000 | |||
Less: Ending Inventory | ($10,000) | |||
Less: Indirect material | ($29,000) | |||
Materials used in production | $261,000 | |||
Direct Labor | $270,000 | |||
Manufacturing overhead applied | $534,600 | |||
Total manufacturing costs | $1,065,600 | |||
Add: Beginning Work - in - process | $90,000 | |||
Less: Ending work - in - process | ($80,000) | |||
Cost of goods manufactured | $1,075,600 | |||
Schedule of Cost of goods sold | ||||
Beginnig finished goods inventory | $77,000 | |||
Add:Cost of goods manufactured | $1,075,600 | |||
Goods available for sale | $1,152,600 | |||
Less: ending finished goods inventory | ($67,000) | |||
Cost of goods sold | $1,085,600 | |||
Add: under applied manufacturing O/H | $11,400 | |||
Adjusted Cost of goods sold | $1,097,000 | |||
Income Statement | ||||
Sales | $1,500,000 | |||
Less:Cost of goods sold | ($1,097,000) | |||
Gross Margin | $403,000 | |||
Selling and adminstrative expenses | ||||
Sales Commission | $30,000 | |||
Advertising | $20,000 | |||
Shipping | $16,000 | |||
Head office salaries | $163,000 | ($2,29,000) | ||
Net Income | $174,000 | |||
Please Upvote , if found the answer useful. | ||||
For any clarification feel free to reach at comment section. | ||||