Prepare a schedule of cost of goods manufactured, COGS and income statement

Managerial AccountingCost Behavior & CVP

The problem

Accuity prints and binds exam review books in its own shop. Its inventory accounts showed these balances at the start and end of the year:

InventoryJanuary 1December 31
Raw materials$20,000$22,000
Work in process$55,000$50,000
Finished goods$130,000$140,000

During the year Accuity bought $200,000 of raw materials and incurred $320,000 of direct labor. Manufacturing overhead was:

Manufacturing overheadAmount
Indirect labor$10,000
Indirect materials$18,000
Utilities$20,000
Depreciation on plant equipment$11,000
Other$40,000

Sales for the year were $1,500,000, and selling and administrative expenses were $95,000. Accuity's income tax rate is 20%.

  1. Build a schedule of cost of goods manufactured.
  2. Build a schedule of cost of goods sold.
  3. Build the income statement.

An Accuity original. We write our own version of each problem and solve it from scratch, so you learn the method rather than copying an answer.

Video solution

Covers the full step-by-step solution below, start to finish.

Jake Glidden, CPA, MSA

Solved by

Jake Glidden, CPA, MSA

Founder of Accuity

Jake started Accuity while studying accounting at UCF and has worked with hundreds of students in introductory and upper-level accounting classes. Accuity solutions are checked against the textbook before they're published.

Certified Public Accountant (CPA) · B.S.B.A. in Accounting, UCF · M.S. in Accounting, UCF

More about Accuity →

Step-by-step solution

The same steps the video works through, written out.

This problem tests the three linked statements of a manufacturer: the schedule of cost of goods manufactured (COGM), the schedule of cost of goods sold (COGS) and the income statement. Each one feeds the next, so an error early carries all the way to net income.

The flow: raw materials → work in process → finished goods → cost of goods sold.

Requirement 1 — Schedule of cost of goods manufactured

First find the raw materials used: $20,000 + $200,000 − $22,000 = $198,000

Then total the overhead: $10,000 + $18,000 + $20,000 + $11,000 + $40,000 = $99,000

Accuity — Schedule of Cost of Goods Manufactured
Raw materials, January 1$20,000
Add: Purchases of raw materials200,000
Raw materials available for use220,000
Less: Raw materials, December 31(22,000)
Raw materials used$198,000
Direct labor320,000
Manufacturing overhead99,000
Total manufacturing costs617,000
Add: Work in process, January 155,000
Subtotal672,000
Less: Work in process, December 31(50,000)
Cost of goods manufactured$622,000

Requirement 2 — Schedule of cost of goods sold

Accuity — Schedule of Cost of Goods Sold
Finished goods, January 1$130,000
Add: Cost of goods manufactured622,000
Cost of goods available for sale752,000
Less: Finished goods, December 31(140,000)
Cost of goods sold$612,000

Requirement 3 — Income statement

Accuity — Income Statement
Sales revenue$1,500,000
Less: Cost of goods sold(612,000)
Gross margin888,000
Less: Selling and administrative expenses(95,000)
Income before taxes793,000
Income tax expense (20% × $793,000)(158,600)
Net income$634,400

Where students go wrong

  • Using purchases instead of materials used. The $200,000 purchased is not the cost that entered production. Adjust for the change in raw materials inventory to get $198,000.
  • Putting selling and administrative costs in the COGM schedule. They are period costs and appear only on the income statement.
  • Swapping the inventory accounts. Work in process belongs in the COGM schedule; finished goods belongs in the COGS schedule.
  • Taxing the wrong subtotal. Tax is 20% of income before taxes ($793,000), not of gross margin or sales.

More Cost Behavior & CVP problems

Got a different wording of this problem?

Assignments vary by school and semester. Share the version you were given and we'll add it so other students can find this solution.

Studying Cost Behavior & CVP for a class?

Accuity courses map to your actual syllabus — video lessons, exam-style practice, and walkthroughs for the problems you're assigned.

Ace your accounting classes.

Textbook questions are for reference. We show a textbook's question only so you can find the problem you were assigned. We don't solve textbook questions: every solution and video on this site works through our own Accuity problem, written to teach the same method with different numbers.

Educational use. Accuity problems are original teaching material — we write our own version of each problem and solve it on video so you learn the method. Don't submit our work as your own; that violates your school's academic integrity policy. If you believe content here infringes your rights, file a DMCA notice.