In: Accounting
You are provided with the following information for Sunland Inc. Sunland Inc. uses the periodic system of accounting for its inventory transactions.
March | 1 | Beginning inventory 1,950 liters at a cost of 60¢ per liter. | ||
March | 3 | Purchased 2,475 liters at a cost of 65¢ per liter. | ||
March | 5 | Sold 2,320 liters for $1.10 per liter. | ||
March | 10 | Purchased 3,820 liters at a cost of 72¢ per liter. | ||
March | 20 | Purchased 2,580 liters at a cost of 80¢ per liter. | ||
March | 30 | Sold 5,160 liters for $1.25 per liter. |
1 - Calculate the value of ending inventory
that would be reported on the balance sheet, under each of the
following cost flow assumptions. (Round answers to 2
decimal places, e.g. 125.25.)
(1) | Specific identification method assuming: | ||
(i) | The March 5 sale consisted of 1,000 liters from the March 1 beginning inventory and 1,320 liters from the March 3 purchase; and | ||
(ii) | The March 30 sale consisted of the following number of units sold from beginning inventory and each purchase: 500 liters from March 1; 545 liters from March 3; 2,900 liters from March 10; 1,215 liters from March 20. | ||
(2) | FIFO | ||
(3) | LIFO |
2 - Prepare partial income statements through gross profit, under each of the following cost flow assumptions. (Round answers to 2 decimal places, e.g. 125.25.)
(1) | Specific identification method assuming: | ||
(i) | The March 5 sale consisted of 1,000 liters from the March 1 beginning inventory and 1,320 liters from the March 3 purchase; and | ||
(ii) | The March 30 sale consisted of the following number of units sold from beginning inventory and each purchase: 500 liters from March 1; 545 liters from March 3; 2,900 liters from March 10; 1,215 liters from March 20. | ||
(2) | FIFO | ||
(3) |
LIFO |
Income statement (partial)
Specific Identification | FIFO | LIFO |
sales revenue | ||
beginning inventory | ||
purchases | ||
cost of goods for sale | ||
ending of inventory | ||
cost of goods sold | ||
gross profit (loss) |
Correct Answer:
Specific identification |
FIFO |
LIFO |
|
Cost of Ending Inventory |
$ 2,420.9 |
$ 2,615 |
$ 2,077 |
Partial Income statement |
|||
FIFO |
LIFO |
Specific identification |
|
Sales Revenue |
$ 9,002.00 |
$ 9,002.00 |
$ 9,002.00 |
Cost of Goods sold: |
|||
Beginning Inventory |
$ 1,170.00 |
$ 1,170.00 |
$ 1,170.00 |
Add: Purchases |
$ 6,423.15 |
$ 6,423.15 |
$ 6,423.15 |
Cost of goods available for sale |
$ 7,593.15 |
$ 7,593.15 |
$ 7,593.15 |
Less: Ending Inventory |
$ 2,614.80 |
$ 2,076.75 |
$ 2,420.90 |
Less: Cost of goods sold |
$ 4,978.35 |
$ 5,516.40 |
$ 5,172.25 |
Gross Profit |
$ 4,023.65 |
$ 3,485.60 |
$ 3,829.75 |
Working:
Cost of Goods Available for sale |
|||
Litres |
Cost per Litre |
value |
|
Beginning Inventory |
1950 |
$ 0.60 |
$ 1,170.0 |
Purchases |
2475 |
$ 0.65 |
$ 1,608.8 |
Purchases |
3820 |
$ 0.72 |
$ 2,750.40 |
Purchases |
2580 |
$ 0.80 |
$ 2,064.0 |
Total |
10825 |
$ 7,593.15 |
FIFO |
|||||||
A |
Total Litres Available for sale |
10825 |
$ 7,593 |
||||
Litres Sold |
7480 |
||||||
Ending Inventory Litres |
3345 |
||||||
Valuation |
|||||||
Cost of Goods Sold |
1950 |
$ 0.60 |
$ 1,170.00 |
||||
2475 |
$ 0.65 |
$ 1,609 |
|||||
3055 |
$ 0.72 |
$ 2,199.60 |
|||||
B |
Cost of Goods Sold |
7480 |
Litres |
$ 4,978 |
|||
A-B |
Ending Inventory |
3345 |
Litres |
$ 2,615 |
|||
LIFO |
|||||||
A |
Total Litres Available for sale |
10825 |
$ 7,593 |
||||
Litres Sold |
7480 |
||||||
Ending Inventory Litres |
3345 |
||||||
Valuation |
|||||||
Cost of Goods Sold |
2580 |
$ 0.80 |
2,064.00 |
||||
3820 |
$ 0.72 |
2,750.40 |
|||||
1080 |
$ 0.65 |
702.00 |
|||||
B |
Cost of Goods Sold |
7480 |
Litres |
$ 5,516.40 |
|||
A-B |
Ending Inventory |
3345 |
Litres |
$ 2,076.75 |
|||
Specific Identifications |
Cost of Goods Available for sale |
Cost of goods sold |
Ending Inventory |
||||||
No. of Litres |
Cost per unit |
Cost of goods available for sale |
No. of Litres |
Cost per unit |
Cost of goods sold |
No. of Litres |
Cost per unit |
Ending Inventory |
|
Beginning inventory |
1950 |
$ 0.60 |
$ 1,170.00 |
1500 |
$ 0.60 |
$ 900 |
450 |
$ 0.60 |
$ 270.00 |
Purchases: |
|||||||||
03-Mar |
2475 |
$ 0.65 |
$ 1,608.75 |
1865 |
$ 0.65 |
$ 1,212 |
610 |
$ 0.65 |
$ 396.50 |
10-Mar |
3820 |
$ 0.72 |
$ 2,750.40 |
2900 |
$ 0.72 |
$ 2,088 |
920 |
$ 0.72 |
$ 662.40 |
20-Mar |
2580 |
$ 0.80 |
$ 2,064.00 |
1215 |
$ 0.80 |
$ 972 |
1365 |
$ 0.80 |
$ 1,092.00 |
Total |
10825 |
$ - |
$ 7,593.15 |
7480 |
$ 5,172 |
3345 |
$ 2,420.90 |
Litres |
Selling price |
Total |
|
05-Mar |
2320 |
$ 1.10 |
$ 2,552.00 |
30-Mar |
5160 |
$ 1.25 |
$ 6,450.00 |
Total Revenue |
$ 9,002.00 |
End of Answer.
Thanks