Enter the unadjusted trial balance on an end-of-period spreadsheet (work sheet) and complete the spreadsheet using the following adjustment data.

Insurance expired during May is $275.
Supplies on hand on May 31 are $715.
Depreciation of office equipment for May is $330.
Accrued receptionist salary on May 31 is $325.
Rent expired during May is $1,600.
Unearned fees on May 31 are $3,210.

If an amount box does not require an entry, leave it blank. Kelly Consulting End-of-Period Spreadsheet (Work Sheet) For the Month Ended May 31, 2019

For each of the following cases determine the ending balance in the inventory account. (hint: first, determine the total cost of inventory available for sale. next, subtract the cost of the inventory sold to arrive at the ending balance.)a. jill’s dress shop had a beginning balance in its inventory account of $40,000. during the accounting period jill’s purchased $75,000 of inventory, returned $5,000 of inventory, and obtained $750 of purchases discounts. jill’s incurred $1,000 of transportation-in cost and $600 of transportation-out cost. salaries of sales personnel amounted to $31,000. administrative expenses amounted to $35,600. cost of goods sold amounted to $82,300.b. ken’s bait shop had a beginning balance in its inventory account of $8,000. during the accounting period ken’s purchased $36,900 of inventory, obtained $1,200 of purchases allowances, and received $360 of purchases discounts. sales discounts amounted to $640. ken’s incurred $900 of transportation-in cost and $260 of transportation-out cost. selling and administrative cost amounted to $12,300. cost of goods sold amounted to $33,900.a& b. cost of goods avaliable for sale? ending inventory?