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
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 |
Cost of Ending Inventory |
|
|
|
Cost of Goods Sold
|
|
|
|
1b) 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) | $3,000 | $3,000 | $3,000 |
Cost of Goods Sold |
|
|
|
Gross Profit |
|
|
|
Which method results in the highest inventory balance on the Balance Sheet?
Which method results in the highest cost of goods sold expense on the Income Statement?
Which method results in the highest Gross Profit?
Which method will result in the highest tax expense?
Calculate inventory turnover (cost of goods sold expense/average inventory) under each of the three methods.
What conclusions can you draw regarding these methods?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started