Math Problem Statement

The disclosure note below is from the 2020 10-K report of Casey's General Stores, Inc., an operator of convenience stores ($ thousands).

Inventories Inventories, which consist of merchandise and fuel, are stated at the lower of cost or market. For fuel, cost is determined through the use of the first-in, first-out (FIFO) method. For merchandise inventories, cost is determined through the use of the last-in, first-out (LIFO) method. The excess of replacement cost over the stated LIFO value was $87,546 and $80,814 at April 30, 2020 and 2019, respectively. There were no material LIFO liquidations during the period presented. Below is a summary of the inventory values at April 30, 2020 and 2019.

Years Ended April 30, ($ thousands) 2020 2019 Fuel $33,695 $83,204 Merchandise 202,312 189,836 Total Inventory $236,007 $273,040

In 2020, Casey's General Stores reported sales revenue of $9,175.3 million and cost of goods sold of $7,030.6 million.

a. Calculate the amount of inventories purchased by Casey's General Stores in 2020. Round intermediate calculations and answers to one decimal place. $Answer million.

b. What amount of gross profit would Casey's General Stores have reported if the FIFO method had been used to value all inventories in 2020. Round intermediate calculations and answer to one decimal place. $Answer million

c. Calculate the gross profit margin (GPM) as reported and assuming that the FIFO method had been used to value all inventories. Round answers to two decimal places (i.e., 0.15785 = 15.79%) As reported Answer Under FIFO Answer

Solution

Part A: Calculating the Amount of Inventories Purchased by Casey's General Stores in 2020

To calculate the amount of inventories purchased, we can use the inventory equation for cost of goods sold (COGS):

COGS=Beginning Inventory+PurchasesEnding Inventory\text{COGS} = \text{Beginning Inventory} + \text{Purchases} - \text{Ending Inventory}

We are given the following data### Part A: Calculating the Amount of Inventories Purchased by Casey's General Stores in 2020

To calculate the amount of inventories purchased, we can use the inventory equation for cost of goods sold (COGS):

COGS=Beginning Inventory+PurchasesEnding Inventory\text{COGS} = \text{Beginning Inventory} + \text{Purchases} - \text{Ending Inventory}

We are given the following

  • Beginning Inventory (2019) = $273,040 thousand
  • Ending Inventory (2020) = $236,007 thousand
  • COGS = $7,030,600 thousand

Rearranging the equation to solve for Purchases:

Purchases=COGS+Ending InventoryBeginning Inventory\text{Purchases} = \text{COGS} + \text{Ending Inventory} - \text{Beginning Inventory}

Substituting the given values:

Purchases=7,030,600+236,007273,040\text{Purchases} = 7,030,600 + 236,007 - 273,040

Let's compute this value.

The amount of inventories purchased by Casey's General Stores in 2020 was $6,993.6 million.

Part B: Calculating Gross Profit if FIFO Had Been Used for All Inventories

The LIFO reserve (the excess of replacement cost over the LIFO value) was:

  • $87,546 thousand in 2020
  • $80,814 thousand in 2019

To adjust for the gross profit using FIFO for all inventories, we need to add the change in the LIFO reserve to the reported cost of goods sold (COGS).

COGS under FIFO=COGS under LIFO(LIFO Reserve in 2020LIFO Reserve in 2019)\text{COGS under FIFO} = \text{COGS under LIFO} - (\text{LIFO Reserve in 2020} - \text{LIFO Reserve in 2019})

The gross profit under FIFO would then be:

Gross Profit under FIFO=Sales RevenueCOGS under FIFO\text{Gross Profit under FIFO} = \text{Sales Revenue} - \text{COGS under FIFO}

Given values:

  • Sales Revenue = $9,175.3 million
  • Reported COGS (under LIFO) = $7,030.6 million

Now let's calculate the COGS under FIFO and the gross profit.

The gross profit under the FIFO method for all inventories in 2020 would have been $2,151.4 million.

Part C: Calculating the Gross Profit Margin (GPM)

The gross profit margin (GPM) is calculated as:

GPM=Gross ProfitSales Revenue\text{GPM} = \frac{\text{Gross Profit}}{\text{Sales Revenue}}

1. As Reported (using LIFO)

Gross Profit as Reported=Sales RevenueCOGS\text{Gross Profit as Reported} = \text{Sales Revenue} - \text{COGS} GPM as Reported=Gross Profit as ReportedSales Revenue\text{GPM as Reported} = \frac{\text{Gross Profit as Reported}}{\text{Sales Revenue}}

2. Under FIFO

GPM under FIFO=Gross Profit under FIFOSales Revenue\text{GPM under FIFO} = \frac{\text{Gross Profit under FIFO}}{\text{Sales Revenue}}

Let's calculate both gross profit margins.

Gross Profit Margins (GPM):

  • As reported (using LIFO): 23.37%
  • Under FIFO: 23.45%

Summary of Results:

a. The amount of inventories purchased in 2020 was $6,993.6 million.
b. The gross profit under FIFO would have been $2,151.4 million.
c. The gross profit margin as reported was 23.37%, and under FIFO, it would have been 23.45%.

Would you like further details or have any other questions?

Here are some related questions for further exploration:

  1. How does the change in the LIFO reserve affect taxes?
  2. Why might a company prefer using LIFO over FIFO for inventory accounting?
  3. What would happen if the company had a LIFO liquidation?
  4. How does inventory accounting affect the company's cash flow?
  5. What other financial ratios are impacted by changes in inventory methods?

Tip: FIFO tends to report higher profits in times of rising prices, while LIFO can help defer taxes.

Ask a new question for Free

By Image

Drop file here or Click Here to upload

Math Problem Analysis

Mathematical Concepts

Inventory Accounting
Gross Profit Calculation
Cost of Goods Sold
LIFO vs FIFO Accounting

Formulas

COGS = Beginning Inventory + Purchases - Ending Inventory
Purchases = COGS + Ending Inventory - Beginning Inventory
Gross Profit = Sales Revenue - COGS
Gross Profit Margin = (Gross Profit / Sales Revenue)

Theorems

Inventory Accounting under LIFO and FIFO
Impact of LIFO reserve on gross profit

Suitable Grade Level

College level - Accounting or Business Studies