50.1K

Verified Solution

Link Copied!

Please can someone help me with the part 2 on this excel format, i need it asap

Chart of Accounts \begin{tabular}{|c|l|} \hline \multicolumn{2}{|l|}{ Current Assets } \\ \hline 10000 & Cash \\ \hline 11000 & Accounts Receivable \\ \hline 12000 & Inventory - Skis \\ \hline 12100 & Inventory - Snowboards \\ \hline 13100 & Office Supplies \\ \hline 13200 & Shipping Supplies \\ \hline 14000 & Prepaid Rent \\ \hline 14100 & Prepaid Insurance \\ \hline \end{tabular} \begin{tabular}{|c|l|} \hline \multicolumn{2}{|l|}{ Stockholders' Equity } \\ \hline 39003 & Common Stock \\ \hline 39005 & Retained Earnings \\ \hline 39007 & Dividends \\ \hline \end{tabular} \begin{tabular}{|c|l|} \hline \multicolumn{2}{|c|}{ Revenue } \\ \hline 40000 & Sales \\ \hline \end{tabular} \begin{tabular}{|c|l|} \hline \multicolumn{2}{|l|}{ Long-Term Assets } \\ \hline 15000 & Furniture and Fixtures \\ \hline 17000 & AccumulatedDepreciation-FurnitureandFixtures \\ \hline 15100 & Computer Equipment \\ \hline 17100 & AccumulatedDepreciation-ComputerEquipment \\ \hline \end{tabular} \begin{tabular}{|c|l|} \hline \multicolumn{2}{|c|}{ Current Liabilities } \\ \hline 20000 & Accounts Payable \\ \hline 21100 & NotePayable-WellsFargoBank \\ \hline 21200 & NotePayable-ComputerInc. \\ \hline 23100 & Wages Payable \\ \hline 23200 & Interest Payable \\ \hline 23300 & Sales Tax Payable \\ \hline 23400 & Utilities Payable \\ \hline Long Term Liabilities \\ \hline 27000 & Mortgage Payable \\ \hline 27100 & Note Payable \\ \hline \end{tabular} \begin{tabular}{|c|l|} \hline \multicolumn{2}{|c|}{ Expenses } \\ \hline 50000 & Cost of Goods Sold \\ \hline 60100 & Legal Expense \\ \hline 60150 & Office Supplies Expense \\ \hline 60200 & ShippingSuppliesExpense \\ \hline 60300 & Insurance Expense \\ \hline 60350 & Wages Expense \\ \hline 60400 & Credit Card Expense \\ \hline 60450 & Delivery Expense \\ \hline 60500 & AdvertisingandPromotionExpense \\ \hline 60550 & Utlity Expense \\ \hline 60600 & Rent Expense \\ \hline 60650 & Depreciation Expense \\ \hline 60700 & Interest Expense \\ \hline 60750 & Bank Service Fee \\ \hline 60800 & RegistrationFeeExpense \\ \hline 60850 & Gasoline Expense \\ \hline \end{tabular} Part Two Instructions Before you prepare the eight adjusting joumal entries below in an Excel spreadisheet, please make sure corrections have been made to any of the previous joumal entries in part one. The following are the Gdiusting iournal entries for the month of January. Record all adjusting entries as of January 31, 2023. Record Adjusting Entries: Record the following month end adjusting entries for the month of January. Write the journal entries in the practice set atter the original journal entries. Round all answers to the nearest cent. a. $70 of office supplies remained on hand. b. $200 of shipping supplies remained on hand. c. $1,300 of wages for the part-time help from lrene's Temp Services for January should be accrued. Do not worry about payroll taxes: Temp Services inc. will handle these. d. Make the necessary adjusting entries for one month's depreciation for the Computer Equipment using Straight Line Depreciation. e. Make the necessary adjusting entry for one month's depreciation for the furniture and fixtures using Straight Line Depreciation. f. One month of the prepaid insurance has expired. g. One month of the prepaid rent has expired. h. Record the interest for the loan from Wells Fargo for one month. Make sure you prepare the adjusting entries and write them in the template for the adjusting entries. Follow the same instructions for the adjusting journal entries that you did in part one. Once the adjusting entries have been completed in the spreadsheet use the spreadsheet to answer the questions in Blackboard then upload the spreadsheet to Blackboard. Follow these instructions. Step 1: Enter the adjusting journal entries in an Excel spreadsheet and print it out. Step 2: Use the Excel spreadsheet to answer the questions in Blackboard in the content folder n the corresponding week. itep 3: Once you complete entering information into Blackboard upload the spreadsheet into lackboard. 'Do not enter the information highlighted in vellow into BB, Some transactions will have more then one debit or eredit so enter the smallest account first. Do not enter the transaction H in BE: Use with or without grithines. Chart of Accounts \begin{tabular}{|c|l|} \hline \multicolumn{2}{|l|}{ Current Assets } \\ \hline 10000 & Cash \\ \hline 11000 & Accounts Receivable \\ \hline 12000 & Inventory - Skis \\ \hline 12100 & Inventory - Snowboards \\ \hline 13100 & Office Supplies \\ \hline 13200 & Shipping Supplies \\ \hline 14000 & Prepaid Rent \\ \hline 14100 & Prepaid Insurance \\ \hline \end{tabular} \begin{tabular}{|c|l|} \hline \multicolumn{2}{|l|}{ Stockholders' Equity } \\ \hline 39003 & Common Stock \\ \hline 39005 & Retained Earnings \\ \hline 39007 & Dividends \\ \hline \end{tabular} \begin{tabular}{|c|l|} \hline \multicolumn{2}{|c|}{ Revenue } \\ \hline 40000 & Sales \\ \hline \end{tabular} \begin{tabular}{|c|l|} \hline \multicolumn{2}{|l|}{ Long-Term Assets } \\ \hline 15000 & Furniture and Fixtures \\ \hline 17000 & AccumulatedDepreciation-FurnitureandFixtures \\ \hline 15100 & Computer Equipment \\ \hline 17100 & AccumulatedDepreciation-ComputerEquipment \\ \hline \end{tabular} \begin{tabular}{|c|l|} \hline \multicolumn{2}{|c|}{ Current Liabilities } \\ \hline 20000 & Accounts Payable \\ \hline 21100 & NotePayable-WellsFargoBank \\ \hline 21200 & NotePayable-ComputerInc. \\ \hline 23100 & Wages Payable \\ \hline 23200 & Interest Payable \\ \hline 23300 & Sales Tax Payable \\ \hline 23400 & Utilities Payable \\ \hline Long Term Liabilities \\ \hline 27000 & Mortgage Payable \\ \hline 27100 & Note Payable \\ \hline \end{tabular} \begin{tabular}{|c|l|} \hline \multicolumn{2}{|c|}{ Expenses } \\ \hline 50000 & Cost of Goods Sold \\ \hline 60100 & Legal Expense \\ \hline 60150 & Office Supplies Expense \\ \hline 60200 & ShippingSuppliesExpense \\ \hline 60300 & Insurance Expense \\ \hline 60350 & Wages Expense \\ \hline 60400 & Credit Card Expense \\ \hline 60450 & Delivery Expense \\ \hline 60500 & AdvertisingandPromotionExpense \\ \hline 60550 & Utlity Expense \\ \hline 60600 & Rent Expense \\ \hline 60650 & Depreciation Expense \\ \hline 60700 & Interest Expense \\ \hline 60750 & Bank Service Fee \\ \hline 60800 & RegistrationFeeExpense \\ \hline 60850 & Gasoline Expense \\ \hline \end{tabular} Part Two Instructions Before you prepare the eight adjusting joumal entries below in an Excel spreadisheet, please make sure corrections have been made to any of the previous joumal entries in part one. The following are the Gdiusting iournal entries for the month of January. Record all adjusting entries as of January 31, 2023. Record Adjusting Entries: Record the following month end adjusting entries for the month of January. Write the journal entries in the practice set atter the original journal entries. Round all answers to the nearest cent. a. $70 of office supplies remained on hand. b. $200 of shipping supplies remained on hand. c. $1,300 of wages for the part-time help from lrene's Temp Services for January should be accrued. Do not worry about payroll taxes: Temp Services inc. will handle these. d. Make the necessary adjusting entries for one month's depreciation for the Computer Equipment using Straight Line Depreciation. e. Make the necessary adjusting entry for one month's depreciation for the furniture and fixtures using Straight Line Depreciation. f. One month of the prepaid insurance has expired. g. One month of the prepaid rent has expired. h. Record the interest for the loan from Wells Fargo for one month. Make sure you prepare the adjusting entries and write them in the template for the adjusting entries. Follow the same instructions for the adjusting journal entries that you did in part one. Once the adjusting entries have been completed in the spreadsheet use the spreadsheet to answer the questions in Blackboard then upload the spreadsheet to Blackboard. Follow these instructions. Step 1: Enter the adjusting journal entries in an Excel spreadsheet and print it out. Step 2: Use the Excel spreadsheet to answer the questions in Blackboard in the content folder n the corresponding week. itep 3: Once you complete entering information into Blackboard upload the spreadsheet into lackboard. 'Do not enter the information highlighted in vellow into BB, Some transactions will have more then one debit or eredit so enter the smallest account first. Do not enter the transaction H in BE: Use with or without grithines

Answer & Explanation Solved by verified expert

See Answer