I just need help with part 4, how do you get the gross profit value and the rest of the blanks?

The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: assets as of March 31: ur Cash 9,200 26,800 Accounts receivable Inventory 49,800 ipment, net 29.925 Accounts pavable Common stock Retained earnings 150,000 $ 10,275 a. The gross margin is 25% of sales . b. Actual and budgeted sales data: (actual) 83.800 April ay June July 88,000 113,000 $ 64,000 c. Sales are 60% for cash and 40% on credit. Credit sales are collected in the month following sale. The accounts receivable at March 31 are a result of March credit sales d. Each month's ending inventory should equal 80% of the following month's budgeted cost of goods sold. e. One-half of a month's inventory purchases is paid for in the month of purchase; the other half is paid for in the following month. The accounts payable at March 31 are the result of March purchases of inventory. of salo nses are as follows: commisslons. 12ly Depreciation is $783 per month (includes depreciation on new assets). month g. Equipment costing $3,200 will be purchased for cash in April. t least $4,000 at the end of each month. The company has an of h agreement with a local bank that allows the company to borrow in increments of $1,000 at the beginning of each month, up to a total loan balance of $20,000. The interest rate on these loans is 1% per month and for simplicity we will assume that interest is not compounded. The company would, as far as it is able, repay the loan plus accumulated interest at the end of the quarter. absorption costing income statement for the quarte Prepare an Shilow Company Income Statement For the Quarter Ended June 30 Sales $ 284,000 Cost of goods sold: Beginning inventory 49,800 Purchases 201,600 251,400 Goods available for sale 251,400 Ending inventory Gross margin 32,600 Selling and administrative expenses: Commissions Rent Other expenses Depreciation 0 Net operating income Interest expense 32,600 Net income 32,600