Question

In: Accounting

The records of Lohse Stores included the following data: Inventory, May 1, at retail, $14,500; at...

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

Solutions

Expert Solution

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

Related Solutions

Retail Inventory Method The records of Sudbury Menswear report the following data for the month of...
Retail Inventory Method The records of Sudbury Menswear report the following data for the month of September: Sales $118,500 Purchase (at cost) $59,500 Sales returns 2,500 Purchase (at retail) 112,600 Additional markups 10,500 Purchase return (at cost) 2,500 Markup cancellations 1,500 Purchase return (at retail) 3,500 Markdowns 9,300 Beginning inventory (at cost) 32,000 Markdown cancellations 2,800 Beginning inventory (at retail) 48,500 Freight on purchase 3,600 Required: a. Estimate the ending inventory using the retail inventory method. Round the cost ratio...
The following data concerning the retail inventory method are taken from the financial records of Blake...
The following data concerning the retail inventory method are taken from the financial records of Blake Company.                                                                                                   Cost                        Retail             Beginning inventory                                           $132,000              $ 220,000             Purchases                                                            362,500                 550,000             Freight-in                                                               16,000                       —             Net markups                                                               —                      45,000             Net markdowns                                                          —                      16,000             Sales                                                                          —                    625,000 a.) What is the ending inventory at retail?                         b.) If the ending inventory is to be valued at approximately the conventional retail inventory method, the calculation of the cost to retail...
The following data concerning the retail inventory method are taken from the financial records of Blake Company.
The following data concerning the retail inventory method are taken from the financial records of Blake Company.                                          Cost                     Retail            Beginning inventory                                           $132,000              $ 220,000            Purchases                                                            362,500                 550,000            Freight-in                                                                16,000                       —            Net markups                                                              —                      45,000            Net markdowns                                                          —                      16,000            Sales                                                                          —                    625,0001. What is the ending inventory at retail?                       2. If the ending inventory is to be valued at approximately theconventional retail inventory method, the calculation of the cost to retail ratio should be based on goods available for sale...
10 The following data are obtained from DK Stores Inc.’s financial records: 2021 Cost Retail Beginning...
10 The following data are obtained from DK Stores Inc.’s financial records: 2021 Cost Retail Beginning Inventory $75,600 $126,000 Purchases 176,000 244,000 Purchases discount 1,130 Net markups 9,500 Net markdowns 10,625 Normal spoilage 1,200 Sales to customers 215,000 Sales to employees (after 40% employee discounts) 9,705 Price index 1.05 Price indices are based on January 1, 2021 which is the base year. Suppose DK uses the average cost retail inventory method to account for its inventory. What is the current...
Tess Company's inventory records show the following data for the month of May: Units Unit Cost...
Tess Company's inventory records show the following data for the month of May: Units Unit Cost Inventory, May 1 200 $2.00 Purchases: May 8 200 3.00 May 15 100 4.00 The company uses a periodic inventory system. A physical inventory on May 30 shows 150 units on hand. Assuming FIFO (First-In-First-Out) inventory costing, calculate the cost of goods sold. a. $1,100 b. $850 c. $700 d. $980
On January 1, 2018, Pet Friendly Stores adopted the retail inventory method. Inventory transactions at both...
On January 1, 2018, Pet Friendly Stores adopted the retail inventory method. Inventory transactions at both cost and retail, and cost indexes for 2018 and 2019 are as follows: 2018 2019 Cost Retail Cost Retail Beginning inventory $ 162,500 $ 250,000 Purchases 800,000 1,084,000 $ 680,000 $ 1,063,000 Purchase returns 7,000 12,150 2,000 4,300 Freight-in 12,500 2,000 Net markups 6,900 11,800 Net markdowns 4,750 8,000 Net sales to customers 950,000 722,000 Sales to employees (net of 25% discount) 22,500 22,500...
On January 1, 2018, Pet Friendly Stores adopted the retail inventory method. Inventory transactions at both...
On January 1, 2018, Pet Friendly Stores adopted the retail inventory method. Inventory transactions at both cost and retail, and cost indexes for 2018 and 2019 are as follows: 2018 2019 Cost Retail Cost Retail Beginning inventory $ 140,000 $ 200,000 Purchases 440,000 594,000 $ 680,000 $ 854,000 Purchase returns 3,500 4,350 3,200 4,550 Freight-in 6,600 5,000 Net markups 5,450 9,800 Net markdowns 4,300 7,000 Net sales to customers 480,000 702,000 Sales to employees (net of 20% discount) 19,200 19,200...
On January 1, 2021, Pet Friendly Stores adopted the retail inventory method. Inventory transactions at both...
On January 1, 2021, Pet Friendly Stores adopted the retail inventory method. Inventory transactions at both cost and retail, and cost indexes for 2021 and 2022 are as follows: 2021 2022 Cost Retail Cost Retail Beginning inventory $ 102,300 $ 165,000 Purchases 484,000 715,000 $ 625,000 $ 974,000 Purchase returns 2,800 1,500 2,500 6,100 Freight-in 5,000 8,000 Net markups 5,500 8,400 Net markdowns 4,000 6,300 Net sales to customers 634,000 660,000 Sales to employees (net of 30% discount) 11,900 11,900...
On January 1, 2021, Pet Friendly Stores adopted the retail inventory method. Inventory transactions at both...
On January 1, 2021, Pet Friendly Stores adopted the retail inventory method. Inventory transactions at both cost and retail, and cost indexes for 2021 and 2022 are as follows: 2021 2022 Cost Retail Cost Retail Beginning inventory $ 102,300 $ 165,000 Purchases 484,000 715,000 $ 625,000 $ 974,000 Purchase returns 2,800 1,500 2,500 6,100 Freight-in 5,000 8,000 Net markups 5,500 8,400 Net markdowns 4,000 6,300 Net sales to customers 634,000 660,000 Sales to employees (net of 30% discount) 11,900 11,900...
On January 1, 2021, Pet Friendly Stores adopted the retail inventory method. Inventory transactions at both...
On January 1, 2021, Pet Friendly Stores adopted the retail inventory method. Inventory transactions at both cost and retail, and cost indexes for 2021 and 2022 are as follows: 2021 2022 Cost Retail Cost Retail Beginning inventory $ 128,000 $ 200,000 Purchases 435,000 585,000 $ 670,000 $ 843,000 Purchase returns 3,200 3,750 2,900 4,125 Freight-in 5,000 6,000 Net markups 5,300 9,200 Net markdowns 4,150 6,700 Net sales to customers 400,000 696,000 Sales to employees (net of 20% discount) 16,800 16,800...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT