Question

Use this information for the following three questions. KW Steel Corp. uses the LIFO method of...

Use this information for the following three questions.

KW Steel Corp. uses the LIFO method of inventory valuation. Waretown Steel, KW’s major competitor, instead uses the FIFO method. The following are excerpts from each company’s 2014 and 2013 financial statements:

KW Steel Corp.

Waretown Steel

($ in millions)

2014

2013

2014

2013

Balance sheet inventories

797.6

692.7

708.2

688.6

LIFO reserve

378.0

334.9

Sales

4,284.8

4,029.7

3,584.2

3,355.8

Cost of goods sold

3,427.8

3,226.5

2,724.0

2,617.5

A- Calculate inventory turnover for 2014 for KW Steel

B-Calculate inventory turnover for 2014 for Warehouse Steel

C-Re-calculate inventory turnover for 2014 for KW Steel if they used FIFO

Homework Answers

Answer #1

A

Inventory Turnover = COGS / Average Inventory = 3,427.8 / (797.6 + 692.7) / 2 = 3,427.8 / 745.15 = 4.6 times

B.

Inventory Turnover = COGS / Average Inventory =3,584.2 / (708.2 + 688.6) / 2 = 3,584.2 / 698.4 = 3.9 times

C.

Increase in KW's LIFO reserve = 378 - 334.9 = 43.1
COGS (FIFO) = 3,427.8 - 43.1 = 3,384.7

Inventory (LIFO) = 797.6 and 692.7
LIFO Reserve = 378 and 334.9
Inventory (FIFO) = (797.6 + 378) and (692.7 + 334.9) = 1,175.6 and 1,027.6

Inventory turnover = 3,384.7 / (1,175.6 + 1,027.6) / 2 = 3.1 times

Know the answer?
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
Similar Questions
KW Steel Corp. uses the LIFO method of inventory valuation. Waretown Steel, KW’s major competitor, instead...
KW Steel Corp. uses the LIFO method of inventory valuation. Waretown Steel, KW’s major competitor, instead uses the FIFO method. The following are excerpts from each company’s 2014 and 2013 financial statements: KW Steel Corp. Waretown Steel 2014 2013 2014 2013 Balance sheet inventories 800 700 720 700 LIFO reserve 400 350 Sales 4,300 4,000 3,500 3,350 Cost of goods sold 3,400 3,200 2,700 2,600 Calculate 2014 inventory turnover for both companies. Then re-calculate KW Steel’s 2014 inventory turnover if...
Sauerbraten Corp. reported 2007 sales ($ in millions) of $2,157 and cost of goods sold of...
Sauerbraten Corp. reported 2007 sales ($ in millions) of $2,157 and cost of goods sold of $1,827. Inventories at year - end 2007 and 2006, respectively, were $553 and $562. The company uses the LIFO method for inventory valuation and discloses that if the FIFO inventory valuation method had been used, inventories would have been $63.3 million and $56.8 million higher in 2007 and 2006, respectively. Compared to the inventory turnover ratio reported, if Sauerbraten had exclusively used the FIFO...
Carolina Company uses the LIFO method for valuing its ending inventory. The following financial statement information...
Carolina Company uses the LIFO method for valuing its ending inventory. The following financial statement information is available for its first year of operation: Carolina Company Income Statement For the year ended December 31 Sales    60,000 Cost of Goods sold   23,000 Gross Profit   37,000 Expenses 13,000 Income before taxes $ 24,000 Carolina's ending inventory using the LIFO method was $8,700. Carolina's accountant determined that had the company used FIFO, the ending inventory would have been $9,100. a. Determine what...
Johnson Corp. uses dollar-value LIFO method of computing its inventory cost. Data for the past three...
Johnson Corp. uses dollar-value LIFO method of computing its inventory cost. Data for the past three years is as follows:      Year ended                           Inventory at                   Price      December 31                    End-of-year Prices             Index           2013                                  $250,000                     1.00           2014                                      480,000                     1.10           2015                                      560,000                     1.25 What is the 2015 inventory balance using dollar-value LIFO? Select one: A. $448,000 B. $469,545 C. $560,000 D. $700,000
Sletten Industries uses the last-in, First-out(LIFO) method of accounting for the inventories of its single product....
Sletten Industries uses the last-in, First-out(LIFO) method of accounting for the inventories of its single product. For fiscal year 2020, the company reported sales revenue of $200 million and cost of goods sold of $135 million. The following table was reported in the financial statement footnotes, ($ millions) Jan 1, 2020 Dec 31, 2020 Inventory value at LIFO $25 $28 LIFO Reserve 14 22 Inventory value at FIFO 39 50 If Sletten Industries had used FIFO to account for its...
With respect to LIFO, which of the following is incorrect? If a company uses LIFO for...
With respect to LIFO, which of the following is incorrect? If a company uses LIFO for tax purposes it must use it for GAAP purposes If the LIFO reserve increases in a given year, then LIFO COGS is higher than it would have been if FIFO had been used for that year LIFO results in better matching on the income statement than FIFO LIFO results in inventory levels on the balance sheet that are closer to current cost than FIFO
Analyzing Inventory Disclosure Comparing LIFO and FIFO The current asset section of the 2014 and 2013...
Analyzing Inventory Disclosure Comparing LIFO and FIFO The current asset section of the 2014 and 2013 fiscal year end balance sheets of The Kroger Co. are presented in the accompanying table: $ millions January 31, 2015 February 1, 2014 Current assets Cash and temporary cash investments $188 $825 Deposits in-transit 786 666 Receivables 949 845 FIFO inventory 6,297 5,793 LIFO credit (1,083) (827) Prepaid and other current assets 288 319 Total current assets $7,425 $7,621 In addition, Kroger provides the...
You have the following information for Blue Spruce Corp.. Blue Spruce Corp. uses the periodic method...
You have the following information for Blue Spruce Corp.. Blue Spruce Corp. uses the periodic method of accounting for its inventory transactions. Blue Spruce Corp. only carries one brand and size of diamonds—all are identical. Each batch of diamonds purchased is carefully coded and marked with its purchase cost. March 1 Beginning inventory 165 diamonds at a cost of $284 per diamond. March 3 Purchased 180 diamonds at a cost of $317 each. March 5 Sold 175 diamonds for $585...
ABC Corp. uses the dollar-value LIFO method of computing its inventory cost. Information for the past...
ABC Corp. uses the dollar-value LIFO method of computing its inventory cost. Information for the past three years is presented below.                                                                                   LIFO               Year ed                 Inventory at                   Price             December 31       End-of-year Prices            Index             2017                       $143,000                        1.00             2018                         277,200                        1.05             2019                         308,000                        1.10             2020                         312,000                         1.20 What is the 2020 year-end inventory balance using dollar-value LIFO (do not type $) ?
Aegis Industries Inc., is the biggest snowmobile manufacturer in the world. It reported the following amounts...
Aegis Industries Inc., is the biggest snowmobile manufacturer in the world. It reported the following amounts in its financial statements (in millions): 2012 2013 2014 2015 Net Sales Revenue $ 5,100 $ 4,560 $ 3,890 $ 3,470 Cost of Goods Sold 3,520 3,110 2,710 3,070 Average Inventory 510 460 400 390 Required: 1-a. Calculate the inventory turnover ratio for 2015, 2014, and 2013. 1-b. Calculate the average days to sell inventory for 2015, 2014, and 2013. 2. Is Aegis performing...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT