Question

In: Accounting

A substantial portion of inventory owned by Prentiss Sporting Goods was recently destroyed when the roof...

A substantial portion of inventory owned by Prentiss Sporting Goods was recently destroyed when the roof collapsed during a rainstorm. Prentiss also lost some of its accounting records. Prentiss must estimate the loss from the storm for insurance reporting and financial statement purposes. Prentiss uses the periodic inventory system. The following accounting information was recovered from the damaged records:

Beginning inventory $ 202,500
Purchases to date of storm 403,200
Sales to date of storm 600,100


The value of undamaged inventory counted was $121,423. Historically, Prentiss’s gross margin percentage has been approximately 23 percent of sales.

Required
Estimate the following:

a. Gross margin in dollars.
  



b. Cost of goods sold in dollars.
  



c. Ending inventory.
  



d. Amount of lost inventory.
  

Solutions

Expert Solution

A) Gross margin

Gross Margin = (Total Revenue – Cost of Goods Sold)/Total Revenue).

here, percentage of gross margin is 23 % on sales

= $600,100×23%

=$600,100×23/100

Gross margin is = $138,023 dollars

B) Cost of goods sold

  1. Add the cost of beginning inventory to the cost of purchases during the period. This is the cost of goods available for sale.
  2. Multiply the gross profit percentage by sales to find the estimated cost of goods sold.
  3. Subtract the cost of goods available for sold from the cost of goods sold to get the ending inventory.

Starting inventory + purchases - ending inventory = cost of goods sold

The valueof undamaged inventory treated as ending inventory= $121,423

COGS=$202,500+$403,200-$121,423.

COGS= $484,277

C) Ending inventory

Formula= Beginning Inventory + Net Purchases - Cost of Goods Sold (or COGS) = Ending Inventory.

= $202,500+$403,200-$484,277

Ending inventory=$121,423.

D) Amount of lost of inventory

=


Related Solutions

A substantial portion of inventory owned by Prentiss Sporting Goods was recently destroyed when the roof...
A substantial portion of inventory owned by Prentiss Sporting Goods was recently destroyed when the roof collapsed during a rainstorm. Prentiss also lost some of its accounting records. Prentiss must estimate the loss from the storm for insurance reporting and financial statement purposes. Prentiss uses the periodic inventory system. The following accounting information was recovered from the damaged records: Beginning inventory $ 203,200 Purchases to date of storm 404,800 Sales to date of storm 599,200 The value of undamaged inventory...
A fire recently destroyed a substantial portion of Culver Company’s production capacity. It will be many...
A fire recently destroyed a substantial portion of Culver Company’s production capacity. It will be many months before capacity can be restored. During this period, demand for the firm’s products will exceed the company’s ability to produce them. Per-unit data on the firm’s three major products is summarized as follows: Product A B C Selling price $74 $90 $63 Variable costs 32 25 19 Fixed costs 15 19 9 Operating profit $27 $46 $35 Fixed costs have been allocated to...
Milt’s building, which houses his retail sporting goods store, is destroyed by a flood. Sandra’s warehouse,...
Milt’s building, which houses his retail sporting goods store, is destroyed by a flood. Sandra’s warehouse, which she is leasing to Milt to store the inventory of his business, also is destroyed in the same flood. Both Milt and Sandra receive insurance proceeds that result in a realized gain and they both intend to purchase replacement property within the required time period. a. What type of replacement property must Milt find and why? b. What type of replacement property must...
You are the manager of a local sporting goods store and recently purchased a shipment of...
You are the manager of a local sporting goods store and recently purchased a shipment of 60 sets of skis and ski bindings at a total cost of $25,000 (your wholesale supplier would not let you purchase the skis and bindings separately, nor would it let you purchase fewer than 60 sets). The community in which your store is located consists of many different types of skiers, ranging from advanced to beginners. From experience, you know that different skiers value...
You are the manager of a local sporting goods store and recently purchased a shipment of...
You are the manager of a local sporting goods store and recently purchased a shipment of 60 sets of skis and ski bindings at a total cost of $25,000 (your wholesale supplier would not let you purchase the skis and bindings separately, nor would it let you purchase fewer than 60 sets). The community in which your store is located consists of many different types of skiers, ranging from advanced to beginners. From experience, you know that different skiers value...
Leslie Sporting Goods is a locally owned store that specializes in printing team jerseys. The majority...
Leslie Sporting Goods is a locally owned store that specializes in printing team jerseys. The majority of its business comes from orders for various local teams and organizations. While Leslie’s prints everything from bowling team jerseys to fraternity/sorority apparel to special event shirts, summer league baseball and softball team jerseys are the company’s biggest source of revenue. A portion of Leslie’s operating information for the company’s last year follows: Month Number of Jerseys Printed Operating Cost January 150 $4,880 February...
Leslie Sporting Goods is a locally owned store that specializes in printing team jerseys. The majority...
Leslie Sporting Goods is a locally owned store that specializes in printing team jerseys. The majority of its business comes from orders for various local teams and organizations. While Leslie’s prints everything from bowling team jerseys to fraternity/sorority apparel to special event shirts, summer league baseball and softball team jerseys are the company’s biggest source of revenue. A portion of Leslie’s operating information for the company’s last year follows: Number of Operating Month Jerseys Printed Cost January 170 $5,790 February...
Leslie Sporting Goods is a locally owned store that specializes in printing team jerseys. The majority...
Leslie Sporting Goods is a locally owned store that specializes in printing team jerseys. The majority of its business comes from orders for various local teams and organizations. While Leslie’s prints everything from bowling team jerseys to fraternity/sorority apparel to special event shirts, summer league baseball and softball team jerseys are the company’s biggest source of revenue. A portion of Leslie’s operating information for the company’s last year follows: Number of Operating Month Jerseys Printed Cost January 200 $5,785 February...
Leslie Sporting Goods is a locally owned store that specializes in printing team jerseys. The majority...
Leslie Sporting Goods is a locally owned store that specializes in printing team jerseys. The majority of its business comes from orders for various local teams and organizations. While Leslie’s prints everything from bowling team jerseys to fraternity/sorority apparel to special event shirts, summer league baseball and softball team jerseys are the company’s biggest source of revenue. A portion of Leslie’s operating information for the company’s last year follows: Month Number of Jerseys Printed Operating Cost January 215 $5,830 February...
COGS and Inventory Valuation Kane Sporting Goods Company uses the periodic inventory system, and the following...
COGS and Inventory Valuation Kane Sporting Goods Company uses the periodic inventory system, and the following information about the Company’s football inventory is available: Date Transaction Units Cost per Unit Total Cost 1/1 Beginning Inventory 1,000 $12.00 $12,000 4/22 Purchase 4,000 $14.00 $56,000 8/25 Purchase 5,000 $16.40 $82,000 10,000 $150,000 During the year, 7,200 footballs were sold at $30 each. Compute the following (PLEASE SHOW YOUR WORK!): A. Dollar value of ending inventory using First-in, first-out (FIFO B. Cost of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT