/*! This file is auto-generated */ .wp-block-button__link{color:#fff;background-color:#32373c;border-radius:9999px;box-shadow:none;text-decoration:none;padding:calc(.667em + 2px) calc(1.333em + 2px);font-size:1.125em}.wp-block-file__button{background:#32373c;color:#fff;text-decoration:none} Question 11E John Adams Company’s record of... [FREE SOLUTION] | 91Ó°ÊÓ

91Ó°ÊÓ

John Adams Company’s record of transactions for the month of April was as follows.

Purchases Sales

April 1 (balance on hand) 600 @ \( 6.00 April 3 500 @ \)10.00

4 1,500 @ 6.08 9 1,400 @ 10.00

8 800 @ 6.40 11 600 @ 11.00

13 1,200 @ 6.50 23 1,200 @ 11.00

21 700 @ 6.60 27 900 @ 12.00

29 500 @ 6.79 4,600

5,300

Instructions

(a) Assuming that periodic inventory records are kept in units only, compute the inventory at April 30 using (1) LIFO and(2) average-cost.

(b) Assuming that perpetual inventory records are kept in dollars, determine the inventory using (1) FIFO and (2) LIFO.

(c) Compute the cost of goods sold assuming periodic inventory procedures and inventory priced at FIFO.

(d) In an inflationary period, which inventory method—FIFO, LIFO, average cost—will show the highest net income?

Short Answer

Expert verified

Value of closing inventory would be highest under FIFO, and the value of COGS would be highest under LIFO.

Step by step solution

01

Value of ending inventory under the periodic system

EndingInventory(Units)=TotalInventoryAvailable-TotalSales=5,300-4,600=700Units

a) Value of ending inventory using LIFO

Endinginventory(LIFO)=BeginningInventoryvalue+April14Purchasevaluefor100units=600×$6+100×$6.08=$3,600+$608=$4,208

b) Value of ending inventory using average cost

Units

Rate

Amount

Beginning Inventory

600

$6

$3600

April 4 Purchase

1,500

$6.08

$9120

April 8 Purchase

800

$6.40

$5120

April 13 Purchase

1,200

$6.50

$7800

April 21 Purchase

700

$6.60

$4620

April 29 Purchase

500

$6.79

$3395

Total

5,300

$33,655

Averagecostofinventory=TotalinventoryvalueTotalinventory=$33,6555,300=$6.35

Endinginventory(Average)=Endinginventoryunits×Averagecost=700×$6.35=$4,445

02

Value of ending inventory under the perpetual system

a) Using FIFO

Date

Purchase

Cost of Goods Sold

Balance

April 1

Beginning Balance (600 units @ $6)

$3,600

April 3

500 units @ $6

-$3,000

$600

April 4

1,500 units @ $6.08

$9,120

$9,720

April 8

800 units @ $6.40

$5,120

$14,840

April 9

100 units @ $6

-$600

1300 units @ $6.08

-$7,904

$6,336

April 11

200 units @ $6.08

-$1,216

400 units @ $6.40

-$2,560

$2,560

April 13

1200 units @ $6.50

$7,800

April 21

700 units @ $6.60

$4,620

$14,980

April 23

400 units @ $6.40

-$2,560

800 units @ $6.50

-$5,200

$7,220

April 27

400 units @ $6.50

-$2,600

500 units @ $6.60

-$3,300

$1,320

April 29

500 units $6.79

$3,395

$4,715

The value of closing inventory comes out to be $4,715.

a) Using LIFO

Date

Purchase

Cost of Goods Sold

Balance

April 1

Beginning Balance (600 units @ $6)

$3,600

April 3

500 units @ $6

-$3,000

$600

April 4

1,500 units @ $6.08

$9,120

$9,720

April 8

800 units @ $6.40

$5,120

$14,840

April 9

800 units @ $6.40

-$5,120

600 units @ $6.08

-$3,648

$6,072

April 11

600 units @ $6.08

-$3,648

$2,424

April 13

1200 units @ $6.50

$7,800

April 21

700 units @ $6.60

$4,620

