Question

In: Accounting

Cruz Company uses LIFO for inventory costing and reports the following financial data. It also recomputed...

Cruz Company uses LIFO for inventory costing and reports the following financial data. It also recomputed inventory and cost of goods sold using FIFO for comparison purposes. 2017 2016 LIFO inventory $ 190 $ 140 LIFO cost of goods sold 770 710 FIFO inventory 260 165 FIFO cost of goods sold 725 — Current assets (using LIFO) 250 220 Current liabilities 170 150 1. Compute its current ratio, inventory turnover, and days' sales in inventory for 2017 using (a) LIFO numbers and (b) FIFO numbers. (Round your answers to 1 decimal place.)

Solutions

Expert Solution

2017 2016
LIFO Inventory 190 140
LIFO COGS 770 710
FIFO Inventory 260 165
FIFO COGS 725 -
Current Assets LIFO 250 220
Current Liabilities 170 150

LIFO Current Assets = LIFO Inventory + Other Current Assets

250 = 190 + Other Current Assets

Other Current Assets = 60

Therefore, FIFO Current Assets = FIFO Inventory + Other Current Assets

FIFO Current Assets(2017) = 260 + 60 = 320

Similarly FIFO Current Assets(2016) = 165 + 80 = 245

1.

Current Ratio

LIFO(2017) = Current Assets/Current Liabilities = 250/170 = 1.5

FIFO(2017) = Current Assets/Current Liabilities = 320/170 = 1.9

2.

Inventory turnover

LIFO 2017 = COGS/Average Inventory = 770/[(190+140)/2] = 4.7

FIFO 2017 = COGS/Average Inventory = 725/[(260+165)/2] = 3.4

3.

Days' sales in inventory

LIFO 2017 = 365/Inventory Turnover Ratio = 365/4.7 = 77.7 Days = 78 days

FIFO 2017 = 365/Inventory Turnover Ratio = 365/3.4 = 107.4 Days = 108 Days


Related Solutions

Cruz Company uses LIFO for inventory costing and reports the following financial data. It also recomputed...
Cruz Company uses LIFO for inventory costing and reports the following financial data. It also recomputed inventory and cost of goods sold using FIFO for comparison purposes. Year 2 Year 1 LIFO inventory $ 180 $ 130 LIFO cost of goods sold 760 700 FIFO inventory 250 155 FIFO cost of goods sold 715 — Current assets (using LIFO) 240 210 Current assets (using FIFO) 310 235 Current liabilities 175 155 1. Compute its current ratio, inventory turnover, and days'...
F8i-G2 Company uses the LIFO inventory costing method. The company had a beginning inventory of 1,840...
F8i-G2 Company uses the LIFO inventory costing method. The company had a beginning inventory of 1,840 units that cost $13.40 each. Purchases were made throughout the most recent year as follows: March: 2,100 units purchased at $15.80 per unit June: 900 units purchased at $12.30 per unit August: 1,400 units purchased at $16.65 per unit October: 800 units purchased at $14.70 per unit During the most recent year, 4,800 units were sold to customers at a selling price of $21.00...
F8i-G2 Company uses the LIFO inventory costing method. The company had a beginning inventory of 1,840...
F8i-G2 Company uses the LIFO inventory costing method. The company had a beginning inventory of 1,840 units that cost $13.20 each. Purchases were made throughout the most recent year as follows: March: 2,100 units purchased at $15.60 per unit June: 900 units purchased at $12.10 per unit August: 1,400 units purchased at $16.35 per unit October: 800 units purchased at $14.40 per unit During the most recent year, 4,800 units were sold to customers at a selling price of $21.00...
CA8.11   (LO 3, 4 ) (LIFO Choices) Wilkens Company uses the LIFO method for inventory costing....
CA8.11   (LO 3, 4 ) (LIFO Choices) Wilkens Company uses the LIFO method for inventory costing. In an effort to lower net income, company president Mike Wilkens tells the plant accountant to take the unusual step of recommending to the purchasing department a large purchase of inventory at year-end. The price of the item to be purchased has nearly doubled during the year, and the item represents a major portion of inventory value. Also answer the following:       -what ratios are...
SPK Industries uses the LIFO inventory costing system, use the following information to calculate the COGS...
SPK Industries uses the LIFO inventory costing system, use the following information to calculate the COGS if they sold 50 units in July. Date Purchases Price per Unit 6/15 30 units $120 6/30 40 units $130 7/15 20 units $150
Inventory Costing Methods-Periodic Method The Lippert Company uses the periodic inventory system. The following July data...
Inventory Costing Methods-Periodic Method The Lippert Company uses the periodic inventory system. The following July data are for an item in Lippert's inventory: July 1 Beginning inventory 40 units @ $9 per unit 10 Purchased 60 units @ $10 per unit 15 Sold 70 units @ 26 Purchased 35 units @ $11 per unit Calculate the cost of goods sold for July and ending inventory at July 31 using (a) first-in, first-out, (b) last-in, first-out, and (c) the weighted-average cost...
Inventory Costing Methods-Periodic Method Merritt Company uses the periodic inventory system. The following May data are...
Inventory Costing Methods-Periodic Method Merritt Company uses the periodic inventory system. The following May data are for an item in Merritt's inventory: May 1 Beginning inventory 210 units @ $36 per unit 12 Purchased 160 units @ $41 per unit 16 Sold 240 units @ 24 Purchased 220 units @ $42 per unit Calculate the cost of goods sold for May and ending inventory at May 31 using (a) first-in, first-out, (b) last-in, first-out, and (c) the weighted-average cost methods....
Inventory Costing Methods-Periodic Method The Lippert Company uses the periodic inventory system. The following July data...
Inventory Costing Methods-Periodic Method The Lippert Company uses the periodic inventory system. The following July data are for an item in Lippert's inventory: July 1 Beginning inventory 40 units @ $9 per unit 10 Purchased 60 units @ $10 per unit 15 Sold 70 units @ 26 Purchased 35 units @ $11 per unit Calculate the cost of goods sold for July and ending inventory at July 31 using (a) first-in, first-out, (b) last-in, first-out, and (c) the weighted-average cost...
Inventory Costing Methods-Periodic Method The Lippert Company uses the periodic inventory system. The following July data...
Inventory Costing Methods-Periodic Method The Lippert Company uses the periodic inventory system. The following July data are for an item in Lippert's inventory: July 1 Beginning inventory 40 units @ $9 per unit 10 Purchased 60 units @ $10 per unit 15 Sold 70 units @ 26 Purchased 35 units @ $11 per unit Calculate the cost of goods sold for July and ending inventory at July 31 using (a) first-in, first-out, (b) last-in, first-out, and (c) the weighted-average cost...
Inventory Costing Methods-Periodic Method The Lippert Company uses the periodic inventory system. The following July data...
Inventory Costing Methods-Periodic Method The Lippert Company uses the periodic inventory system. The following July data are for an item in Lippert's inventory: July 1 Beginning inventory 40 units @ $9 per unit 10 Purchased 60 units @ $10 per unit 15 Sold 70 units @ 26 Purchased 35 units @ $11 per unit Calculate the cost of goods sold for July and ending inventory at July 31 using (a) first-in, first-out, (b) last-in, first-out, and (c) the weighted-average cost...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT