Orwell surf shop accumulates the following adjustments data at December 31. 1. Services performed but unbilled total $3,000 2. Supplies of $300 have been used 3. Utility expenses of $552 are unpaid. 4. Services performed of $260 collected in advance. 5. Salaries of $800 are unpaid. 6. Prepaid insurance totaling $350 has expired. Required: For each of the above items, indicate the type of adjustment required.

Orwell surf shop accumulates the following adjustments data at December 31. 1. Services performed but unbilled total $3,000 2. Supplies of $300 have been used 3. Utility expenses of $552 are unpaid. 4. Services performed of $260 collected in advance. 5. Salaries of $800 are unpaid. 6. Prepaid insurance totaling $350 has expired. Required: For each of the above items, indicate the type of adjustment required.

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter2: Service Company Worksheet (f1work)

Section: Chapter Questions

Problem 5R: The trial balance of Wikki Cleaners at December 31, 2012, the end of the current fiscal year, is as...

See similar textbooks

Similar questions

Reece Financial Services Co., which specializes in appliance repair services, is owned and operated by Joni Reece. Reece Financial Services Co.s accounting clerk prepared the following unadjusted trial balance at July 31, 2016: The data needed to determine year-end adjustments are as follows: a. Depreciation of building for the year, 6,400. b. Depreciation of equipment for the year, 2,800. c. Accrued salaries and wages at July 31, 900. d. Unexpired insurance at July 31, 1,500. e. Fees earned but unbilled on July 31, 10,200. f. Supplies on hand at July 31, 615. g. Rent unearned at July 31, 300. Instructions 1. Journalize the adjusting entries using the following additional accounts: Salaries and Wages Payable; Rent Revenue; Insurance Expense; Depreciation ExpenseBuilding; Depreciation ExpenseEquipment; and Supplies Expense. 2. Determine the balances of the accounts affected by the adjusting entries and preparean adjusted trial balance.
At the end of April, the first month of operations, the following selected data were taken from the financial statements of Shelby Crawford, an attorney: In preparing the financial statements, adjustments for the following data were overlooked: Supplies used during April, 2,750. Unbilled fees earned at April 30, 23,700. Depreciation of equipment for April, 1,800. Accrued wages at April 30, 1,400. Instructions 1. Journalize the entries to record the omitted adjustments. 2. Determine the correct amount of net income for April and the total assets, liabilities, and owners equity at April 30. In addition to indicating the corrected amounts, indicate the effect of each omitted adjustment by setting up and completing a columnar table similar to the following. The adjustment for supplies used is presented as an example.
The unadjusted trial balance of La Mesa Laundry at August 31, 2016, the end of the fiscal year, follows: The data needed to determine year-end adjustments are as follows: a. Wages accrued but not paid at August 31 are 2,200. b. Depreciation of equipment during the year is 8,150. c. Laundry supplies on hand at August 31 are 2,000. d. Insurance premiums expired during the year are 5,300. Instructions 1. For each account listed in the unadjusted trial balance, enter the balance in a T account. Identify the balance as Aug. 31 Bal. In addition, add T accounts for Wages Payable, Depreciation Expense, Laundry Supplies Expense, Insurance Expense, and Income Summary. 2. (Optional) Enter the unadjusted trial balance on an end-of-period spreadsheet and complete the spreadsheet. Add the accounts listed in part (1) as needed. 3. Journalize and post the adjusting entries. Identify the adjustments by Adj. and the new balances as Adj. Bal. 4. Prepare an adjusted trial balance. 5. Prepare an income statement, a statement of owners equity (no additional investments were made during the year), and a balance sheet. 6. Journalize and post the closing entries. Identify the closing entries by Clos. 7. Prepare a post-closing trial balance.
At the end of August, the first month of operations, the following selected data were taken from the financial statements of Tucker Jacobs, an attorney: In preparing the financial statements, adjustments for the following data were overlooked: Unbilled fees earned at August 31, 31,900. Depreciation of equipment for August, 7,500. Accrued wages at August 31, 5,200. Supplies used during August, 3,000. Instructions 1. Journalize the entries to record the omitted adjustments. 2. Determine the correct amount of net income for August and the total assets, liabilities, and owners equity at August 31. In addition to indicating the corrected amounts, indicate the effect of each omitted adjustment by setting up and completing a columnar table similar to the following. The first adjustment is presented as an example.
The trial balance of Wikki Cleaners at December 31, 2012, the end of the current fiscal year, is as follows: Information for the adjusting entries is as follows: a. Cleaning supplies on hand on December 31, 2012, 18,750. b. Insurance premiums expired during the year, 1,800. c. Depreciation on equipment during the year, 21,600. d. Wages accrued but not paid at December 31, 2012, 1,830. As the accountant for Wikki Cleaners, you have been asked to prepare financial statements for the year. A file called F1WORK has been provided to assist you in this assignment. As you review this file, it should be noted that columns H and I will automatically change when you enter values in columns E or G.
Crazy Mountain Outfitters Co., an outfitter store for fishing treks, prepared the following unadjusted trial balance at the end of its first year of operations: For preparing the adjusting entries, the following data were assembled: Supplies on hand on April 30 were 1,380. Fees earned but unbilled on April 30 were 3,900. Depreciation of equipment was estimated to be 3,000 for the year. Unpaid wages accrued on April 30 were 2,475. The balance in unearned fees represented the April 1 receipt in advance for services to be provided. Only 14,140 of the services was provided between April 1 and April 30. Instructions 1. Journalize the adjusting entries necessary on April 30, 2019. 2. Determine the revenues, expenses, and net income of Crazy Mountain Outfitters Co. before the adjusting entries. 3. Determine the revenues, expenses, and net income of Crazy Mountain Outfitters Co. after the adjusting entries. 4. Determine the effect of the adjusting entries on John Bridger, Capital.
The trial balance of Sports Connection at June 30, 2013, the end of the current fiscal year, is as follows: Adjustment information is as follows: a. Supplies on hand as of June 30, 2013, 450. b. Insurance premiums that expired during the year, 2,420. c. Depreciation on equipment during the year, 1,500. d. Included in the rent expense of 30,000 is 1,200 that is prepaid for July 2013. e. Salaries accrued but not paid at June 30, 2013, 1,440. f. Merchandise inventory on June 30, 2013, 68,864. Open the file P2WORK from the website for this book at cengagebrain.com. Enter the formulas in the appropriate cells on the worksheet. Then enter the adjusting amounts in columns E and G. Also, in column D or F, insert the letter corresponding to the adjusting entry (ae). (Note: Not all textbooks handle the change in inventory as an adjustment. Use the method for handling inventory that is prescribed in your textbook.) Column A is frozen on the screen to assist you in completing requirement 3.
The trial balance of Sports Connection at June 30, 2013, the end of the current fiscal year, is as follows: Adjustment information is as follows: a. Supplies on hand as of June 30, 2013, 450. b. Insurance premiums that expired during the year, 2,420. c. Depreciation on equipment during the year, 1,500. d. Included in the rent expense of 30,000 is 1,200 that is prepaid for July 2013. e. Salaries accrued but not paid at June 30, 2013, 1,440. f. Merchandise inventory on June 30, 2013, 68,864. As the accountant for Sports Connection, you have been asked to prepare adjusting entries and financial statements to complete the accounting cycle for the year. A worksheet called P2WORK has been provided to assist you in this assignment. As you review this worksheet, it should be noted that columns H and I will automatically change when you enter values in columns E and G.
The trial balance of Sports Connection at June 30, 2013, the end of the current fiscal year, is as follows: Adjustment information is as follows: a. Supplies on hand as of June 30, 2013, 450. b. Insurance premiums that expired during the year, 2,420. c. Depreciation on equipment during the year, 1,500. d. Included in the rent expense of 30,000 is 1,200 that is prepaid for July 2013. e. Salaries accrued but not paid at June 30, 2013, 1,440. f. Merchandise inventory on June 30, 2013, 68,864. Complete the income statement and balance sheet by entering formulas in columns J, K, L, and M that reference the appropriate cells in column H or I. Net income will be automatically calculated at the bottom of the income statement and balance sheet columns. Check to be sure that these numbers are the same. Enter your name in cell A1. Save the completed file as P2WORK3. Print the worksheet. Also print your formulas using landscape orientation and fit-to-1 page scaling. Check figure: Net income (cell J34), 37,902.
The trial balance of Sports Connection at June 30, 2013, the end of the current fiscal year, is as follows: Adjustment information is as follows: a. Supplies on hand as of June 30, 2013, 450. b. Insurance premiums that expired during the year, 2,420. c. Depreciation on equipment during the year, 1,500. d. Included in the rent expense of 30,000 is 1,200 that is prepaid for July 2013. e. Salaries accrued but not paid at June 30, 2013, 1,440. f. Merchandise inventory on June 30, 2013, 68,864. In the space provided below, prepare an income statement, a capital statement (statement of owners equity), and a balance sheet. Use the corrected worksheet (P2WORK4) as a basis for your work. Assume no additional owner investments were made during the year.
The account balances of Bryan Company as of June 30, the end of the current fiscal year, are as follows: Required 1. Data for the adjustments are as follows: a. Expired or used up insurance, 495 b. Depreciation expense on equipment, 670. c. Depreciation expense on the van, 1,190. d. Salary accrued (earned) since the last payday, 540 (owed and to be paid on the next payday). e. Supplies used during the period, 97. Your instructor may want you to use a work sheet for these adjustments. 2. Journalize the adjusting entries. 3. Prepare an income statement. 4. Prepare a statement of owners equity. Assume that there was an additional investment of 2,000 on June 10. 5. Prepare a balance sheet. 6. Journalize the closing entries using the four steps in the correct sequence. Check Figure Net Income, 13,627
Reece Financial Services Co., which specializes in appliance repair services, is owned and operated by Joni Reece. Reece Financial Services accounting clerk prepared the following unadjusted trial balance at July 31, 2019: The data needed to determine year-end adjustments are as follows: Depreciation of building for the year, 6,400. Depreciation of equipment for the year, 2,800. Accrued salaries and wages at July 31, 900. Unexpired insurance at July 31, 1,500. Fees earned but unbilled on July 31, 10,200. Supplies on hand at July 31, 615. Rent unearned at July 31, 300. Instructions 1. Journalize the adjusting entries using the following additional accounts: Salaries and Wages Payable, Rent Revenue, Insurance Expense, Depreciation ExpenseBuilding, Depreciation ExpenseEquipment, and Supplies Expense. 2. Determine the balances of the accounts affected by the adjusting entries and prepare an adjusted trial balance.