Costing inventory
Golden Eagle Company begun operations in 2016 by selling a single product. Data on purchases and sales for the year were as follows:
Sales: | |
April | 16,000 units |
May | 16,000 |
June | 20,000 |
July | 24,000 |
August | 28,000 |
September | 28.000 |
October | 18,000 |
November | 10,000 |
December | 8,000 |
Total units | 168,000 |
Total sales | $10,000,000 |
On January 4, 2017, the president of the company, Connie Kilmer, asked for your advice on costing the 32,000-unit physical inventory that was taken on December 51, 2016. Moreover, since the firm plans to expand its product line, she asked for your advice on the use of a perpetual inventory system in the future.
- 1. Determine the cost of the December 31. 2016, inventory under the periodic system, using the (a) first-m, first-out method, (b) last-in, first-out method, and (c) weighted average cost method.
- 2. Determine the gross profit for the year under each of the three methods in (1).
- 3. a. Explain varying viewpoints why each of the three inventory costing methods may best reflect the results of operations for 2016.
- b. Which of the three inventory costing methods may best reflect the replacement cost of the inventory on the balance sheet as of December 31, 2016:'
- c. Which inventory costing method would you choose to use for income tax purposes? Why?
- d. Discuss the advantages and disadvantages of using a perpetual inventory system. From the data presented in this case, is there any indication of the adequacy of inventory' levels during the year?
1. (a)
Periodic Inventory System:
Periodic inventory system is a system, in which the inventory is updated in the accounting records on a periodic basis such as at the end of each month, quarter or year. In other words, it is an accounting method which is used to determine the amount of inventory at the end of each accounting period.
First-in-First-Out:
In First-in-First-Out method, the costs of the initially purchased items are considered as cost of goods sold, for the items which are sold first. The value of the ending inventory consists of the recent purchased items.
Last-in-Last-Out:
In Last-in-First-Out method, the costs of last purchased items are considered as the cost of goods sold, for the items which are sold first. The value of the closing stock consists of the initial purchased items.
Weighted-average cost method:
Under Weighted average cost method, the company calculates a new average cost after every purchase is made. It is determined by dividing the cost of goods available for sale by the units on hand.
To determine: The cost of inventory on December 31, 2016 using first in first out method under periodic inventory system.
Explanation of Solution
Calculate the cost of ending inventory as follows:
Details | Units | Unit Price | Total |
(A) | (B) | (A) × (B) | |
December 10 | 8,000 | 48 | 384,000 |
November 4 | 8,000 | 44.85 | 358,800 |
October 25 | 12,800 | 43.50 | 556,800 |
August 10 | 3,200 | 42.75 | 136,800 |
Total | 32,000 | 1,436,400 |
Table (1)
Hence, the ending inventory on December 31, 2016 under First in First out Method is $1,436,400.
(b)
Explanation of Solution
Calculate the cost of ending inventory as follows:
Details | Units | Unit Price | Total |
(A) | (B) | (A) × (B) | |
April 6 | 31,000 | 36.60 | 1,134,600 |
May 18 | 1,000 | 39.00 | 39,000 |
Total | 32,000 | 1,173,600 |
Table (2)
Hence, the ending inventory on December 31, 2016 under Last in First out Method is $1,173,600.
(c)
Explanation of Solution
Calculate the cost of ending inventory as follows:
The value of ending inventory is calculated by multiplying ending inventory with weighted average cost per unit.
Working note:
The weighted average unit cost is calculated as follows:
Hence, the ending inventory on December 31, 2016 under weighted average method is $1,303,680.
2.
Explanation of Solution
The table showing all the three methods of inventory is as follows:
Details | FIFO ($) |
LIFO ($) |
Weighted Average ($) |
Sales | 10,000,000 | 10,000,000 | 10,000,000 |
Less: Cost of merchandise sold (Refer Table 4) |
6,711,600 | 6,974,400 | 6,844,320 |
Gross Profit | 3,288,400 | 3,025,600 | 3,155,680 |
Table (3)
Working Note:
Calculate the cost of merchandise sold under the three methods.
Details | FIFO ($) |
LIFO ($) |
Weighted Average ($) |
Cost of Merchandise Available For Sale | 8,148,000 | 8,148,000 | 8,148,000 |
Less: Ending Inventory | 1,436,400 (a) | 1,173,600 (b) | 1,303,680 (c) |
Cost of Merchandise Sold | 6,711,600 | 6,974,400 | 6,844,320 |
Table (4)
3. (a)
To Explain: The reason for each of the three inventory costing methods might best reflect the results of operations for 2016.
Explanation of Solution
- Most often the LIFO method is considered as the best method for reflecting the results of operations as it matches the recent merchandise purchase cost against the current year sales. As a result, the gross profit determined is best reflects the result of current year operations.
- In the present case, the gross profit of $3,025,600 best reflects the matching of the most current merchandise cost of $6,974,400 against the current sales of $10,000,000. As a result, the effects of price fluctuations on the income of operations are minimum, incase, the current sales of merchandise exceeds the current year’s merchandise. LIFO could not best match the current merchandise cost with the current sales. This is because the cost of goods sold includes the cost of some beginning inventory purchased in the prior years. Thus, in such case, LIFO could not be able to satisfy the current matching concept. This kind of situation is generally experienced by the companies whose ending inventory consistently increases in each year. Hence, LIFO method is considered to be the best method for matching the expenses against the expenses.
- However, FIFO is considered as best method when the physical flow of the merchandise is consistent. It is mostly adopted by the companies who intend to sell the merchandise in order of their purchases made. In such a case, it approximates the results of operations based on specific identification of costs.
- While, the weighted average cost method lies somewhere in between LIFO and FIFO. The effects of the price fluctuations are averaged for calculating the merchandise cost and income from operations.
Hence, to decide which inventory costing method best reflects the income from operations depends upon the Company G’s emphasis on which of the aforesaid parameters:
- Whether it emphasizes on matching the current year merchandise cost against the current year sales (LIFO method).
- Whether it emphasizes on the physical flow of merchandise (FIFO method).
- Whether it equally emphasizes on both matching concept and physical flow of goods.
(b)
To Find: The three inventory costing methods that may best reflect the replacement cost of the inventory on the balance sheet as of December 31, 2016.
Explanation of Solution
Among the three inventories costing methods that reflects the replacement cost of the inventory on the balance sheet as of December 31, 2016 is FIFO method. This is because it includes the most recently purchased merchandise in its ending inventory. The Company G’s ending inventory of $1,436,000 as on December 31, 2016 represents the recent purchases during the period August to December. Thus, FIFO method most appropriately approximates the replacement cost of the ending inventory than the other two inventory methods.
(c)
To Explain: The inventory costing that would be used for income tax purposes.
Explanation of Solution
- During inflation on rising price trend LIFO method would be helpful for income tax purposes. This is because it results in lesser income from operations which fetch less income tax.
- In the present case, the Company G should use LIFO method for lowering its income tax. LIFO method includes the most recent purchases that increases the cost of goods sold thereby decreasing the net income.
- However, for decreasing price trend, FIFO method would be useful for income tax purposes. This is because, it would include the prior period purchases carrying higher prices in its cost of goods sold. As a result, it would decrease the net income and thus, the income tax.
(d)
To Discuss: The advantages and disadvantages of using a perpetual inventory system.
Explanation of Solution
The advantages of using a perpetual inventory system are stated below:
- It is an effective method of controlling inventory. Any sort of inventory shortages can be determined by comparing the ending inventory with the subsidiary account balance.
- It determines the accurate value of inventories to be used for preparing interim statements.
- It helps in maintaining the adequate level of inventories. The regular track records of the perpetual inventory help the company for timely recorder of the merchandise to avoid loss of sales and prevent excess accumulated inventory on hand.
- It is analyzed that from the period April through July, the company has ordered more inventory irrespective to the accumulated excess inventory. In such a case, the perpetual inventory system if adopted would have helped to avoid the occurrence of an excessive accumulated inventory.
Want to see more full solutions like this?
Chapter 6 Solutions
FINANCIAL+MANG.-W/ACCESS PRACTICE SET
- Golden Eagle Company began operations on April 1 by selling a single product. Data on purchases and sales for the year are as follows: Purchases: Sales: The president of the company, Connie Kilmer, has asked for your advice on which inventory cost flow method should be used for the 32,000-unit physical inventory that was taken on December 31. The company plans to expand its product line in the future and uses the periodic inventory system. Write a brief memo to Ms. Kilmer comparing and contrasting the LIFO and FIFO inventory cost flow methods and their potential impacts on the companys financial statements.arrow_forwardCommunication Golden Eagle Company began operations on April 1 by selling a single product. Data on purchases and sales for the year are as follows: Purchases: Sales: The president of the company, Connie Kilmer, has asked for your advice on which inventory cost flow method should be used for the 32,000-unit physical inventory that was taken on December 31. The company plans to expand its product line in the future and uses the periodic inventory system. Write a brief memo to Ms. Kilmer comparing and contrasting the LIFO and FIFO inventory cost flow methods and their potential impacts on the companys financial statements.arrow_forwardHabicht Company was formed in 2018 to produce a single product. The production and sales for the next 4 years were as follows: Required: 1. Determine the gross profit for each year under each of the following periodic inventory methods: a. FIFO b. LIFO c. Average cost (Round unit costs to 3 decimal places.) 2. Next Level Explain whether the companys return on assets (net income divided by average total assets) would be higher under FIFO or LIFO.arrow_forward
- Inventory Costing Methods VanderMeer Inc. reported the following information for the month of February: During February, VanderMeer sold 140 units. The company uses a periodic inventory system. Required What is the value of ending inventory and cost of goods sold for February under the following assumptions: Of the 140 units sold, 55 cost $20, 35 cost $22, 45 cost $23, and 5 cost $24. FIFO LIFO Weighted averagearrow_forwardThe Lady in Red Corp. reported the following information for the month of September 2015: Date Units Price Amount September 1, 2015 Inventory 100 $30 $3,000 September 9, 2015 purchase 50 $32 1,600 September 18, 2015 purchase 100 $33 3,300 September 27, 2015 purchase 50 $34 1,700 Total 300 $9,600 During September, Lady in Red Corp. sold 150 units. The company uses the periodic inventory system. Using the last-in, first-out (LIFO) method of inventory accounting, compute the cost of goods sold.arrow_forwardMassive Company provided the following information for the current year: Units Unit cost Total cost January 1 Inventory on hand 200 1,500 300,000 April 3 Purchase 300 1,750 525,000 October 1 Purchase 500 2,000 1,000,000 The entity sold 400 units on June 25 and 400 on December 10. What is the weighted average cost of the inventory at year-end?arrow_forward
- At May 1, 2017, Oriole Company had beginning inventory consisting of 340 units with a unit cost of $8. During May, the company purchased inventory as follows:▪ 670 units at $8▪ 1010 units at $9The company sold 1680 units during the month for $13 per unit. Oriole Company uses the average cost method. Oriole Company's gross profit for the month of May is a.) $14280. b.) $17170. c.) $7560. d.) $21840.arrow_forwardThe data summarize the inventory-related activities of Novak Inc. for the month of March. Note that the company experienced increasing unit costs for its purchases throughout the month. Date Mar. 1 Mar. 2 Mar. 15 Mar. 19 Mar. 30 Purchases (beginning inventory) 500 @ $3.70 1,600 @ $4.10 6,200 @ $4.40 1,700 @ $4.80 10,000 Novak Inc. 500 units @ $3.70 1,600 units @ $4.10 6,200 units @ $4.40 1,700 units @ $4.80 10,000 units = = = Sold or Issued The cost of goods available for sale is calculated and shown below. $1,850 6,560 27,280 8,160 4,000 $43,850 4,000 Balance 500 units 2,100 units 8,300 units 4,300 units 6,000 units Assume that Novak Inc. uses a periodic inventory system, where the inventory cost is calculated only at the end of the month. How are ending inventory and cost of goods sold calculated using the FIFO cost formula?arrow_forwardLOVING-KINDNESS Corp’s inventory records revealed the following: Date Transaction Number of Units Unit Cost August 1 Beginning inventory 500 P8.50 August 20 Purchase 400 P8.90 The company sold 700 units of inventory during the month. The company uses weighted-average costing. What is cost of the ending inventory? Round weighted-average unit cost to four decimals and final answer to the nearest whole peso.arrow_forward
- The Stake Technology Inc. company has the following purchases and sales during the year ended December 31, 2014. Sales March 5: 110 units October 21: 200 units Inventory and Purchases Beginning: 210 units @ $15/unit March 31: 150 units @ $16/unit July 13: 250 units @ $17/unit The units have a selling price of $20.00 per unit. a) Given that Stake Technology Inc. employs a perpetual inventory system, calculate the cost of goods available for sale and the number of units available for sale, as well as the units remaining in ending inventory. Cost of goods available for sale: Units available for sale: Units remaining in ending inventory: b) Please fill in the table by calculating the dollar value of cost of goods sold and ending inventory, as well as the gross profit eamed by Stake Technology Inc. using the weighted average system. Calculate weighted average cost per unit of merchandise inventory to the nearest cent Cost of Goods Sold Ending Inventory Gross Profit 9,800 610 210 Weighted…arrow_forwardDuring 2012, a company sells 200 units of inventory for $50 each. The company has the following inventory purchase transactions for 2012: Date Transaction Units Unit Cost Total Cost Beginning Inventory $39 $1,950 3,800 2,960 Jan 1 50 May 5 Nov 3 Purchase 100 38 Purchase 80 37 Actual sales by the company include its entire beginning inventory, 80 units of inventory from the May 5 purchase, and 70 units from the November 3 purchase. Required: Calculate cost of goods sold and ending inventory for 2012 assuming the company uses: a) FIFO (First in, First out) b) LIFO (Last in, First out) c) Average Cost d) Explain the impact of these different methods in the recognition of Cost of goods sold and Ending Inventory in the financial statement of the company.arrow_forwardJailbird Company provided the following data about the inventory for the month of January : Units Unit Cost Total Cost January 1 Beginning 16,000 140 2,240,000 5 Purchase 4,000 150 600,000 10 Sales 15,000 15 Purchase 20,000 160 3,200,000 16 Purchase Return 1,000 160 160,000 25 Sales 8,000 26 Sales Return 4,000 31 Purchase 30,000 150 4,500,000 Required: Compute the total cost balances of Ending Inventory and Cost of Goods Sold using: Periodic Weighted Averagearrow_forward
- Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage LearningIntermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage Learning
- Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage LearningCornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning