Designer Furniture Began June with Merchandise Inventory of 45 Sofas

Designer Furniture began June with merchandise inventory of 45 sofas that cost a total of $31,500. During the month, Designer Furniture purchased and sold merchandise on account as follows:
$\begin{array}{|c|l|l|}\hline \text { June } 7 & \text { Purchase } & \text { 25 sofas @ } \$ 750 \text { each } \\\hline 14 & \text { Sale } & 30 \text { sofas } @ \$ 1,150 \text { each } \\\hline 18 & \text { Purchase } & \text { 50 sofas } @ \$ 775 \text { each } \\\hline 27 & \text { Sale } & 35 \text { sofas } @ \$ 1,200 \text { each } \\\hline\end{array}$ Prepare a perpetual inventory record, using the LIFO inventory costing method, and determine the company's cost of goods sold, ending merchandise inventory, and gross profit.
| Purchases | Cost of Goods Sold | Inventory on Hand |