Question

In: Accounting

QS 6-12 Estimating inventories—gross profit method LO6 The inventory of Sixth Avenue Department Store was destroyed...

QS 6-12 Estimating inventories—gross profit method LO6

The inventory of Sixth Avenue Department Store was destroyed by a fire on September 10, 2020. The following 2020 data were found in the accounting records

Jan. 1 inventory ............................................................... $180,000

Jan. 1–Sept. 10 purchases (net) ................................. $342,000

Jan. 1–Sept.10 sales ..................................................... $675,000

2020 estimated gross profit rate ................................ 42%

QS 6-13 Estimating inventories—gross profit method LO6

During the past two months, management of Wallace Lake Computing Supplies was closely watching inven-tory levels due to suspected shrinkage caused by unknown factors. The physical count on July 31, the end of the current month, shows $48,000 of merchandise actually on hand. The accounting records for prior periods indicate that gross profit should be 30% of the $565,000 net sales for July. Inventory at June 30 was actually $65,000 and July purchases were $385,500. Calculate the estimated:

a. Ending inventory

Solutions

Expert Solution

QS 6-12

Beginning inventory = $180,000

Purchases = $342,000

Sales = $675,000

Gross profit = Sales x Gross profit rate

= 675,000 x 42%

= $283,500

Cost of goods sold = Sales - Gross profit

= 675,000-283,500

= $391,500

Cost of goods sold = Beginning inventory + Purchases - Ending inventory

391,500= 180,000+342,000-Ending inventory

Ending inventory = $130,500

Inventory lost by fire = $130,500

QS 6-13

Net sales = $565,000

Gross profit rate = 30%

Beginning inventory = $65,000

Purchases = $385,500

Gross profit = Net sales x Gross profit rate

= 565,000 x 30%

= $169,500

Cost of goods sold = Net sales - Gross profit

= 565,000-169,500

= $395,500

Cost of goods sold = Beginning inventory + Purchases - Ending inventory

395,500 = 65,000+385,500-Ending inventory

Ending inventory = $55,000

Kindly comment if you need further assistance. Thanks‼!            


Related Solutions

Gross profit method of estimating inventory. Leia completed a physical inventory on 12-31-18. On the basis...
Gross profit method of estimating inventory. Leia completed a physical inventory on 12-31-18. On the basis of her count, Leia determined her ending inventory to be $416,750. In recent years, Leia's gross profit equaled 64% of Leia’s selling price. Additional information from Leia’s accounting records identified the following: Inventory, 12-31-17                                                                                                             $320,000 Purchases during 2018                                                                                                     $1,208,000 Purchase returns during 2018                                                                                               $44,000 Purchase discounts during 2018                                                                                            $9,664 Sales during 2018                                                                                                              $3,066,000 Sales returns during 2018                                                                                                   $160,000 Leia suspects some inventory is missing. Leia used the gross profit method...
Describe the gross profit method of estimating ending inventory values. a) Provide an overview of the...
Describe the gross profit method of estimating ending inventory values. a) Provide an overview of the process used to estimate ending inventory. b) List the three assumptions on which the method relies. c) Given a firm that has $1,000,000 in sales; purchases $750,000 of items for resale; has a beginning inventory of $215,000; and a gross profit percentage of 27% calculate ending inventory and cost of goods sold. d) Given a firm has gross profit on selling price of 37%,...
Companies are allowed to use the gross profit estimation method for the inventory on the balance...
Companies are allowed to use the gross profit estimation method for the inventory on the balance sheet filed with the SEC True False Both markups and markdowns are taken into account for the calculation of goods available for sale at retail prices with the cost method. True False Stolen goods cannot be taking into account in the gross profit inventory estimated whereas they can be taken into account in the retail inventory estimation method. True False If replacement cost is...
Retail Method; Gross Profit Method Selected data on inventory, purchases, and sales for Celebrity Tan Co....
Retail Method; Gross Profit Method Selected data on inventory, purchases, and sales for Celebrity Tan Co. and Ranchworks Co. are as follows: Cost Retail Celebrity Tan Co. Inventory, August 1 $216,000 $328,000 Transactions during August Purchases (net) 2,490,000 3,772,000 Sales 3,880,000 Ranchworks Co. Inventory, March 1 $278,000 Transactions during March through November: Purchases (net) 3,698,000 Sales 6,057,000 Estimated gross profit rate 38% Required: 1. Determine the estimated cost of the inventory of Celebrity Tan Co. on August 31 by the...
Retail Method; Gross Profit Method Selected data on merchandise inventory, purchases, and sales for Celebrity Tan...
Retail Method; Gross Profit Method Selected data on merchandise inventory, purchases, and sales for Celebrity Tan and Ranchworks Co. are as follows: Cost Retail Celebrity Tan Merchandise inventory, August 1 $363,000 $472,000 Transactions during August: Purchases (net) 4,180,000 5,428,000 Sales 5,584,000 Ranchworks Co. Merchandise inventory, March 1 $221,000 Transactions during March through November: Purchases (net) 2,943,000 Sales 5,152,000 Estimated gross profit rate 42% Required: 1. Determine the estimated cost of the merchandise inventory of Celebrity Tan on August 28 by...
Royal Gorge Company uses the gross profit method to estimateending inventory and cost of goods...
Royal Gorge Company uses the gross profit method to estimate ending inventory and cost of goods sold when preparing monthly financial statements required by its bank. Inventory on hand at the end of October was $60,100. The following information for the month of November was available from company records:    Purchases$126,000  Freight-in4,600  Sales260,000  Sales returns7,500  Purchases returns6,500In addition, the controller is aware of $7,500 of inventory that was stolen during November from one of the company’s warehouses.1.Calculate the estimated inventory at the end of November, assuming...
Royal Gorge Company uses the gross profit method to estimateending inventory and cost of goods...
Royal Gorge Company uses the gross profit method to estimate ending inventory and cost of goods sold when preparing monthly financial statements required by its bank. Inventory on hand at the end of October was $60,100. The following information for the month of November was available from company records:Purchases$126,000Freight-in4,600Sales260,000Sales returns7,500Purchases returns6,500In addition, the controller is aware of $7,500 of inventory that was stolen during November from one of the company's warehouses.Required:1. Calculate the estimated inventory at the end of November,...
we focus on different methods used to estimate ending inventory – the gross profit method and...
we focus on different methods used to estimate ending inventory – the gross profit method and the retail inventory method. Discuss how each method is used to calculated estimated ending inventory. Under what circumstances is it appropriate to use these methods? Support your response to question #2 with a reference from the ASC (Accounting Standard Codification).
define shrinkage as it applies to a physical inventory count. after using the gross profit method...
define shrinkage as it applies to a physical inventory count. after using the gross profit method to estimate ending inventory, explain how a company determines ending inventory, explain how a company determines if a loss was due to shrinkage. explain in detail
Brandon Shoe Store uses the retail inventory method to estimate its monthly ending inventories. The following...
Brandon Shoe Store uses the retail inventory method to estimate its monthly ending inventories. The following information is available at November 30, 2021: Women’s Shoes Men’s Shoes Cost Retail Cost Retail Beginning inventory $276,000 $424,000 $191,000 $323,000 Purchases 1,181,000 1,801,000 1,046,000 1,772,000 Purchase returns and allowances 24,600 37,000 21,900 36,400 Freight in 6,000 7,200 Sales 1,826,000 1,651,000 Sales returns and allowances 28,000 25,000 At November 30, Brandon Shoe Store takes a physical inventory count at retail. The actual retail values...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT