Average Cost Method $(4$ marks$)$

Question $22(4$ points$)$

c$.$aved

usten

Diamonds $\text{'}$R$\text{'}$ Us uses a perpetual inventory system and started operations first of the month. Please answer the following questions related to the in provided for the month's transactions. Assume that the Company uses th cost method and does not expect any returns.

ou may use the following spreadsheet to prepare your calculations: $W$ Diamonds $\text{'}$R$\text{'}$ Us$\_$template.xIsx Your instructor will not mark the spr ur final answers in the question below.

and your final answers to the nearest dollar.

$\backslash$table$[[$Purchases$,$Sales$],[$Units$,$Unit Cost,Units,,Price$],[100,4\mathrm{.}00,,,],[125,$$$,5\mathrm{.}50,,,],[,,99,$$$,10\mathrm{.}00],[40,$$$,5\mathrm{.}60,,,],[,,60,$$$,11\mathrm{.}00],[50,$$$\mathrm{.}6\mathrm{.}00,,,],[,,75,$$$,11\mathrm{.}50]]$