$14,844

April 23

700 units @ $6.60

-$4,620

500 units @ $6.50

-$3,250

$6,974

April 27

700 units @ $6.50

-$4,550

200 units @ $6.08

-$1,216

$1,208

April 29

500 units $6.79

$3,395

$4,603

The value of closing inventory comes out to be $4,603.

03

Value of COGS under the periodic system using FIFO

EndingInventory(Units)=TotalInventoryAvailable-TotalSales=5,300-4,600=700Units

a) Value of ending inventory using FIFO

Endinginventory(LIFO)=Inventoryvalueof500unitsonApril29+April21Purchasevaluefor200units=500×$6.79+200×$6.6=$3,395+$1,320=$4,715

Costofgoodssold=Totalgoodsvalueavailableforsale-Endinginventoryvalue=$33,655-$4,715=$28,940


04

Inventory valuation method producing highest net income

The highest net income is the result of the lowest cost of goods sold. The cost of goods sold is the difference between the total available inventory and ending inventory. So, if the ending inventory is high in value, the COGS would be below. FIFO I is based on the historical cost among all the inventory valuing alternatives. Thus under this method, the value of COGS would not be affected due to inflation as inventories at the latest cost are left in the stock. So the COGS would always be lower.

Unlock Step-by-Step Solutions & Ace Your Exams!

  • Full Textbook Solutions

    Get detailed explanations and key concepts

  • Unlimited Al creation

    Al flashcards, explanations, exams and more...

  • Ads-free access

    To over 500 millions flashcards

  • Money-back guarantee

    We refund you if you fail your exam.

Over 30 million students worldwide already upgrade their learning with 91Ó°ÊÓ!

One App. One Place for Learning.

All the tools & learning materials you need for study success - in one app.

Get started for free

Most popular questions from this chapter

You are the vice president of finance of Sandy Alomar Corporation, a retail company that prepared two different schedules of gross margin for the first quarter ended March 31, 2017. These schedulesappear below.

Sales Cost of Gross

(\(5 per unit) Goods Sold Margin

Schedule 1 \)150,000 \(124,900 \)25,100

Schedule 2 150,000 129,400 20,600

The computation of cost of goods sold in each schedule is based on the following data.

Cost Total

Units per Unit Cost

Beginning inventory, January 1 10,000 \(4.00 \)40,000

Purchase, January 10 8,000 4.20 33,600

Purchase, January 30 6,000 4.25 25,500

Purchase, February 11 9,000 4.30 38,700

Purchase, March 17 11,000 4.40 48,400

Jane Torville, the president of the corporation, cannot understand how two different gross margins can be computed from thesame set of data. As the vice president of finance, you have explained to Ms. Torville that the two schedules are based on differentassumptions concerning the flow of inventory costs, i.e., FIFO and LIFO. Schedules 1 and 2 were not necessarily prepared inthis sequence of cost flow assumptions.

Instructions

Prepare two separate schedules computing cost of goods sold and supporting schedules showing the composition of the endinginventory under both cost flow assumptions.

Accounting, Analysis, and Principles

Englehart Company sells two types of pumps. One is large and is for commercial use. The other is smaller and is used in residentialswimming pools. The following inventory data is available for the month of March.

Price per

Units Unit Total

Residential Pumps

Inventory at Feb. 28: 200 \( 400 \) 80,000

Purchases:

March 10 500 \( 450 \)225,000

March 20 400 \( 475 \)190,000

March 30 300 \( 500 \)150,000

Sales:

March 15 500 \( 540 \)270,000

March 25 400 \( 570 \)228,000

Inventory at March 31: 500

Commercial Pumps

Inventory at Feb. 28: 600 \( 800 \)480,000

Purchases:

March 3 600 \( 900 \)540,000

March 12 300 \( 950 \)285,000

March 21 500 \(1,000 \)500,000

Sales:

March 18 900 \(1,080 \)972,000

March 29 600 \(1,140 \)684,000

Inventory at March 31: 500

Accounting

