Solution of the above problem is as under
Statement showing Cost of Ending Inventory and Cost of Goods Sold (COGS) | ||||||
Event | Particulars | Quantity (in units) | Unit Cost ($) | Value ($) | Quantity Balance | Value Balance ($) |
1 | Beginning Inventory | 200 | 120 | 24000 | 200 Units @ $120 | 24000 |
2 | Cash Purchases | 130 | 124 | 16120 | 200
Units @ $120 130 Units @ $124 |
40120 |
3 | Cash Purchases | 220 | 128 | 28160 | 200
Units @ $120 130 Units @ $124 220 Units @ $128 |
68280 |
Total Units and Cost | 550 | 68280 | ||||
Note : Units Sold as given in Question 350 Units @ $320, Therefore Ending Inventory is (550-350) Units = 200 Units | ||||||
a) 1) Computation of Cost of Ending Inventory and Cost of Goods Sold using FIFO Method | ||||||
Cost of Ending Inventory (200 units) is: | 200 Units @ $128 | 25600 | ||||
Cost of Goods Sold (350 Units) is: | 200
Units @ $120 130 Units @ $124 20 Units @ $128 |
42680 | ||||
a) 2) Computation of Cost of Ending Inventory and Cost of Goods Sold using LIFO Method | ||||||
Cost of Ending Inventory (200 units) is: | 200 Units @ $120 | 24000 | ||||
Cost of Goods Sold (350 Units) is: | 220
Units @ $128 130 Units @ $124 |
44280 | ||||
a) 3) Computation of Cost of Ending Inventory and Cost of Goods Sold using Weighted Average Cost Method | ||||||
Weighted Average Cost per Unit: | [Total Cost/Total Units] | $ 124.15 | ||||
Cost of Ending Inventory (200 units) is: | 200 Units X $ 124.15 | 24830 | ||||
Cost of Goods Sold (350 Units) is: | 350 Units X $ 124.15 | 43452.50 | ||||
Statement showing Journal Entries of transactions occurred in Year-2 | |||
S.No | Account Titles | Debit ($) | Credit ($) |
1 | Inventory A/c Dr | 16120 | |
To Cash A/c | 16120 | ||
(Being purchases made for cash) | |||
2 | Inventory A/c Dr | 28160 | |
To Cash A/c | |||
(Being purchases made for cash) | 28160 | ||
3 | Cash A/c Dr | 112000 | |
To Sales Revenue A/c | 112000 | ||
(Being sales made in cash) | |||
3)a) | Cost of Goods Sold A/c Dr | 42680 | |
To Inventory A/c | 42680 | ||
(Being COGS recorded of goods sold using FIFO) | |||
3)b) | Cost of Goods Sold A/c Dr | 44280 | |
To Inventory A/c | 44280 | ||
(Being COGS recorded of goods sold using LIFO) | |||
3)c) | Cost of Goods Sold A/c Dr | 43452.50 | |
To Inventory A/c | 43452.5 | ||
(Being COGS recorded of goods sold using Weighted Average Method) | |||
4) | Operating Expenses A/c Dr | 24000 | |
To Cash A/c | 24000 | ||
(Being operating expenses paid) | |||
5)a) | Income Tax A/c Dr | 18128 | |
To Cash A/c | 18128 | ||
(Being Income Tax Paid FIFO) | |||
5)b) | Income Tax A/c Dr | 17488 | |
To Cash A/c | 17488 | ||
(Being Income Tax Paid LIFO) | |||
5)c) | Income Tax A/c Dr | 17819 | |
To Cash A/c | 17819 | ||
(Being Income Tax Paid Weighted Average) | |||
Income Statement using FIFO, LIFO and WEIGHTED AVERAGE COST FLOW | |||
Particulars | FIFO | LIFO | Weighted Average Cost |
Amount ($) | Amount ($) | Amount ($) | |
Sales Revenue | 112000 | 112000 | 112000 |
Less: Cost of Goods Sold | 42680 | 44280 | 43452.50 |
Contribution Margin | 69320 | 67720 | 68547.5 |
Less: Operating Expenses | 24000 | 24000 | 24000 |
Operating Income | 45320 | 43720 | 44547.5 |
Less: Income Tax Expense @ 40% | 18128 | 17488 | 17819 |
Net Income (After Tax) | 27192 | 26232 | 26728.5 |
The accounting Teculus UI Alle misurull, Ill. Terecleu de IULIUWIIIg varices as Ul Jaliuary 1, Tea...
ONLY NEED NUMBER C! Balance sheet, statement of cash flows, and
income statement please!
INIC ac ng ICULUS ULANICU UTALII, C. CLICCICU LIIC BOIRIWIng talanes a UL Jalaly I, Ica 2. Cash Beginning inventory Common stock Retained earnings $36,000 24,000 (200 units a $120) 25,000 The following five transactions occurred in Year 2: 1. First purchase (cash) 130 units @ $124 2. Second purchase (cash) 220 units @ $128 3. Sales (all cash) 350 units @ $320 4. Paid $24,000...
The accounting records of Wall's China Shop reflected the following balances as of January 1, Year 2: Cash $ 17,500 Beginning inventory 13,350 (150 units @ $89) Common stock 14,100 Retained earnings 16,750 The following five transactions occurred in Year 2: First purchase (cash) 120 units @ $91 Second purchase (cash) 195 units @ $99 Sales (all cash) 425 units @ $186 Paid $14,500 cash for salaries expenses. Paid cash for income tax at the rate of 40 percent of...
The accounting records of Wall's China Shop reflected the following balances as of January 1. Year 2 Cash Beginning inventory Common stock Retained earnings $80, 100 33,000 (220 units @ $150) 50,000 63,100 ook The following five transactions occurred in Year 2- 1. First purchase (cash) 150 units @ $155 2. Second purchase (cash) 160 units @ $160 3. Sales (all cash): 410 units @ $320 4. Paid $38,000 cash for salaries expense 5. Paid cash for income tax at...
The accounting records of Wall's China Shop reflected the following balances as of January 1, Year 2: Cash Beginning inventory Common stock Retained earnings $19,900 18,490 (215 units @ $86) 14,300 24,090 The following five transactions occurred in Year 2: 1. First purchase (cash) 115 units @ $88 2. Second purchase (cash) 200 units @ $96 3. Sales (all cash) 360 units @ $199 4. Paid $16,900 cash for salaries expense 5. Paid cash for income tax at the rate...
The accounting records of Wall’s China Shop reflected the following balances as of January 1, Year 3: Cash $19,700, Beginning inventory $18,200 (200 @ $91), Common stock $14,600, Retained earnings $23,300. The following five transactions occurred in Year 3: First purchase (cash): 120 units @ $93 Second purchase (cash): 200 units @ $101 Sales (all cash): 350 units @ $189 Paid $13,650 cash for salaries expense Paid cash for income tax at the rate of 25 percent of income before...
The accounting records of Wall's China Shop reflected the following balances as of January 1, Year 2: Cash $ 18,900 Beginning inventory: 14,105 (155 units @ $91) Common stock: 16,000 Retained earnings: 17,005 The following five transactions occurred in Year 2: First purchase (cash) 120 units @ $93 Second purchase (cash) 200 units @ $101 Sales (all cash) 420 units @ $191 Paid $15,100 cash for salaries expenses. Paid cash for income tax at the rate of 40 percent of...
The accounting records of Wall's China Shop reflected the following balances as of January 1, Year 2: Cash $ 19,000 Beginning inventory 15,040 (160 units @ $94) Common stock 15,500 Retained earnings 18,540 The following five transactions occurred in Year 2: First purchase (cash) 115 units @ $96 Second purchase (cash) 200 units @ $104 Sales (all cash) 420 units @ $187 Paid $14,500 cash for salaries expenses. Paid cash for income tax at the rate of 40 percent of...
The accounting records of Wall’s China Shop reflected the following balances as of January 1, Year 3: Cash $ 18,000 Beginning inventory 17,835 (205 @ $87) Common stock 14,500 Retained earnings 21,335 The following five transactions occurred in Year 3: First purchase (cash): 125 units @ $89 Second purchase (cash): 195 units @ $97 Sales (all cash): 360 units @ $191 Paid $13,800 cash for salaries expense Paid cash for income tax at the rate of 25 percent of income...
The accounting records of Wall’s China Shop reflected the following balances as of January 1, Year 3: Cash $ 17,700 Beginning inventory 20,680 (220 @ $94) Common stock 14,700 Retained earnings 23,680 The following five transactions occurred in Year 3: First purchase (cash): 125 units @ $96 Second purchase (cash): 195 units @ $104 Sales (all cash): 375 units @ $200 Paid $16,100 cash for salaries expense Paid cash for income tax at the rate of 25 percent of income...
The accounting records of Wall's China Shop reflected the following balances as of January 1, Year 3: Cash Beginning inventory Common stock Retained earnings $19,000 19,320 (210 14,300 24,020 $92) The following five transactions occurred in Year 3: 1. First purchase (cash): 125 units @ $94 2. Second purchase (cash): 195 units @ $102 3. Sales (all cash): 365 units @ $185 4. Paid $15.400 cash for salaries expense 5. Pald cash for income tax at the rate of 25...