Concept explainers
1.
Compute cost of goods available for sale and number of units available for sale.
1.

Explanation of Solution
Cost of goods available for sale: Cost of goods available for sale represents the sum of beginning merchandise and purchased merchandise. Cost of goods available for sale is not reported on any of the financial statements because the cost of goods available for sale is either sold, or remained as ending inventory, at the end of the year.
Compute cost of goods available for sale and number of units available for sale:
Particulars | Units | Cost of goods |
Beginning inventory | 20 units @ $3,000 | $60,000 |
April 6 | 30 units @ $3,500 | 105,000 |
April 17 | 5 units @ $4,500 | 22,500 |
April 25 | 20 units @ $4,800 | 48,000 |
Units available | 65 units | |
Cost of goods available for sale | $235,500 |
Table (1)
Therefore, units available are 65units and cost of goods available for sale is $235,500.
2.
Compute the number of units in ending inventory.
2.

Explanation of Solution
Compute the number of units in ending inventory:
Units available (refer requirement 1) | 65 units |
Less: Units sold | (60 units) |
Ending Inventory (units) | 5 units |
Table (2)
Hence, the ending inventory is 5 units.
3.
Compute the cost assigned to ending inventory using (a) FIFO, (b) LIFO, (c) weighted average, and (d) specific identification.
3.

Explanation of Solution
First-in-First-Out (FIFO): In this method, items purchased initially are sold first. Therefore, the value of the ending inventory contains the recent cost for the remaining unsold items.
a) Compute the cost assigned to ending inventory using FIFO:
Date | Goods Purchased | Cost of Goods Sold | Inventory Balance |
April 1 | 20 @ $3,000= $60,000 | ||
April 6 | 30 @ $3,500 = $105,000 | 20 @ $3,000 | |
30@$3,500 = $165,000 | |||
April 9 | 20 @ $3,000 = $60,000 | 15 @ $3,500 = $52,500 | |
15 @ $3,500 = $52,500 | |||
April 17 | 5 @ $4,500 = $22,500 | 15 @ $3,500 | |
5 @ $4,500 = $75,000 | |||
April 25 | 10 @ 4,800 = $48,000 | 15 @ $3,500 | |
5 @ $4,500 | |||
10 @ 4,800= $123,000 | |||
April 30 | 15 @ $3,500 = $52,500 | 5 @ 4,800 = $24,000 | |
5 @ $4,500 = $22,500 | |||
5 @ $4,800= $24,000 | |||
$ 211,500 |
Table (3)
Therefore, the cost assigned to ending inventory using FIFO is $24,000.
Last-in-First-Out (LIFO): In this method, items purchased recently are sold first. So, the value of the ending inventory contains the initial cost for the remaining unsold items.
b) Compute the cost assigned to ending inventory using LIFO:
Date | Goods Purchased | Cost of Goods Sold | Inventory Balance |
April 1 | 20 @ $3,000 = $60,000 | ||
April 6 | 30@$3,500 = $105,000 | 20 @ $3,000 = $60,000 | |
30@$3,500 = $105,000 | |||
March 9 | 30@$3,500 = $105,000 | 15 @ $3,000 = $45,000 | |
5 @ $3,000 = $15,000 | |||
April 17 | 5 @ $4,500 = $22,500 | 15 @ $3,000 = $45,000 | |
5 @ $4,500 = $22,500 | |||
April 25 | 10@$4,800 = $48,000 | 15 @ $3,000 = $45,000 | |
5 @ $4,500 = $22,500 | |||
10 @ 4,800= $48,000 | |||
April 30 | 10 @ $4,800 = $48,000 | 5 @ 3,000= $15,000 | |
5 @ $4,500 = $22,500 | |||
10@$3,000 = $30,000 | |||
= $220,500 |
Table (4)
Therefore, the cost assigned to ending inventory using LIFO is $15,000.
Weighted average cost method: Under average cost method, company calculates a new average after every purchase. It is determined by dividing the cost of goods available for sale by the units on hand.
c) Compute the cost assigned to ending inventory using weighted average cost:
Date | Goods Purchased | Cost of Goods Sold | Inventory Balance |
April 1 | 20 @ $3,000 = $60,000 | ||
April 6 | 30@ $3,500 = $105,000 | 20 @ $3,000 = $60,000 | |
30@$3,500=$105,000 | |||
Average cost is $3,300 | |||
April 9 | 35@ $3,300= $115,500 | 15 @ $3,300 = $49,500 | |
Average cost is $3,300 | |||
April 17 | 5 @ $4,500 = $22,500 | 15 @ $3,300 = $49,500 | |
5 @ $4,500= $22,500 | |||
Average cost is $3,600 | |||
April 25 | 10@ 4,800 = $48,000 | 15@ $3,300= $49,500 | |
5 @ $4,500= $22,500 | |||
10 @ 4,800= $48,000 | |||
Average cost is $4,000 | |||
April 30 | 25@$4,000= 100,000 | 5 @ $4,000= $20,000 | |
$ 215,500 | |||
Average cost is $4,000 |
Table (5)
Therefore, the cost assigned to ending inventory using weighted average cost is $20,000.
Specific identification inventory system: It is one of the
d) Compute the cost assigned to ending inventory using weighted average cost:
Particulars | Amount ($) |
Total goods available for sale (requirement 1) | $235,500 |
Less: Cost of goods sold (1) | ($213,000) |
Ending inventory | $22,500 |
Table (6)
Therefore, the cost assigned to ending inventory using specific identification method is $22,500.
Working note:
Calculate the cost of goods sold:
Particulars | Units @ cost per unit | Amount ($) |
Beginning inventory | 20 units @ $3,000 | $60,000 |
Purchase on April 6 | 30 units @ $3,500 | $105,500 |
Purchase on April 25 | 10 units @ $4,800 | $48,000 |
Cost of goods sold | 213,000 |
(1)
Table (7)
4.
Compute the gross profit earned by the Company W for each of the four costing methods in requirement 3.
4.

