In: Accounting
The records of Lohse Stores included the following data: Inventory, May 1, at retail, $14,500; at cost, $10,440 Purchases during May, at retail, $42,900; at cost, $31,550 Freight-in, $2,000; purchase discounts, $250 Additional markups, $3,800; markup cancellations, $400; net markdowns, $1,300 Sales during May, $45,500 Calculate the estimated inventory at May 31 on a LIFO basis. Estimated inventory
| Computation of the estimated inventory at May 31 on a LIFO basis | ||
| Cost ($) | ||
| Inventory, May 1 | 10,440.00 | 14,500.00 |
| Purchases | 31,550.00 | 42,900.00 |
| Freight - in | 2,000.00 | - |
| Purchase discounts | (250.00) | - |
| Add: Net markups (3,800-400) | - | 3,400.00 |
| Less: Net markdowns: | - | (1,300.00) |
| Totals excluding beginning inventory | 33,300.00 | 45,000.00 |
| Goods available | 43,740.00 | 59,500.00 |
| Less: sales | (45,500.00) | |
| Ending inventory, at retail | 14,000.00 | |
| Cost-to-retail ratio = 10,440,500/14 = 72% | ||
| Ending inventory at cost = 14,000 * 72% = $10,080 | ||