Question
Production Budget and Direct Materials Purchases Budgets Smee Inc. produces all-natural organic peanut butter. The peanut butter is sold in 12-ounce jars. The sales budget
Production Budget and Direct Materials Purchases Budgets
Smee 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 | 105,000 |
February | 80,000 | 168,000 |
March | 40,000 | 84,000 |
April | 62,000 | 130,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 39,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.
Smee 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. Do not include a multiplication symbol as part of your answer.
Smee, 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 |
Prepare a direct materials purchases budget for peanuts for the months of January and February. Do not include a multiplication symbol as part of your answer.
Smee, 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