Question

In: Accounting

Please complete the provided partially adjusted trial balance worksheet with the information provided. (Not all information...

Please complete the provided partially adjusted trial balance worksheet with the information provided. (Not all information provided may be relevant in completing the question).

Inventory Information
Inventory on hand at the beginning of October:
Units Cost / unit Total Cost
Purchase # 1 15 60 $900
Purchase # 2 25 70 1,750
40 $2,650
October 2018 transactions related to buying and selling widget inventory
1-Oct Sold 30 widgets at $125 each on credit
3-Oct Purchased 60 widgets at a cost of $80 per widget on credit
10-Oct Sold 45 widgets at $150 each on credit
20-Oct Purchased 40 widgets at a cost of $85 per widget on credit
24-Oct Sold 35 widgets at $165 each on credit
The PHYSICAL count of widget inventory on hand at October 31, 2018 shows 23 widgets at a FIFO cost of $1,955.
Beginning Inventory Units Cost / unit Cost
15         60             900
25 70          1,750
40          2,650
Number of Days Outstanding
Total 0-30 31-60 61-90 91-120 over 120
Accounts Receivable $     163,075 $146,768 $     6,523 $     3,262 $     4,892 $     1,631
% Uncollectible 0.02 0.06 0.075 0.08 0.09
Estimated Uncollectible $         4,109         2,935            391            245            391            147

NFT Consulting and Sales Inc

PARTIALLY ADJUSTED TRIAL BALANCE
October 31 2017
Part Adj T/B October JES Trial Balance Adj JES Adj T/B
DR CR DR CR DR CR DR CR DR CR
Cash $332,218      332,218
Accounts Receivable 146,800
Allowance for Uncollectible Accounts $3,689          3,689
Supplies 42,600        42,600
Inventory 2,650
Prepaid Insurance 16,800        16,800
Land 50,000        50,000
Building 110,000      110,000
Accumulated Depr – Building 5,670          5,670
Computer equipment 52,950        52,950
Accumulated Depr – Comp Equip 1,750          1,750
Office Furniture        45,900        45,900
Accumulated Depr - Office Furniture 890             890
Accounts Payable 16,560
Interest Payable          3,200          3,200
Utilities Payable 8,952          8,952
Wages Payable 45,800        45,800
Long term Note Payable 90,000        90,000
Mortgage Payable 60,000        60,000
Common Stock 400,000      400,000
Retained Earnings 126,867      126,867
Dividends          4,000          4,000
Service Revenue 365,400      365,400
Tablet Sales Revenue 222,400
Cost of Goods Sold 154,500
Bad Debt Expense
Depreciation Expense – Building 1,350          1,350
Depreciation Expense - Computer Equip 890             890
Depreciation Expense - Office Furn 650             650
Interest Expense 3560          3,560
Insurance Expense 38,950        38,950
Supplies expense 72,860        72,860
Utilities Expense 75,900        75,900
Wage Expense 198,600      198,600
Subtotals
Net Income
TOTALS $1,351,178 $1,351,178

Solutions

Expert Solution


Related Solutions

The adjusted trial balance columns of the worksheet for Monty Company are as follows: Complete the...
The adjusted trial balance columns of the worksheet for Monty Company are as follows: Complete the worksheet. Monty Company Worksheet (Partial) choose the accounting period                                                          April 30, 2022For the Month Ended April 30, 2022 Adjusted Trial Balance Income Statement Balance Sheet Account Titles Dr. Cr. Dr. Cr. Dr. Cr. Cash 11,000 Accounts Receivable 8,000 Prepaid Rent 2,200 Equipment 22,700 Accumulated Depreciation—Equip. 5,000...
Please complete a classified balance sheet with the information provided. (Not all information provided may be...
Please complete a classified balance sheet with the information provided. (Not all information provided may be relevant in completing the question). Inventory Information Inventory on hand at the beginning of October: Units Cost / unit Total Cost Purchase # 1 15 60 $900 Purchase # 2 25 70 1,750 40 $2,650 October 2018 transactions related to buying and selling widget inventory 1-Oct Sold 30 widgets at $125 each on credit 3-Oct Purchased 60 widgets at a cost of $80 per...
Create a balance sheet The adjusted trial balance columns of the worksheet for Ayayai Company are...
Create a balance sheet The adjusted trial balance columns of the worksheet for Ayayai Company are as follows. Ayayai Company Worksheet (Partial) For the Month Ended April 30, 2019 Adjusted Trial Balance Account Titles Dr. Cr. Cash 11,500 Accounts Receivable 7,620 Prepaid Rent 2,180 Equipment 22,950 Accumulated Depreciation—Equip. 5,000 Notes Payable 5,800 Accounts Payable 4,500 Common Stock 20,500 Retained Earnings 8,550 Dividends 3,500 Service Revenue 15,500 Salaries and Wages Expense 10,800 Rent Expense 700 Depreciation Expense 600 Interest Expense 60...
Please complete the weighted average information with the information provided. (Not all information provided may be...
Please complete the weighted average information with the information provided. (Not all information provided may be relevant in completing the question). Inventory Information Inventory on hand at the beginning of October: Units Cost / unit Total Cost Purchase # 1 15 60 $900 Purchase # 2 25 70 1,750 40 $2,650 October 2018 transactions related to buying and selling widget inventory 1-Oct Sold 30 widgets at $125 each on credit 3-Oct Purchased 60 widgets at a cost of $80 per...
Please complete the LIFO information with the information provided. (Not all information provided may be relevant...
Please complete the LIFO information with the information provided. (Not all information provided may be relevant in completing the question). Inventory Information Inventory on hand at the beginning of October: Units Cost / unit Total Cost Purchase # 1 15 60 $900 Purchase # 2 25 70 1,750 40 $2,650 October 2018 transactions related to buying and selling widget inventory 3-Oct Purchased 60 widgets at a cost of $80 per widget on credit 10-Oct Sold 45 widgets at $150 each...
Create a worksheet showing the unadjusted trial balance, adjusting entries, adjusted trial balance, income statement, and...
Create a worksheet showing the unadjusted trial balance, adjusting entries, adjusted trial balance, income statement, and balance sheet included with the data below. Also, create a pivot table. Create a general ledger, worksheet, income statement, changes in retained earnings, and balance sheet with the data below. June 1: Hudson Bloom invested $105,273.00 cash and computer equipment with a fair market value of $32,970.00 in his new business, Byte of Accounting. June 1:   Check # 5000 was used to purchased office...
Prepare a worksheet that contains the following columns: Trial Balance, Adjustments, Adjusted Trial Balance, Income Statement...
Prepare a worksheet that contains the following columns: Trial Balance, Adjustments, Adjusted Trial Balance, Income Statement and Balance Sheet. From the following transactions as well as add't data, please complete the entire accounting cycle for Parker's Plowing (using the chart of accounts below) for 2018. Jan. 1 Parker invested $10,000 cash and $12,000 worth of snow equipment into the plowing company. Jan. 1 Paid rent for six months in advance for garage space, $6000 Jan. 6 Purchased snow supplies for...
After all account balances have been transferred from the Adjusted Trial Balance section of the worksheet...
After all account balances have been transferred from the Adjusted Trial Balance section of the worksheet to the financial statement sections, the Income Statement section of the worksheet includes the following totals. The Credit column total is $120,000 and the total of the Debit column is $80,000. The Income Statement section of the worksheet: Multiple Choice   is now complete.    would be completed by entering $40,000 in the Credit column with the words “Net Income” in the Account Name column....
Please complete the October journal entries with the information provided. (Not all information provided may be...
Please complete the October journal entries with the information provided. (Not all information provided may be relevant in completing the question). Inventory Information Inventory on hand at the beginning of October: Units Cost / unit Total Cost Purchase # 1 15 60 $900 Purchase # 2 25 70 1,750 40 $2,650 October 2018 transactions related to buying and selling widget inventory 1-Oct Sold 30 widgets at $125 each on credit 3-Oct Purchased 60 widgets at a cost of $80 per...
Please complete a statement of retained earnings with the information provided. (Not all information provided may...
Please complete a statement of retained earnings with the information provided. (Not all information provided may be relevant in completing the question). Inventory Information Inventory on hand at the beginning of October: Units Cost / unit Total Cost Purchase # 1 15 60 $900 Purchase # 2 25 70 1,750 40 $2,650 October 2018 transactions related to buying and selling widget inventory 1-Oct Sold 30 widgets at $125 each on credit 3-Oct Purchased 60 widgets at a cost of $80...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT