Please complete the chart and do the third requirment

a. b. c. d. Sales in April are expected to be $160,000. Thumbtack forecasts that monthly sales will increase 2% over April sales in May. June's sales will increase by 4% over April sales. July sales will increase 20% over April sales. Thumbtack maintains inventory of $12,000 plus 25% of the cost of goods sold budgeted for the following month. Cost of goods sold equal 50% of sales revenue. Monthly salaries amount to $10,000. Sales commissions equal 5% of sales for that month. The budget co O (Click the Read the requ Data table Current Assets: Cash Accounts Receivable Merchandise Inventory Prepaid Insurance Total Current Assets Balance Sheet March 31, 2024 Assets Other monthly expenses are as follows: Rent: $2,800 Depreciation: $400 Insurance: $300 Income tax: $1 ,900 print Done Thumbtack Supply Company Inventory, Purchases, and Cost of Goods Sold Budget April and May, 2024 April Plus: Desired ending merchandise inventory Total merchandise inventory required Less: Beginning merchandise inventory Budgeted Purchases Requirements Property, Plant, and Equipment Equipment and Fixtures Less: Accumulated Depreciation Total Assets Liabilities May Current Liabilities: Accounts Payable Salaries and Commissions Payable Total Liabilities Stockholders' Equity Common Stock, no par Retained Eamings Total Stockholders' Equity Total Liabilities and Stockholders' Equity Done print 30,000 14,000 32,000 45,000 (18,000) 10,000 4,700 s 23,000 66,700 77,400 27,000 104,400 14,700 89,700 104,400 I. 2. 3. Prepare Thumbtack's sales budget for April and May 2024. Round all calculations to the nearest dollar. Prepare Thumbtack's inventory, purchases, and cost of goods sold budget for April and May. Prepare Thumbtack's selling and administrative expense budget for April and May.