![Financial Accounting Fundamentals](https://www.bartleby.com/isbn_cover_images/9781259726910/9781259726910_largeCoverImage.gif)
Concept explainers
1.
Compute cost of goods available for sale and number of units available for sale.
1.
![Check Mark](/static/check-mark.png)
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.
![Check Mark](/static/check-mark.png)
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.
![Check Mark](/static/check-mark.png)
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.
![Check Mark](/static/check-mark.png)
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 Fundamentals
- The depreciation expense for the truth is 20X1arrow_forwardDirect materials price variancearrow_forward$ 36,000 204,000 The Drysdale, Koufax, and Marichal partnership has the following balance sheet immediately prior to liquidation: Cash Noncash assets Liabilities Drysdale, loan $ 50,000 10,000 Total assets $ 240,000 Drysdale, capital (50%) Koufax, capital (30%) Marichal, capital (20%) Total liabilities and capital 70,000 60,000 50,000 $ 240,000 Required: a-1. Determine the maximum loss that can be absorbed in Step 1. Then, assuming that this loss has been incurred, determine the next maximum loss that can be absorbed in Step 2. a-2. Liquidation expenses are estimated to be $15,000. Prepare a predistribution schedule to guide the distribution of cash. b. Assume that assets costing $74,000 are sold for $60,000. How is the available cash to be divided? Complete this question by entering your answers in the tabs below.arrow_forward
- Problem 19-13 (Algo) Shoney Video Concepts produces a line of video streaming servers that are linked to personal computers for storing movies. These devices have very fast access and large storage capacity. Shoney is trying to determine a production plan for the next 12 months. The main criterion for this plan is that the employment level is to be held constant over the period. Shoney is continuing in its R&D efforts to develop new applications and prefers not to cause any adverse feelings with the local workforce. For the same reason, all employees should put in full workweeks, even if that is not the lowest-cost alternative. The forecast for the next 12 months is MONTH FORECAST DEMAND January February March April 530 730 830 530 May June 330 230 July 130 August 130 September 230 October 630 730 800 November December Manufacturing cost is $210 per server, equally divided between materials and labor. Inventory storage cost is $4 per unit per month and is assigned based on the ending…arrow_forwardCompute 007s gross profit percentage and rate of inventory turnover for 2016arrow_forwardHeadland Company pays its office employee payroll weekly. Below is a partial list of employees and their payroll data for August. Because August is their vacation period, vacation pay is also listed. Earnings to Weekly Vacation Pay to Be Employee July 31 Pay Received in August Mark Hamill $5,180 $280 Karen Robbins 4,480 230 $460 Brent Kirk 3,680 190 380 Alec Guinness 8,380 330 Ken Sprouse 8,980 410 820 Assume that the federal income tax withheld is 10% of wages. Union dues withheld are 2% of wages. Vacations are taken the second and third weeks of August by Robbins, Kirk, and Sprouse. The state unemployment tax rate is 2.5% and the federal is 0.8%, both on a $7,000 maximum. The FICA rate is 7.65% on employee and employer on a maximum of $142,800 per employee. In addition, a 1.45% rate is charged both employer and employee for an employee's wages in excess of $142,800. Make the journal entries necessary for each of the four August payrolls. The entries for the payroll and for the…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
![Text book image](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)