Question

Question 5 Swifty Limited uses a perpetual inventory system. The inventory records show the following data for its first mont
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Solution b:

Computation of ending inventory COGS under Average Cost - Perpectual
Date Beginning Inventory Purchase Cost of Goods Sold Ending Inventory
Qty Rate Amount Qty Rate Amount Qty Rate Amount Qty Rate Amount
2-Aug 0 $0.00 $0.00 249 $67.00 $16,683 0 $0.00 $0.00 249 $67.00 $16,683.00
3-Aug 249 $67.00 $16,683 515 $102.00 $52,530 0 $0.00 $0.00 764 $90.59 $69,213.00
10-Aug 764 $90.59 $69,213 0 $0.00 $0 274 $90.59 $24,822.46 490 $90.59 $44,390.54
15-Aug 490 $90.59 $44,391 859 $119.00 $102,221 0 $0.00 $0.00 1349 $108.68 $146,611.54
3-Mar 1349 $108.68 $146,612 0 $0.00 $0 330 $108.68 $35,864.94 1019 $108.68 $110,746.59
Total 604 $60,687.41 1019 $110,746.59
Add a comment
Know the answer?
Add Answer to:
Question 5 Swifty Limited uses a perpetual inventory system. The inventory records show the following data...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Sheffield Limited uses a perpetual inventory system. The inventory records show the following data for its...

    Sheffield Limited uses a perpetual inventory system. The inventory records show the following data for its first month of operations: Date Explanation Balance in Units Units 244 Aug. 2 Purchases Unit Cost $73 102 Total Cost $17,812 50,184 244 Purchases 492 736 443 3 10 15 25 Sales Purchases Sales (293) 936 115 107,640 1,379 (331) 1,048 Calculate the cost of goods sold and ending inventory using the FIFO cost method. Cost of goods sold $ Ending inventory $

  • Inventory Costing Methods-Perpetual Method The Luann Company uses the perpetual inventory system. The following July data...

    Inventory Costing Methods-Perpetual Method The Luann Company uses the perpetual inventory system. The following July data are for an item in Luann's inventory: July 1 Beginning inventory 30 units @ 10 Purchased $9 per unit 50 units @$11 per unit 15 Sold 60 units 26 Purchased 25 units @$13 per unit Calculate the cost of goods sold for the July 15 sale using (a) first-in, first-out, (b) last-in, first- out, and (c) the weighted-average cost methods. Round your final answers...

  • Martinez Ltd. uses the perpetual inventory system and reports the following inventory transactions for the month...

    Martinez Ltd. uses the perpetual inventory system and reports the following inventory transactions for the month of June: Date Explanation Units Unit Cost Total Cost June 1 Beginning inventory 1,500 $6 $9,000.00 12 Purchases 2,480 7 17,360 15 Sale (2,610 ) 16 Purchases 4,560 8 36,480 23 Purchases 1,380 9 12,420 27 Sales (5,830 ) (a) Determine the cost of goods sold and the cost of the ending inventory using (1) FIFO and (2) Average cost. (Round average final answers...

  • Question B, please. Marigold Inc. uses a perpetual inventory system. Its records show the following for...

    Question B, please. Marigold Inc. uses a perpetual inventory system. Its records show the following for the month of May. Unit Total Date Explanation Units Cost Cost May 1 Inventory 29 $9 $261 May 15 Purchase 24 10 240 May 18 Sale (49) May 24 Purchase 38 11 418 Total 42 $919 42 $919 Your answer is correct. Calculate the cost of goods sold for May and the ending inventory at May 31 using the FIFO formula. Cost of goods...

  • Question 1 Question 2 Question 3 Question 4 Sandhill Co. uses a perpetual inventory system. Data...

    Question 1 Question 2 Question 3 Question 4 Sandhill Co. uses a perpetual inventory system. Data for product E2-D2 includes the following purchases. Date Number of Units Unit Price May 7 48 $14 July 28 36 19 On June 1, Sandhill sold 24 units, and on August 27,36 more units. * Your answer is incorrect. Calculate the average cost of the goods sold in the sale. (Round answers to 3 decimal places, e.g. 5.125.) June 1 sale: $ 336 Aug....

  • London Co. uses a periodic inventory system is records show the following for the month of...

    London Co. uses a periodic inventory system is records show the following for the month of May, in which 80 units were sold. Unit Cost Total Cost May 1 Inventory 35 $8 $ 280 15 Purchases 30 11 330 24 Purchases 12 480 Totais $1090 Instructions Compute the ending inventory at May 31 and cost of goods sold using the (1) FIFO and 2) Weighted Average methods. Prove the amount allocated to cost of goods sold under each method on...

  • Calculate the cost of goods sold and ending inventory using the FIFO cost method. Calculate the...

    Calculate the cost of goods sold and ending inventory using the FIFO cost method. Calculate the cost of goods sold and ending inventory using the average cost method. Blue Limited uses a perpetual inventory system. The inventory records show the following data for its first month of operations: Date Explanation Units Unit Cost Total Cost Balance in Units Aug. 2 Purchases 249 $69 $17,181 249 3 Purchases 506 96 48,576 755 Sales (275) 480 15 Purchases 926 121 112,046 1,406...

  • Type or paste question here Blue Ltd. uses the perpetual inventory system and reports the following...

    Type or paste question here Blue Ltd. uses the perpetual inventory system and reports the following inventory transactions for the month of June: Total Cost $8,220.00 17,010 Date Explanation June 1 Beginning inventory 12 Purchases 15 Sale 16 Purchases 23 Purchases 27 Sales Unit Units Cost 1,370 $6 2,430 7 (2,540 ) 4,0708 1,400 (5,230) 32,560 12,600 - Your answer is partially correct. Determine the cost of goods sold and the cost of the ending inventory using (1) FIFO and...

  • Show your calculations. Riverbed Corp uses a perpetual inventory system reports the following for the month...

    Show your calculations. Riverbed Corp uses a perpetual inventory system reports the following for the month of June. Date Explanation Units Unit Cost Total Cost June 1 Inventory 150 $750 12 Purchases 2,100 350 240 Purchases 1,680 Inventory 260 - Your answer is partially correct. Calculate the average cost per unit, using a perpetual inventory system. Assume a sale of 420 units occurred on June 15 for a selling price of $8 and a sale of 60 units on June...

  • Sheffield Inc. uses a perpetual inventory system. Its records show the following for the month of...

    Sheffield Inc. uses a perpetual inventory system. Its records show the following for the month of May. Unit Total Date Explanation Units Cost Cost May 1 Inventory 29 $7 $203 May 15 Purchase 26 8 208 May 18 Sale (44) May 24 Purchase 41 9 369 Total 52 $780 52 (b) Calculate the cost of goods sold for May and the ending inventory at May 31 using the average cost formula. (For average, use 3 decimal places, e.g. 15.235 in...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT