Question

In: Accounting

Salisbury Company uses the perpetual inventory system and had the following inventory & sales activity for...

Salisbury Company uses the perpetual inventory system and had the following inventory & sales activity for the month of May 2019:

Date

Activity

Quantity

Unit Price

5/1

Beginning Inventory

175

$12.00

5/5

Purchase

200

$10.50

5/10

Sales

300

$25

5/15

Purchase

200

$13.00

5/20

Sales

250

$28

5/25

Purchase

150

$13.50

Using the LIFO method, determine the dollar value for Ending Inventory at the end of month of May. Round to the nearest cent.

Solutions

Expert Solution

LIFO Cost of Goods Available for sale Cost of Goods Sold Ending Balance
Date Activity Units Unit Price Amount Units Unit Price Amount Units Unit Price Amount
May-01 Beginning Inventory 175 $   12.00 $    2,100.00
May-05 Purchase 200 $              10.50 $      2,100.00 175 $   12.00 $    2,100.00
200 $   10.50 $    2,100.00
May-10 Sales 200 $   10.50 $ 2,100.00 75 $   12.00 $       900.00
100 $   12.00 $ 1,200.00
May-15 Purchase 200 $              13.00 $      2,600.00 75 $   12.00 $       900.00
200 $   13.00 $    2,600.00
May-20 Sales 200 $   13.00 $ 2,600.00 25 $   12.00 $       300.00
50 $   12.00 $    600.00
May-15 Purchase 150 $              13.50 $      2,025.00 25 $   12.00 $       300.00
150 $   13.50 $   2,025.00
Total $ 6,500.00 $   2,325.00

Under LIFO method, inventory purchased first is sold first


Related Solutions

Easton Company uses the periodic inventory system and had the following inventory & sales activity for...
Easton Company uses the periodic inventory system and had the following inventory & sales activity for the month of May 2019: Date Activity Quantity Unit Price 5/1 Beginning Inventory 130 $10 5/5 Purchase 210 $12 5/15 Purchase 350 $14 5/25 Purchase 310 $16 Sales were 470 units at $20.  Using the FIFO method, determine the dollar value of Cost of Goods Sold for the month of May.
Alpha Company uses the periodic inventory system and had the following inventory & sales activity for...
Alpha Company uses the periodic inventory system and had the following inventory & sales activity for the month of May 2016: Date Activity Quantity Unit Price 5/1 Beginning Inventory 150 $10 5/5 Purchase 200 $12 5/15 Purchase 300 $14 5/25 Purchase 150 $16 Sales were 525 units at $20.  Using the LIFO method, determine the dollar values following for the month of May: 1. Ending Inventory 2. Cost of Goods Available for Sale 3. Cost of Goods Sold
Emmett Inc. uses a perpetual inventory system and had the following activity for a single inventory...
Emmett Inc. uses a perpetual inventory system and had the following activity for a single inventory item: 1. Calculate the value of COGS, Ending Inventory and Gross profit under FIFO and Moving Average. (round unit cost to two digits) Units     Unit Cost 1-Jan inventory     510      100.00 Purchases 5-Jan 275      110.00 10-Jan 175      114.00 15-Jan 100      116.00 20-Jan 125      118.00 Sales 12-Jan           525      135.00 18-Jan            405      140.00 22-Jan            200      142.00
Tama Inc. uses a perpetual inventory system and had the following activity for a single inventory...
Tama Inc. uses a perpetual inventory system and had the following activity for a single inventory item:    Units    Unit Cost Total Cost        May 1, inventory                 140       $2.50                                $350        Purchases:               May 5                          200       3.50                                    700               May 10                        140       4.50                                    630               May 15                        160       5.50                                    880        Sales:               May 11                        250               May 19                        150 Using the perpetual system, determine the ending inventory and cost of goods sold under weighted-average method (round unit cost...
Chris Company uses the perpetual inventory system and had the following activity during the current monthly...
Chris Company uses the perpetual inventory system and had the following activity during the current monthly period. November 1:             Beginning Inventory of 100 units @$20 November 5:              Purchased 100 units @ $22 November 8:              Purchased 50 units @$23 November 16:            Sold 200 units @ $45 November 19:            Purchased 50 units @ $25 Using the weighted-average inventory method, the company's ending inventory would be reported at: A)   $2,200. B) $2,320. C) $2,250. D) $2,400. E) $2,270. The answer is B but I need a detailed explanation...
3. Easton Company uses the periodic inventory system and had the following inventory & sales activity...
3. Easton Company uses the periodic inventory system and had the following inventory & sales activity for the month of May 2019: Date Activity Quantity Unit Price 5/1 Beginning Inventory 100 $10 5/5 Purchase 240 $12 5/15 Purchase 270 $14 5/25 Purchase 320 $16 Sales were 430 units at $20. Using the FIFO method, determine the dollar value of Cost of Goods Sold for the month of May.
During January, a company that uses a perpetual inventory system had beginning inventory, purchases, and sales...
During January, a company that uses a perpetual inventory system had beginning inventory, purchases, and sales as follows : Units Cost per unit Begin Inventory 100 12 Jan 5 Sale 50 10 Purchase 70 16 15 Sale 25 25 Sale 35 Required: Prepare a schedule showing cost of goods sold and ending inventory using weighted average. Prepare a schedule showing cost of goods sold and ending inventory using First In First Out. C.           Compute gross profit under for a...
During January, a company that uses a perpetual inventory system had beginning inventory, purchases, and sales...
During January, a company that uses a perpetual inventory system had beginning inventory, purchases, and sales as follows : Units Cost per unit Begin Inventory 100 12 Jan 5 Sale 50 10 Purchase 70 16 15 Sale 25 25 Sale 35 Required: Prepare a schedule showing cost of goods sold and ending inventory using weighted average. Prepare a schedule showing cost of goods sold and ending inventory using First In First Out Compute gross profit under for a and b....
This company uses a perpetual inventory system. It had the following beginning inventory and current year...
This company uses a perpetual inventory system. It had the following beginning inventory and current year purchases of its product. Jan 1. Beginning Inventory ..... 50 units @ $100 = $5,000 Jan 14. Purchase .......................150 units @ $120 = 18,000 Apr 30. Purchase........................ 200 units @ $150= 30,000 Sept 26th. Purchase................... 300 units @ $200= 60,000 The company transacted sales on the following dates at $350 per unit sales price. Jan 10. 30 units (specific cost: 30 @ $100) Feb...
Walstrom Company uses a perpetual inventory system and had the following inventory transactions for June 2019....
Walstrom Company uses a perpetual inventory system and had the following inventory transactions for June 2019. June 1 Beg. Inventory 50 units @ $14 for $700, on June 4 Purchased 115 units @ $15 for $1,725, on June 5 Sold 100 units, on June 10 Purchased 75 units @ $16 for $1,200, and on June 24 Sold 50 units. Total Cost of Goods Sold Available equals $3,625. The June 30th Ending Inventory is 90 units. The June 30th ending inventory...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT