Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Dymac Appliances uses the periodic inventory system. Details regarding the inven

ID: 2545939 • Letter: D

Question

Dymac Appliances uses the periodic inventory system. Details regarding the inventory of appliances at January 1, purchases invoices during the next 12 months, and the inventory count at December 31 are summarized as follows:

Required:

1. Determine the cost of the inventory on December 31 by the first-in, first-out method.

If the inventory of a particular model comprises one entire purchase plus a portion of another purchase acquired at a different unit cost, use a separate line for each purchase. If units are in inventory at two different costs, enter the units PURCHASED MOST RECENTLY first.

2. Determine the cost of the inventory on December 31 by the last-in, first-out method.

If the inventory of a particular model comprises one entire purchase plus a portion of another purchase acquired at a different unit cost, use a separate line for each purchase. If units are in inventory at two different costs, enter the OLDEST units first.

3. Determine the cost of the inventory on December 31 by the weighted average cost method.

4.  Would FIFO or LIFO be preferred for income tax purposes in periods of rising prices?

Purchases Invoices Inventory, January 1 Inventory Count, Model 1st 2nd 3rd December 31 A10 B15 E60 G83 J34 M90 Q70 4 at $ 27 4 at $30 4 at 33 97 65 5 at254 10 at 253 67 3 at 130 7 at 188 90 6 at 8 at 3 at 7 at 12 at 2 at 5 at $93 70 236 57 108 168 7 4 at 3 at 6 at 10 at 843 at 60 15 at 63 9 at 244 59 16 at 66 16 at 13 2 at 110 3 at 128 4 at 178 4 at 183 8

Explanation / Answer

1

As per FIFO Method

Quantity

Price

Amount

A 10

1

7.5

7.5

4

8.25

33

40.5

B15

1

          30.00

        30.00

6

          16.17

        97.00

     127.00

E60

5

            7.22

        36.11

G83

9

          25.30

     227.70

J34

13

            4.19

        54.44

M90

2

          42.67

        85.33

3

          43.33

     130.00

     215.33

Q70

1

          45.75

        45.75

7

          26.86

     188.00

     233.75

TOTAL

     934.83

2

As per LIFO Method

A 10

Quantity

Price

Amount

1

7.5

7.5

4

6.75

27

34.5

B15

7

          11.63

        81.38

E60

3

          23.33

        70.00

2

          20.00

        40.00

     110.00

G83

7

          33.71

     236.00

2

          40.67

        81.33

     317.33

J34

12

            4.75

        57.00

1

            5.90

          5.90

        62.90

M90

2

          54.00

     108.00

2

          55.00

     110.00

1

          42.67

        42.67

     260.67

Q70

5

          33.60

     168.00

3

          44.50

     133.50

     301.50

TOTAL

1,168.28

3

As Per Weighted Average cost Method

A10

5

        7.500

       37.500

B15

7

     17.333

     121.333

E60

5

        8.600

       43.000

G83

9

     35.250

     317.250

J34

13

        4.611

       59.944

M90

5

     47.600

     238.000

Q70

8

     35.850

     286.800

1,103.828

4

LIFO method should be preferred for Income Tax Purposes in periods of rising prices.

1

As per FIFO Method

Quantity

Price

Amount

A 10

1

7.5

7.5

4

8.25

33

40.5

B15

1

          30.00

        30.00

6

          16.17

        97.00

     127.00

E60

5

            7.22

        36.11

G83

9

          25.30

     227.70

J34

13

            4.19

        54.44

M90

2

          42.67

        85.33

3

          43.33

     130.00

     215.33

Q70

1

          45.75

        45.75

7

          26.86

     188.00

     233.75

TOTAL

     934.83

2

As per LIFO Method

A 10

Quantity

Price

Amount

1

7.5

7.5

4

6.75

27

34.5

B15

7

          11.63

        81.38

E60

3

          23.33

        70.00

2

          20.00

        40.00

     110.00

G83

7

          33.71

     236.00

2

          40.67

        81.33

     317.33

J34

12

            4.75

        57.00

1

            5.90

          5.90

        62.90

M90

2

          54.00

     108.00

2

          55.00

     110.00

1

          42.67

        42.67

     260.67

Q70

5

          33.60

     168.00

3

          44.50

     133.50

     301.50

TOTAL

1,168.28

3

As Per Weighted Average cost Method

A10

5

        7.500

       37.500

B15

7

     17.333

     121.333

E60

5

        8.600

       43.000

G83

9

     35.250

     317.250

J34

13

        4.611

       59.944

M90

5

     47.600

     238.000

Q70

8

     35.850

     286.800

1,103.828

4

LIFO method should be preferred for Income Tax Purposes in periods of rising prices.