Question

In: Accounting

You are provided with the following information for Sunland Inc. Sunland Inc. uses the periodic system...

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)

Solutions

Expert Solution

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


Related Solutions

You have the following information for Sunland Company. Sunland uses the periodic method of accounting for...
You have the following information for Sunland Company. Sunland uses the periodic method of accounting for its inventory transactions. Sunland only carries one brand and size of diamonds—all are identical. Each batch of diamonds purchased is carefully coded and marked with its purchase cost. March 1 Beginning inventory 150 diamonds at a cost of $300 per diamond. March 3 Purchased 200 diamonds at a cost of $340 each. March 5 Sold 170 diamonds for $630 each. March 10 Purchased 345...
You are provided with the following information for Barton Inc. Barton Inc. uses the periodic method...
You are provided with the following information for Barton Inc. Barton Inc. uses the periodic method of accounting for its inventory transactions. March 1 Beginning inventory 2,000 liters at a cost of 60¢ per liter. March 3 Purchased 2,500 liters at a cost of 65¢ per liter. March 5 Sold 2,300 liters for $1.05 per liter. March 10 Purchased 4,000 liters at a cost of 72¢ per liter. March 20 Purchased 2,500 liters at a cost of 80¢ per liter....
You are provided with the following information for Novak Corp. Novak Corp. uses the periodic system...
You are provided with the following information for Novak Corp. Novak Corp. uses the periodic system of accounting for its inventory transactions. March 1 Beginning inventory 1,930 liters at a cost of 60¢ per liter. March 3 Purchased 2,450 liters at a cost of 65¢ per liter. March 5 Sold 2,395 liters for $1.05 per liter. March 10 Purchased 4,190 liters at a cost of 72¢ per liter. March 20 Purchased 2,510 liters at a cost of 80¢ per liter....
Sunland Company uses a periodic inventory system. Details for the inventory account for the month of...
Sunland Company uses a periodic inventory system. Details for the inventory account for the month of January 2022 are as follows: Units Per unit price Total Balance, 1/1/2022 290 $5.00 $1450 Purchase, 1/15/2022 140 ..5.10 714 Purchase, 1/28/2022 140 ..5.30 742 An end of the month (1/31/2022) inventory showed that 230 units were on hand. If the company uses FIFO and sells the units for $10 each, what is the gross profit for the month? $1695 $1705 $3400 $2300
[The following information applies to the questions displayed below.] Beck Inc. uses a periodic inventory system....
[The following information applies to the questions displayed below.] Beck Inc. uses a periodic inventory system. At the end of the annual accounting period, December 31 of the current year, the accounting records provided the following information for product 2: Units Unit Cost Inventory, December 31, prior year 6,900 $ 13 For the current year: Purchase, March 5 18,900 11 Purchase, September 19 9,900 7 Sale ($29 each) 7,900 Sale ($31 each) 15,900 Operating expenses (excluding income tax expense) $...
Sunland uses the periodic inventory system. For the current month, the beginning inventory consisted of 7200...
Sunland uses the periodic inventory system. For the current month, the beginning inventory consisted of 7200 units that cost $14.00 each. During the month, the company made two purchases: 2900 units at $15.00 each and 11900 units at $15.50 each. Sunland also sold 12700 units during the month. Using the average cost method, what is the amount of cost of goods sold for the month?
Beck Inc. uses a periodic inventory system. At the end of the annual accounting period, December 31 of the current year, the accounting records provided the following information for product 2:
  Beck Inc. uses a periodic inventory system. At the end of the annual accounting period, December 31 of the current year, the accounting records provided the following information for product 2:       Units Unit Cost Inventory, December 31, prior year       6,900     $ 13   For the current year:                   Purchase, March 5       18,900       11   Purchase, September 19...
Larkspur, Inc. uses a periodic inventory system and reports the following for the month of June....
Larkspur, Inc. uses a periodic inventory system and reports the following for the month of June. Date Explanation Units Unit Cost Total Cost June 1 Inventory 105 $5 $ 525 12 Purchases 375 6 2,250 23 Purchases 205 7 1,435 30 Inventory 240 Calculate weighted-average unit cost. (Round answer to 3 decimal places, e.g. 5.125.) Weighted-average unit cost $enter a weighted-average unit cost in dollars eTextbook and Media       Compute the cost of the ending inventory and the cost...
McMillan Company uses the periodic inventory system. It has compiled the following information in order to...
McMillan Company uses the periodic inventory system. It has compiled the following information in order to prepare the financial statements at December 31, 2014: Gross sales during 2014 $2,000,000 Sales returns and allowances during 2014 50,000 Begining inventory, January 1, 2014 100,000 Ending inventory, December 31, 2014 120,000 Purchases during 2014 750,000 Required: Calculate each of the following: A. Cost of goods available for sale B. Cost of goods sold C. Gross profit
Calvin Company uses a periodic inventory system. They had the following information concerning their inventory for...
Calvin Company uses a periodic inventory system. They had the following information concerning their inventory for the month of March. Units Cost Per Unit Beginning Inventory (March 1) 250 $12 Purchase (March 25th) 130 $13 Purchase (March 28th) 285 $15 Sale (March 30th) 350 1. If the company uses a FIFO inventory method, what will be COST OF GOODS SOLD for the month of March? (please only enter positive numbers) Use the same information as for Question 1 If the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT