Please solve all the requirements, thank you!

Keira's Sports, Inc., carries a line of titanium putters, Keira's Sports, Inc., uses the average cost method and a perpetual inventory system. The sales price of each putter is $166. Company records indicate the following activity for putters for the month of July (Click the icon to view the records.) Read the requirements. Requirement 1. Prepare a perpetual inventory record for the putters on the average cost basis to determine the cost of ending inventory and cost of goods sold for the month. Round average cost per unit to the nearest cent and all other amounts to the nearest dollar. Start by entering the beginning inventory balances. Enter the transactions in chronological order, calculating new inventory on hand balances after each transaction. Once all of the transactions have been entered into the perpetual record, calculate the quantity and total cost of inventory purchased, sold, and on hand at the end of the period. (Round average cost per unit to the nearest cent and all other amounts to the nearest dollar.) Avg Cost: Purchases Cost of goods sold Inventory on hand Unit Total Unit Total Unit Total Data table Date Qty Cost Cost Qty Cost Cost Qty Cost Cost Jul 1 Date Item Jul 1 Balance 7 Purchase 11 Sale 19 Purchase 28 Sale Quantity Unit Cost 4 $ 95 20 $ 96 22 16 $ 99 15 Print Done Requirements 1. Prepare a perpetual inventory record for the putters on the average cost basis to determine the cost of ending inventory and cost of goods sold for the month. Round average cost per unit to the nearest cent and all other amounts to the nearest dollar. 2. Journalize the inventory transactions for Keira's Sports, Inc., using the perpetual average cost method. Assume all purchases and sales are on account. Print Done