Question

Question 6 (33 marks) *this question must be completed in Excel. Prepare, in good format, a schedule of cost of goods manufac
0 0
Add a comment Improve this question Transcribed image text
Answer #1
Consolidated Minerals Ltd
Schedule of cost of goods manufactured
For the year ended December 31, 2019
Direct materials
Direct material, January 1, 2019 $    35,000
Add: Raw material purchases $      8,500
Total raw materials available $    43,500
Less: Direct material, December 31, 2019 $      8,000
Raw material used in production $    35,500
Direct manufacturing labor $    83,000
Manufacturing overhead
Depreciation - Plant, building and equipment $    55,000
Plant suppervisory salaries $ 102,000
Mis. Plant overhead $    99,000
Plant supplies used $    22,000
Plant utilities $    75,500
Indirect manufacturing labour $    39,000
Total manufacturing overhead $ 392,500
Total manufacturing cost $ 511,000
Add: Work in process, January 1, 2019 $ 110,000
Less: Work in process, December 31, 2019 $ 250,000
Cost of goods manufactured $ 371,000
Consolidated Minerals Ltd
Schedule of cost of goods sold
For the year ended December 31, 2019
Finished goods, January 1, 2019 $ 265,000
Cost of goods manufactured $ 371,000
Add: Goods available for sale $ 636,000
Less: Finished goods, December 31, 2019 $ 280,000
Cost of goods sold $ 356,000
Consolidated Minerals Ltd
Income statement
For the year ended December 31, 2019
Revenues $ 525,000
Less: Cost of goods sold $ 356,000
Gross profit $ 169,000
Less: Marketing, distribution and customer service cost $    43,000
Net income $ 126,000

You can reach me over comment box, if you have any doubts. Please rate this answer

