please show how to calculate the answer, i am confused

all amounts to the nearest dollar. r Office i Requirements - X Fales Bu and Ma Prepare Ruler's sales budget for April and May 2018. Round all calculations to the nearest dollar. 1. Prepare Ruler's inventory, purchases, and cost of goods sold budget for April and May. 2. er's inve Prepare Ruler's selling and administrative expense budget for April and May. 3. tory, Pu Done Print - X Data Table Current Assets: Cash $ 23,000 oi Accounts Receivable 20,000 Merchandise Inventory 27,000 1,300 Prepaid Insurance Total Current Assets $ 71,300 Property, Plant, and Equipment: Equipment and Fixtures 60,000 (18,000) 42,000 Less: Accumulated Depreciation ods $ 113,300 Total Assets Liabilities Sold Current Liabilities: Accounts Payable $ 15,000 pril 3,400 Salaries and Commissions Payable 8 Total Liabilities $ 18,400 21 Stockholders' Equity 10 Common Stock, no par 12,000 Retained Eamings 82,900 Total Stockholders' Equity 94,900 $ 113,300 Total Liabilities and Stockholders' Equity and then Print Done More Info ay Sales in April are expected to be $160,000. Ruler 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. Ruler maintains inventory of $7,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 $8,000. Sales commissions equal 5 % of sales for that month. d. a. 163,20 cost of b. pany . Other monthly expenses are as follows: Rent: $2,200 Depreciation: $500 Insurance: $400 Income tax: $1,600 Goods 018 Done Print Requirement 2. Prepare Ruler's inventory, purchases, and cost of goods sold budget for April and May. Ruler Supply Company Inventory, Purchases, and Cost of Goods Sold Budget April and May, 2018 May April Cost of goods sold Desired ending merchandise inventory Plus: Total merchandise inventory required Beginning merchandise inventory Less: Budgeted Purchases Requirement 3. Prepare Vinning's selling and administrative expense budget for April and May. Vinning Office Supply Selling and Administrative Expense Budget April and May, 2018 April May Variable expenses: Fixed expenses: Choose from any list or enter anv number in the input fields and then click Check