GreenThumb Organic Fertilizer Company plans to sell 250,000 units in July

Managerial AccountingBudgeting & Variances

The textbook question

GreenThumb Organic Fertilizer Company plans to sell 250,000 units of finished product in July and anticipates a growth rate in sales of 4 percent per month. The desired monthly ending inventory in units of finished product is 85 percent of the next month's estimated sales. There are 212,500 finished units in inventory on June 30. Each unit of finished product requires 3 pounds of raw material at a cost of $1.95 per pound. There are 720,000 pounds of raw material in inventory on June 30.

Required:
1. Compute the company's total required production in units of finished product for the entire three-month period ending September 30.
Note: Round all intermediate calculations and your final answer to the nearest unit.
2. Independent of your answer to requirement 1, assume the company plans to produce 760,000 units of finished product in the three-month period ending September 30, and to have raw-material inventory on hand at the end of the three-month period equal to 25 percent of the use in that period. Compute the total estimated cost of raw-material purchases for the entire three-month period ending September 30.

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 makes recycled-paper notebooks and ships them by the case. It expects to sell 200,000 cases in July, and it projects sales to grow 5% each month after that. Its policy is to finish every month holding enough cases to cover 75% of the next month's expected sales. On June 30 there were 210,000 finished cases in the warehouse. Each case takes 3 pounds of paper stock, which costs $1.90 a pound, and 700,000 pounds of paper stock were on hand on June 30.

  1. How many cases must Accuity produce in total for the three months July through September? Round every intermediate figure to the nearest whole unit.
  2. Set requirement 1 aside. Suppose Accuity plans to produce 750,000 cases over July through September and wants paper stock on hand at September 30 equal to 25% of the pounds used during the quarter. What is the total cost of the paper stock it must buy for the quarter?

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 a production budget with a growth rate and an inventory policy, then a raw-material purchases budget in dollars. Both rest on one equation:

Production (or purchases) = Amount needed + Desired ending inventory − Beginning inventory

Requirement 1 — Total production for the quarter

Step 1: Project sales. Each month is 5% above the one before. You also need October, because September's ending inventory depends on October's sales.

MonthExpected sales (cases)
July200,000
August (200,000 × 1.05)210,000
September (210,000 × 1.05)220,500
October (220,500 × 1.05)231,525

Step 2: Find the quarter's ending inventory. Ending inventory on September 30 = 75% of October sales:

231,525 × 75% = 173,643.75, rounded to 173,644 cases

Step 3: Build the quarter's production budget. For the whole quarter, the inventory at the end of July and August cancels out, so you only need the June 30 and September 30 balances.

Production budget, July–SeptemberCases
Expected sales (200,000 + 210,000 + 220,500)630,500
Add: Desired ending inventory, Sept. 30173,644
Total cases needed804,144
Less: Beginning inventory, June 30(210,000)
Cases to produce594,144

Month by month gives the same total:

JulyAugustSeptember
Sales200,000210,000220,500
Add: Ending (75% of next month)157,500165,375173,644
Less: Beginning(210,000)(157,500)(165,375)
Production147,500217,875228,769

147,500 + 217,875 + 228,769 = 594,144. The June 30 count of 210,000 is above the 75% policy, but it's the actual inventory on hand, so use it as given.

Requirement 2 — Cost of paper stock purchases

This part stands alone, so start from 750,000 cases.

Paper used: 750,000 × 3 lb = 2,250,000 lb

Desired ending paper stock: 2,250,000 × 25% = 562,500 lb

Purchases budget, July–SeptemberPounds
Paper needed for production2,250,000
Add: Desired ending paper stock562,500
Total paper needed2,812,500
Less: Beginning paper stock(700,000)
Pounds to purchase2,112,500
× Cost per pound$1.90
Cost of purchases$4,013,750

Where students go wrong

  • Basing September 30 inventory on September sales. The policy looks one month ahead, so it needs October.
  • Adding up three monthly ending inventories. For a quarter total, only the final ending balance counts.
  • Stopping at pounds. The requirement asks for cost, so multiply by $1.90.

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.