Modern Goods Corporation has the following budgeted sales for the selected six-month period: Month Unit Sales January 15,000 February 20,000 March 35,000 April 25,000 May 30,000 June 20,000 There were 7,500 units of finished goods in inventory at the beginning of January. Plans are to have an inventory of finished product equal to 20 percent of the unit sales for the next month. Three pounds of materials are required for each unit produced. Each pound of material costs $20. Inventory levels for materials equal 30 percent of the needs for the next month. Materials inventory on January 1 was 5,000 pounds. Required: Prepare production budgets in units for February, March, and April.
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
Modern Goods Corporation has the following budgeted sales for the selected six-month period:
Month |
Unit Sales |
January |
15,000 |
February |
20,000 |
March |
35,000 |
April |
25,000 |
May |
30,000 |
June |
20,000 |
There were 7,500 units of finished goods in inventory at the beginning of January. Plans are to have an inventory of finished product equal to 20 percent of the unit sales for the next month.
Three pounds of materials are required for each unit produced. Each pound of material costs $20. Inventory levels for materials equal 30 percent of the needs for the next month. Materials inventory on January 1 was 5,000 pounds.
Required:
Prepare production budgets in units for February, March, and April.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images