Periodic inventory using FIFO, LIFO, and weighted average cost methods The units of an item available for sale during the year were as follows: Date Line Item Description Units Cost per Unit Amount Jan. 1 Inventory 16 units at $34 $544 Aug. 13 Purchase 7 units at $36 252 Nov. 30 Purchase 7 units at $37 259 Available for sale 30 units $1,055 There are 18 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using the (a) first-in, first-out (FIFO) method; (b) last-in, first-out (LIFO) method; and (c) weighted average cost method (round per-unit cost to two decimal places and your final answer to the nearest whole dollar).
Question
Periodic inventory using FIFO, LIFO, and weighted average cost methods The units of an item available for sale during the year were as follows: Date Line Item Description Units Cost per Unit Amount Jan. 1 Inventory 16 units at 544 Aug. 13 Purchase 7 units at 37 259 Available for sale 30 units $1,055 There are 18 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using the (a) first-in, first-out (FIFO) method; (b) last-in, first-out (LIFO) method; and (c) weighted average cost method (round per-unit cost to two decimal places and your final answer to the nearest whole dollar).
Solution
(a) First-In, First-Out (FIFO) Method:
In the FIFO method, we assume that the first units purchased are the first ones sold. So, the ending inventory consists of the units purchased most recently.
- The first 16 units sold are from the January 1 inventory, costing $34 each.
- The next 7 units sold are from the August 13 purchase, costing $36 each.
- The remaining 7 units in the inventory are from the November 30 purchase, costing $37 each.
So, the cost of the ending inventory is:
(7 units x 259
(b) Last-In, First-Out (LIFO) Method:
In the LIFO method, we assume that the last units purchased are the first ones sold. So, the ending inventory consists of the units purchased earliest.
- The first 7 units sold are from the November 30 purchase, costing $37 each.
- The next 7 units sold are from the August 13 purchase, costing $36 each.
- The remaining 4 units in the inventory are from the January 1 inventory, costing $34 each.
So, the cost of the ending inventory is:
(4 units x 136
(c) Weighted Average Cost Method:
In the weighted average cost method, we calculate an average cost per unit by dividing the total cost of goods available for sale by the total units available for sale. Then, we multiply this average cost per unit by the number of units in the ending inventory.
- Total cost of goods available for sale = $1,055
- Total units available for sale = 30 units
So, the average cost per unit is:
35.17/unit (rounded to two decimal places)
Then, the cost of the ending inventory is:
18 units x 633 (rounded to the nearest whole dollar)
Similar Questions
Cost of goods sold and inventory (24 marks) Rifle Co. had the following inventory information available: Date Transactions Purchases Sales Units Unit Cost Units 1 Sep Beginning inventory 300 $100 3 Sep Purchases 100 $84 5 Sep Sales 250 10 Sep Purchases 250 $80 15 Sep Sales 200 20 Sep Purchases 250 $76 28 Sep Sales 150 (Q1-A). Assume that the company uses LIFO method under the perpetual inventory system to estimate cost of goods sold, please calculate the cost of sale for the month of September
Which of the following statements is correct regarding the use of the first-in first-out (FIFO) method of valuing inventory?Cost of sales for the period is calculated using weighted average cost of the goods acquired.Cost of sales for the period is calculated using the most recent inventory cost per item.Closing inventory consists of the most recently purchased goods.Closing inventory consists of goods purchased earlier in the period.
There are advantages to using each of the four inventory costing methods. Identify the statements below that are correct regarding these advantages. (Check all that apply.)Multiple select question.FIFO assigns an amount to cost of goods sold on the income statement that approximates its current replacement cost.FIFO assigns an amount to inventory on the balance sheet that approximates its current cost.Weighted average tends to smooth out erratic changes in costs.LIFO mimics the actual flow of goods for most businesse
Assuming purchase costs are rising in a periodic inventory system, determine which of the statements below are correct regarding the cost of goods sold under FIFO, LIFO and weighted average cost flow methods.Multiple select question.Companies using FIFO will report the highest gross profit and net income.Companies using FIFO will pay higher taxes than companies using LIFO, assuming all else being equal.Weighted average cost of goods sold will be between FIFO and LIFO costs of goods sold.Companies using LIFO will report the smallest cost of goods sold.
The GMA corporation shows the following data related to an item of InventoryInventory, January 1 200 units @P50 Purchases, January 9 200 units @ P54 Purchases, January 19 100 units @ P60 Sales, January 20 380 units What value should be assigned to the Cost of Sale using FIFO?
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.