Production Budget and Direct Materials Purchases Budgets Peanut Land Inc. produces all-natural organic peanut butter. The peanut butter is sold in 12-ounce jars. The sales budget for the first four months of the year is as follows:   Unit Sales Dollar Sales ($) January 50,000 90,000 February 70,000 126,000 March 60,000 108,000 April 58,000 104,400 Company policy requires that ending inventories for each month be 25% of next month's sales. At the beginning of January, the inventory of peanut butter is 31,000 jars. Each jar of peanut butter needs two raw materials: 24 ounces of peanuts and one jar. Company policy requires that ending inventories of raw materials for each month be 20% of the next month's production needs. That policy was met on January 1. Required: 1.  Prepare a production budget for the first quarter of the year. Show the number of jars that should be produced each month as well as for the quarter in total.

Principles of Accounting Volume 2
19th Edition
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax
Chapter7: Budgeting
Section: Chapter Questions
Problem 4EB: Rehydrator makes a nutrition additive and expects to sell 3,000 units in January, 2,000 in February,...
icon
Related questions
icon
Concept explainers
Question

Production Budget and Direct Materials Purchases Budgets

Peanut Land Inc. produces all-natural organic peanut butter. The peanut butter is sold in 12-ounce jars. The sales budget for the first four months of the year is as follows:

  Unit Sales Dollar Sales ($)
January 50,000 90,000
February 70,000 126,000
March 60,000 108,000
April 58,000 104,400

Company policy requires that ending inventories for each month be 25% of next month's sales. At the beginning of January, the inventory of peanut butter is 31,000 jars.

Each jar of peanut butter needs two raw materials: 24 ounces of peanuts and one jar. Company policy requires that ending inventories of raw materials for each month be 20% of the next month's production needs. That policy was met on January 1.

Required:

1.  Prepare a production budget for the first quarter of the year. Show the number of jars that should be produced each month as well as for the quarter in total.

1. Prepare a production budget for the first quarter of the year. Show the number of jars that should be produced each month as well as for the quarter in total.
Peanut Land Inc.
Production Budget
For the First Quarter of the Year
January
February
March
Total
Sales
50,000
70,000
60,000 V
180,000
Desired ending inventory
17,500 V
15,000
14,500
14,500
Total needs
67,500 V
85,000 V
74,500 V
194,500
Less: Beginning inventory
31,000
17,500 V
15,000 V
31,000
Units produced
36,500 V
67,500 V
59,500 V
163,500
2. Prepare a direct materials purchases budget for jars for the months of January and February.
Peanut Land Inc.
Direct Materials Purchases Budget for Jars
For January and February
January
February
Total
Production
36,500
67,500 V
104,000
Jar
1
1
1
Jars for production
67,500 V
36,500
104,000
Desired ending inventory
11,900 V
13,500
11,900
Total needs
50,000
79,400
115,900
Less: Beginning inventory
7,300 V
13,500 V
7,300
Jars purchased
42,700 V
65,900 V
84,900 X
Transcribed Image Text:1. Prepare a production budget for the first quarter of the year. Show the number of jars that should be produced each month as well as for the quarter in total. Peanut Land Inc. Production Budget For the First Quarter of the Year January February March Total Sales 50,000 70,000 60,000 V 180,000 Desired ending inventory 17,500 V 15,000 14,500 14,500 Total needs 67,500 V 85,000 V 74,500 V 194,500 Less: Beginning inventory 31,000 17,500 V 15,000 V 31,000 Units produced 36,500 V 67,500 V 59,500 V 163,500 2. Prepare a direct materials purchases budget for jars for the months of January and February. Peanut Land Inc. Direct Materials Purchases Budget for Jars For January and February January February Total Production 36,500 67,500 V 104,000 Jar 1 1 1 Jars for production 67,500 V 36,500 104,000 Desired ending inventory 11,900 V 13,500 11,900 Total needs 50,000 79,400 115,900 Less: Beginning inventory 7,300 V 13,500 V 7,300 Jars purchased 42,700 V 65,900 V 84,900 X
Prepare a direct materials purchases budget for peanuts for the months of January and February.
Peanut Land Inc.
Direct Materials Purchases Budget for Peanuts
For January and February
January
February
Total
Production
36,500 V
67,500
104,000
24 V
24
Ounces
24
Ounces for production
876,000
1,620,000
2,496,000
Desired ending inventory
324,000 V
288,000 X
288,000 X
Total needs
552,000 X
1,322,000 X
2,208,000 X
Less: Beginning inventory
7,300 X
13,500
Ounces purchased
Transcribed Image Text:Prepare a direct materials purchases budget for peanuts for the months of January and February. Peanut Land Inc. Direct Materials Purchases Budget for Peanuts For January and February January February Total Production 36,500 V 67,500 104,000 24 V 24 Ounces 24 Ounces for production 876,000 1,620,000 2,496,000 Desired ending inventory 324,000 V 288,000 X 288,000 X Total needs 552,000 X 1,322,000 X 2,208,000 X Less: Beginning inventory 7,300 X 13,500 Ounces purchased
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Principles of Cost Accounting
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning