Financial Accounting Help With Project! Hello, I am having some trouble with the first page of my homework for my financial accounting class. I am having some trouble analyzing the differences between LIFO and FIFO in this specific question and how exactly I begin and end the question. Any help on this problem so I can refresh my memory after being gone over spring break would absolutely help a ton, especially considering I have another 4 pages of this stuff and this is the shortest problem. Also if I could receive assistance on how to analyze the bottom transactions, that would be great too. Thank you!
As a side note, I just posted this question a couple of hours ago. I sadly forgot to include the rest of the the page so the information provided seemed somewhat confusing. Sorry about that whoever answered the first time, here it is again. Thanks in advance!
November Inventory account | ||||||
1-Nov | Beg. Bal. | 500 | ||||
3 | Sales | 250 | ||||
5 | Purchases | 500 | ||||
10 | Sales | 250 | ||||
15 | Purchases | 450 | ||||
19 | Purchases | 300 | ||||
23 | Sales | 200 | ||||
29 | Purchases | 300 | ||||
Total | 2050 | 700 | ||||
Inv.bal. | 1350 | |||||
As per LIFO | ||||||
Everytime, a sale tales place,COGS is valued at the latest price available.So, the balance in inventory are valued at older prices.. | ||||||
If there is a purchase , before a sale, then that purchase price becomes the latest price. | ||||||
Beg. Bal. | 250 | 22 | 5500 | |||
5 | Purchases | 250 | 23 | 5750 | ||
15 | Purchases | 450 | 26 | 11700 | ||
19 | Purchases | 100 | 28 | 2800 | ||
29 | Purchases | 300 | 30 | 9000 | ||
1350 | 34750 | |||||
Whereas, | ||||||
In FIFO, COGS is priced at the oldest price available till all inventory in that price category is exhausted. | ||||||
so,bal.in inventory have the latest price available. | ||||||
As per FIFO | ||||||
29 | Purchases | 300 | 30 | 9000 | ||
19 | Purchases | 300 | 28 | 8400 | ||
15 | Purchases | 450 | 26 | 11700 | ||
5 | Purchases | 300 | 23 | 6900 | ||
1350 | 36000 | |||||
From the above 2 Tables, | ||||||
we conclude that the company had used FIFO for calculating November inventory | ||||||
as we see that $ 36000 is the value of inventory as per the Nov. Trial balance given. | ||||||
Now,we can calculate the December inventory using the same FIFO method , as under: | ||||||
Beg. Bal.on Dec 1 | ||||||
5 | Purchases | 300 | ||||
15 | Purchases | 450 | ||||
19 | Purchases | 300 | ||||
29 | Purchases | 300 | ||||
Dec. 4 | Sales | 350 | ||||
10 | Purchases | 500 | ||||
13 | Sales | 600 | ||||
18 | Purchases | 600 | ||||
20 | Sales | 600 | ||||
21 | Purchases | 400 | ||||
24 | Sales | 550 | ||||
2850 | 2100 | |||||
31 | Inv. Bal. | 750 | ||||
so, the inventory as at Dec 31 must be | ||||||
21-Dec | Purchases | 400 | 30 | 12000 | ||
18 | Purchases | 350 | 31 | 10850 | ||
750 | 22850 |
DEC Journal enties | ||
Salaries expense | 2930 | |
Cash | 2930 | |
(32230/11) | ||
Rent Expense | 2200 | |
Cash | 2200 | |
(24200/11) | ||
Depreciation expense | 1000 | |
Accum. Dep. -equip. | 1000 | |
(11000/11) | ||
Advertising expense | 900 | |
Cash | 900 | |
Utilities expense | 700 | |
Cash | 700 | |
Communications expense | 500 | |
Cash | 500 | |
Cash | 17000 | |
Accounts receivables | 68000 | |
Sales | 85000 | |
(350*38)+(600*40)+(600*41)+(550*42) | ||
COGS | 58250 | |
Inventory | 58250 | |
Supplies | 1100 | |
Cash | 1100 | |
Supplies expense | 1450 | |
Supplies | 1450 | |
(2200+1100-1850) | ||
Prepaid Insurance | 6160 | |
Insurance expense | 560 | |
Cash | 6720 | |
(6720/12) | ||
Cash | 18500 | |
Accounts receivable | 18500 | |
Accounts payable | 22500 | |
Cash | 22000 | |
Discounts received | 500 | |
Distributions | 15000 | |
Cash | 15000 | |
Retained Earnings | 15000 | |
Distributions | 15000 |
Adj.Dec. T/B | Income Stat. | Balance Sheet | ||||
Account Title | Debit | Credit | ||||
Cash | 10650 | 10650 | ||||
Acc.Rec. | 58220 | 58220 | ||||
Inventory | 22850 | 22850 | ||||
Supplies | 1850 | 1850 | ||||
Prepaid Ins. | 6160 | 6160 | ||||
Land | 50000 | 50000 | ||||
Equipment | 75000 | 75000 | ||||
Acc. Depn. Equip | 72000 | 72000 | ||||
Acc.payabale | 52800 | 52800 | ||||
Paid-in capital | 70000 | 70000 | ||||
Ret. Earn. | 3900 | 3900 | ||||
Distrbns. | ||||||
Sales | 344710 | 344710 | ||||
Sales discounts | 23650 | 23650 | ||||
Sales return/allowance | 11000 | 11000 | ||||
COGS | 177050 | 177050 | ||||
Discounts recd | 500 | 500 | ||||
Salaries expense | 35160 | 35160 | ||||
Rent expense | 26400 | 26400 | ||||
Ins. Exp. | 6060 | 6060 | ||||
Advt. Exp. | 9920 | 9920 | ||||
Depn. Exp. | 12000 | 12000 | ||||
Utilities exp. | 7630 | 7630 | ||||
Commn. Exp. | 5120 | 5120 | ||||
Supplies exp. | 5190 | 5190 | ||||
Income summary | 26030 | 26030 | ||||
Total | 543910 | 543910 | 345210 | 345210 | 224730 | 224730 |
Financial Accounting Help With Project! Hello, I am having some trouble with the first page of my...
These are the journal entries to the accounts in the general ledgar. I am having trouble on how to make a trial balance. It has 12 columns to fill in data with account type and the amount that each account type has but I can not figure the pieces out. 28 N o Q H K M notes payable Date Explanation Ref Debit Credit Balance 4-Sep equipment 20000 20000 common stock Date Explanation Ref Debit Credit Balance 1-Sep cash 25000...
Hello please see attachments for reference. Please help me. I am so confused. Thank you very much. Accounting 2140 - Comprehensive Problem On October 1, 2019, Santana Rey launched a computer services company called Business Solutions, which provides consulting services, computer system installations, and custom program development Rey adopts the calendar year for reporting purposes and expects to prepare the company's first set of financial statements on December 31, 2019. After the success of the company's first two months, Santana...
Hello, I am finish working on my worksheet for Sound Bytes Electronics and I need help with the Income Statement, Statement of Changes in Owner’s Equity and a Balance Sheet. I was wondering if you could help me? This is the worksheet that I did: Worksheet Credit 11.9 Account Titles 101 Bank Account Chequing 120 Accounts Receivable - 122 Merchandise Inventory 124 Store Supplies on Hand 128 Prepaid Insurance 161 Store Equipment 162 Accum Deprec Store Equip 210 Accounts Payable...
Hello, I'm having trouble with the trial balance. Can someone please help me with it. I think something is wrong with the adjusted trial balance. khampton ACCOUNTING SERVICE INC Dear Newbie, Welcome to Hampton! My name is Julio Antoni, your supervisor. We believe the best way for you to get familiar with what you are going to be doing here is to throw you right in, so we are asking you to start working on the books for us right...
I am unsure if my data on the last page are correct. I feel as though I am missing at least one number in each. Thanks! P3-36A Journalizing and posting adjustments to the four-column accounts and preparing an adjusted trial balance The unadjusted trial balance of Newport Inn Company at December 31, 2016, and the data needed for the adjustments follow NEWPORT INN COMPANY Unadjusted Trial Balance December 31, 2016 Balance Account Title Cash Accounts Receivable Prepaid Insurance Office Supplies...
This is an assignment that I am having a lot of trouble on. Comprehensive Problem Taylors Delivery Service had the following transactions during December 2019: Dec 1 Taylors Delivery Service began operations by receiving $15,000 cash and with a fair value of $30,000 from the owner, Rue Taylor. The business ga Taylors capital in exchange for this contribution. Dec 1 Paid $2,000 cash for a 6-month insurance policy. The policy will begin on December 1. Dec 7 Paid Office Rent...
comprehensive problem. requires the whole accounting cycle. please help! first 3 pics actual problem. Accounting 2140 - Comprehensive Problem On October 1, 2019, Santana Rey launched a computer services company called Business ilting services, computer system installations, and custom program development. Rey adopts the calendar year for reporting purposes and expects to prepare the company's first set of financial statements on December 31, 2019. After the success of the company's first two months, Santana Rey continues to operate Business...
I am needing help with the general ledger portion of this problem. Also, please check my work on the journal portion. I am struggling with the unadjusted and adjusted trial balance so i want to make sure the ledger is correct. Project Data: Taylor Scott owns and operates a consulting firm called Scott Consulting. The business began operating in October 2019. Transactions for October and November 2019 have been recorded and posted. Scott Consulting had the following transactions in December...
Hello, I need help making an accounting "worksheet" with these entries. If you'd like to update the journal entries it's fine. But, please help me on finishing the worksheet? Thank you. ACC 111 Project 1B The adjustment data as of September 30, 2016, the end of the fiscal year, for Diaz Company were as follows: a. Merchandise Inventory taken on September 30 was $65,800. b. The depreciation on the Delivery Truck for the month amounted to $700. C. The depreciation...
Help! I'm stuck. The first image is the question, the 2nd image is what I have so far. I am so beyond frustrated. Thanks. 79. The trial balance and information for year-end adjustments for Litton Company are as follows: Litton Company Trial Balance December 31, 20- Account Title Debit Credit Cash 19,780 Accounts Receivable 5,500 Supplies 1,500 Prepaid Insurance 2,400 Equipment 30,200 Accumulated Depreciation Equipment 5,000 Accounts Payable 5,520 Wages Payable Litton, Capital 44,000 Litton, Drawing 4,000 20,000 Service Fees...