Add a comment
Know the answer?
Add Answer to:
Question 6 (33 marks) *this question must be completed in Excel. Prepare, in good format, a...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 2-27 Statement of comprehensive income and schedule of cost of goods manufactured. The Howell Corporation has...

    2-27 Statement of comprehensive income and schedule of cost of goods manufactured. The Howell Corporation has the following account balances (in millions): For Specific Date For Year 2019 Direct materials, January 1, 2019 Purchases of direct materials Work in process, January 1, 2019 Direct manufacturing labour Finished goods, January 1, 2019 Depreciation—plant, building, and equipment Direct materials, December 31, 2019 Plant supervisory salaries Work in process, December 31, 2019 Miscellaneous plant overhead Finished goods, December 31, 2019 Revenues 1,140 Marketing,...

  • LO 2,4 Operating income $75 COGM, $762 2-37 Statement of comprehensive income and schedule of cost...

    LO 2,4 Operating income $75 COGM, $762 2-37 Statement of comprehensive income and schedule of cost of goods manufactured. The Powell Corporation has the following account balances (in millions): For Specific Date For Year 2019 Direct materials, January 1, 2019 $15 Purchases of direct materials $ 390 Work in process, January 1, 2019 10 Direct manufacturing labour 120 Finished goods, January 1, 2019 70 Depreciation-plant building and 96 equipment Direct materials, December 31, 2019 20 Plant supervisory salaries 6 Work...

  • 2-28 Computing cost of goods manufactured and cost of goods sold. The following are account be...

    2-28 Computing cost of goods manufactured and cost of goods sold. The following are account be NINTRODUCTION TO COST TERMS AND PURPOSES R 200 800 ances relating to 2019 (in thousands): Property tax on plant building Marketing, distribution, and customer-service costs Finished goods inventory, January 1, 2019 Plant utilities Work-in-process inventory, December 31, 2019 Depreciation of plant building General and administrative costs (nonplant) Direct materials used $ 4,200 44,400 37,400 20,400 32,200 14,700 51,600 106,800 44,800 14,700 19,200 25,000 38,400...

  • USUUN Hp Consider the following account balances (in thousands) for the Sillow Corporation: (Click the icon...

    USUUN Hp Consider the following account balances (in thousands) for the Sillow Corporation: (Click the icon to view the account balances.) Requirements 1. Prepare a schedule for the cost of goods manufactured for 2017 2. Revenues (in thousands) for 2017 were $1,200,000. Prepare the income statement for 2017 Requirement 1. Prepare a schedule for the cost of goods manufactured for 2017 Start with the direct materials and labor costs, then manufacturing overhead costs, and complete the schedule by calculating cost...

  • Question 3: Process Costing [35 MARKS] You are employed by Spirit Ltd, a manufacturer of digital...

    Question 3: Process Costing [35 MARKS] You are employed by Spirit Ltd, a manufacturer of digital watches. The company's chief financial officer is trying to verify the accuracy of the ending work in process and finished goods inventories prior to closing the books for the year. You have been asked to assist with this The year-end balances shown on Spirit Ltd's books are as follows: Units 300,000 Cost $660,960 Work in process, 31 December 2019 (labour and overhead 50% complete)...

  • The Genesis Corporation has the following account balances (in millions) For Year 20x1 Purchases of direct...

    The Genesis Corporation has the following account balances (in millions) For Year 20x1 Purchases of direct materials Direct manufacturing labor For Specific Date Direct materials, January 1, 20X1 Work in process, January 1,20X1 Finished goods, January 1, 20X1 P325 100 P15 10 70 Depreciation plant building 80 Direct materials, December 31, 20X1 20 Work in process, December 31, 20X15 Finished goods, December 31, 20X1 55 and equipment Plant supervisory salaries Miscellaneous plant overhead Revenues Marketing, distribution and 35 950 customer-service...

  • From the account balances listed below, prepare a schedule of cost of goods manufactured for Sampson...

    From the account balances listed below, prepare a schedule of cost of goods manufactured for Sampson Manufacturing Company for the month ended December 31, 2019. Account Balances Finished Goods Inventory, December 31 $42,000 Factory Supervisory Salaries 12,000 Income Tax Expense 18,000 Raw Materials Inventory, December 1 12,000 Work In Process Inventory, December 31 15,000 Sales Salaries Expense 14,000 Factory Depreciation Expense 8,000 Finished Goods Inventory, December 1 35,000 Raw Materials Purchases 105,000 Work In Process Inventory, December 1 25,000 Factory...

  • Now prepare the income statement for Rouse Corporation (in millions). (Use parentheses or a minus sign...

    Now prepare the income statement for Rouse Corporation (in millions). (Use parentheses or a minus sign for operating losses.) Rouse Corporation Income Statement For the Year Ended December 31, 2017 (in millions) Cost of goods sold: Cost of goods manufactured $ 628 Cost of goods sold Ending finished goods, Dec. 31, 2017 Revenues Cost of goods sold Gross margin Marketing, distribution, and customer-service costs $ Operating income/(loss) ule of cost of anods manufactured for the vear ended December 21 20:17...

  • Test: Test I chapters 16 17 18 19 This Question: 10 pls 19 of 22 13...

    Test: Test I chapters 16 17 18 19 This Question: 10 pls 19 of 22 13 complete 12. TUV Manufacturing Company has the following data for 2019 (amounts in mibon) !! Click the icon to the information ) Prepare the schedule of cost of goods manufactured and the cost of goods sold section of the income statement for the year ended December 31, 2015 Beginning Work in Process Inventory Direct Maconals Used Direct Materiais Available for Use Manufacturing Overhead X...

  • JS Kimmel, Accounting, 7e PRIN. OF ACCT I&II (AC Time: 08:33 PM / Remaining: 92 min....

    JS Kimmel, Accounting, 7e PRIN. OF ACCT I&II (AC Time: 08:33 PM / Remaining: 92 min. CALCULATOR Exercise 177 From the account balances listed below, prepare a schedule of cost of goods manufactured for Sampson Manufacturing Company for the month ended December 31, 2019. Finished Goods Inventory, December 31 Factory Supervisory Salaries Income Tax Expense Raw Materials Inventory, December 1 Work In Process Inventory, December 31 Sales Salaries Expense Factory Depreciation Expense Finished Goods Inventory, December 1 Raw Materials Purchases...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT