please format it as such so its easy to understand, thank you!

Preparing an Operating Budget Hardin Fabrications is preparing its master budget for the third quarter. Average sales price of merchandise $220 Capacity for the year 25,000 \& of next month's sales in production ending inventory 4 of next month's production in naterials ending inventory 30s Units on hand July 1 Steel ingots on hand July 12,083 Required: Create the Operating Budget and Budgeted Income Statement for the third quarter. Note: Do not use the ROUND() function. 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 Create the Operatins Budset and Budgesed income Statement for the third guarter. Note: Oo not use the notvoO function. AI numbers thould be shown as poiktive numbers. Preparing an Operating Budget Hardin Fabrications is preparing its master budget for the third quarter. Average sales price of merchandise $220 Capacity for the year 25,000 \& of next month's sales in production ending inventory 4 of next month's production in naterials ending inventory 30s Units on hand July 1 Steel ingots on hand July 12,083 Required: Create the Operating Budget and Budgeted Income Statement for the third quarter. Note: Do not use the ROUND() function. 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 Create the Operatins Budset and Budgesed income Statement for the third guarter. Note: Oo not use the notvoO function. AI numbers thould be shown as poiktive numbers