A company uses the periodic inventory system, and the following information is available. All purchases and

sales are on credit. The selling price for the merchandise is $$11$ per unit.

Units Unit Cost Total Cost

$6/01$ Inventory Balance $30,$$$30$

$\frac{6}{06}$ Purchase $70,4,280$

$\frac{6}{11}$ Purchase $45,5,225$

$6/16$ Purchase ${50}_{,}6,{300}_{?}$

Goods available $,{195}_{\text{\$}}$$${95}_{?}$

$6/12$ Sale $100$

$6/20$ Sale ${60}_{?}$

Goods sold $,{160}_{?}$

$6/31$ Inventory Balance ${35}_{?}$

Required:

Determine the cost of the ending inventory and the cost of goods sold for June using the LIFO method. Please show work on an excel spreadsheet