Knowee
Questions
Features
Study Tools

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 3434 544 Aug. 13 Purchase 7 units at 36252Nov.30Purchase7unitsat36 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).

...expand
🧐 Not the exact question you are looking for?Go ask a question

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 37/unit)=37/unit) = 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 34/unit)=34/unit) = 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:

1,055/30units=1,055 / 30 units = 35.17/unit (rounded to two decimal places)

Then, the cost of the ending inventory is:

18 units x 35.17/unit=35.17/unit = 633 (rounded to the nearest whole dollar)

This problem has been solved

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?

1/3

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.