Question

In: Accounting

Problem 2. You have the following information for Divine Diamonds. The company uses the periodic method...

Problem 2.

You have the following information for Divine Diamonds. The company uses the periodic method of accounting for its inventory transactions. Divine Diamonds 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 $350 each.
March 10 Purchased 350 diamonds at a cost of $375 each.
During the month, Devine Diamonds sold 500 diamonds for $650 each.

Problem 2: Instructions

(a) Assume that Divine Diamonds uses the specific identification cost flow method.

1. Demonstrate how Divine Diamonds could maximize its gross profit for the month by specifically selecting which diamonds to sell.

2. Demonstrate how Divine Diamonds could minimize its gross profit for the month by selecting which diamonds to sell.

(b) Assume that Devine Diamonds uses the FIFO cost flow assumption. Calculate cost of goods sold. How much gross profit would Devine Diamonds report under this cost flow assumption?

(c) Assume that Devine Diamonds uses the LIFO cost flow assumption. Calculate cost of goods sold. How much gross profit would the company report under this cost flow assumption?

(d) Assume that Devine Diamonds uses the weighted average cost flow assumption. Calculate cost of goods sold. How much gross profit would Devine Diamonds report under this cost flow assumption?

(e) Which cost flow method should Gold Nugget Gems select? Explain.

Solutions

Expert Solution

(a)
1.

Cost of goods available for sale Cost of Goods Sold Ending Inventory
Date Activity Units Unit Price Amount Units Unit Price Amount Units Unit Price Amount
Mar-01 Beginning Inventory 150 $         300.00 $          45,000 150 $          300.00 $          45,000
Mar-03 Purchase 200 $         350.00 $          70,000 200 $          350.00 $          70,000
Mar-10 Purchase 350 $         375.00 $       1,31,250 150 $          375.00 $          56,250 200 $          375.00 $          75,000
Total 700 $       2,46,250 500 $       1,71,250 200 $          75,000
Sales Revenue $       3,25,000
Cost of Goods Sold $       1,71,250
Gross Profit $       1,53,750

2.

Cost of goods available for sale Cost of Goods Sold Ending Inventory
Date Activity Units Unit Price Amount Units Unit Price Amount Units Unit Price Amount
Mar-01 Beginning Inventory 150 $         300.00 $          45,000 150 $          300.00 $          45,000
Mar-03 Purchase 200 $         350.00 $          70,000 150 $          350.00 $          52,500 50 $          350.00 $          17,500
Mar-10 Purchase 350 $         375.00 $       1,31,250 350 $          375.00 $       1,31,250
Total 700 $       2,46,250 500 $       1,83,750 200 $          62,500
Sales Revenue $       3,25,000
Cost of Goods Sold $       1,83,750
Gross Profit $       1,41,250

(b) FIFO

Sales Revenue $       3,25,000
Cost of Goods Sold $       1,71,250
Gross Profit $       1,53,750

(c) LIFO

Sales Revenue $       3,25,000
Cost of Goods Sold $       1,83,750
Gross Profit $       1,41,250

(d) Weighted Average

Sales Revenue $       3,25,000
Cost of Goods Sold $ 1,75,893
Gross Profit $       1,49,107

(e) FIFO method should be selected as usually inventory purchased first is sold first, moreover it will give highest gross profit hence highest net income


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 have the following information for Sheridan Company. Sheridan uses the periodic method of accounting for...
You have the following information for Sheridan Company. Sheridan uses the periodic method of accounting for its inventory transactions. Sheridan 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 $320 per diamond. March 3 Purchased 200 diamonds at a cost of $360 each. March 5 Sold 190 diamonds for $650 each. March 10 Purchased 325...
You have the following information for Crane Company. Crane uses the periodic method of accounting for...
You have the following information for Crane Company. Crane uses the periodic method of accounting for its inventory transactions. Crane 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 160 diamonds at a cost of $300 per diamond. March 3 Purchased 210 diamonds at a cost of $340 each. March 5 Sold 170 diamonds for $600 each. March 10 Purchased 325...
You have the following information for Sheffield Corp.. Sheffield uses the periodic method of accounting for...
You have the following information for Sheffield Corp.. Sheffield uses the periodic method of accounting for its inventory transactions. Sheffield 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 141 diamonds at a cost of $285 per diamond. March 3 Purchased 207 diamonds at a cost of $365 each. March 5 Sold 166 diamonds for $570 each. March 10 Purchased 328...
Happy Company uses the periodic inventory method and had the following inventory information available:                          
Happy Company uses the periodic inventory method and had the following inventory information available:                                                              Units       Unit Cost           Total Cost 1/1       Beginning Inventory               100                  $4                    $400 1/20     Purchase                                  400                  $6                    $2400 7/25     Purchase                                  200                  $7                    $1400 10/20   Purchase                                  300                  $8                    $2400 1,000                                      $6,600 A physical county if inventory on December 31 revealed that there were 400 units on hand Answer questions below and show computations supporting the answer: Assume that the company uses the FIFO...
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....
Peeke Company uses the periodic method of accounting. Peeke Company has the following inventory information summarizing...
Peeke Company uses the periodic method of accounting. Peeke Company has the following inventory information summarizing activity during November: Beginning Inventory 100 units @ $30.00 per unit Purchase #1   60 units @ $35.00 per unit Purchase #2   40 units @ $40.00 per unit Ending Inventory (physical count) 30 units Peeke's recorded 17,000 in Sales Revenue. 1. What cost is assigned to Peeke's ending inventory using Average Cost? Round interim computations to the nearest penny and your final answer to the...
Anabtawi Company uses the periodic inventory method and had the following inventory information available: ( 8...
Anabtawi Company uses the periodic inventory method and had the following inventory information available: ( 8 points) Date Explanation Number of Units Unit Cost Total Cost January 1 Beginning inventory 100 $4 $400 January 20 Purchase 400 $5 $2,000 July 25 Purchase 300 $6 $1,800 October 20 Purchase 200 $7 $1,400 Total 1000 $5,600 A physical count of inventory on December 31 revealed that there were 300 units on hand. Assume that the company uses the FIFO method. The Ending...
Anabtawi Company uses the periodic inventory method and had the following inventory information available: ( 8...
Anabtawi Company uses the periodic inventory method and had the following inventory information available: ( 8 points) Date Explanation Number of Units Unit Cost Total Cost January 1 Beginning inventory 100 $4 $400 January 20 Purchase 400 $5 $2,000 July 25 Purchase 300 $6 $1,800 October 20 Purchase 200 $7 $1,400 Total 1000 $5,600 A physical count of inventory on December 31 revealed that there were 300 units on hand. Assume that the company uses the FIFO method. The Ending...
SJH Company uses the periodic inventory method and had the following inventory information available:                          &n
SJH Company uses the periodic inventory method and had the following inventory information available:                                                                Units              Unit Cost           Total Cost 1/1         Beginning Inventory                    100                    $4                $   400 1/20       Purchase                                     400                    $5                     2,000 7/25       Purchase                                     200                    $7                     1,400 10/20     Purchase                                  300                    $8                 2,400                                                                1,000                                           $6,200 A physical count of inventory on December 31 revealed that there were 350 units on hand. Instructions Answer the following independent questions and show computations supporting your answers. Q.  Assume that the company uses...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT