Golf Unlimited carries an inventory of putters and other golf clubs. The sales price of each putter is $$143.$ Company records indicate the following for a particular line of Golf Unlimited's putters:

$($Click the icon to view the records.$)$

Read the requirements.

Requirement $1.$ Prepare Golf Unlimited's perpetual inventory record for the putters assuming Golf Unlimited uses the weighted$-$average inventory costing method. Round weighted$-$average cost per unit to the nearest cent and all other amounts to the nearest dollar. Then identify the cost of ending inventory and cost of goods sold for the month.

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.

$\backslash$table$[[$Date$,$Purchases,Cost of Goods Sold,Inventory on Hand$],[$Quantity$,\backslash$table$[[$Unit$],[$Cost$]],\backslash$table$[[$Total$],[$Cost$]],$Quantity,$\backslash$table$[[$Unit$],[$Cost$]],\backslash$table$[[$Total$],[$Cost$]],$Quantity,$\backslash$table$[[$Unit$],[$Cost$]],\backslash$table$[[$Total$],[$Cost$]]],[$Jun$.1,,,2x,62,,,,,]]$

Data table

$\backslash$table$[[$Date$,$Item,Quantity,Unit Cost$],[$Jun$.1,$Balance,$17,$$$8$