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....
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...
Olaf Corp. uses a perpetual inventory system. The company had the following inventory transactions in April:...
Olaf Corp. uses a perpetual inventory system. The company had the following inventory transactions in April: April 3 Purchased merchandise from Flounder Ltd. for $30,700, terms 1/10, n/30, FOB shipping point. 6 The appropriate company paid freight costs of $660 on the merchandise purchased on April 3. 7 Purchased supplies on account for $5,490. 8 Returned damaged merchandise to Flounder and was given a purchase allowance of $3,700. The merchandise was repaired by Flounder and returned to inventory for future...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT