Question

Data given Units Unit Cost 1-Jan Beginning inventory 4,190 $20 12-Feb Purchase 4,630 $25 2-Mar Sale...

Data given
Units Unit Cost
1-Jan Beginning inventory 4,190 $20
12-Feb Purchase 4,630 $25
2-Mar Sale 3,640 $38
18-Apr Purchase 5,950 $28
31-May Sale 5,180 $40
Total Units Sold 8,820

Based on the data above, compute the cost of goods sold under FIFO (perpetual/periodic), LIFO (perpetual/periodic), weighted-average (periodic) and moving-average (perpetual).

0 0
Add a comment Improve this question Transcribed image text
Answer #1

To calculate cost of goods sold and ending inventory there are following methods

  • FIFO(first in first out)
  • LIFO(last in first out)
  • Weighted average method

Under periodic method inventory account is not updated regularly it is adjusted at the end of accounting period.

Under perpetual method inventory account is changed regularly .

Date Ruschass fom Balance- 너190x20ー8320 4140x20-8380 2Mar 4630 X2s 1157s 3IM SIOX20looo $1995SDtt 190 20 4630 о25- 83 800 1570 Coste geds sd1一軍1995 SO Leapcriel LIFO Sale 4190X&DE 83800 Peb 4630x2S-1157s 1630X2lS7sD Costcosd 66600 5150& Balanc 8320 x280199550 1130X3S.S -233172 Sale Tan 2Mch 82337 SI80X32-ll/72 PAp $95028 166600 1 2753 CoS 21442 (4770 24구

Add a comment
Know the answer?
Add Answer to:
Data given Units Unit Cost 1-Jan Beginning inventory 4,190 $20 12-Feb Purchase 4,630 $25 2-Mar Sale...
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
  • Why Moms A Option #1: Inventory Costing & Periodic and Perpetual Inventory Systems Jordan Company is...

    Why Moms A Option #1: Inventory Costing & Periodic and Perpetual Inventory Systems Jordan Company is a manufacturing firm. Presented below is information concerning one of its products: 1/1 Beginning inventory 4,190 $20 2/12 Purchase 4,630 $25 3/2 Sale 3,640 $38 4/18 Purchase 5,950 $28 5/31 Sale 5,180 $40 Part A Use the ACT350_CTTemplate_Mod5_option1.xlsx file (in the module folder) to compute the cost of goods sold under the following situations: 1. Periodic system, FIFO cost flow 2. Perpetual system, FIFO...

  • Jordan Company is a manufacturing firm. Presented below is information concerning one of its products: Compute...

    Jordan Company is a manufacturing firm. Presented below is information concerning one of its products: Compute the cost of goods sold under the following situations: Periodic system, FIFO cost flow Perpetual system, FIFO cost flow Periodic system, LIFO cost flow Perpetual system, LIFO cost flow Periodic system, weighted-average cost flow Perpetual system, moving-average cost flow Your answers must be submitted in an Excel file and must show all calculations used to arrive at the final answers. Data given Unit Cost...

  • INVENTORY ITEM 621AB UNITS DATE COST Beginning Inventory $6 $7 Jan 1 120 Purchase 200 Jan...

    INVENTORY ITEM 621AB UNITS DATE COST Beginning Inventory $6 $7 Jan 1 120 Purchase 200 Jan 7 Sale Jan 10 250 Purchase $8 Jan 15 300 Jan 17 Purchase $9 200 Sale 325 Jan 20 Sale Jan 25 100 Jan 28 Purchase $10 175 Smith Corporation uses a perpetual inventory system. Determine the costs assigned to Cost of Goods Sold and Ending Inventory using both FIFO and LIFO methods. DATE ITEM RED16 UNITS COST Beginning Inventory $10 Jan 1 100...

  • Activities Date Mar. 1 Beginning inventory Mar. 5 Purchase Mar. 9 Sales Mar. 18 Purchase Mar....

    Activities Date Mar. 1 Beginning inventory Mar. 5 Purchase Mar. 9 Sales Mar. 18 Purchase Mar. 25 Purchase Mar. 29 Sales Units Acquired at Cost 22e units $53.40 per unit 285 units $58.40 per unift Units Sold at Retail 38e units $88.40 per unit 145 units $63.40 per unit 270 units $65.40 per unit 25e units $98.4e per unit Totals 92e units 630 units . Compute the cost assigned to ending Inventory using (a) FIFO, (b) LIFO, (c) welghted average,...

  • Weighted Average Cost Method with Perpetual Inventory The beginning inventory for Midnight Supplies and data on...

    Weighted Average Cost Method with Perpetual Inventory The beginning inventory for Midnight Supplies and data on purchases and sales for a three-month period are as follows: Date Transaction Number of Units Per Unit Total Jan. 1 Inventory 7,200 $74.00 $532,800 10 Purchase 21,600 84.00 1,814,400 28 Sale 10,800 148.00 1,598,400 30 Sale 3,600 148.00 532,800 Feb. 5 Sale 1,440 148.00 213,120 10 Purchase 51,840 86.50 4,484,160 16 Sale 25,920 158.00 4,095,360 28 Sale 24,480 158.00 3,867,840 Mar. 5 Purchase 43,200...

  • Weighted Average Cost Method with Perpetual Inventory The beginning inventory for Midnight Supplies and data on...

    Weighted Average Cost Method with Perpetual Inventory The beginning inventory for Midnight Supplies and data on purchases and sales for a three-month period are as follows: Date Transaction Number of Units Per Unit Total Jan. 1 Inventory 7,700 $79.00 $608,300 10 Purchase 23,100 89.00 2,055,900 28 Sale 11,550 158.00 1,824,900 30 Sale 3,850 158.00 608,300 Feb. 5 Sale 1,540 158.00 243,320 10 Purchase 55,440 91.50 5,072,760 16 Sale 27,720 168.00 4,656,960 28 Sale 26,180 168.00 4,398,240 Mar. 5 Purchase 46,200...

  • Weighted Average Cost Method with Perpetual Inventory The beginning inventory for Midnight Supplies and data on...

    Weighted Average Cost Method with Perpetual Inventory The beginning inventory for Midnight Supplies and data on purchases and sales for a three-month period are as follows: Date Transaction Number of Units Per Unit Total Jan. 1 Inventory 7,300 $77.00 $562,100 10 Purchase 21,900 87.00 1,905,300 28 Sale 10,950 154.00 1,686,300 30 Sale 3,650 154.00 562,100 Feb. 5 Sale 1,460 154.00 224,840 10 Purchase 52,560 89.50 4,704,120 16 Sale 26,280 164.00 4,309,920 28 Sale 24,820 164.00 4,070,480 Mar. 5 Purchase 43,800...

  • Weighted Average Cost Method with Perpetual Inventory The beginning inventory for Midnight Supplies and data on...

    Weighted Average Cost Method with Perpetual Inventory The beginning inventory for Midnight Supplies and data on purchases and sales for a three-month period are as follows: Date Transaction Number of Units Per Unit Total Jan. 1 Inventory 7,600 $71.00 $539,600 10 Purchase 22,800 81.00 1,846,800 28 Sale 11,400 142.00 1,618,800 30 Sale 3,800 142.00 539,600 Feb. 5 Sale 1,520 142.00 215,840 10 Purchase 54,720 83.50 4,569,120 16 Sale 27,360 152.00 4,158,720 28 Sale 25,840 152.00 3,927,680 Mar. 5 Purchase 45,600...

  • The following is the inventory record of widgets for the ABC Company Units Cost/Unit 1-Jan Beginning...

    The following is the inventory record of widgets for the ABC Company Units Cost/Unit 1-Jan Beginning Inventory 1001 $10.00 15-Apr Purchase 2001 $11.00 24-Aug Purchase 300 $12.00 27-Nov Purchase 400 $13.00 At the end of the fiscal year, the physical inventory found 450 widgets on hand at 12/31. Total sales for the year were 500 widgets sold at a retail price of $20.00 per widget Required: (a) Calculate the endign inventory value under FIFO, LIFO and Weighted Average (b) Calculate...

  •                                Inventory   Date       Activity       Units &nbsp

                                   Inventory   Date       Activity       Units        Unit Cost       Balance                                      1-Mar       Beginning Balance       250       $14        $3,500                                       3-Mar       Sale       (200)               - - 0                                       10-Mar       Purchase       200       15       ...

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
Active Questions
ADVERTISEMENT