please answer the question in the table form. Thanks

2.1. The following information is budgeted for Plumbing Company for next quarter: April May June Sales 110,000 130,000 180,00 Merchandise purchases 85,000 92,000 105,00 Selling & Administrative expenses 50,000 50,000 50,00 All sales at Plumbing are on credit. Forty percent are collected in the month of sale, in the month following the sale, and the remaining 2% are uncollectible. Merchandise purch are paid in full the month following the month of purchase. The selling and administr expenses above include $8,000 of depreciation on display fixtures and warehouse equipmen other selling and administrative expenses are paid as incurred. Plumbing wants to maint cash balance of $15,000. Any amount below this can be borrowed from a local bank as need increments of $2,000. All borrowings are made at month end. Required: Prepare Plumbing's cash budget for the month of May and June. Plumbing expec have $24,000 of cash on hand at the beginning of May. 2.1. The following information is budgeted for Plumbing Company for next quarter: April May June Sales 110,000 130,000 180,00 Merchandise purchases 85,000 92,000 105,00 Selling & Administrative expenses 50,000 50,000 50,00 All sales at Plumbing are on credit. Forty percent are collected in the month of sale, in the month following the sale, and the remaining 2% are uncollectible. Merchandise purch are paid in full the month following the month of purchase. The selling and administr expenses above include $8,000 of depreciation on display fixtures and warehouse equipmen other selling and administrative expenses are paid as incurred. Plumbing wants to maint cash balance of $15,000. Any amount below this can be borrowed from a local bank as need increments of $2,000. All borrowings are made at month end. Required: Prepare Plumbing's cash budget for the month of May and June. Plumbing expec have $24,000 of cash on hand at the beginning of May