In: Accounting
|
|
|
|
Please give positive ratings so I can keep answering. It would help me a lot. Please comment if you have any query. Thanks! |
Novak | A | B | C | D=(B-B*C) | E=D*A |
Periodic FIFO | No. of Units | Invoice Cost | Discount | Net Cost | Total net cost |
Purchased on Jan 15 | 75.00 | 32.00 | 0% | 32.00 | 2,400.00 |
Purchased on Mar 15 | 90.00 | 25.00 | 1% | 24.75 | 2,227.50 |
Purchased on Jun 20 | 115.00 | 24.00 | 1% | 23.76 | 2,732.40 |
Purchased on Sep 12 | 109.00 | 19.00 | 1% | 18.81 | 2,050.29 |
Purchased on Nov 24 | 101.00 | 17.00 | 1% | 16.83 | 1,699.83 |
Total | 490.00 | 11,110.02 | |||
Final Answer- FIFO | |||||
Ending Inventory | Units | Net Cost | Total net cost | ||
From Purchases on Sep 12 | 18.00 | 18.81 | 338.58 | ||
From Purchases on Nov 24 | 101.00 | 16.83 | 1,699.83 | ||
Cost of ending inventory | 119.00 | 2,038.41 | |||
Cost of goods sold | 9,071.61 | ||||
Cost of goods sold is total net cost less cost of ending inventory. | |||||
Final Answer- LIFO | |||||
Ending Inventory | Units | Net Cost | Total net cost | ||
From Purchases on Jan 15 | 75.00 | 32.00 | 2,400.00 | ||
From Purchases on Mar 15 | 44.00 | 24.75 | 1,089.00 | ||
Cost of ending inventory | 119.00 | 3,489.00 | |||
Cost of goods sold | 7,621.02 | ||||
Cost of goods sold is total net cost less cost of ending inventory. | |||||
The prices are falling so in order to minimize taxes the owner should use FIFO. Because FIFO gives higher cost of goods sold so the income will be lower and hence income taxes will also be lower. |