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):
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):
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:
Substituting the given values:
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).
The gross profit under FIFO would then be:
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:
1. As Reported (using LIFO)
2. Under FIFO
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:
- How does the change in the LIFO reserve affect taxes?
- Why might a company prefer using LIFO over FIFO for inventory accounting?
- What would happen if the company had a LIFO liquidation?
- How does inventory accounting affect the company's cash flow?
- 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