SESSION:10 InventoryProblem Set B – GU4L Leadership Institute

Session:10 Inventory

Problem Set B

Principles of Accounting, Volume 1: Financial Accounting | Leadership Development – Micro-Learning Session

Rice University 2020 | Michael Laverty, Colorado State University Global Chris Littel, North Carolina State University| https://openstax.org/details/books/principles-financial-accounting

PB 1.

LO 10.1When prices are falling (deflation), which costing method would produce the highest gross margin for the following? Choose first-in, first-out (FIFO); last-in, first-out (LIFO); or weighted average, assuming that B62 Company had the following transactions for the month.

Chart showing three purchases: 10 units at $200 each, 20 units at $205 each, and 10 units at $230 each, for a total of 40 units.

Calculate the gross margin for each of the following cost allocation methods, assuming B62 sold just one unit of these goods for $400. Provide your calculations.

first-in, first-out (FIFO)
last-in, first-out (LIFO)
weighted average (AVG)

PB 2.

LO 10.2DeForest Company had the following transactions for the month.

Chart showing Beginning Inventory 500 units at $40 each for a total of 20,000, April 30 purchase of 600 units at 45 for a total of 27,000, August 15 purchase of 650 units at 40 for a total of 26,000, December 10 purchase of 700 units at 35 for a total of 24,500, with a Total (Goods Available) of 2,450 units for a total of $97,500. Ending Inventory is 550 units at a cost per unit of ?.

Calculate the ending inventory dollar value for the period for each of the following cost allocation methods, using periodic inventory updating. Provide your calculations.

first-in, first-out (FIFO)
last-in, first-out (LIFO)
weighted average (AVG)

PB 3.

LO 10.2DeForest Company had the following transactions for the month.

Calculate the ending inventory dollar value for the period for each of the following cost allocation methods, using periodic inventory updating. Provide your calculations.

first-in, first-out (FIFO)
last-in, first-out (LIFO)
weighted average (AVG)

PB 4.

LO 10.3Calculate the cost of goods sold dollar value for B74 Company for the sale on November 20, considering the following transactions under three different cost allocation methods and using perpetual inventory updating. Provide calculations for (a) first-in, first-out (FIFO); (b) last-in, first-out (LIFO); and (c) weighted average (AVG).

November 1 Beginning Inventory is 650 units at cost of $55 each, November 15 purchased 500 units at $52 each, November 20 sold 400 units for $80 each.

PB 5.

LO 10.3Use the first-in, first-out method (FIFO) cost allocation method, with perpetual inventory updating, to calculate (a) sales revenue, (b) cost of goods sold, and c) gross margin for B75 Company, considering the following transactions.

Beginning Inventory is 7,500 units at cost of $60 each, September 18 purchased 8,000 units at $55 each, September 28 sold 500 units for $100 each.

PB 6.

LO 10.3Use the last-in, first-out method (LIFO) cost allocation method, with perpetual inventory updating, to calculate (a) sales revenue, (b) cost of goods sold, and c) gross margin for B75 Company, considering the following transactions.

Beginning Inventory is 7,500 units at cost of $60 each, September 18 purchased 8,000 units at $55 each, September 28 sold 500 units for $100 each.

PB 7.

LO 10.3Use the weighted-average (AVG) cost allocation method, with perpetual inventory updating, to calculate (a) sales revenue, (b) cost of goods sold, and c) gross margin for B75 Company, considering the following transactions.

Beginning Inventory is 7,500 units at cost of $60 each, September 18 purchased 8,000 units at $55 each, September 28 sold 500 units for $100 each.

PB 8.

LO 10.3Prepare journal entries to record the following transactions, assuming perpetual inventory updating, and last-in, first-out (LIFO) cost allocation. Assume no beginning inventory.

Purchased 165 units at cost of $21 each, sold 120 units for $36 each, purchased 225 units at $27 each, sold 180 units for $39 each, purchased 210 units at $33 each.

PB 9.

LO 10.3Calculate a) cost of goods sold, b) ending inventory, and c) gross margin for B76 Company, considering the following transactions under three different cost allocation methods and using perpetual inventory updating. Provide calculations for first-in, first-out (FIFO).

Beginning Inventory is 420 units at cost of $200 each, sold 150 units for $401 each, purchased 250 units at $205 each, sold 275 units for $421 each, purchased 200 units at $215 each, sold 260 units for $441 each, Ending Inventory is 185 units.

PB 10.

PB 11.

PB 12.

LO 10.3Compare the calculations for gross margin for B76 Company, based on the results of the perpetual inventory calculations using FIFO, LIFO, and AVG.

PB 13.

LO 10.4Company Edgar reported the following cost of goods sold but later realized that an error had been made in ending inventory for year 2021. The correct inventory amount for 2021 was 12,000. Once the error is corrected, (a) how much is the restated cost of goods sold for 2021? and (b) how much is the restated cost of goods sold for 2022?

Beginning Inventory plus purchases equals Goods Available for Sale minus Ending Inventory equals Cost of Goods Sold for 2021 and 2022, respectively: 11,000 plus 135,000 equals 146,000 minus 16,000 equals 130,000; 16,000 plus 140,000 equals 156,000 minus 14,000 equals 142,000.

PB 14.

LO 10.4Assuming a company’s year-end inventory were understated by $16,000, indicate the effect (overstated/understated/no effect) of the error on the following balance sheet and income statement accounts.

Income Statement: Cost of Goods Sold
Income Statement: Net Income
Balance Sheet: Assets
Balance Sheet: Liabilities
Balance Sheet: Equity

PB 15.

LO 10.5Use the following information relating to Singh Company to calculate the inventory turnover ratio and the number of days’ sales in inventory ratio.

Table showing Sales, Cost of Goods Sold, and Average Inventory respectively for: 2021: $12,500, $8,750, $1,750; 2022: $14,000, $9,800, $2,200; 2023: $19,500, $13,650, $2,800; 2024: $20,500, $14,350, $3,000.

PB 16.

LO 10.5Use the following information relating to Medinas Company to calculate the inventory turnover ratio, gross margin, and the number of days’ sales in inventory ratio, for years 2022 and 2023.

Table showing Sales, Cost of Goods Sold, and Average Inventory respectively for: 2021: $75,000, $52,500, $8,000; 2022: $90,000, $63,000, $9,500; 2023: $100,000, $70,000, $11,000.

Session:10 Inventory

Problem Set B

©2025 GU4L.COM, ALL RIGHTS RESERVED | PRIVACY POLICY

LEARN | GROW | LEAD

Access Your Leadership Academy!

Evolutionary

Leadership Academy

Leadership

Excellence Academy

Leadership

On the Go

Audiobooks

Leadership

On the Go

Courses

Go

LEARN | GROW | LEAD

Access Your Leadership Academy!

Evolutionary

Leadership Academy

Leadership

Excellence Academy

Leadership

On the Go

Audiobooks

Leadership

On the Go

Courses

Free Leadership Resource Library

LEARN | GROW | LEAD

Access Your Free Leadership Resource Library

Leadership

Research Article

Leadership

Micro-Learning Courses