Question

In: Accounting

Problem 6-15B Retail inventory method LO6 CHECK FIGURE: 2. Loss at cost = $2,040.27 The records...

Problem 6-15B Retail inventory method LO6
CHECK FIGURE: 2. Loss at cost = $2,040.27
The records of The Wilke Co. provided the following information for the year ended December 31, 2020:

At Cost At Retail
January 1 beginning inventory ......................... $ 40,835 $ 57,305
Purchases ............................................................... 251,945 383,530
Purchase returns .................................................. 5,370 7,665
Sales ........................................................................ 393,060
Sales returns ......................................................... 2,240

Required
1. Prepare an estimate of the company’s year-end inventory by the retail method. Round all calculations to
two decimal places.
2. Under the assumption the company took a year-end physical inventory at marked selling prices that totalled
$39,275, prepare a schedule showing the store’s loss from theft or other causes at cost and at retail.

Solutions

Expert Solution

Answer to Part 1: Computing estimated year ending inventory by retail method

Particulars Amount
Beginning Inventory $ 57,305
Add: Purchases $ 383,530
Less: Purchase return ($7,665)
Cost of goods available for sale $433,170
Less: Sales ($393,060)
Add: Sales return $2,240
Estimated year end inventory by retail method $42,350

Answer to Part 2: Schedule showing the store’s loss from theft or other causes by cost and by retail method

Step 1: Determining cost of goods available for sale both at cost level and retail level

Particulars At Cost At Retail
Beginning Inventory $ 40,835 $ 57,305
Add: Purchases $251,945 $ 383,530
Less: Purchases return ($5,370) ($7,665)
Cost of goods available for sale $287,410 $ 433,170

Step 2: Calculating Cost to Retail Ratio:

On basis of Cost of goods availabe for sale the cost to retail ratio can be computed as  

This comes out to be 0.6635 or 66.35%

Step 3: Calculating estimated inventory at cost and retail method

Particulars Amount
(A) Estimated Inventory at year end by retail method (as per part 1) $42,350
(B) Cost to Retail Ratio (as per step 2) 66.35%
(C) =
(A) x (B)
Estimated inventory by cost method $28,099

Step 4: Determining actual inventory at cost and retail method

Particulars Amount
(A) Actual Inventory at selling price (i.e. retail method) (given) $ 39,275
(B) Cost to Retail Ratio (as per step 2) 66.35%
(C) =
(A) x (B)
Actual inventory by cost method $26,059

Step 5: Schedule showing store's loss from theft or other causes by cost and retail method

Particulars Cost method Retail method
Estimated inventory $28,099 (as per step 3) $42,350 (part 1)
Less: Actual Inventory $26,059 (as per step 4) $39,275 (Given)
Store's loss from theft or other cause $2,040 $3,075

Related Solutions

