Question

In: Operations Management

Study the FIFO and LIFO explanations in Chapter 8. 1) Compute ending FIFO inventory and cost of goods sold.

FIFO & LIFO Inventory

Study the FIFO and LIFO explanations in Chapter 8. 1) Compute ending FIFO inventory and cost of goods sold. Assume $90,000 sales; beginning inventory 500 units @$50; purchases of 400 units @$50; 100 units @$65; 400 units @$80. 2) Compute the cost of goods sold percentage of sales. 3) Compute ending LIFO inventory and cost of goods sold, using same assumptions. 4) Compute the cost of goods sold percentage of sales. 5) Comment on the difference in outcomes

Solutions

Expert Solution

FIFO Inventory Calculation: In FIFO (First In, First Out) method, the inventory purchased first is sold first.

Hence, going by this method, $90000 sales of year will be done from beginning inventory followed by inventory purchased first. Assume that one unit is sold @$90.

Hence,

Total Units Sold = $90000/$90 = 1000 units

Now beginning inventory = $50 * 500 units (beginning inventory units) = $25000

Ist Purchase inventory = $50 * 400 units (units purchased first) = $20000

2nd Purchase Inventory = $65 * 100 units (units purchased second time) = $6500

Last Purchase Inventory = $80 * 400 units (units purchased last time) = $32000

Now, In FIFO, Cost of 1000 units sold will be calculated by adding Beginning Inventory, First Purchase and Second Purchase. This total is equal to 1000 units sold.

Hence, Cost of Goods Sold = $25000 + $20000 + $6500 = $51500

Therefore, Cost of Goods Sold as percentage of Sales = ($51500/$90000) * 100 = 57.22%

Now, Ending FIFO Inventory = Last Purchase Inventory = $32000

LIFO Inventory Calculation: In LIFO (Last In, First Out) method, the inventory purchased last is sold first.

Hence, going by this method, $90000 sales of year will be done from last inventory purchased followed by second last inventory purchased. Assume that one unit is sold @$90.

Hence,

Total Units Sold = $90000/$90 = 1000 units

Now beginning inventory = $50 * 500 units (beginning inventory units) = $25000

Ist Purchase inventory = $50 * 400 units (units purchased first) = $20000

2nd Purchase Inventory = $65 * 100 units (units purchased second time) = $6500

Last Purchase Inventory = $80 * 400 units (units purchased last time) = $32000

Now, In LIFO, Cost of 1000 units sold will be calculated by adding Last Inventory Purchased, Second Last Inventory Purchased, Third Last Inventory Purchased and 100 units from beginning inventory. These all purchases are equal to 1000 units sold.

Hence, Cost of Goods Sold = $32000 + $6500 + $20000 + $5000 = $63500

Therefore, Cost of Goods Sold as percentage of Sales = ($63500/$90000) * 100 = 70.55%

Now, Ending LIFO Inventory = 400 units from beginning Inventory = $50 * 400 units = $20000

Comment on Differences: Higher Cost of Goods Sold and lower ending inventory in LIFO as compared to FIFO is due to inflation. It reflects increasing purchase price of the units purchased. Because of this inflation in purchase price, LIFO has higher Cost of Goods Sold and FIFO has higher inventory as last purchased units account for inventory in FIFO.

keosha answered 1 year ago

Next > < Previous

Related Solutions

Compute ending inventory and cost of goods sold for the current year under FIFO, LIFO, and average cost inventory costing methods.

Penn Company uses a periodic inventory system. At the end of the annual accounting period, December 31 of the current year, the accounting records provided the following information for product 1:Required Compute ending inventory and cost of goods sold for the current year under FIFO, LIFO, and average cost inventory costing methods.

Computing Cost of Goods Sold and Ending Inventory Under FIFO, LIFO, and Average Cost Assume that...

Computing Cost of Goods Sold and Ending Inventory Under FIFO, LIFO, and Average Cost Assume that Madden Company reports the following initial balance and subsequent purchase of inventory. Inventory balance at beginning of year 1,820 units @ $150 each $273,000 Inventory purchased during the year 2,380 units @ $180 each 428,400 Cost of goods available for sale during the year 4,200 units $701,400 Assume that 2,800 units are sold during the year. Compute the cost of goods sold for the...

Calculate cost of ending inventory and cost of goods sold using periodic FIFO, LIFO, and Weighted...

Calculate cost of ending inventory and cost of goods sold using periodic FIFO, LIFO, and Weighted Average Cost methods. Description # of units Cost per unit Beginning inventory: 20 20 Jan.15 Purchase: 22 27 Jan. 20 Sale 10 blank Jan.25 Purchase 18 25 Jan.28 Sale 15 blank

Calculate the cost of goods sold and the cost of ending inventory using the FIFO, LIFO, and average cost methods.

Inventory Costing Methods: Periodic Inventory Systems. (Appendix 6B)Tyler Company has the following information related to purchases and sales of one of its inventory items.DateDescriptionUnits Purchased at CostUnits Sold at RetailSept. 1Beginning inventory20 units @ $510Purchase30 units @ $820Sales40 units @ $1525Purchase25 units at $10Assume that the company uses the periodic inventory system.Required:Calculate the cost of goods sold and the cost of ending inventory using the FIFO, LIFO, and average cost methods. (Note: Use four decimal places for per-unit calculations and...

how do you calculate ending inventory or cost of goods sold under LIFO and FIFO ...

how do you calculate ending inventory or cost of goods sold under LIFO and FIFO how do you use the Gross Profit Method to estimate a loss of inventory how do you use the relative sales value method of allocating cost to items purchased What are the common disclosures required for inventory?

Calculate cost of goods sold and ending inventory for Emergicare’s bandages orders using FIFO, LIFO and...

Calculate cost of goods sold and ending inventory for Emergicare’s bandages orders using FIFO, LIFO and average cost. There are 36 units in ending inventory. (Do not round intermediate calculations, such as average cost per unit values. Round your answers to the nearest cent.) Date Units purchased Cost per unit Total cost January 1 43 $ 7.10 $ 305.30 April 1 38 6.35 241.30 June 1 53 6.10 323.30 September 1 48 6.60 316.80 Total 182 $ 1,186.70 Cost of...

How can i calculate Cost of goods sold and ending inventory using FIFO, LIFO and the...

How can i calculate Cost of goods sold and ending inventory using FIFO, LIFO and the periodic system given the information below? On December 1, 2017, Ivanhoe Company had the account balances shown below. Debits Credits Cash $5,180 Accumulated Depreciation—Equipment $1,460 Accounts Receivable 4,230 Accounts Payable 2,710 Inventory (2,900 x $0.60) 1,740 Common Stock 10,200 Equipment 21,400 Retained Earnings 18,180 $32,550 $32,550 The following transactions occurred during December. Dec. 3 Purchased 3,900 units of inventory on account at a cost...

Calculate cost of goods sold and ending inventory for Emergicare’s bandages orders using FIFO, LIFO and...

Calculate cost of goods sold and ending inventory for Emergicare’s bandages orders using FIFO, LIFO and average cost. There are 38 units in ending inventory. (Do not round intermediate calculations, such as average cost per unit values. Round your answers to the nearest cent.) Date Units purchased Cost per unit Total cost January 1 54 $ 7.50 $ 405.00 April 1 49 6.75 330.75 June 1 64 6.50 416.00 September 1 59 7.00 413.00 Total 226 $ 1,564.75. FIFO $...

Calculate cost of goods sold and ending inventory for Emergicare’s bandages orders using FIFO, LIFO and...

Calculate cost of goods sold and ending inventory for Emergicare’s bandages orders using FIFO, LIFO and average cost. There are 33 units in ending inventory. (Do not round intermediate calculations, such as average cost per unit values. Round your answers to the nearest cent.) Date Units purchased Cost per unit Total cost January 1 41 $ 7.80 $ 319.80 April 1 36 7.05 253.80 June 1 51 6.80 346.80 September 1 46 7.30 335.80 Total 174 $ 1,256.20 Cost of...

Calculate the cost of goods sold and the cost of the ending inventory using the LIFO...

Calculate the cost of goods sold and the cost of the ending inventory using the LIFO periodic cost flow assumption. Sales 97 units at $ 18 per unit Beginning inventory 88 units at $ 6 per unit Purchases 58 units at $ 10 per unit Calculate the cost of goods sold using the LIFO periodic cost flow assumption. Units x Cost per Unit = Total Cost Units from beginning inventory x = Units from purchase x = Cost of Goods...

Subjects