Question: Given the following data, fill in the table FOR JANUARY using the three cost flow assumptions given. That is, indicate the COST of ending inventory

  1. Given the following data, fill in the table FOR JANUARY using the three cost flow assumptions given. That is, indicate the COST of ending inventory that will appear on the Balance Sheet and the COST of goods sold expense that will appear on the Income Statement.
Date Units Cost per unit Total cost
1/1 beginning inventory 40 $10 $400
1/10 purchase of inventory 20 $20 $400
1/15 purchase of inventory 20 $22 $440
Available for sale 80 $1,240
Ending inventory 20

Number of units sold is 60 in January (80 20 ending inventory).

FIFO LIFO Average Cost ($1,240/80units = $15.50)
Cost of Ending Inventory

Cost of Goods Sold

2. If the sales price is $50 per unit, calculate the Gross Profit FOR JANUARY as well under each of the three cost flow assumptions.

FIFO LIFO Average Cost
Sales Revenue (60 units * $50)
Cost of Goods Sold
Gross Profit

3. Which method results in the highest inventory balance on the Balance Sheet?

4. Which method results in the highest cost of goods sold expense on the Income Statement?

5. Which method results in the highest Gross Profit?

6. Which method will result in the highest tax expense?

7. Calculate inventory turnover (cost of goods sold expense/average inventory) under each of the three methods.

8. What conclusions can you draw regarding these methods?

Please help with all parts, especially # 7 and # 8.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!