Required:

Create the Operating Budget and Budgeted Income Statement for the third quarter.

Note: Do not use the ROUND$()$ function.

Use the Open Excel in New Tab button to launch this question.

When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect.Hardin Fabrications is preparing its master budget for the third quarter.

Average sales price of merchandise $$220$

Projected Sales

in Units

Selling expense per unit sold

Fixed administrative expense per year $,$$$125,000$

Capacity for the year $25,000$

$\%$ of next month's sales in production ending inventory

$30\%$

$\%$ of next month's production in materials ending inventory