need help with requirement 6-8

Requirements Bigeted income state 1. Prepare the sales budget for April 2. Prepare the inventory, purchases, and cost of goods sold budget for April 3. Prepare the selling and administrative expense budget for April 4. Prepare the schedule of cash receipts from customers for April 5. Prepare the schedule of cash payments for selling and administrative expenses for April 6. Prepare the cash budget for April Assume the company does not use short-term financing to maintain a minimum cash balance 7. Prepare the budgeted income statement for April 8. Prepare the budgeted balance sheet at April 30, 2024 Print Done short-term financing to Review the budgeted cash payments for seung and administrative expenses you prepared above. Sheet Printing Supply Cash Budget For the Month Ended April 30, 2024 Beginning cash balance $50,500 Cash receipts from customers $76.900 Cash available $127 400 Cash payments Purchases of merchandise inventory Selling and administrative expenses $22,800 Capital expenditures 516,000 Payments for dividend $4 500 Total cash payments Ending cash balance Choose from any list or enter any number in the input fields and then click Check Answer 3 parts remaining E TE e. a. April dividends of $4,500 were declared and paid b. April capital expenditures of $16,000 budgeted for cash purchase of equipment c. April depreciation expense, $400. d. Cost of goods sold, 40% of sales. Desired ending inventory for April is $21,200 f. April selling and administrative expenses include salaries of $33,000, 30% of which will be paid in cash and the remainder paid next month 9. Additional April selling and administrative expenses also include miscellaneous expenses of 15% of sales, all paid in April h. April budgeted sales. $86,000,75% collected in April and 25% in May i. April cash payments of March 31 liabilities incurred for March purchases of inventory, $8,500 April purchases of inventory $5.700 for cash and $37,800 on account. Half the credit purchases will be paid in April and half in May. Om Print Done Sheet Printing Supply Cash Budget For the Month Ended April 30, 2024 Beginning cash balance Cash receipts from customers Cash available Cash payments Purchases of merchandise inventory Soling and administrative expenses Capital expenditures Payments for dividend Total cash payments Ending cash balance $50,500 $76,900 $127.400 $22.800 $16,000 $4,500 Choose from any list of enter any number in the input fields and then click Check Answer 3 parts remaining E at Printing Supply of Baltimore has applied for a loan. Its bank has request 2024 The March 31, 2024, balance sheet follows: (Click the icon to view the balance sheet) Data Table - Sheet Printing Supply Balance Sheet March 31, 2024 Assets Current Assets Cash $ Accounts Receivable 50,500 12.400 12.100 S 75,000 Budgeted Cash Payments for Selling and Administrative Expenses For the Month Ended April 30, 2024 ariable expenses: 12 iscellaneous expenses Ixed expenses: 30% of current month's salaries expense 22 Total payments for selling and administrative expenses Requirement 6. Prepare the cash budget for April. Assume the company doo review the budgeted cash receipts from customers. You cepared above Ceview the budgeted cash payments for selling and administrative expenses. Sheet Printing Supply Cash Budget For the Month Ended April 30, 2024 Beginning cash balance $50,500 Cash receipts from customers $76,900 Cash available $127.400 Cash payments Purchases of merchandise eventory Selling and administrative expenses $22,800 Capital expenditures $16,000 Payments for dividend $4,500 Merchandise Inventory Total Current Assets Property, Plant, and Equipment Equipment and Fixtures Less Accumulated Depreciation 80,700 (12,300) 68.400 143,400 $ 8,500 Total Assets Liabilities Current Liabilities Accounts Payable Stockholders' Equity Common Stock, no par $ Retained Earnings Total Stockholders' Equity Total Liabilities and Stockholders' Equity 25.000 109,900 Total cash payments 4,900 143,400 $ Ending cash balance Choose from any list or enter any number in the input fields and then click Print Done Isimilar tal Budgeted cash receipts from customers She 30 budgeted income statement for April 2024 and budgeted balance sheet at April As She (CE Read the VE Sheet Printing Supply Budgeted Cash Receipts from Customers For the Month Ended April 30, 2024 Current month sales, 75% $ Prior month sales, 25% $ Total cash receipts MO 64,500 12.400 FI 76,900 30 TO Print Done Red use short-term financing to maintain a minimum cash balance Budgeted cash payments for setting and administrative expenses Review the budgeted cash receipts from customers.you prepared above. Beview the budgeted cash. Rayment for selling and administrative expenses. Shout Printing Supply Cash Budget For the Month Ended April 30, 2024 Beginning cash balance $50,500 Cash receipts from customers S76,900 Cash available $127 400 Cash payments Purchases of merchandise inventory Selling and administrative expenses $22,000 Capital expenditures $16,000 Payments for dividend $4.500 Total cash payments Ending cash balance Sheet Printing Supply Budgeted Cash Payments for Selling and Administrativo Expenses For the Month Ended April 30, 2024 Variable expenses S 12.900 Miscellaneous expenses Fixed expenses 9.900 30% of current month's salaries expense $ 22,800 Total payments for selling and administrative expenses Print Done Choose from any list of enter any number in the input fields and then click Check