(a) Assuming Englehart uses a periodic inventory system, determine the cost of inventory on hand at March 31 and thecost of goods sold for March under first-in, first-out (FIFO).

(b) Assume Englehart uses dollar-value LIFO and one pool, consisting of the combination of residential and commercialpumps. Determine the cost of inventory on hand at March 31 and the cost of goods sold for March. Assume Englehart’sinitial adoption of LIFO is on March 1. Use the double-extension method to determine the appropriate price indices.

(Hint:The price index for February 28/March 1 should be 1.00.) (Round the index to three decimal places.)

Analysis

(a) Assume you need to compute a current ratio for Englehart. Which inventory method (FIFO or dollar-value LIFO) doyou think would give you a more meaningful current ratio?

(b) Some of Englehart’s competitors use LIFO inventory costing and some use FIFO. How can an analyst compare theresults of companies in an industry, when some use LIFO and others use FIFO?

Principles

Can companies change from one inventory accounting method to another? If a company changes to an inventory accounting methodused by most of its competitors, what are the trade-offs in terms of the conceptual framework discussed in Chapter 2 of the textbook?

Question:Presented below is a list of items that may or may not be reported as inventory in a company’s December 31 balance sheet.

1. Goods out on consignment at another company’s store.

2. Goods sold on an installment basis (bad debts can be reasonably estimated).

3. Goods purchased f.o.b. shipping point that are in transit at December 31.

4. Goods purchased f.o.b. destination that are in transit at December 31.

5. Goods sold to another company, for which our company has signed an agreement to repurchase at a set price that coversall costs related to the inventory.

6. Goods sold where large returns are predictable.

7. Goods sold f.o.b. shipping point that are in transit at December 31.

8. Freight charges on goods purchased.

9. Interest costs incurred for inventories that are routinely manufactured.

10. Costs incurred to advertise goods held for resale.

11. Materials on hand not yet placed into production by a manufacturing firm.

12. Office supplies.

13. Raw materials on which a manufacturing firm has started production but which are not completely processed.

14. Factory supplies.

15. Goods held on consignment from another company.

16. Costs identified with units completed by a manufacturing firm but not yet sold.

17. Goods sold f.o.b. destination that are in transit at December 31.

18. Short-term investments in stocks and bonds that will be resold in the near future.

Instructions

Indicate which of these items would typically be reported as inventory in the financial statements. If an item should not bereported as inventory, indicate how it should be reported in the financial statements.

The following example was provided to encourage the use of the LIFO method. In a nutshell, LIFO subtracts inflation from inventory costs, deducts it from taxable income, and records it in a LIFO reserve account on the books. The LIFO benefit grows as inflation widens the gap between current-year and past-year (minus inflation) inventory costs.

This gap is:

With LIFO Without LIFO

Revenues \(3,200,000 \)3,200,000

Cost of goods sold 2,800,000 2,800,000

Operating expenses 150,000 150,000

Operating income 250,000 250,000

LIFO adjustment 40,000 0

Taxable income \( 210,000 \) 250,000

Income taxes @ 36% \( 75,600 \) 90,000

Cash flow \( 174,400 \) 160,000

Extra cash \( 14,400 0

Increased cash flow 9% 0%

Instructions

(a) Explain what is meant by the LIFO reserve account.

(b) How does LIFO subtract inflation from inventory costs?

(c) Explain how the cash flow of \)174,400 in this example was computed. Explain why this amount may not be correct.

(d) Why does a company that uses LIFO have extra cash? Explain whether this situation will always exist.

Question:Stallman Company took a physical inventory on December 31 and determined that goods costing \(200,000 were on hand. Not included in the physical count were \)25,000 of goods purchased from Pelzer Corporation, f.o.b. shipping point, and \(22,000 of goods sold to Alvarez Company for \)30,000, f.o.b. destination. Both the Pelzer purchase and the Alvarez sale werein transit at year-end. What amount should Stallman report as its December 31 inventory?

See all solutions

Recommended explanations on Business Studies Textbooks

View all explanations

What do you think about this solution?

We value your feedback to improve our textbook solutions.

Study anywhere. Anytime. Across all devices.