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
Horngren's Accounting: The Managerial Chapters, Student Value Edition (12th Edition)
- (Learning Objectives 1, 2: Show how to account for inventory transactions; applythe FIFO cost method) Griffin Company’s inventory records for its retail division show thefollowing at December 31:Dec 1 Beginning inventory ............... 9 units @ $165 = $1,48515 Purchase................................. 5 units @ 166 = $ 83026 Purchase................................. 13 units @ 175 = $2,275At December 31, 11 of these units are on hand. Journalize the following for Griffin Companyunder the perpetual system:1. Total December purchases in one summary entry. All purchases were on credit.2. Total December sales and cost of goods sold in two summary entries. The selling price was$500 per unit, and all sales were on credit. Assume that Griffin uses the FIFO inventorymethod.3. Under FIFO, how much gross profit would Griffin earn for the month ending December 31?What is the FIFO cost of Griffin Company’s ending inventory?arrow_forwardLearning Objectives 1, 2: Show how to account for inventory in a perpetual systemusing the average-costing method) Western Trading Company purchases inventory in cratesof merchandise; each crate of inventory is a unit. The fiscal year of Western Trading ends eachJanuary 31. Assume you are dealing with a single Western Trading store in Nashville, Tennessee. The Nashville store began the year with an inventory of 20,000 units that cost a total of$1,060,000. During the year, the store purchased merchandise on account as follows:July (29,000 units at $59) ..................................... $1,711,000November (49,000 units at $63) ........................... 3,087,000December (59,000 units at $69)............................ 4,071,000Total purchases..................................................... $8,869,000Cash payments on account totaled $8,541,000. During fiscal year 2018, the store sold 155,000units of merchandise for $15,887,500, of which $4,900,000 was for cash and the balance…arrow_forward(Learning Objective 2: Compare inventory by three methods) SWAT Surplus beganMarch 2018 with 100 tents that cost $10 each. During the month, the company made the following purchases at cost:1826Mar 6 110 tents @ $20120 tents @ $2540 tents @ $30= $2,200= 3,000= 1,200The company sold 318 tents, and at March 31, the ending inventory consisted of 52 tents. Thesales price of each tent was $52.Requirements1. Determine the cost of goods sold and ending inventory amounts for March under theaverage-cost, FIFO, and LIFO costing methods. Round the average cost per unit to twodecimal places, and round all other amounts to the nearest dollar.2. Explain why cost of goods sold is highest under LIFO. Be specific.3. Prepare the SWAT Surplus income statement for March. Report gross profit. Operatingexpenses totaled $3,250. The company uses average costing for inventory. The income taxrate is 36%.arrow_forward
- (Learning Objectives 4, 5: Compute gross profit; estimate inventory using the grossprofit method) Cleveland Company, a camera store, lost some inventory in a fire on October15. To file an insurance claim, the company must estimate its October 15 inventory using thegross profit method. For the past two years, Cleveland Company’s gross profit has averaged41% of net sales. Its inventory records reveal the following data:Inventory, October 1................ $ 57,700Transactions October 1–15:Purchases ................................. 490,800Purchase discounts................... 17,000Purchase returns....................... 70,900Sales......................................... 660,000Requirements1. Estimate the cost of the lost inventory using the gross profit method.2. Prepare the income statement for October 1 to October 15 for this product through grossprofit. Show the detailed computations of cost of goods sold in a separate schedule.arrow_forward(Learning Objective 4: Compute and evaluate gross profit percentage and inventory turnover) The Red Wagon Shop had the following inventory data:2017Ending inventory at:FIFO Cost ...............LIFO Cost...............2018$27,92012,510$ 30,50020,150Cost of goods sold at:FIFO Cost ...............LIFO Cost...............Sales revenue ...............$ 87,63097,980138,000Company managers need to know the company’s gross profit percentage and rate of inventoryturnover for 2018 under1. FIFO.2. LIFO.Which method produces a higher gross profit percentage? A higher inventory turnover?arrow_forward(Learning Objectives 1, 2: Show how to account for inventory transactions; applythe FIFO cost method) Accounting records for Allegheny Corporation yield the followingdata for the year ended June 30, 2018:Inventory, June 30, 2017.......................................................................... $ 13,000Purchases of inventory (on account)......................................................... 53,000Sales of inventory—82% on account; 18% for cash (cost $46,000).........Inventory at FIFO, June 30, 2018 ............................................................73,00020,000Requirements1. Journalize Allegheny’s inventory transactions for the year under the perpetual system.2. Report ending inventory, sales, cost of goods sold, and gross profit on the appropriatefinancial statementarrow_forward
- (Learning Objectives 1, 2: Show how to account for inventory transactions; applythe FIFO cost method) Accounting records for Jubilee Corporation yield the following datafor the year ended June 30, 2018 (assume sales returns are non-existent):Inventory, June 30, 2017.......................................................................... $ 7,000Purchases of inventory (on account)......................................................... 61,000Sales of inventory—77% on account; 23% for cash (cost $49,000).........Inventory at FIFO, June 30, 2018 ............................................................100,00019,000Requirements1. Journalize Jubilee’s inventory transactions for the year under the perpetual system.2. Report ending inventory, sales, cost of goods sold, and gross profit on the appropriatefinancial statement.arrow_forwardUsing 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_forward(Learning Objective 2: Calculate purchases by analyzing inventory account activity)On Willow Grove Department Stores’ most recent balance sheet, the balance of its inventory at the beginning of the year was $12,000. At the end of the year, the inventory balancewas $14,500. During that year, its cost of goods sold was $55,000. All purchases of inventorythroughout the year were on account. What was the total of Willow Grove’s purchases duringthe year?arrow_forward
- (Learning Objective 2: Compare gross profit—FIFO vs. LIFO—falling prices)Suppose a Target store in Chicago, Illinois, ended November 2018 with 500,000 units of merchandise that cost $8.00 each. Suppose the store then sold 110,000 units for $960,000 duringDecember. Further, assume the store made two large purchases during December as follows:Dec 8 35,000 units @ $6.10 = $213,50028 50,000 units @ $5.20 = $260,000Requirements1. Calculate the store’s gross profit under FIFO and LIFO at December 31.2. What caused the FIFO and LIFO gross profit figures to differ?arrow_forward(Learning Objectives 1, 2, 3: Apply GAAP for sales, sales returns, and salesdiscounts) Pastel Interiors reported the following transactions in June:June 210111519Sold merchandise on account to Elisa Birch, $700, terms 1/10, n/30.Sold merchandise on account to Melissa Movens, $2,400, terms 1/10, n/30.Collected payment from Elisa Birch for June 2 sale.Movens returned $1,400 of the merchandise purchased on June 10.Collected payment from Movens for the balance of the June 10 sale.Requirements1. Record the foregoing transactions in the journal of Pastel Interiors using the gross method.(You do not need to make the cost of sales journal entries; assume that these entries will bemade by the company when it makes its other adjusting entries at period end.)2. Calculate the amount of gross sales minus sales discounts for the month of Junearrow_forward2: Record the inventory transaction in the month of june 2020, Under LIFO , FIFO and AVG find the closing inventory at the end of the month. In this question value (x) is your UNIVERSITY ROLL NUMBER Date Transaction Details 1-June Balance 800 units @ 10 Per unit 3-June Purchase 100 Units @ (X) Per unit (157) 8-June Unit Sold 100 19-June Purchase 400 Units @ (X) Per Unit (157 25-June Unit Sold 800arrow_forward