Problem 6-4A Report inventory using lower of cost and net realizable value (LO6-6) Skip to question...
Problem 6-4A Report inventory using lower of cost and net realizable value (LO6-6) Skip to question [The following information applies to the questions displayed below.] A local Chevrolet dealership carries the following types of vehicles: Unit Unit Inventory Items Quantity Cost NRV Vans 3 $ 21,000 $ 19,000 Trucks 6 16,800 15,800 2-door sedans 2 11,800 13,800 4-door sedans 7 15,800 18,800 Sports cars 3 31,000 34,000 SUVs 5 27,600 22,000 Because of recent increases in gasoline prices, the car...
Retail Inventory Method Beginning Inventory At cost $100,000 At retail $125,000 Net purchases At cost $300,000...
Retail Inventory Method Beginning Inventory At cost $100,000 At retail $125,000 Net purchases At cost $300,000 At retail $360,000 Net markups $15,000 Net markdowns $10,000 Net sales at retail $280,000 Average cost per unit $8.00 Average selling price per unit $10.00 Using the gross profit inventory estimation method: 1. Compute gross profit on sales. 2. Compute cost of goods sold. 3. Compute the estimated cost of ending inventory. Using the conventional (average LCM) inventory estimation method: 1. Compute the ending...
Problem 6-20 CVP Applications: Break-Even Analysis; Cost Structure; Target Sales [LO6-1, LO6-3, LO6-4, LO6-5, LO6-6, LO6-8]...
Problem 6-20 CVP Applications: Break-Even Analysis; Cost Structure; Target Sales [LO6-1, LO6-3, LO6-4, LO6-5, LO6-6, LO6-8] Northwood Company manufactures basketballs. The company has a ball that sells for $25. At present, the ball is manufactured in a small plant that relies heavily on direct labor workers. Thus, variable expenses are high, totaling $15.00 per ball, of which 60% is direct labor cost. Last year, the company sold 36,000 of these balls, with the following results: Sales (36,000 balls) $ 900,000...
Problem 6-20 CVP Applications: Break-Even Analysis; Cost Structure; Target Sales [LO6-1, LO6-3, LO6-4, LO6-5, LO6-6, LO6-8]...
Problem 6-20 CVP Applications: Break-Even Analysis; Cost Structure; Target Sales [LO6-1, LO6-3, LO6-4, LO6-5, LO6-6, LO6-8] Northwood Company manufactures basketballs. The company has a ball that sells for $25. At present, the ball is manufactured in a small plant that relies heavily on direct labor workers. Thus, variable expenses are high, totaling $15.00 per ball, of which 60% is direct labor cost. Last year, the company sold 30,500 of these balls, with the following results: Sales (30,500 balls) $ 775,000...
Retail inventory method; various cost methods Sparrow Company uses the retail inventory method to estimate ending...
Retail inventory method; various cost methods Sparrow Company uses the retail inventory method to estimate ending inventory and cost of goods sold. Data for 2016 are as follows: Cost Retail Beginning Inventory $90,000 $180,000 Purchases $355,000 $581,000 Freight-in $9,000 Purchase Returns $7,000 $11,000 Net Markups $16,000 Net Markdowns $12,000 Normal Spoilage $3,000 Abnormal Spoilage $4,800 $8,000 Sales $540,000 Sales Returns $10,000 The company records sales net of employee discounts. Discounts for 2016 totaled $4,000. Required: Estimate Sparrow’s ending inventory and...
Problem 6-22 CVP Applications; Contribution Margin Ratio; Break-Even Analysis; Cost Structure [LO6-1, LO6-3, LO6-4, LO6-5, LO6-6]...
Problem 6-22 CVP Applications; Contribution Margin Ratio; Break-Even Analysis; Cost Structure [LO6-1, LO6-3, LO6-4, LO6-5, LO6-6] Due to erratic sales of its sole product—a high-capacity battery for laptop computers—PEM, Inc., has been experiencing financial difficulty for some time. The company’s contribution format income statement for the most recent month is given below:    Sales (13,200 units × $20 per unit) $ 264,000 Variable expenses 158,400 Contribution margin 105,600 Fixed expenses 117,600 Net operating loss $ (12,000 ) Required: 1. Compute...
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...
Chapter 6 HOMEWORK Problem 6-20 CVP Applications: Break-Even Analysis; Cost Structure; Target Sales [LO6-1, LO6-3, LO6-4,...
Chapter 6 HOMEWORK Problem 6-20 CVP Applications: Break-Even Analysis; Cost Structure; Target Sales [LO6-1, LO6-3, LO6-4, LO6-5, LO6-6, LO6-8] Northwood Company manufactures basketballs. The company has a ball that sells for $25. At present, the ball is manufactured in a small plant that relies heavily on direct labor workers. Thus, variable expenses are high, totaling $15.00 per ball, of which 60% is direct labor cost. Last year, the company sold 37,500 of these balls, with the following results: Sales (37,500...
Chapter 6 Homework Problem 6A-8 High-Low Method; Predicting Cost [LO6-10] Nova Company’s total overhead cost at...
Chapter 6 Homework Problem 6A-8 High-Low Method; Predicting Cost [LO6-10] Nova Company’s total overhead cost at various levels of activity are presented below: Month Machine- Hours Total Overhead Cost April 46,000 $ 168,260 May 36,000 $ 144,660 June 56,000 $ 191,860 July 66,000 $ 215,460 Assume that the total overhead cost above consists of utilities, supervisory salaries, and maintenance. The breakdown of these costs at the 36,000 machine-hour level of activity is: Utilities (variable) $ 46,800 Supervisory salaries (fixed) 45,000...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT