Alright. Let's try this example. So a company had the following inventory data for the month of July in its periodic inventory system. So there we go, we have the inventory and then the purchases, right? Notice that in a periodic system, we're not going to be updating the inventory every time we make a sale, right? We deal with how much cost of goods sold we had at the end of the period. So the month-end physical count noted that there were 800 units on hand, right? So this is going to be the goal of pretty much all the times when you're dealing with FIFO, LIFO, and average cost, it's going to be either to calculate COGS or to calculate the ending inventory based on the information given to you, okay? So we have to find out what COGS and ending inventory is going to be and let's do this one at a time. Let's start with FIFO, then we'll do LIFO and then we'll do average cost. So let's start here with FIFO. The first thing we want to know is how much did we sell, right? Cost of goods sold, how many units did we sell? So the first thing we want to know is how many total units were there available for sale, right? We started with an inventory balance of 1000 units, and then we purchased 500 units and 600 units, so we could say that the total units that were available for sale were 2,100 units, right? 1000 plus 500 plus 600 gives us 2,100 total units, and they tell us that 800 of those units were left at the end of the period, right? So that means if there were 2,100 total that were available for sale, we either sold them or we didn't sell them, right? And the ones we didn't sell are the 800 that are left over, right? So if we take 2,100, the total available for sale, minus the 800 that are left over at the end of the period, we know that 1300 units were sold, right? We sold 1300 units. So that's the first step to find out how many units did we actually sell and that is by taking what's left over and the total right? In this case, we're in a FIFO system, right? So the FIFO system means that the first unit we bought is the first unit we're going to sell. So in this case, our beginning balance is the first thing we're going to sell. So we're going to sell all 1000 of that beginning balance, right? We're going to sell 1300 units but we're going to eliminate that beginning balance first. So the 1000 units in beginning balance times the $20 per unit, well, that's going to be $20,000 right? $20,000 for those first 1000 units, but we sold 1300 units, right? Not just 1000. So where are those next 300 units going to come from? Well, from the first in first out, right? We want to look at the oldest units. So in this case, we already sold the beginning balance, right? Don't cross these out, I'm going to uncross them because we're going to do this a bunch of times. So we sold those already, so we need to sell 300 more and that's going to come out of this purchase, right? Because that was the first ones in. We want to sell the oldest units first, so we're going to sell 300 of those, right? We don't sell the full 500, we only sold 1300 units, the first 1000 was the beginning balance and then 300 came out of this purchase. So that's a little bit of the trick there, right? We didn't sell that entire purchase, we only sold 300 from that purchase. So 300 times the price of that purchase which was $22.40. Well, I can't do that one in my head. Let's go ahead and type this in. 22.40 times 300, that comes out to 6,720. Okay? So that means this is our cost of goods sold, right? We figured out that we sold 1300 units and now we found the cost of those units. Okay? We picked out which units we sold and this is going to be the cost. $26,720. Alright? That's our cost of goods sold in the FIFO method. Okay? So now let's go ahead and see what's left in ending inventory, right? Ending inventory is going to be everything that we didn't sell. Sell, so we sold that inventory balance at the beginning, right? We sold the beginning balance and we sold 300 units from the purchase on July 11th. So we have 800 units here that we're dealing with here, right? They told us that in the problem there were 800 units on hand at the end of the month, so which ones are on hand? It's going to be the last units we bought, right? Because we sold all of the first units, so all that's left are the last units, so we definitely know that the 600 is still on hand, the 600 from July 30th, and those 600 were at a price of $23.30 So let's go ahead and figure out what those are worth. 600 times 23.3, $13,980 for those 600 units, but there are 800 total units, right? So those last 200, well, that's the 200 that we didn't sell from this shipment on July 11th, right? So it's going to be 200 units from the July 11th shipment times $22.40. So let's see how much that comes out to. 200 times 22.4, $4,480. Okay? So there we go. Now we know the value of our ending inventory gives us $18,460. Okay? So there we go. Our ending inventory is going to have that balance and our cost of goods sold would be the other number we calculated there. Cool? So now let's see how it's different from a LIFO perspective and from an average cost perspective. Alright, let's pause here and then we'll continue with the LIFO example.
- 1. Introduction to Accounting1h 21m
- 2. Transaction Analysis1h 13m
- 3. Accrual Accounting Concepts2h 38m
- Accrual Accounting vs. Cash Basis Accounting10m
- Revenue Recognition and Expense Recognition24m
- Introduction to Adjusting Journal Entries and Prepaid Expenses36m
- Adjusting Entries: Supplies12m
- Adjusting Entries: Unearned Revenue11m
- Adjusting Entries: Accrued Expenses12m
- Adjusting Entries: Accrued Revenues6m
- Adjusting Entries: Depreciation16m
- Summary of Adjusting Entries7m
- Unadjusted vs Adjusted Trial Balance6m
- Closing Entries10m
- Post-Closing Trial Balance2m
- 4. Merchandising Operations2h 30m
- Service Company vs. Merchandising Company10m
- Net Sales28m
- Cost of Goods Sold - Perpetual Inventory vs. Periodic Inventory9m
- Perpetual Inventory - Purchases10m
- Perpetual Inventory - Freight Costs9m
- Perpetual Inventory - Purchase Discounts11m
- Perpetual Inventory - Purchasing Summary6m
- Periodic Inventory - Purchases14m
- Periodic Inventory - Freight Costs7m
- Periodic Inventory - Purchase Discounts10m
- Periodic Inventory - Purchasing Summary6m
- Single-step Income Statement4m
- Multi-step Income Statement17m
- Comprehensive Income2m
- 5. Inventory1h 55m
- Merchandising Company vs. Manufacturing Company6m
- Physical Inventory Count, Ownership of Goods, and Consigned Goods10m
- Specific Identification7m
- Periodic Inventory - FIFO, LIFO, and Average Cost23m
- Perpetual Inventory - FIFO, LIFO, and Average Cost31m
- Financial Statement Effects of Inventory Costing Methods10m
- Lower of Cost or Market11m
- Inventory Errors14m
- 6. Internal Controls and Reporting Cash1h 16m
- 7. Receivables and Investments3h 8m
- Types of Receivables8m
- Net Accounts Receivable: Direct Write-off Method5m
- Net Accounts Receivable: Allowance for Doubtful Accounts13m
- Net Accounts Receivable: Percentage of Sales Method9m
- Net Accounts Receivable: Aging of Receivables Method11m
- Notes Receivable25m
- Introduction to Investments in Securities13m
- Trading Securities31m
- Available-for-Sale (AFS) Securities26m
- Held-to-Maturity (HTM) Securities17m
- Equity Method25m
- 8. Long Lived Assets5h 1m
- Initial Cost of Long Lived Assets42m
- Basket (Lump-sum) Purchases13m
- Ordinary Repairs vs. Capital Improvements10m
- Depreciation: Straight Line32m
- Depreciation: Declining Balance29m
- Depreciation: Units-of-Activity28m
- Depreciation: Summary of Main Methods8m
- Depreciation for Partial Years13m
- Retirement of Plant Assets (No Proceeds)14m
- Sale of Plant Assets18m
- Change in Estimate: Depreciation21m
- Intangible Assets and Amortization17m
- Natural Resources and Depletion16m
- Asset Impairments16m
- Exchange for Similar Assets16m
- 9. Current Liabilities2h 19m
- 10. Time Value of Money1h 23m
- 11. Long Term Liabilities2h 45m
- 12. Stockholders' Equity2h 15m
- Characteristics of a Corporation17m
- Shares Authorized, Issued, and Outstanding9m
- Issuing Par Value Stock12m
- Issuing No Par Value Stock5m
- Issuing Common Stock for Assets or Services8m
- Retained Earnings14m
- Retained Earnings: Prior Period Adjustments9m
- Preferred Stock11m
- Treasury Stock9m
- Dividends and Dividend Preferences17m
- Stock Dividends10m
- Stock Splits9m
- 13. Statement of Cash Flows2h 24m
- 14. Financial Statement Analysis5h 25m
- Horizontal Analysis14m
- Vertical Analysis23m
- Common-sized Statements5m
- Trend Percentages7m
- Discontinued Operations and Extraordinary Items6m
- Introduction to Ratios8m
- Ratios: Earnings Per Share (EPS)10m
- Ratios: Working Capital and the Current Ratio14m
- Ratios: Quick (Acid Test) Ratio12m
- Ratios: Gross Profit Rate9m
- Ratios: Profit Margin7m
- Ratios: Quality of Earnings Ratio8m
- Ratios: Inventory Turnover10m
- Ratios: Average Days in Inventory9m
- Ratios: Accounts Receivable (AR) Turnover9m
- Ratios: Average Collection Period (Days Sales Outstanding)8m
- Ratios: Return on Assets (ROA)8m
- Ratios: Total Asset Turnover5m
- Ratios: Fixed Asset Turnover5m
- Ratios: Profit Margin x Asset Turnover = Return On Assets9m
- Ratios: Accounts Payable Turnover6m
- Ratios: Days Payable Outstanding (DPO)8m
- Ratios: Times Interest Earned (TIE)7m
- Ratios: Debt to Asset Ratio5m
- Ratios: Debt to Equity Ratio5m
- Ratios: Payout Ratio5m
- Ratios: Dividend Yield Ratio7m
- Ratios: Return on Equity (ROE)10m
- Ratios: DuPont Model for Return on Equity (ROE)20m
- Ratios: Free Cash Flow10m
- Ratios: Price-Earnings Ratio (PE Ratio)7m
- Ratios: Book Value per Share of Common Stock7m
- Ratios: Cash to Monthly Cash Expenses8m
- Ratios: Cash Return on Assets7m
- Ratios: Economic Return from Investing6m
- Ratios: Capital Acquisition Ratio6m
- 15. GAAP vs IFRS56m
- GAAP vs. IFRS: Introduction7m
- GAAP vs. IFRS: Classified Balance Sheet6m
- GAAP vs. IFRS: Recording Differences4m
- GAAP vs. IFRS: Adjusting Entries4m
- GAAP vs. IFRS: Merchandising3m
- GAAP vs. IFRS: Inventory3m
- GAAP vs. IFRS: Fraud, Internal Controls, and Cash3m
- GAAP vs. IFRS: Receivables2m
- GAAP vs. IFRS: Long Lived Assets5m
- GAAP vs. IFRS: Liabilities3m
- GAAP vs. IFRS: Stockholders' Equity3m
- GAAP vs. IFRS: Statement of Cash Flows5m
- GAAP vs. IFRS: Analysis and Income Statement Presentation5m
5. Inventory
Periodic Inventory - FIFO, LIFO, and Average Cost
Video duration:
6mPlay a video:
Related Videos