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
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 | 80,000 | 144,000 |
February | 70,000 | 126,000 |
March | 50,000 | 90,000 |
April | 54,000 | 97,200 |
Company policy requires that ending inventories for each month be 10% of next month's sales. At the beginning of January, the inventory of peanut butter is 34,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.
Sales | Totals | |||
Desired ending inventory | ||||
Total needs | ||||
Less: Beginning inventory | ||||
Units produced |
2. Prepare a direct materials purchases budget for jars for the months of January and February.
Production | Totals | ||
Jar | |||
Jars for production | |||
Desired ending inventory | |||
Total needs | |||
Less: Beginning inventory | |||
Jars purchased |
3. Prepare a direct materials purchases budget for peanuts for the months of January and February.
Jan | Feb | ||
Production | |||
Ounces | |||
Ounces for production | |||
Desired ending inventory | |||
Total needs | |||
Less: Beginning inventory | |||
Ounces purchased | |||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started