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.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
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
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education