Data table EVA Industries, Inc., completed the following inventory transactions during the month of March: (Click the icon to view the transactions.) Date Item Read the requirements 11 Mar mit 601 Mar 1 Balance 4 Purchase 12 Sale 5220 Quantity Unit Cost 45 $ 90 600$ 87 90 54 $ 84 87 90 45 4050 60 87 5220 Mar 12 60 87 5220 22 Purchase 31 Sale 30 2700 90 15 90 44 1125 Mar 22 54 14 4536 15 90 1125 54 84 4536 Mar 31 90 1350 Print Done 15 10 44 84 3696 84 840 Total 114 9756 134 11616 25 2190 Requirement 4. Prepare a perpetual inventory record using average cost. Round average cost per unit to the nearest cent and all other amounts to the nearest dollar. Start by entering the opening inventory balance. 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.) Purchases Unit Total Cost of goods sold Unit Total Inventory on hand Unit Total Date Qty Cost Cost Qty Cost Cost Cost Qty 45 Cost 90 Mar 1 4050 Mar 4 60 87 5220 105 Mar 12 90 15 Mar 22 54 B4 4536 69 Mar 31 44 25 Total 114 9756 134 25