In: Accounting
The Unadjusted Trial Balance has been prepared (provided below and also in ThreeBrothers worksheet.xlsx), showing only those accounts with a non-zero balance. You have gathered the following information that will be helpful in preparing any necessary adjusting entries (add any accounts necessary). Good luck!
|
ThreeBrothers |
Unadjusted Trial Balance |
|
|
Dec. 31, 2017 |
||
|
debit |
credit |
|
|
Cash |
4,400,000 |
|
|
Accounts Receivable |
22,500,000 |
|
|
Allowance for Bad Debts |
20,000 |
|
|
Inventory |
2,500,000 |
|
|
Purchases |
85,832,500 |
|
|
Construction in Progress Inventory |
36,000,000 |
|
|
Billings on Contract |
35,000,000 |
|
|
PP&E |
60,000,000 |
|
|
Accumulated Depreciation |
36,000,000 |
|
|
Accounts Payable |
18,000,000 |
|
|
Income Tax Payable |
136,000 |
|
|
Common Stock |
1,500,000 |
|
|
Retained Earnings |
33,444,000 |
|
|
Sales Revenue |
134,500,000 |
|
|
Sales Returns |
2,017,500 |
|
|
NEWPROD Revenue |
9,000,000 |
|
|
FITTRACKER Revenue |
10,000,000 |
|
|
Cost of NEWPROD Sold |
8,100,000 |
|
|
Cost of FITTRACKER Sold |
4,500,000 |
|
|
General and Admin |
51,750,000 |
|
|
TOTAL |
277,600,000 |
277,600,000 |
ThreeBrothers uses a periodic FIFO inventory system for its normal operations. A physical inventory count indicated 40,000 units on hand at the end of 2017.
PURCHASES FOR 2017(normal operations)
|
Beginning units: |
5,000 units @ $500 each |
|
Purchases: |
|
|
Apr - May |
40,000 units @ $500 each |
|
Jun - Jul |
35,000 units @ $505 each |
|
Aug - Sep |
48,500 units @ $515 each |
|
Oct |
24,000 units @ $520 each |
|
Nov - Dec |
20,000 units @ $535 each |
Question - ThreeBrothers uses straight-line depreciation and all fixed assets were purchased at the beginning of 2014 and have a 5-year useful life. No depreciation entries have been recorded in 2017.
I need the adjusting journal entry and closing journal entry - for the question, if necessary. Thank You.
Answer
Calculation of Depriciation for 2017 = $60,000,000/5 = $12,000,000
Calculation of closing Inventory = ThreeBrothers is using FIFO so inventory which has been bought at last will go to stock
Nov - Dec - 20,000 units @ $535 each = $10,700,000
Oct - 20000 Units @$520 each = $10,400,000
So closing Inventory Value = $10,700,000+ $10,400,000 = $21,100,000
So Increase/ (Decrease) in Inventory = $21,100,000 -$2,500,000 (Closing - Opening) = $18,600,000
Journal Entries
| Journal Entry | ||
| Dr | Cr | |
| Inventory Dr | 18,600,000 | |
| Cost of Goods sold credit | 18,600,000 | |
| (To record diff in opening and closing inventory) | ||
| Depriciation | 12,000,000 | |
| Accumulated Depreciation | 12,000,000 | |
| (To record depriciation for 2017) | ||
| Sales Revenue Account | 134,500,000 | |
| NEWPROD Revenue Account | 9,000,000 | |
| FITTRACKER Revenue Account | 10,000,000 | |
| Sales Return Account | 2,017,500 | |
| Depriciation Account | 12,000,000 | |
| Purchase Account | 85,832,500 | |
| Cost of NEWPROD Sold Account | 9,000,000 | |
| Cost of FITTRACKER Sold Account | 10,000,000 | |
| General and Admin Account | 51,750,000 | |
| Cost of Goods sold credit | 18,600,000 | |
| Profit and Loss Account | 1,500,000 | |
| (Adjustment entry for 2017 end) | ||
| Profit and Loss Account | 1,500,000 | |
| Retained Earning | 1,500,000 | |
|
(To transfer profit of 2017 to retained earning by assuming no Interest and Tax) Thanks |