On January 1, 2020, the Ivanhoe Company budget committee has reached agreement on the following data for the 6 months ending June 30, 2020. Sales units: First quarter 6,000; second quarter 6,900; third quarter 7,400. Ending raw materials inventory: 40% of the next quarter’s production requirements. Ending finished goods inventory: 25% of the next quarter’s expected sales units. Third-quarter production: 7,840 units. The ending raw materials and finished goods inventories at December 31, 2019, follow the same percentage relationships to production and sales that occur in 2020. 4 pounds of raw materials are required to make each unit of finished goods. Raw materials purchased are expected to cost $5 per pound.
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.
On January 1, 2020, the Ivanhoe Company budget committee has reached agreement on the following data for the 6 months ending June 30, 2020.
Sales units: | First quarter 6,000; second quarter 6,900; third quarter 7,400. | |
Ending raw materials inventory: | 40% of the next quarter’s production requirements. | |
Ending finished goods inventory: | 25% of the next quarter’s expected sales units. | |
Third-quarter production: | 7,840 units. |
The ending raw materials and finished goods inventories at December 31, 2019, follow the same percentage relationships to production and sales that occur in 2020. 4 pounds of raw materials are required to make each unit of finished goods. Raw materials purchased are expected to cost $5 per pound.
![Prepare a direct materials budget by quarters for the 6-month period ended June 30, 202O.
IVANHOE COMPANY
Direct Materials Budget
For the Six Months Ending June 30, 2020
Quarter
1
2
Units to be Produced
Direct Materials Per Unit
Total Pounds Needed for Production
Add +:
Desired Ending Direct Materials (Pounds)
Total Materials Required
Less :
Beginning Direct Materials (Pounds)
Direct Materials Purchases
Cost Per Pound
Total Cost of Direct Materials Purchases
$
%24](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fc0603834-a839-4b2d-a2db-fc20bf5fdfa1%2F5c1b4fcd-31f7-4b4c-a7bd-fa6cf9b9eb6e%2Fg0p4cni_processed.png&w=3840&q=75)
![Your answer is partially correct.
Prepare a production budget by quarters for the 6-month period ended June 30, 2020.
IVANHOE COMPANY
Production Budget
For the Six Months Ending June 30, 2020 +
Quarter
1
2
M
Expected Unit Sales
Add +:
Desired Ending Finished Goods Unit +
Total Required Units
Less +:
Beginning Finished Goods Unit
Required Production Units](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fc0603834-a839-4b2d-a2db-fc20bf5fdfa1%2F5c1b4fcd-31f7-4b4c-a7bd-fa6cf9b9eb6e%2Fkftaz5i_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)