Purchase budget. how to solve for questions 1-4 with information given?

I prepared a purchases and cash payments budget for February through June. The information is prese Data February March April May June Unit sales 100 160 200 260 300 Inventory balance 15% of next month's budgeted sales Selling price $28 Unit cost $18 Payments on payables 40% in the month of purchase 60% in the month following the purchaseCorporation XYZ manufactures and sells office supplies. The financial analyst prepared a budget of purchases for February through June. This will be used in preparation ofthe income statement, cash flow statement, and balance sheet. Based on the information in the exhibit, calculate the amounts requested below for April. Enter the appropriate amounts in the associated cells. Enter all amounts as positive values. Round amounts to the nearest hundredth. 1. Purchase budget (dollars) 2. Cash payments to vendors 3. Accounts payable 4. Cost of goods sold