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 |