Explanation of Solution
Gross margin (gross profit): Gross margin is the amount of revenue earned from goods sold over the costs incurred for the goods sold.
Compute the gross profit earned by the Company W for each of the four costing methods in requirement 3:
FIFO |
LIFO |
Weighted Average |
Specific Identification | |
Sales (2) | $770,000 | $770,000 | $770,000 | $770,000 |
Less: Cost of goods sold | 211,500 | 220,500 | 215,500 | 213,000 |
Gross profit | $558,500 | $549,500 | $554,500 | $557,000 |
Table (8)
Gross profit under FIFO method is higher ($558,500) and under LIFO method is lower ($549,500)
Working note:
Calculate the sales amount:
Sales on April 9 | $420,000 |
Sales on April 30 | $350,000 |
Total sales amount | $770,000 |
(2)
Table (9)
Want to see more full solutions like this?
Chapter 5 Solutions
FINANCIAL ACCOUNTING ACCT 2301 >IC<
- On January 1 of the current year, Piper Company issues a 4-year, non-interest-bearing note with a face value of $8,000 and receives $4,952 in exchange. The recording of the issuance of the note includes a: a. credit to Notes Payable for $4,952. b. credit to Discount on Notes Payable for $3,048. c. debit to Discount on Notes Payable for $3,048. d. debit to Cash for $8,000.arrow_forwardPLease helparrow_forwardPLEASE HELParrow_forward
- Hy expert provide answer with calculationarrow_forwardDuring September, the assembly department completed 10,500 units of a product that had a standard materials cost of 3.0 square feet per unit at $2.40 per square foot. The actual materials purchased consisted of 22,000 square feet at $2.60 per square foot, for a total cost of $57,200. The actual material used during this period was 25,500 square feet. Compute the materials price variance and materials usage variance.arrow_forwardBluesy Electronics recorded the following financial data: Net Sales $720,500 Average Inventory at Cost = $80,200 Gross Margin Percentage = 42% Calculate the GMROI.arrow_forward
- Need help this question solutionarrow_forwardXYZ Company has a gross profit margin of 0.30, an operating profit margin of 18%, a total asset turnover ratio of 2.0x, and cost of goods sold of $700,000. The company's tax rate is 35%, and it has no debt. Calculate XYZ Company's Return on Assets (ROA).arrow_forwardMON Pools builds custom swimming pools. MON budgets that they will build 16 pools during the month of June at a price of $22,750 per pool. The actual pools built by MON during June were 13 pools at a price of $23,420 per pool. What is the Flexible Budget Variance for June?arrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education





