Requirement 4. Prepare a perpetual inventory record using average cost Round average cost per unit to the nearest oent 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 trarsactions have bean entered into the perpetual record, calcuiahe 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 neareet cont and al other amours to the neareal dolar) Cost of goods sold Inventory on hand Unit Total UnitotalData Table UnitTotal Unit Total Date Qty Cost Cost aity Cost Cost Qity Cost Cost Mar1 Date tem Mar Balance |-| aantry | Unit Cost Mar 4 Mar 12 31 22 Purchase40 Enter any number in the edit fields and then continue to the next question Print Done caps