Concept explainers
Accounting for inventory using the perpetual inventory system—FIFO, LIFO, and weighted-average, and comparing FIFO, LIFO, and weighted-average
Learning Objective 2, 3 5. FIFO GP $5,235
Steel Mill began August with 50 units of iron inventory that cost 535 each. During August, the company completed the following inventory transactions:
Units | Unit Cost | unit Sales Price | ||
Aug.3 | Sale | 45 | $85 | |
8 | Purchase | 90 | $54 | |
21 | Sale | 85 | 88 | |
30 | purchase | 15 | 58 |
Requirements
1. Prepare a perpetual inventory record for the merchandise inventory using the FIFO inventory costing method.
2. Prepare a perpetual inventory record for the merchandise inventory using the LIFO inventory costing method.
3. Prepare a perpetual inventory record for the merchandise inventory using the weighted-average inventory costing method.
4. Determine the company’s cost of goods sold for August using FIFO, LIFO, and weighted-average inventory costing methods.
5. Compute gross profit for August using FIFO, LIFO, and weighted-average inventory costing method 6. If the business wanted to maximize gross profit, which method would it select?
Want to see the full answer?
Check out a sample textbook solutionChapter 6 Solutions
EBK HORNGREN'S ACCOUNTING
- Using Excel to Cost Inventory Student Work Area PROBLEM Required: Provide input into cells shaded in yellow in this template.Use only mathematical formulas with cell references to compute the unit cost and the cost of ending inventory. In its first month of operations, McLanie Company made three purchases. Information concerning these purchases and units on hand are: Units Cost per Unit Compute the cost of the ending inventory under the average-cost method in a periodic inventory system. 300 $ 6.00 400 8.00 500 9.00 Weighted-average unit cost Units on hand at period end 200 Round unit cost to 3 decimals using the ROUND function Purchases of merchandise were made in the sequence listed above. Cost of ending…arrow_forwardDo not give answer in imagearrow_forwardCengageNOWv2 | Online teaching and learning resource from Cengage Learning Close Window eBook Show Me How Weighted Average Cost Flow Method Under Perpetual Inventory System The following units of a particular item were available for sale during the calendar year: Jan. 1 Inventory 30,000 units at $30.00 Mar. 18 Sale 24,000 units May 2 Purchase 54,000 units at $31.00 Aug. 9 Sale 45,000 units Oct. 20 Purchase 21,000 units at $32.10 The firm uses the weighted average cost method with a perpetual inventory system. Determine the cost of merchandise sold for each sale and the inventory balance after each sale. Present the data in the form illustrated in Exhibit 5. Round unit cost to two decimal places, if necessary.arrow_forward
- Problem: Module 2 Textbook Problem 10 Learning Objective: Module 2-7 Show how different inventory cost flow methods (specific identification, FIFO, LIFO, and weighted average) affect financial statements The Shirt Shop had the following transactions for T-shirts for Year 1, its first year of operations: Jan. 20 Apr. 21 July 25 Sept. 19 Purchased Purchased Purchased Purchased 400 units @ 90 units @ 250 units 60 units $ 4- $5- $7 = $9- During the year. The Shirt Shop sold 650 T-shirts for $14 each. Required Gross margin $1,600 450 1,750 540 a. Compute the amount of ending inventory The Shirt Shop would report on the balance sheet, assuming the following cost flow assumptions: (1) FIFO, (2) LIFO, and (3) weighted average. b. Compute the difference in gross margin between the FIFO and LIFO cost flow assumptions. Complete this question by entering your answers in the tabs below. Required A Required B Compute the difference in gross margin between the FIFO and LIFO cost flow assumptions.…arrow_forwardll. Subject Accountingarrow_forwardQuestion 21: A company that uses the perpetual inventory system sold goods to a customer cash on September 10 for $20. The company has the following inventory information: January 1 Beginning Inventory, 15 units at $9 each -June 10 Purchase, 17 units at $10 each September 10 Sale, 8 units The company uses the LIFO method of inventory costing. Calculate the cost of goods sold for the sale on September 10. a) $48 b) $160 c) $88 d) $170 e) $80arrow_forward
- Assignment 4: Inventory Valuation 1. Purchase Date Quantities Unit Price Total February 1 February 13 February 22 February 28 175 25 50 90 May 1 May 13 May 12 May 30 The company sold 220 coffee mugs by February 28. Calculate the COGS and the Ending Inventory using FIFO, LIFO and Weighted Average. Assume the inventory was 50 at the beginning of the month @ $2.25 each. Show all your Work. $2.25 $393.75 $3.25 $81.25 $3.50 $175.00 $4.00 $360.00 2. Purchase Date Quantities Unit Price Total 75 125 150 210 $5 $375 $6 $750 $7 $1,050 $8 $1,680 The company sold 110 towels by May 31. Calculate the COGS and the Ending Inventory using FIFO, LIFO and Weighted Average. Assume the inventory was 25 at the beginning of the month @ $5.00 each. Show all your work.arrow_forwardproblem session purchases and sales of a particular product during the year are shown below: may. 1 Beginning Inventory 1,500 units @ $ 10 may. 18 Purchase 1,250 units @ $ 12 may 20 Sold 1,500 units @ $ 20 may. 25 Purchase 1,750 units @ $ 14 may. 27 Sold 1,750 units @ $ 25 may. 29 Purchase 500 units @ $ 15 Assuming that company uses perpetual inventory system, determine the cost of goods sold and compute the ending inventory as of may. 31 and make the journal entry for may. 27 transaction by using inventory subsidiary ledger for LIFO cost flow assumption.arrow_forwardReview Score Review Results by Study Objective Keaton Accessories uses a perpetual inventory system. The company's beginning inventory of a particular product and its purchases during the month of January were as follows: Quantity Unit Cost Total Cost Beginning Inventory (Jan. 1) 180 $40 $7,200 Purchase (Jan. 9) 90 45 4,050 Purchase (Jan. 21) 90 46 4,140 Total 360 $15,390 On January 24, Keaton sold 200 units of this product. The other 160 units remain in inventory at January 31. i.) Determine the cost of goods sold using each of the following flow assumptions: LIFO FIFO Average Cost ii.) Determine the cost of the 160 units in inventory at January 31 using each of the following flow assumptions: LIFO FIFO Average Cost ***** *** x**** ****arrow_forward
- Sd Subject: acountingarrow_forwardConcept Videos i es Required information UNIT 30s $45 May 1 April 5 April 10 April 15 April 201 April 22 # Knowledge Check 01 Assume that we use a perpetual inventory system and that five identical units are purchased at the following four dates and costs: 3 $ 10 $ 12 0:00-0:54 $14 $16 - $17 Cost of the ending inventory $ One unit is sold on April 25. The company uses the weighted average inventory costing method. Identify the cost of the ending inventory on the balance sheet. Note: Round your answer to 2 decimal places. 4 % 5 H 6 Inarrow_forwardPeriod Inventory using FIFO & LIFO There are 15 units of the item in the physical inventory at December 31. Determine the inventory cost uniting the First-in, first-out (FIFO) and the last-in first-out(LIFO) method. (Round per unit cost two decimal places and your final answer to the nearest whole dollar.) Trying to create my spreadsheet to have it all setup. Thank you. Jan 1 Inventory 16 units $49 $784 Jul 7 Purchase 15 units $52 $780 Nov 23 Purchase 19 units $54 $1026 50 total units $2590 (Total) A. FIFO___________ B. LIFO __________arrow_forward
- Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,Century 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:Cengage