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

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question

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.
Transcribed Image Text: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.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education