In: Accounting
Retail Inventory Method
Harmes Company is a clothing store that uses the retail inventory method. The following information relates to its operations during 2016:
| Cost | Retail | |
|---|---|---|
| Inventory, January 1 | $29,000 | $40,200 |
| Purchases | 67,500 | 100,100 |
| Markups (net) | — | 2,200 |
| Markdowns (net) | — | 700 |
| Sales | — | 88,400 |
Required:
1. Compute the ending inventory by the retail inventory method for the following cost flow assumption: FIFO. Round the cost-to-retail ratio to three decimal places. If necessary, round dollar amounts to the nearest whole dollar.
| HARMES COMPANY | ||
| Calculation of ending inventory by retail inventory method | ||
| FIFO 2016 | ||
| Cost | Retail | |
| $ | $ | |
| $ | $ | |
| $ | $ | |
| $ | ||
| $ | ||
2. Compute the ending inventory by the retail inventory method for the following cost flow assumption: Average cost. Round the cost-to-retail ratio to three decimal places. If necessary, round dollar amounts to the nearest whole dollar.
| HARMES COMPANY | ||
| Calculation of ending inventory by retail inventory method | ||
| Average Cost 2016 | ||
| Cost | Retail | |
| $ | $ | |
| $ | $ | |
| $ | ||
| $ | ||
3. Compute the ending inventory by the retail inventory method for the following cost flow assumption: LIFO. Round the cost-to-retail ratio to three decimal places. If necessary, round dollar amounts to the nearest whole dollar.
| HARMES COMPANY | ||
| Calculation of ending inventory by retail inventory method | ||
| LIFO 2016 | ||
| Cost | Retail | |
| $ | $ | |
| $ | ||
| $ | $ | |
| $ | ||
| Ending inventory at LIFO cost | ||
| Beginning layer (as stated in data) | $29,000 | |
| New layer | ||
| Total | $ | |
4. Compute the ending inventory by the retail inventory method for the following cost flow assumption: Lower of cost or market (based on average cost). Round the cost-to-retail ratio to three decimal places. If necessary, round dollar amounts to the nearest whole dollar.
| HARMES COMPANY | ||
| Calculation of ending inventory by retail inventory method | ||
| Lower of Cost or Market (based on average cost) 2016 | ||
| Cost | Retail | |
| $ | $ | |
| $ | $ | |
| $ | ||
| $ | ||
| Calculation of ending inventory of Harmes Company | ||||||||
| Particulars | Cost $ | Retail value $ | Cost to Retail % | Retail | FIFO | Average costs | LIFO | Lower of avg cost or market |
| Given | Given | Cost / Retail | Purchases % | COGS % |
Opening stock % |
|||
| Beginning inventory | 29,000 | 40,200 | 72% | 29,000 | 29,000 | 29,000 | 29,000 | 29,000 |
| Purchases | 67,500 | 100,100 | 67% | 67,500 | 67,500 | 67,500 | 67,500 | 67,500 |
| Less : Return to vendors | - | - | - | - | - | - | - | |
| Goods available for sale | 96,500 | 140,300 | 69% | 96,500 | 96,500 | 96,500 | 96,500 | 96,500 |
| Add : Mark ups | - | 2,200 | - | - | - | - | - | |
| Less: Mark downs | - | 700 | - | - | - | - | - | |
| 96,500 | 141,000 | 68% | 96,500 | 96,500 | 96,500 | 96,500 | 96,500 | |
| Less : Sales net of returns | 88,400 | 60,501 | 60,501 | 60,803 | 63,771 | 60,803 | ||
| ($88400*68%) | ($88400*67%) | ($88400*69%) | ($88400*72%) | Lower of $ 60803 and $ 60501 | ||||
| Ending inventory | 35,999 | 35,999 | 35,697 | 32,729 | 35,697 | |||