How do I prepare a direct materials budget (Rounded to nearest dollar) that is similar to Illustration 22-9 of the textbook? (illustration attached) please explain what you did to get the numbers or show formulas.

Illustration 22.9 below

Materials Inventory Costs & Planning Direct Materials Amount Used per Unit Cost Metal 2 lb $ 1.00 lb The company likes to keep 5% of the material needed for the next month's production in raw materials ending inventory. 100% Accounts Payable & Disbursements Purchases on Account Payment Activity Month of Purchase Month after Purchase Balance at 12/31/19 50% 50% 120,000 $ Direct Labor & Costs Time per Unit Production Pay Rate/Hour $ 9 minutes 7.00 0.30 0.45 0.45 0.25 Manufacturing Overhead Costs Variable costs per direct labor hour Indirect materials Indirect labor Utilities Maintenance Fixed costs per month Salaries Depreciation Property taxes Insurance Janitorial $ 42,000 16,800 2,675 1,200 1,300 $ 1.45 Selling and Administrative Costs Variable costs per unit sold Fixed costs per month Advertising Insurance Salaries Depreciation Other fixed costs 15,000 14,000 72,000 25,000 3,000 Income Taxes Accrued on Monthly Net Income Amounts Accrued Q4 2019, paid January 2020 35% rounded to nearest dollar 200,000 $ Cash and Financing Matters Cash Balance, 12/31/2019 2020 Minimum Balance Required $ 90,000 715,000 $ Monthly Dividends Outstanding Shares 2.25 per share 5,000 Line of Credit Limit None Borrowing Increment Required $ 1,000 Interest Rate Draws First of Month Repayments Last of Month Interest accumulates to the loan balance and is paid in full with each repayment. 9% Additional Item Fixed Asset Purchase Month $ 445,000 February Serious Business, Inc. Sales Budget For the first Quarter January February 111000 112000 12.00 $ 12.00 $1,332,000.00 $ 1,344,000.00 Expected Sales Units Unit Selling Price Total Sales March 114000 $ 12.00 $ 1,368,000.00 Q1 337000 $ 12.00 $ 4,044,000.00 Expected Sales Units Add: Desired Ending Finished Goods Units Total Required Units Less: Beginning Finished Goods Required Production Units Serious Business, Inc. Production Budget For the first Quarter January February 111000 112000 11200 11400 122200 123400 11100 11200 111100 1 12200 March 114000 12400 126400 11400 115000 337000 35000 372000 33700 3 38300 m in Year Hayes Company Direct Materials Budget For the Year Ending December 31, 2022 Quarter 2 6 Units to be produced (Illustration 22.5) 3,100 3,600 4,100 Direct materials units per unit produced x2 - X2 - X2 8 Direct materials units required for production 6,200 7,200 8,200 Add: Desired ending direct materials (pounds) 720 820 920 10 Total materials required 6,920 8,020 9,120 11 Less: Beginning direct materials (pounds) 6206 720 820 12 Direct materials units to be purchased (pounds) 6,300 7,300 8,300 13 Cost per pound X $4 X $4 X $4 14 Cost of direct materials purchases $25,200 $29,200 $33,200 4,600 X2 9,200 1,0200 10,220 920 9,300 x $4 $37,200 $124,800 16 a10% of next quarter's production requirements 17 610% of estimated first-quarter pounds needed for production