Question

In: Accounting

Gross profit method of estimating inventory. Leia completed a physical inventory on 12-31-18. On the basis...

Gross profit method of estimating inventory.

  1. 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 to estimate what her ending inventory should be based on historical facts and trends. Prepare the entry, if necessary, to reflect Leia’s estimated loss from any missing inventory.

  1. Evan completed a physical inventory on 12-31-18. On the basis of his count, Evan determined his ending inventory at retail selling prices was $306,000. In recent years, Evan's gross profit equaled 80% of Evan’s inventory costs.

Additional information from Evan Additional information from Leia’s accounting records identified the following:

Inventory cost, 12-31-17                                                                                                     $230,000

Net purchases during 2018                                                                                              $1,008,000

Net sales revenue during 2018                                                                                       $1,863,000

Evan suspects some inventory is missing. Evan used the gross profit method to estimate what his ending inventory should be based on historical facts and trends. Prepare the entry, if necessary, to reflect Evan’s estimated loss from any missing inventory.

Solutions

Expert Solution

Answer :

(a).

Sales $3,066,000 -
Less : Sales returns $160,000 -
Net sales $2,906,000 a
Gross profit % 64% -
Gross profit on sales $1,859,840 b
Cost of goods sold $1,046,160 a-b
Inventory 12.31.17 - $320,000
Purchases $1,208,000 -
Purchases returns -$44,000 -
Purchase discount $-9,664 -
Net purchase during 2018 - $1,154,336
Cost of goods available for sale - $1,474,336
Cost of goods sold - $1,046,160
Closing inventory - $428,176
Actual ending inventory - $416,750
Estimated loss - $11,426

Journal Entries

Date Account Title and explanations Debit Credit
Cost of goods sold $11,426 -
Inventory - $11,426
(To Record loss of inventory) - -

Note : If loss on inventory is accounted separately entry will be debited to loss on inventory.

(b).

Net sales $1,863,000 a
Gross profit % on sales 44.44% -
Gross profit on sales $$828,000 b
Cost of goods sold $1,035,000 a-b

80% profit on inventory cost is equal 44.44% profit on sales = 80%/180%

Ending inventory at retail SP $306,000 -
Gross profit % on sales 44.44% -
Gross profit on sales $136,000 50% of $306,000
Ending inventory at cost $170,000 -
Invnetory 13-31-17 $230,000
Net purchase during 2018 $1,008,000
Cost of goods available for sale $1,238,000
Cost of goods sold $1,035,000
Closing inventory $203,000
Actual ending inventory at cost $170,000
Estimated loss $33,000

Journal Entries

Date Account Titles and Explanations Debit Credit
Cost of goods sold $33,000 -
Inventory - $33,000
(To Record loss of invnetory) - -

Note : If loss on inventory is accounted separately entry will be debited to loss on inventory.


Related Solutions

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%,...
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...
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
Armstrong Inc. did a physical inventory count and accidentally overstated ending inventory on the 12/31/18 financial...
Armstrong Inc. did a physical inventory count and accidentally overstated ending inventory on the 12/31/18 financial statement by $20,000. The company noticed the error during 2020, before books were closed. The 2020 inventory was not affected since physical inventory was adequately counted. How would Armstrong Inc correct this error in 2020, assume a 21% tax rate. Credit Retained Earnings by $15,800. No adjustment necessary since it fixed itself. Debit Retained Earnings by $15,800. Credit Inventory by $20,000 On January 1,...
E9-14 (L04) (Gross Profit Method) Mark Price Company uses the gross profit method to estimate inventory...
E9-14 (L04) (Gross Profit Method) Mark Price Company uses the gross profit method to estimate inventory for monthly reporting purposes. Presented below is information for the month of May. Inventory, May 1 $ 160,000 Purchases (gross) 640,000 Freight-in 30,000 Sales revenue 1,000,000 Sales returns 70,000 Purchase discounts 12,000 Instructions (a) Compute the estimated inventory at May 31, assuming that the gross profit is 30% of sales. (b) Compute the estimated inventory at May 31, assuming that the gross profit is...
3: Gross profit method. On December 31, 2017 Alex Company's inventory burned. Sales and purchases for...
3: Gross profit method. On December 31, 2017 Alex Company's inventory burned. Sales and purchases for the year had been $1,400,000 and $980,000, respectively. The beginning inventory (Jan. 1, 2017) was $170,000; in the past Felt's gross profit has averaged 40% of selling price. Instructions: Compute the estimated cost of inventory burned, and give entries as of December 31, 2017 to close merchandise accounts.
Lewis Company adopted the dollar-value LIFO method of inventory valuation on 12/31/18. Its inventory at that...
Lewis Company adopted the dollar-value LIFO method of inventory valuation on 12/31/18. Its inventory at that date was $320,000 and the relevant price index was 100. What will Lewis report as inventory at the end of 2019, 2020, 2021, and 2022 using dollar-value LIFO? Date Inv at current price current price index inv at base level price 12/31/19 338,000 104 325,000 12/31/20 371,000 106 350,000 12/31/21 372,600 108 345,000 12/31/22 381,500 109 350,000
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT