Question

In: Accounting

Westor Company lost all of its inventory in a fire on December 28, 2021. The accounting...

Westor Company lost all of its inventory in a fire on December 28, 2021. The accounting records showed the following gross profit data for November and December:
November December (to Dec. 28)
Sales $674,000 $965,390
Sales Returns and Allowances 14,000 26,600
Purchases 441,190 621,660
Purchase returns and allowances 17,550 22,575
Freight in 6,860 12,300
Beginning inventory 34,050 39,405
Ending inventory 39,405 ?

Westor is fully insured for fire losses but must prepare a report for the insurance company.
Your answer is correct.

Calculate gross profit for the month of November.

Gross profit $

SHOW SOLUTION

LINK TO TEXT

Your answer is incorrect. Try again.

Calculate the gross profit margin percentage for November. (Round gross profit margin to 1 decimal place, e.g. 52.7%.)

Gross profit margin $
Your answer is incorrect. Try again.

Determine the amount of inventory lost by Westor Company as a result of the fire using the gross profit method. (Round gross profit margin to 1 decimal place, e.g. 52.7% and final answer to 0 decimal places, e.g. 5,275.)

Inventory lost by Westor $

Solutions

Expert Solution

November
Sales $674,000
Less: Sales returns and allowances ($14,000)
Net Sales $660,000
Beginning Inventory $34,050
Add: Net purchases ($441,190 - $17,550) $423,640
Add: Freight-in $6,860
Total goods available for sale $464,550
Less: Ending inventory ($39,405)
Cost of goods sold $425,145
Net sales $660,000
Less: Cost of goods sold ($425,145)
Gross Profit $234,855
Therefore, gross profit for November is $234,855.
Gross Progit Margin ($234,855/$660,000*100) 35.6%
December
Sales $965,390
Less: Sales returns and allowances ($26,600)
Net Sales $938,790
Gross Profit in December ($938,790*35.6%) $334,060
Net Sales $938,790
Less: Gross profit ($334,060)
Cost of goods sold in December $604,730
Beginning Inventory $39,405
Add: Net purchases ($621,660 - $22,575) $599,085
Add: Freight-in $12,300
Total goods available for sale $650,790
Less: Cost of goods sold ($604,730)
Ending inventory in December $46,060

Therefore, inventory lost by Westor is $46,060.


Related Solutions

Crane Company lost all of its inventory in a fire on December 28, 2021. The accounting...
Crane Company lost all of its inventory in a fire on December 28, 2021. The accounting records showed the following gross profit data for November and December: November December (to Dec. 28) Sales $674,000 $964,000 Sales Returns and Allowances 16,000 24,000 Purchases 439,000 621,000 Purchase returns and allowances 18,000 21,000 Freight in 7,200 13,000 Beginning inventory 35,000 39,400 Ending inventory 39,400 ? Crane is fully insured for fire losses but must prepare a report for the insurance company. New attempt...
Problem 6-10A a-b Sheridan Company lost all of its inventory in a fire on December 26,...
Problem 6-10A a-b Sheridan Company lost all of its inventory in a fire on December 26, 2020. The accounting records showed the following gross profit data for November and December. November December (to 12/26) Net sales $601,500 $710,000 Beginning inventory 30,000 38,000 Purchases 382,000 421,000 Purchase returns and allowances 13,000 14,900 Purchase discounts 8,500 9,500 Freight-in 8,400 10,800 Ending inventory 38,000 ? Sheridan is fully insured for fire losses but must prepare a report for the insurance company. Compute the...
A company lost all but $50 of its inventory in a fire on Feb. 22, 2017....
A company lost all but $50 of its inventory in a fire on Feb. 22, 2017. The company’s financial records are listed below: 2015                       2016                    Net Sales                     10,000                      12,300                    COGS                           6,500                        7,995                           Gross Profit                  3,500                        4,305                           Operating Exp.             2,000                        2,500                           Net Income                   1,500                        1,805                                  For 2017 the company’s records showed beginning inventory of $350, purchases of $500 and purchase returns of $90.           Net sales for the first part of the year totaled $1,000.            Determine the amount of inventory destroyed in the fire. (You must first calculate the company’s...
Larkspur Company lost most of its inventory in a fire in December just before the year-end...
Larkspur Company lost most of its inventory in a fire in December just before the year-end physical inventory was taken. Corporate records disclose the following. Inventory (beginning) $ 80,000 Sales revenue $410,800 Purchases 295,700 Sales returns 21,200 Purchase returns 28,300 Gross profit % based on net selling price 38 % Merchandise with a selling price of $30,600 remained undamaged after the fire, and damaged merchandise has a net realizable value of $8,300. The company does not carry fire insurance on...
Taki Company lost most of its inventory in a fire in December just before the year-end...
Taki Company lost most of its inventory in a fire in December just before the year-end physical inventory was taken. Corporate records disclose the following. Inventory (beginning) $ 80,700 Sales revenue $408,300 Purchases 291,500 Sales returns 20,900 Purchase returns 28,000 Gross profit % based on net selling price 35 % Merchandise with a selling price of $30,500 remained undamaged after the fire, and damaged merchandise has a net realizable value of $7,700. The company does not carry fire insurance on...
Forester Company has five products in its inventory. Information about the December 31, 2021, inventory follows....
Forester Company has five products in its inventory. Information about the December 31, 2021, inventory follows. Product Quantity Unit Cost Unit Replacement Cost Unit Selling Price A 500 $ 18 $ 20 $ 24 B 800 23 19 26 C 700 11 10 16 D 800 15 12 14 E 700 22 20 21 The cost to sell for each product consists of a 10 percent sales commission. The normal profit for each product is 40 percent of the selling...
Decker Company has five products in its inventory. Information about the December 31, 2021, inventory follows....
Decker Company has five products in its inventory. Information about the December 31, 2021, inventory follows. Product Quantity Unit Cost Unit Selling Price A 1,300 $ 26 $ 32 B 1,100 31 34 C 1,000 4 8 D 600 7 6 E 1,000 30 29 The cost to sell for each product consists of a 10 percent sales commission. Required: 1. Determine the carrying value of inventory at December 31, 2021, assuming the lower of cost or net realizable value...
Decker Company has five products in its inventory. Information about the December 31, 2021, inventory follows....
Decker Company has five products in its inventory. Information about the December 31, 2021, inventory follows. Product Quantity Unit Cost Unit Selling Price A 1,300 $ 16 $ 22 B 1,100 21 24 C 900 3 8 D 500 7 6 E 900 20 19 The cost to sell for each product consists of a 10 percent sales commission. Required: 1. Determine the carrying value of inventory at December 31, 2021, assuming the lower of cost or net realizable value...
Decker Company has five products in its inventory. Information about the December 31, 2021, inventory follows....
Decker Company has five products in its inventory. Information about the December 31, 2021, inventory follows. Product Quantity Unit Cost Unit Selling Price A 1,450 $ 19 $ 24 B 1,300 23 28 C 1,100 4 10 D 700 9 8 E 1,100 24 22 The cost to sell for each product consists of a 15 percent sales commission. Required: 1. Determine the carrying value of inventory at December 31, 2021, assuming the lower of cost or net realizable value...
Forester Company has five products in its inventory. Information about the December 31, 2021, inventory follows....
Forester Company has five products in its inventory. Information about the December 31, 2021, inventory follows. Product Quantity Unit Cost Unit Replacement Cost Unit Selling Price A 900 $ 25 $ 27 $ 31 B 900 30 26 33 C 500 18 17 23 D 700 22 19 21 E 500 29 27 28 The cost to sell for each product consists of a 10 percent sales commission. The normal profit for each product is 35 percent of the selling...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT