(a) (1)
Periodic Inventory System: It is a system in which the inventory is updated in the accounting records on a periodic basis such as at the end of each month, quarter or year. In other words, it is an accounting method which is used to determine the amount of inventory at the end of each accounting period.
In First-in-First-Out method, the cost of initial purchased items are sold first. The value of the ending inventory consists the recent purchased items.
To Determine: The selection of diamonds for selling that should follow by J Gems to maximize the gross profit.
(a) (1)
Explanation of Solution
To maximize gross profit, J Gems should sell the diamonds with the lowest cost.
Calculate cost of goods sold and sales revenue.
Date | Cost of goods sold | Sales revenue | ||||
Units | Cost ($) | Total cost ($) | Units | Cost ($) | Total cost ($) | |
(A) | (B) | (C) = (A) × (B) | (D) | (E) | (F) = (D) × (E) | |
March 5 | 150 | 310 | 46,500 | 180 | 600 | 108,000 |
30 | 350 | 10,500 | 390 | 650 | 253,500 | |
March 25 | 170 | 350 | 59,500 | |||
220 | 375 | 82,500 | ||||
Total | 570 | 199,000 | 570 | 361,500 |
Table (1)
Calculate gross profit.
Therefore, the gross profit is $162,500.
(2)
The selection of diamonds for selling that should follow by J Gems to minimize the gross profit.
(2)
Explanation of Solution
To minimize gross profit, J Gems should sell the diamonds with the highest cost.
Calculate cost of goods sold and sales revenue.
Date | Cost of goods sold | Sales revenue | ||||
Units | Cost ($) | Total cost ($) | Units | Cost ($) | Total cost ($) | |
(A) | (B) | (C) = (A) × (B) | (D) | (E) | (F) = (D) × (E) | |
March 5 | 180 | 350 | 63,000 | 180 | 600 | 108,000 |
390 | 650 | 253,500 | ||||
March 25 | 330 | 375 | 123,750 | |||
20 | 350 | 7,000 | ||||
40 | 310 | 12,400 | ||||
Total | 570 | $206,150 | 570 | $361,500 |
Table (2)
Calculate gross profit.
Therefore, the gross profit is $155,350.
(b)
To Calculate: The cost of goods sold and gross profit under FIFO method.
(b)
Explanation of Solution
Calculate cost of goods sold.
Step 1: Calculate cost of goods available for sale.
Cost of Goods Available for Sale | ||||
Date | Particulars | Units ($) | Unit cost ($) | Total cost ($) |
(a) | (b) | (c = a × b) | ||
March 1 | Beginning inventory | 150 | 310 | 46,500 |
March 3 | Purchase | 200 | 350 | 70,000 |
March 10 | Purchase | 330 | 375 | 123,750 |
Total | 680 | $240,250 |
Table (3)
Step 2: Calculate ending inventory under FIFO method.
FIFO Method | |||
Date | Units | Unit cost ($) | Total cost ($) |
(a) | (b) | (c = a × b) | |
March 10 | 110 | 375 | 41,250 |
Total | 110 | 41,250 |
Table (4)
Step 3: Calculate cost of goods sold under FIFO method.
Particulars | Amount ($) |
Cost of goods available for sale | 240,250 |
Less: Ending inventory | (41,250) |
Cost of goods sold | $199,000 |
Table (5)
Calculate gross profit.
Gross Profit - FIFO | |
Details | Amount ($) |
Sales | 361,500 |
Less: Cost of goods sold | (199,000) |
Gross profit | $162,500 |
Table (6)
(c)
To Calculate: The cost of goods sold and gross profit under LIFO method.
(c)
Explanation of Solution
Calculate cost of goods sold.
Step 1: Calculate cost of goods available for sale.
Cost of Goods Available for Sale | ||||
Date | Particulars | Units ($) | Unit cost ($) | Total cost ($) |
(a) | (b) | (c = a × b) | ||
March 1 | Beginning inventory | 150 | 310 | 46,500 |
March 3 | Purchase | 200 | 350 | 70,000 |
March 10 | Purchase | 330 | 375 | 123,750 |
Total | 680 | $240,250 |
Table (7)
Step 2: Calculate ending inventory under LIFO method.
LIFO Method | |||
Date | Units | Unit cost ($) | Total cost ($) |
(a) | (b) | (c = a × b) | |
March 10 | 110 | 310 | 34,100 |
Total | 110 | $34,100 |
Table (8)
Step 3: Calculate cost of goods sold under LIFO method.
Particulars |
Amount ($) |
Cost of goods available for sale | 240,250 |
Less: Ending inventory | (34,100) |
Cost of goods sold | $206,150 |
Table (9)
Calculate gross profit.
Gross Profit - LIFO | |
Details | Amount ($) |
Sales | 361,500 |
Less: Cost of goods sold | (206,150) |
Gross profit | $155,350 |
Table (9)
(d)
To Explain: The cost flow method that should use by J Gems.
(d)
Explanation of Solution
J Gems should select FIFO method because, the ending inventory and gross profit amount is greater than the LIFO method.
Want to see more full solutions like this?
Chapter 6 Solutions
Bundle: Financial Accounting: Tools for Business Decision Making 8e Binder Ready Version + WileyPLUS Registration Code
- The liabilities of Olga Company are $90,000. Common stock account is $150,000; dividends are $40,000; revenues, $450,000; and expenses, $320,000. What is the amount of Olga Company's total assets?arrow_forwardhello tutor provide correct answer General accounting questionarrow_forwardThe Texas division of our west inc.arrow_forward
- Algers Company produces dry fertilizer. Compute the variable overhead efficiency variance. At the beginning of the year, Algers had the following standard cost sheet: Direct materials (5 lbs. @ $2.60) $ 13.00 Direct labor (0.75 hr. @ $18.00) 13.50 Fixed overhead (0.75 hr. @ $4.00) 3.00 Variable overhead (0.75 hr. @ $3.00) 2.25 Standard cost per unit $ 31.75 Algers computes its overhead rates using practical volume, which is 54,000 units. The actual results for the year are as follows: Units produced 53,000 Direct materials purchased 275,000 pounds at $2.50 per pound Direct materials used 270,200 pounds Direct labor 40,100 hours at $17.95 per hour Fixed overhead Variable overhead $1,61,600 $ 1,21,900arrow_forwardi need this question answer General accounting questionarrow_forwardProvide answerarrow_forward
- Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College