Question

In: Accounting

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 to two decimal places.

b. Assuming that a physical count of the inventory determined that the actual ending inventory at retail prices at the end of September was $42,000, estimate the loss due to shrinkage and theft.

Solutions

Expert Solution

a.

ending inventory using the retail inventory method
Particulars cost(Amt. in $) retail(Amt. in $) workings
beginning inventory 32000 48500
Add purchases 59500 112600
Add Purchase return -2500 -3500
Add freight on purchase 3600
Add markups 10500
Add markup cancellation -1500
Less: Markdown(net) -6500 (9300-2800)
Less: Sales (net) -116000 (118500-2500)
ending invenory at retail 92600 44100

Therefore ending inventory is $44,100

b.

Actual ending inventory at retails price at the end of september $42,000
Estimated ending inventory ( from above) $44,100
Loss due to shrinkage & theft $2,100 (44100-42000)

therefore loss due to shrinkage & theft is $2,100


Related Solutions

The records of Ayayai Menswear report the following data for the month of September: Sales $117,500...
The records of Ayayai Menswear report the following data for the month of September: Sales $117,500 Purchases (at cost) $59,000 Sales returns 2,600 Purchases (at sales price) 112,000 Additional markups 10,600 Purchase returns (at cost) 2,600 Markup cancellations 1,600 Purchase returns (at sales price) 3,400 Markdowns 9,300 Beginning inventory (at cost) 33,000 Markdown cancellations 2,800 Beginning inventory (at sales price) 48,000 Freight on purchases 3,600 Estimate the ending inventory using the retail inventory method. (Round intermediate calculations to 2 decimal...
Exercise 8-26 The records of Ayai Menswear report the following data for the month of September:...
Exercise 8-26 The records of Ayai Menswear report the following data for the month of September: Sales $117,500 Purchases (at cost) $59,000 Sales returns 2,600 Purchases (at sales price) 112,000 Additional markups 10,600 Purchase returns (at cost) 2,600 Markup cancellations 1,600 Purchase returns (at sales price) 3,400 Markdowns 9,300 Beginning inventory (at cost) 33,000 Markdown cancellations 2,800 Beginning inventory (at sales price) 48,000 Freight on purchases 3,600 Estimate the ending inventory using the retail inventory method. (Round intermediate calculations to...
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...
Hess Company's inventory records show the following data for the month of September:                             &
Hess Company's inventory records show the following data for the month of September:                                                                                       Units                          Unit Cost Inventory, September 1                     100                            $3.00 Purchases: September 8                   450                              3.50                    September 18                    300                              3.70 A physical inventory on September 30 shows 150 units on hand. a. Calculate the value of ending inventory and cost of goods sold if the company uses FIFO inventory costing and a periodic inventory system. b. Calculate the value of ending inventory and cost of goods sold if...
The records of Sweet’s Boutique report the following data for the month of April. Sales revenue...
The records of Sweet’s Boutique report the following data for the month of April. Sales revenue $97,100 Purchases (at cost) $47,800 Sales returns 2,100 Purchases (at sales price) 86,100 Markups 10,400 Purchase returns (at cost) 2,100 Markup cancellations 1,500 Purchase returns (at sales price) 3,100 Markdowns 10,200 Beginning inventory (at cost) 24,251 Markdown cancellations 2,900 Beginning inventory (at sales price) 44,800 Freight on purchases 2,500 Compute the ending inventory by the conventional retail inventory method. (Round ratios for computational purposes...
The records of Kingbird’s Boutique report the following data for the month of April. Sales revenue...
The records of Kingbird’s Boutique report the following data for the month of April. Sales revenue $95,600 Purchases (at cost) $47,200 Sales returns 1,800 Purchases (at sales price) 85,800 Markups 9,500 Purchase returns (at cost) 1,800 Markup cancellations 1,400 Purchase returns (at sales price) 2,800 Markdowns 8,600 Beginning inventory (at cost) 36,103 Markdown cancellations 2,700 Beginning inventory (at sales price) 50,600 Freight on purchases 2,100 Compute the ending inventory by the conventional retail inventory method. (Round ratios for computational purposes...
The records of Teal’s Boutique report the following data for the month of April. Sales revenue...
The records of Teal’s Boutique report the following data for the month of April. Sales revenue $108,600 Purchases (at cost) $49,700 Sales returns 1,900 Purchases (at sales price) 92,100 Markups 9,200 Purchase returns (at cost) 1,900 Markup cancellations 1,300 Purchase returns (at sales price) 2,800 Markdowns 8,300 Beginning inventory (at cost) 35,220 Markdown cancellations 2,600 Beginning inventory (at sales price) 45,000 Freight on purchases 2,300 Compute the ending inventory by the conventional retail inventory method. (Round ratios for computational purposes...
The records of Ellen's Boutique report the following data for the month of April. Sales Revenue...
The records of Ellen's Boutique report the following data for the month of April. Sales Revenue 95600 Sales Returns 1800 Markups 9500 Markup Cancellations 1400 Markdowns 8600 Markdown Cancellations 2700 Freight on purchases 2100 Purchases (@ Cost) 47200 Purchases (@ sales price) 85800 Purchase Returns (@ cost) 1800 Purchase Returns (@ sales) 2800 Beg Inventory @ cost 36103 Beg. Inventory @ sales 50600 Compute the ending inventory by the conventional retail inventory method
The records of Headland’s Boutique report the following data for the month of April. Sales revenue...
The records of Headland’s Boutique report the following data for the month of April. Sales revenue $100,000 Purchases (at cost) $44,600 Sales returns 2,000 Purchases (at sales price) 87,600 Markups 10,900 Purchase returns (at cost) 2,000 Markup cancellations 1,500 Purchase returns (at sales price) 2,900 Markdowns 8,500 Beginning inventory (at cost) 29,200 Markdown cancellations 2,700 Beginning inventory (at sales price) 48,400 Freight on purchases 2,300 Compute the ending inventory by the conventional retail inventory method. (Round ratios for computational purposes...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT