Question
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
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 | 70,000 | 126,000 |
February | 45,000 | 81,000 |
March | 40,000 | 72,000 |
April | 46,000 | 82,800 |
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 38,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.
Peanut Land Inc. | ||||
Production Budget | ||||
For the First Quarter of the Year | ||||
January | February | March | Total | |
Sales | ||||
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.
Peanut Land Inc. | |||
Direct Materials Purchases Budget for Jars | |||
For January and February | |||
January | February | Total | |
Production | |||
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.
Peanut Land Inc. | |||
Direct Materials Purchases Budget for Peanuts | |||
For January and February | |||
January | February | Total | |
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