Purchase Solution

Inventory Using FIFO and LIFO

Not what you're looking for?

Ask Custom Question

Compute inventory and cost of goods sold using FIFO and LIFO

Andrea's Boards sells a snowboard, Xpert, that is popular with snowboard enthusiasts. information relating to Andrea's purchase of Xpert snowboards during September is shown below. During the same month, 121 Xpert snowboards were sold. Andrea's uses a periodic inventory system.

Date Explanation Units Unit Cost Total Cost
Sept 1 Inventory 26 $97 $2,522
Sept 12 Purchases 45 102 4,590
Sept 19 Purchases 20 104 2,080
Sept 26 Purchases 50 105 5,250
Totals 141 $14,442

Instructions
a) Compute the ending inventory at September 30 and cost of goods sold using the FIFO and LIFO methods. Prove the amount allocated to cost of goods sold under each method.
b) For both FIFO and LIFO, calculate the sum of ending inventory and cost of goods sold. What do you notice about the answers you found for each method?

Attachments
Purchase this Solution
Solution Summary

In this solution, we use LIFO and FIFO to calculate the sum of the ending inventory.

Solution Preview

Dear student,
Solution is provided in a separate excel file attached.

Periodic system-FIFO
Cost of Goods available for sale
Periodi Explanation Units Unit cost Total cost
1-Sep Beginning inventory 26 97.00 2522
12-Sep Purchase 45 102.00 4590
19-Sep Purchase 20 104.00 2080
26-Sep Purchase 50 105.00 5250
Cost of Goods available for sale 141 14442

Ending inventory
Date Units Unit cost Total cost
26-Sep 20 $105.00 2100

Total 20 2100

In First in First out assumption 121 units from first three lots are sold.20 units unsold belongs to last lot of 26th Sept as such
valued at $105 each i.e. 20X105 = $2100
Cost of goods sold represents difference between total cost of goods available for ...

Purchase this Solution
Free BrainMass Quizzes
Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

Lean your Process

This quiz will help you understand the basic concepts of Lean.

Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

View More Free Quizzes
Related BrainMass Solutions

  • Inventory calculations in Financial Accounting

    the ending inventory at September 30 using the FIFO and LIFO methods.

  • Financial Accounting : FIFO and LIFO

    12638 Financial Accounting : FIFO and LIFO Please see the attached file for the fully formatted problems. Compute inventory and cost of goods sold using FIFO and LIFO.

  • FIFO vs LIFO

    Would an analyst consider ending inventory asset value more useful if computed using LIFO or FIFO? b. Would an analyst consider cost of goods sold more useful if computed using LIFO or FIFO? c.

  • FiFO and LIFO Inventory

    This solution illustrates how to compare the FIFO and LIFO values of inventory and the reported net income under each method. All steps are shown.

  • FIFO and LIFO

    160020 Cost-Flow Assumptions - FIFO and LIFO Using Periodic and Perpetual Systems Cost-flow assumptions-FIFO and LIFO using periodic and perpetual systems.

  • LIFO, FIFO, Average cost; Perioidic and Perpetual Methods

    using weighted average cost is $480 LIFO, FIFO, Average cost; Perioidic and Perpetual Methods are examined.

  • FIFO, LIFO Average Cost

    Using the periodic inventory system determine ending inventory under FIFO. 2. Using the periodic inventory system determine cost of goods sold under FIFO. 3. Using the periodic inventory system determine ending inventory under LIFO. 4.

  • Inventory profit and LIFO

    Since, a company is a going concern, inventory must be replacement and replacement cost is more relevant. The difference in profits by using replacement cost and FIFO method of using inventory is called the inventory profit.

  • Calculate FIFO and LIFO using perpetual and periodic inventory methods

    Assuming that perpetual records are maintained and they tie into the general ledger, calculate the ending inventory using (1) FIFO and (2) LIFO. See attached file. The solution calculates FIFO and LIFO using perpetual and periodic inventory methods.

  • Important information about Inventory valuation

    FIFO would show the highest net income The solution explains inventory calculations using FIFO, LIFO and average cost

View More Related Solutions