Bodin Company budgets on an annual basis. The following beginning and ending inventory levels (in units) are planned for the year 20x1. Five units of raw material are required to produce each unit of finished product.

Managerial AccountingBudgeting & Variances

What the textbook asks

January 1December 31
Raw material40,00046,000
Work in process16,00016,000
Finished goods87,00052,000

Required:
1. If Bodin Company plans to sell 472,000 units during the year, compute the number of units the firm would have to manufacture during the year.
2. If 514,000 finished units were to be manufactured by Bodin Company during the year, determine the amount of raw material to be purchased.

Below is the Accuity problem: the same method with different numbers. We solve ours, so work through it and you'll know how to solve yours.

The Accuity problem

Accuity prints and binds its exam-review workbooks in-house and plans production a full year at a time. For 20x1 it has set these inventory targets, all counted in units. Each finished workbook uses five units of raw material.

InventoryJanuary 1December 31
Raw materials50,00052,000
Work in process18,00018,000
Finished goods90,00065,000
  1. Accuity expects to sell 450,000 workbooks during 20x1. How many units must it produce during the year?
  2. Suppose instead that Accuity completes 510,000 finished workbooks during 20x1. How many units of raw material must it buy?

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 two schedules that open a manufacturing master budget: the production budget (how many units to make) and the direct-material purchases budget (how much material to buy). Both use the same inventory equation:

Beginning inventory + Additions = Units needed + Ending inventory

Rearranged for budgeting: Additions = Units needed + Desired ending inventory − Beginning inventory.

Requirement 1 — Units to produce

Finished goods are added by production and used up by sales.

Production budget, 20x1Units
Expected sales450,000
Add: Desired ending finished goods65,000
Total finished units needed515,000
Less: Beginning finished goods(90,000)
Units to produce425,000

Accuity produces 25,000 fewer units than it sells because it plans to draw finished-goods inventory down from 90,000 to 65,000.

What about work in process? Beginning and ending WIP are both 18,000 units, so the WIP balance doesn't change. Everything started during the year is matched by units completed, and WIP drops out of the calculation. If WIP were planned to rise or fall, you would adjust for that change too.

Requirement 2 — Raw material to purchase

This requirement stands on its own: start from the 510,000 finished units given here, not the 425,000 from requirement 1.

First, convert finished units into raw material. Each workbook uses five units of material:

510,000 × 5 = 2,550,000 units of raw material

Raw-material purchases budget, 20x1Units
Raw material needed for production2,550,000
Add: Desired ending raw materials52,000
Total raw material needed2,602,000
Less: Beginning raw materials(50,000)
Raw material to purchase2,552,000

The raw-material inventories (50,000 and 52,000) are already counted in units of material, so don't multiply them by 5. Only the finished-unit figure gets converted.

Where students go wrong

  • Reversing the inventory adjustments. Add the ending inventory you want to have, subtract the beginning inventory you already have.
  • Using 450,000 or 425,000 in requirement 2. The second requirement gives its own production figure of 510,000.
  • Multiplying the raw-material inventories by 5. They're stated in units of material already.
  • Forgetting the ×5 conversion and budgeting only 510,000 units of material.
  • Adding WIP into the totals. With no change in WIP, it has no effect.

More Budgeting & Variances 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 Budgeting & Variances 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.