I only need question 4 done. Please and thank you!

3. Selling, general and administrative Budget The SG&A budget is an estimate of all operating costs other than production. Total SG&A budget (including salaries, rent, advertising, depreciation and other) is $60,000 per quarter, of which $3,000 is depreciation expense. 4 - Complete the Cash Budget The cash budget is divided into four sections: 1.Cash receipts section lists all cash inflows excluding cash received from financing 2.Cash disbursements section consists of all cash payments excluding repayments of principal and interest, 3.Cash excess or deficiency section determines if the company will need to borrow money or if it will be able to repay funds previously borrowed; and 4. Financing section details the borrowings and repayments projected to take place during the budget period. Maintains a minimum cash balance of $30,000 and had no outstanding borrowings. The company's beginning cash balance for the upcoming fiscal year is $30,000. The company requires a minimum cash balance of $30,000 and may borrow in increments of $5,000 as needed from a local bank at a quarterly simple interest rate of 2%. The company may borrow any amount at the beginning of any quarter and may repay its loans, or any part of its loans, at the end of any quarter. Interest payments are due on any principal at the time it is repaid. Pays a cash dividend of $50,000 in Quarter 2 and Quarter 4. Purchases $20,000 of equipment in Quarter 1, $30,000 in Quarter 2 and $25,000 in Quarter 4 (purchases paid in cash). Assume equivalent assets were retired, so there is no impact on depreciation expenses. 5 - Complete the Budgeted Income Statement Izzy's produces accrual based (GAAP) financial statements. Odos A D F 3 Labor rate per hour 3 Total direct labor cost $ $ 13.00 $ 54,600.00 $ 13.00 $ 13.00 $ 79,300.00 $ 92,300.00 $ Cost per unit 13.00 $ 99,320.00 $ 13.00 325,520.00 1.30 $ $ S $ $ 42,000 0.15$ 035$ 21,000.00 $ 35,000.00 56,000.00 $ 61,000 0.15$ 0.35 S 30,500.00 $ 35,000.00 $ 65,500.00 $ 71,000 0.155 0.35 $ 35,500.00 $ 35,000.00 5 70,500.00 $ 76,400 0.15$ 0.35$ 38,200.00 $ 35,000.00 5 73,200.00 5 250,400 0.15 0.35 125,200.00 140,000.00 265,200.00 $ $ 10,000.00 $ 46,000.00 10,000.00 $ 10,000.00 $ 10,000.00 5 $ $ 40,000.00 2,252,000.00 1.06 Cost per unit S $ $ 60,000.00 $ 3,000.00 $ 63,000.00 $ 60,000.00 $ 3,000.00 $ 63,000.00 $ 60,000.00 $ 3,000.00 $ 63,000.00 $ 60,000.00 3,000.00 63,000.00 30,000 2c. Manufacturing Overhead Budgets 10 Units to be produced 1 Indirect materials per unit 2 Indirect labor per unit 3 Variable OH 4 Fixed Overhead 5 Total Overhead Costs 6 -7 Noncash MOH - Depreciation -8 Cash payments for Overhead -9 0 3. Selling general and administrative Budget $1 Expenses per quarter 52 Non cash (Deprecation) 33 Cash for SGA 34 SS 56 4. Cash Budget 57 Cash Receipts 58 Beginning cash balance 59 Cash Collections from Sales 70 Total Cash Receipts 1 272 Cash Disbursements 23 Cash payments for purchases of inventory 24 Cash payments for direct labor 25 Cash payments for MOH 6 Cash payments for SG&A 7 Capital expenditures 28 Dividends 79 Total Cash Disbursements BO 31 Cash Excess (Deficiency) B2 B3 Financing 34 Borrowing 35 Repayments 36 Interest 37 Net Financing 38 39 Ending Cash Balance 90 91 Minimum cash 32 93 Interest-quarterly 94 2% 3. Selling, general and administrative Budget The SG&A budget is an estimate of all operating costs other than production. Total SG&A budget (including salaries, rent, advertising, depreciation and other) is $60,000 per quarter, of which $3,000 is depreciation expense. 4 - Complete the Cash Budget The cash budget is divided into four sections: 1.Cash receipts section lists all cash inflows excluding cash received from financing 2.Cash disbursements section consists of all cash payments excluding repayments of principal and interest, 3.Cash excess or deficiency section determines if the company will need to borrow money or if it will be able to repay funds previously borrowed; and 4. Financing section details the borrowings and repayments projected to take place during the budget period. Maintains a minimum cash balance of $30,000 and had no outstanding borrowings. The company's beginning cash balance for the upcoming fiscal year is $30,000. The company requires a minimum cash balance of $30,000 and may borrow in increments of $5,000 as needed from a local bank at a quarterly simple interest rate of 2%. The company may borrow any amount at the beginning of any quarter and may repay its loans, or any part of its loans, at the end of any quarter. Interest payments are due on any principal at the time it is repaid. Pays a cash dividend of $50,000 in Quarter 2 and Quarter 4. Purchases $20,000 of equipment in Quarter 1, $30,000 in Quarter 2 and $25,000 in Quarter 4 (purchases paid in cash). Assume equivalent assets were retired, so there is no impact on depreciation expenses. 5 - Complete the Budgeted Income Statement Izzy's produces accrual based (GAAP) financial statements. Odos A D F 3 Labor rate per hour 3 Total direct labor cost $ $ 13.00 $ 54,600.00 $ 13.00 $ 13.00 $ 79,300.00 $ 92,300.00 $ Cost per unit 13.00 $ 99,320.00 $ 13.00 325,520.00 1.30 $ $ S $ $ 42,000 0.15$ 035$ 21,000.00 $ 35,000.00 56,000.00 $ 61,000 0.15$ 0.35 S 30,500.00 $ 35,000.00 $ 65,500.00 $ 71,000 0.155 0.35 $ 35,500.00 $ 35,000.00 5 70,500.00 $ 76,400 0.15$ 0.35$ 38,200.00 $ 35,000.00 5 73,200.00 5 250,400 0.15 0.35 125,200.00 140,000.00 265,200.00 $ $ 10,000.00 $ 46,000.00 10,000.00 $ 10,000.00 $ 10,000.00 5 $ $ 40,000.00 2,252,000.00 1.06 Cost per unit S $ $ 60,000.00 $ 3,000.00 $ 63,000.00 $ 60,000.00 $ 3,000.00 $ 63,000.00 $ 60,000.00 $ 3,000.00 $ 63,000.00 $ 60,000.00 3,000.00 63,000.00 30,000 2c. Manufacturing Overhead Budgets 10 Units to be produced 1 Indirect materials per unit 2 Indirect labor per unit 3 Variable OH 4 Fixed Overhead 5 Total Overhead Costs 6 -7 Noncash MOH - Depreciation -8 Cash payments for Overhead -9 0 3. Selling general and administrative Budget $1 Expenses per quarter 52 Non cash (Deprecation) 33 Cash for SGA 34 SS 56 4. Cash Budget 57 Cash Receipts 58 Beginning cash balance 59 Cash Collections from Sales 70 Total Cash Receipts 1 272 Cash Disbursements 23 Cash payments for purchases of inventory 24 Cash payments for direct labor 25 Cash payments for MOH 6 Cash payments for SG&A 7 Capital expenditures 28 Dividends 79 Total Cash Disbursements BO 31 Cash Excess (Deficiency) B2 B3 Financing 34 Borrowing 35 Repayments 36 Interest 37 Net Financing 38 39 Ending Cash Balance 90 91 Minimum cash 32 93 Interest-quarterly 94 2%