requirement 4 please

Requirement 1. Prepare the schedule of cash receipts from customers for January and February 2024 Assume cash receipts are 60% in the month of the sale and 40% in the month following the sale Paperclip Company Budgeted Cash Receipts from Customers Two Months Ended February 28, 2024 January February Current month sales, 60% 5 51.000 51,180 Prior month sales, 40% 20.000 34.000 Total cash receipts 71,000 $ 85.180 Requirement 2. Prepare the schedule of cash payments for purchases for January and February 2024. Assume purchases are paid 30% in the month of purchase and 70% in th month following the purchase. Paperclip Company Budgeted Cash Payments for Purchases Two Months Ended February 28, 2024 January February 70% of last month's purchases $ 11.500 $ 28,350 30% of current month's purchases 12.150 12.570 $ 23,650 $ 40,920 Total cash payments for purchases Requirement 3. Prepare the schedule of cash payments for selling and administrative expenses for January and February 2024 Assume 40% of the accrual for Salaries and Commissions Payable is for commissions and 60% is for salaries The December 31 balance will be paid in January Salaries and commissions are paid 40% in the month incurre and 60% in the following month. Rent and income tax expenses are paid as incurred Insurance expense is an expiration of the prepaid amount. (Round your answers to the nearest whole number.) Paperclip Company Budgeted Cash Payments for Selling and Administrative Expenses Two Months Ended February 28, 2024 January February Variable expenses: 60% of last month's Commission Expense S 1,100 $ 2550 1,700 1.706 40% of current month's Commission Expense Total payments for variable expenses 2 800 4256 Fixed expenses 60% of last month's Salaries Expense 1.650 2.400 40% of current month's Salaries Expense 1600 1600 Rent expense 2.600 2.600 5.850 Total payments for foced expenses 6.500 S 8,650 $ 10,856 Total payments for S and A expenses Requirement 4. Prepare the cash budget for January and February 2024. Assume no financing took place Paperclip Company Cash Budget Data table Two Months Ended February 28, 2024 January February December 31, 2023, account balances Beginning cash balance , : Cash Cash receipts from customers Accounts Receivable Cash available Merchandise Inventory Cash payments: Accounts Payable Purchases of merchandise inventory Salarles and Commissions Payable Selling and administrative expenses Budgeted amounts for 2024: Payments for income taxes Sales, all on account Total cash payments Purchases, all on account , Ending cash balance Commissions Expense Salaries Expense Rent Expense Depreciation Expense Insurance Expense Income Tax Expense S $ 20,000 20.000 24 000 11.500 2,750 January February $ 85,000 S 85,300 40,500 41.900 4250 4265 4000 4,000 2 600 2,600 600 600 400 400 1.600 1,600