Ramos Co. provides the following sales forecast and production budget for the next four months: April May June July Sales (units) 500 580 530 600 Budgeted production (units) 442 570 544 540 The company plans for finished goods inventory of 120 units at the end of June. In addition, each finished unit requires 5 pounds of direct materials and the company wants to end each month with direct materials inventory equal to 30% of next month’s production needs. Beginning direct materials inventory for April was 663 pounds. Direct materials cost $2 per pound. Each finished unit requires 0.50 hours of direct labor at the rate of $16 per hour. The company budgets variable overhead at the rate of $20 per direct labor hour and budgets fixed overhead of $8,000 per month. Prepare a direct materials budget for April, May, and June.
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.
Ramos Co. provides the following sales
| April | May | June | July | |||||
| Sales (units) | 500 | 580 | 530 | 600 | ||||
| Budgeted production (units) | 442 | 570 | 544 | 540 | ||||
The company plans for finished goods inventory of 120 units at the end of June. In addition, each finished unit requires 5 pounds of direct materials and the company wants to end each month with direct materials inventory equal to 30% of next month’s production needs. Beginning direct materials inventory for April was 663 pounds. Direct materials cost $2 per pound. Each finished unit requires 0.50 hours of direct labor at the rate of $16 per hour. The company budgets variable overhead at the rate of $20 per direct labor hour and budgets fixed overhead of $8,000 per month.
Prepare a direct materials budget for April, May, and June.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images
