In: Accounting
Question 1
Chaos Manufacturing had the following financial information for the year ended December 31 2018:
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,486,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 was 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 – 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:
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.
Question 2
What is most likely a good cost driver (or drivers) for each of the following Cost Objects:
Post question2 separately, we are allowed to answer only one question in one screen
Please hit LIKE button if this helped. For any further explanation, please put your query in comment, will get back to you. | |||||
Revenue from Sales | $ 1,500,000 | ||||
Finished Goods Inventory, Beginning | $ 77,000 | ||||
Cost of Goods Manufactured | Working-1 | $ 953,200 | |||
Cost of Finished goods available for sale | $ 1,030,200 | ||||
Less: Finished Goods Inventory, Ending | $ -67,000 | ||||
Cost of Goods Sold-Unadjusted | $ 963,200 | ||||
Underapplied overheads | Working-2 | $ 21,800 | |||
Adjusted Cost of Goods Sold | $ -985,000 | ||||
Gross Profit | $ 515,000 | ||||
Less: Administrative Expense | Working-3 | $ 213,000 | |||
Less: Selling Expense | Working-4 | $ 66,000 | |||
$ -279,000 | |||||
Net Income | $ 236,000 | ||||
1. Cost of Goods Manufactured Schedule: | |||||
Beginning work in process inventory | $ 90,000 | ||||
Direct Material Used: | |||||
Beginning Raw Material Inventory | $ 10,000 | ||||
Add: Purchases | $ 290,000 | ||||
Raw Material Available | $ 300,000 | ||||
Less: Ending Raw material | $ (10,000) | ||||
Raw Material Used | $ 290,000 | ||||
Direct Material Used 90% | $ 261,000 | ||||
Direct Labor | $ 270,000 | ||||
Manufacturing overhead-Applied | $ 412,200 | ||||
Total Manufacturing Cost | $ 943,200 | ||||
Manufacturing Cost | $ 1,033,200 | ||||
Less: Ending work in process inventory | $ (80,000) | ||||
Cost of Goods manufactured | $ 953,200 | ||||
Working-2 | Actual | Budget | |||
Overheads: | |||||
Indirect Material | $290,000*10% | $ 29,000 | $ 30,000 | ||
Indirect Labor | $ 85,000 | $ 80,000 | |||
Building Rent | $100,000*68% | $ 68,000 | $ 68,000 | ||
Utilities Electrical | $180,000*90% | $ 162,000 | $ 180,000 | $200,000*90% | |
Utilities Gas | $ 90,000 | $ 100,000 | |||
Total Overhreads | $ 434,000 | $ 458,000 | a | ||
Direct Labor Cost | $ 270,000 | $ 300,000 | b | ||
Predetermined Rate | 152.67% | a/b | |||
Applied Overheads | $270,000*152.67% | $ 412,200 | |||
Actual Overheads | $ 434,000 | ||||
Under applied overheads | $ 21,800 | ||||
Working-3 | |||||
Head office Salaries | $ 163,000 | ||||
Building Rent | $100,000*32% | $ 32,000 | |||
Utilities Electrical | $180,000*10% | $ 18,000 | |||
$ 213,000 | |||||
Working-4 | |||||
Sales Commission | $ 30,000 | ||||
Advertising | $ 20,000 | ||||
Shipping | $ 16,000 | ||||
$ 66,000 |