Hardin Fabrications is preparing its master budget for the third quarter. Average sales price of merchandise $220 Average ingots of steel per unit Cost of one steel ingot Direct labor hours per unit Direct labor rate per hour Projected Sales in Units January February March April May June July August September 1,500 1,875 1,750 2,000 1,200 1,900 2,250 2,100 1.650 3.5 $ 17.00 1.5 $ 19.00
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.
Please do not give solution in image format thanku
![1
Preparing an Operating Budget
Hardin Fabrications is preparing its master budget for the third quarter.
Average sales price of merchandise $220
Average ingots of steel per unit
Cost of one steel ingot
Direct labor hours per unit
Direct labor rate per hour
Projected Sales
in Units
January
February
Marchi
April
May
June
July
August
September
October
November
December
1,500
1,875
1,750
2,000
1,200
1,900
2,250
2,100
1,650
3,200
1,400
1,900
Variable overhead per unit produced
Fixed overhead per year
3.5
$ 17.00
Units on hand July 1
Steel ingots on hand July 1
1.5
$ 19.00
Selling expense per unit sold
Fixed administrative expense per year.
Capacity for the year 25,000
of next month's sales in production ending inventory
of next month's production in materials ending inventory
$ 40.00
$ 96,000
500
2,083
$18.00
$ 125,000
30%
25%
Required:
Create the Operating Budget and Budgeted Income Statement for the third quarter.
Note: Do not use the ROUND() function.
Saved
1. Use the Open Excel in New Tab button to launch this question.
2. When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fac0a2823-d56e-4b93-99da-cbb20ede3aec%2Fa0075c39-53f1-4499-bf14-781a3fa2a270%2Fgnlea4_processed.jpeg&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 3 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)