Relationships Among Ratios
Financial ratios express one financial quantity concerning another and they can be used... Read More
Whenever prices change, the allocation of total inventory costs between cost of sales on the income statement and inventory on the balance sheet will vary depending on a company’s choice of inventory valuation method.
The following example can help illustrate how the calculation of the cost of sales, gross profit, and ending inventory will differ under the four inventory valuation methods.
In one year, a company received 3 shipments of 1,000 sewing machines at $110 each, then 2,500 sewing machines at $100 each, and finally 3,200 sewing machines at $95 each. During the year, the company sold 5,600 sewing machines at $200 each. The company is able to readily identify each shipment received. As a result, the company determines that the entire first shipment (1,000 sewing machines), 1,800 sewing machines from the second shipment, and 2,800 sewing machines from the third shipment were sold to customers during the year. The sales, cost of sales, gross profit, and ending inventory amounts under each inventory valuation method is as follows:
Sales: 5,600 × $200 = $1,120,000
COGS: (2,400 × $100) + (3,200 × 95) = $544,000
Gross Profit: $1,120,000 – $544,000 = $576,000
Ending Inventory: (1,000 × $110) + (10 0× $100) = $120,000
Sales: 5,600 × $200 = $1,120,000
COGS: (1,000 × $110) + (2,500 × $100) + (2,100 × $95) = $559,500
Gross Profit: $1,120,000 – $559,500 = $560,500
Ending Inventory: (1,100 × $95) = $104,500
Sales: 5,600 × $200 = $1,120,000
COGS: (1,000 × $110) + (1,800 × $100) + (2,800 × $95) = $556,000
Gross Profit: $1,120,000 – $556,000 = $564,000
Ending Inventory: (700 × $100) + (400 × $95) = $108,000
Sales: 5,600 × $200 = $1,120,000
Weighted Average Cost: [(1,000 × $110) + (2,500 × $100) + (3,200 × $95)] / 6,700 = $99.10
COGS: 5,600 × $99,10 = $554,960
Gross Profit: $1,120,000 – $554,960 = $565,040
Ending Inventory: 1,100 × $99.10 = $109,010
The calculation demonstrates how each valuation method provides similar sales figures but different figures for the cost of sales, gross profit, and ending inventory. This arises from the fact that:
Changes to inventory are usually recorded using either a periodic inventory system or a perpetual inventory system.
Under a periodic inventory system, inventory values and costs of sales are determined at the end of an accounting period, and the number of goods in ending inventory is obtained or verified through a physical count of the units in inventory. The cost of goods available for sale allocated to the cost of sales and ending inventory may be quite different if the FIFO method is used compared to when the weighted average cost method is used.
Under a perpetual inventory system, the inventory values and cost of sales are continuously updated to reflect purchases and sales.
Under either system, the allocation of goods available for sale to the cost of sales and ending inventory is the same if the inventory valuation method used is either specific identification or FIFO. Both systems will also result in different allocations to the cost of sales and ending inventory if the LIFO method is used in inventory valuation.
Cameron Ltd. is an electronic retailer company that uses a tracking system to identify every single item in its inventory. The following table illustrates the company’s purchases and sales of LCD screens during the month of April 2017. Assume that the company had no inventory of LCD screens at the beginning of the period and that it sells each unit for $700. Using the given information, calculate the cost of goods sold, the gross profit, and the ending inventory.
$$ \begin{array}{c|c|c} \text{} & \textbf{LCD Screens} & \text{} \\ \hline \textbf{Date} & { \textbf{Purchases} } & \textbf{Volume of Sales} \\ \hline {} & {\textbf{Amount} \quad \textbf{Price}} & {} \\ \hline {1^\text{th}} & {{1000} \quad {500$}} & \text{NA} \\ \hline {8^\text{th}} & {\text{NA} \quad \text{NA}} & {800} \\ \hline {15^\text{th}} & {{1200} \quad {650$}} & \text{NA} \\ \hline {20^\text{th}} & {\text{NA} \quad \text{NA}} & {1000} \\ \hline {28^\text{th}} & {{1100} \quad {600$}} & \text{NA} \\ \hline {30^\text{th}} & {\text{NA} \quad \text{NA}} & {1200} \\ \hline \textbf{Total} & \bf{ { 3,300} \quad {1,940,000}} & \bf{3000} \\ \end{array} $$
No matter which method we use, the value of sales would always be the same
Revenue = Selling price per unit × Number of units sold = $700 × 3,000 = $2,100,000
Cost of goods sold (COGS) = [(800 units × $500) + ((200 units × $500) + (800 units × $650)) + ((400 units × $650) + (800 units × $600)) = $1,760,000
Ending inventory = Beginning inventory + Purchases – COGS
= 0 + $1,940,000 – $1,760,000 = 180,000
Gross profit = revenue – COGS = $2,100,000 – $1,760,000 = $340,000
The cost of each item sold is separately added to the cost of sales. The rest of the steps would be the same as they are in any other method. Since the items in the example (LCD screens) are interchangeable, and it was not clearly disclosed which batch was sold first, we would assume that the company followed a first in, first-out basis. Under this assumption, the ending inventory and gross profit would be the same as they are under FIFO.
First, we need to find the average cost of each unit.
Average cost per unit on April 8th = $500
Average cost per unit on April 20th = [(200 × 500) + (1,200 × 650)] / 1400 = 629
Average cost per unit on April 30th = [(400 × 650) + (1,100 × 600)] / 1500 = 613
Total cost of all units sold within the period = (800 × 500) + (1,000 × 629) + (1,200 × 613) = 1,764,600
Ending inventory = Beginning inventory + Purchases – COGS
= $0 + $1,940,000 – $1,764,600= $175,400
Gross profit = Revenue – COGS = 2,100,000– $1,764,600= $336,000
The cost of sales would be determined according to the price of the last purchased items.
Cost of sales = (800 units × $500) + (1,000 units × $650) + [(1100 units × $600) + (100 units × $650)] = $1,775,000
Ending inventory = Beginning inventory + Purchases – COGS
= $0 + $1,940,000 – $1,775,000 = $165,000
Gross profit = Revenue – Cost of sales = $2,100,000– $1,775,000 = $325,000
The results would be the same as with the perpetual system.
The results would be the same as with the perpetual system.
First, we need to find the average of the total cost of units.
Average cost/Unit = Total amount of purchase cost/Total number of units purchased
= $1,940,000/$3,300 = $587.88
COGS = [Average cost/Unit] × Number of units sold = $587.88 × $3,000 = $1,763,636
Ending inventory = Beginning inventory + Purchases – COGS
= $0 + $1,940,000 – $1,763,636 = $176,364
Gross profit = Revenue – COGS = $2,100,000 – $1,763,636 = $336,364
As we can see, the difference between the periodic and the perpetual systems under the weighted average cost method is only $364.
COGS = (800 units × $600) + [(300 units × $600) + (700 units × $650)] + [(500 units × $650) + (700 units × $500)] = $1,790,000
Ending inventory = Beginning inventory + Purchases – COGS
= $0 + $1,940,000 – $1,790,000 = 150,000
Gross profit = Revenue – COGS = $2,100,000 – $1,790,000 = $310,000
Comparing the LIFO method under the periodic system with the same method under the perpetual system, we notice that under the periodic system, the value of gross profit and the value of ending inventory is $15,000 higher under the periodic system.
Question 1
Which of the following inventory valuation methods is most likely to yield different amounts of gross profit under the periodic inventory system and the perpetual inventory system?
A. FIFO.
B. LIFO.
C. Specific identification method.
Solution
The correct answer is B.
LIFO is likely to yield a different gross profit under each inventory system. This is because the cost of goods sold varies under each inventory system when LIFO is used. Under the periodic system, the COGS varies because the cost of items purchased at the end of the period is added first to the cost of sales, while under the perpetual system, the cost of items last purchased before making a sale is added first to the cost of goods sold.
Question 2
During the year 2006, company XYZ sold 380 folding chairs at $45 each. Given the following information on purchases made by the company during the year, what is the cost of sales and gross profit under the FIFO method?
$$ \begin{array}{c|c} \textbf{Date} & {\textbf{Folding chairs purchased } (\textbf{units})} \\ \hline \text{January 31,2006} & \text{100 units at \$23 each} \\ \hline \text{June 1,2006} & \text{150 units at \$27 each} \\ \hline \text{December 1,2006} & \text{210 units at \$33 each} \\ \end{array} $$
A. Cost of Sales: $15,000; Gross Profit: $3,800.
B. Cost of Sales: $22,340; Gross Profit: $12,000.
C. Cost of Sales: $10,640; Gross Profit: $6,460.
Solution
The correct answer is C.
Cost of sales = (100*$23) + (150*$27) + (130*$33) = $10,640. Since sales = 380*$45 = $17,100, then gross profit = $17,100 – $10,640 = $6,460.