Modern Lifestyle Furniture Began June with Merchandise Inventory of 45

Modern Lifestyle Furniture began June with merchandise inventory of 45 sofas that cost a total of $31,500. During the month, Modern purchased and sold merchandise on account as follows:
$\begin{array}{|r|l|l|}\hline\text { June 7} & \text { Purchase } & 25 \text { 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 FIFO 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 |