Question

In: Finance

Company records indicate the following data for widgets: Date Item Quantity Unit Cost Sales Price Sept....

Company records indicate the following data for widgets:

Date

Item

Quantity

Unit Cost

Sales Price

Sept. 1

Balance

17

$ 59

Sept. 3

Purchase

3

$ 71

Sept. 8

Sale

6

$ 118

            Sept. 12

Sale

7

$ 107

The Cost of Goods (COGS) sold will be different depending upon whether the company uses LIFO or FIFO. Of course, the ending inventory would be different as well.

The dollar difference between COGS computed using LIFO and COGS using FIFO is closest to:

A. $ 56                                                                                                                                                                                  
B. $ 36  
C. $ 12
D. $ 18

Solutions

Expert Solution

COGS when company uses LIFO

LIFO Means Last in First Out, hence the cost of goods sold will be

Date Qty Rate ($) Product( Qty*Rate)($)
Sept 8 3 71 213
Sept 8 3 59 177
Sept 12 7 59 413
TOTAL 803

As the method used is LIFO the company sold on 8th September from the stock it recently purchased on 3rd Sept and then moves on to stock purchased on 1st Sept.

Similarly, when company uses FIFO

FIFO Means First in First Out, hence the cost of goods sold will be

Date Qty Rate($) Product( Qty*Rate)($)
Sept 8 6 59 354
Sept 12 7 59 413
TOTAL 767

As the method used is FIFO the company sold on 8th September from the stock it first purchased on 1st Sept and then moves on to stock purchased on 3rd Sept when the 1st Sept stock is vanished fully.

Therefore $ difference between COGS computed using LIFO and FIFO is closest to :-

Total as per LIFO - Total as per FIFO

= 803 - 767

= $36

Hence, answer is "B" $36


Related Solutions

The following data refer to Bear Company's ending inventory: Item code Quantity Unit Cost Unit Market...
The following data refer to Bear Company's ending inventory: Item code Quantity Unit Cost Unit Market Small 100 $228 $232 Medium 420 152 176 Large 600 168 176 Extra-Large 220 268 256 How much is the inventory if the lower of cost or market rule is applied to each item of inventory? Select one: A. $252,640 B. $243,760 C. $265,440 D. None of the above
Lower-of-Cost-or-Market Method On the basis of the following data: Item Inventory Quantity Cost per Unit Market...
Lower-of-Cost-or-Market MethodOn the basis of the following data: $$ \begin{array}{lccc} \text { Item } & \text { Inventory Quantity } & \text { Cost per Unit } & \begin{array}{l} \text { Market Value per Unit } \\ \text { (Net Realizable Value) } \end{array} \\ \hline \text { JFW1 } & 6,330 & \$ 10 & \$ 11 \\ \text { SAW9 } & 1,140 & 36 & 34 \end{array} $$Determine the value of the inventory at the lower-of-cost-or-market by applying...
Lower-of-Cost-or-Market Inventory On the basis of the following data: Commodity Inventory Quantity Unit Cost Price Unit...
Lower-of-Cost-or-Market Inventory On the basis of the following data: Commodity Inventory Quantity Unit Cost Price Unit Market Price AL65 42 $179 $174 CA22 46 89 89 LA98 30 276 295 SC16 11 116 134 UT28 21 213 222 Determine the value of the inventory at the lower of cost or market. Assemble the data in the form illustrated in Exhibit 10. Inventory at the Lower of Cost or Market Commodity Total Cost Total Market Total Lower of C or M...
Lower-of-Cost-or-Market Inventory On the basis of the following data: Commodity Inventory Quantity Unit Cost Price Unit...
Lower-of-Cost-or-Market Inventory On the basis of the following data: Commodity Inventory Quantity Unit Cost Price Unit Market Price AL65 27 $283 $284 CA22 31 185 169 LA98 38 123 125 SC16 10 207 212 UT28 29 80 71 Determine the value of the inventory at the lower of cost or market. Assemble the data in the form illustrated in Exhibit 10. Inventory at the Lower of Cost or Market Commodity Total Cost Total Market Total Lower of C or M...
Inventory records for a company revealed the following: Date Transaction Number of Units Unit Cost Apr....
Inventory records for a company revealed the following: Date Transaction Number of Units Unit Cost Apr. 1 Beginning inventory 500 $2.40 Apr. 20 Purchase 400 $2.50 The company sold 700 units of inventory during the month. Cost of goods sold assuming FIFO would be: a. $1,690 b. $1,720. c. $1,700. d. $1,730. e. $1,710. If management can estimate the amount of loss that will occur due to litigation against the company, and the likelihood of the loss is reasonably possible,...
A company sells Widgets to consumers at a price of $83 per unit. The cost to...
A company sells Widgets to consumers at a price of $83 per unit. The cost to produce Widgets is $30 per unit. The company will sell 15,000 Widgets to consumers each year. The fixed costs incurred each year will be $220,000. There is an initial investment to produce the goods of $2,700,000 which will be depreciated straight line over the 17 year life of the investment to a salvage value of $0. The opportunity cost of capital is 13% and...
SimpsonSimpson ​Company's inventory records for the most recent year contain the following​ data: Quantity Unit Cost...
SimpsonSimpson ​Company's inventory records for the most recent year contain the following​ data: Quantity Unit Cost Beginning inventory 2,000 $8.00 Purchases during year 18,000 $10.00 Simpson Company sold a total of 19,800 units during this year. 1. Using the average- cost method, compute the cost of goods sold and the ending inventory of the year. 2. Using the FIFO method, compute the cost of goods sold and the ending inventory of the year. 3. Using the LIFO method, compute the...
Inventory records for Marvin Company revealed the following: Date Transaction Number of Units Unit Cost Mar....
Inventory records for Marvin Company revealed the following: Date Transaction Number of Units Unit Cost Mar. 1 Beginning inventory 960 $7.15 Mar. 10 Purchase 540 7.65 Mar. 16 Purchase 395 8.25 Mar. 23 Purchase 530 8.95 Marvin sold 1,790 units of inventory during the month. Ending inventory assuming FIFO would be (Do not round your intermediate calculations. Round your answer to the nearest dollar amount): $5,610 $1,156 $6,864 $1,541
Inventory records for Marvin Company revealed the following: Date Transaction Number of Units Unit Cost Mar....
Inventory records for Marvin Company revealed the following: Date Transaction Number of Units Unit Cost Mar. 1 Beginning inventory 1,000 $ 7.26 Mar. 10 Purchase 540 7.71 Mar. 16 Purchase 760 8.14 Mar. 23 Purchase 590 8.54 Marvin sold 1,910 units of inventory during the month. Cost of goods sold assuming FIFO would be:
Inventory records for Marvin Company revealed the following: Date Transaction Number of Units Unit Cost   Mar....
Inventory records for Marvin Company revealed the following: Date Transaction Number of Units Unit Cost   Mar. 1 Beginning inventory 1,070    $7.29      Mar. 10 Purchase 580    7.79      Mar. 16 Purchase 445    8.39      Mar. 23 Purchase 550    9.09    Marvin sold 1,960 units of inventory during the month. Ending inventory assuming FIFO would be
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT