can you please type it done includeing the fomula on how you got the answer please

Exercise 4-7A (Algo) Determining the cost of inventory LO 4-2, 4-3, 4-4 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.) Required a. Jill's Dress Shop had a beginning balance in its inventory account of $42,000. During the accounting period, Jill's purchased $81,000 of inventory, returned $5,400 of inventory, and obtained $790 of purchases discounts. Jill's incurred $1,080 of transportation-in cost and $640 of transportation-out cost. Salaries of sales personnel amounted to $33,000. Administrative expenses amounted to $37,600. Cost of goods sold amounted to $86,300. b. Ken's Bait Shop had a beginning balance in its inventory account of $8,800. During the accounting period, Ken's purchased $40,100 of inventory, obtained $1,280 of purchases allowances, and received $400 of purchases discounts. Sales discounts amounted to $680. Ken's incurred $980 of transportation-in cost and $300 of transportation-out cost. Selling and administrative cost amounted to $12,700. Cost of goods sold amounted to $34,700. Cost of goods available for sale Ending Inventory Jill's Dress Shop Ken's Bait Shop Exercise 4-20A (Algo) Effect of inventory transactions on the income statement and balance sheet: Periodic system (Appendix) LO 4-9 Bill Rose owns Rose Sporting Goods. At the beginning of the year, Rose Sporting Goods had $2,700 in inventory. During the year, Rose Sporting Goods purchased inventory that cost $13,300. At the end of the year, inventory on hand amounted to $3,900. Required a. Calculate the cost of goods available for sale during the year. b. Calculate the cost of goods sold for the year. c. Calculate the amount of inventory Rose Sporting Goods would report on the year-end balance sheet. a. Cost of goods available for sale b. Cost of goods sold C. Inventory reported on year-end balance sheet