Comprehensive Problem 3 Hide the text assignment. Student Instructions Hide the student instructions. Print the text assignment. Print the instructions. Follow the steps below to complete Comprehensive Problem 3 Part 3 using Cengage General Ledger. The problem is in three parts, each graded separately. When you begin the third part, all account balances will be set correctly for the beginning of that part, in order to prevent any previous errors from compounding. To access additional Help, click on the Help button that appears in the lower part of your screen (note that you may need to scroll down and over to see this button). Selected transactions completed by Kornett Company during its first fiscal year ended December 31, 2045, were as follows: Jan. 3. Issued a check to establish a petty cash fund of $4,500 Feb. 26. Replenished the petty cash fund, based on the following summary of petty cash receipts: office supplies, $1,680, miscellaneous selling expense, $570; miscellaneous administrative expense, $880. Apr. 14. Purchased $31,300 of merchandise on account terms 1/10,n/30. The perpetual inventory system is used to account for inventory. May 13. Paid the invoice of April 14 after the discount period had passed. 17. Received cash from daily cash sales for $21,200. The amount indicated by the cash register was $21,240. June 2. Received a 60-day, 8% note for $180,000 on the Ryanair account. Aug. 1. Received amount owed on June 2 note, plus interest at the maturity date. 24. Received $7,600 on the Finley account and wrote off the remainder owed on a $9,000 accounts receiv- able balance. (The allowance method is used in accounting for uncollectible receivables.) Sept. 15. Reinstated the Finley account written off on August 24 and received $1,400 cash in full payment. 15. Purchased land by issuing a $670,000, 90-day note to Zahorik Co, which discounted it at 9%. 17. Sold office equipment in exchange for $135,000 cash plus receipt of a $100,000, 90-day, 9% note. The equipment had a cost of $320,000 and accumulated depreciation of $64,000 as of October 17. Nov. 30 Journalized the monthly payroll for November, based on the following data: Salaries Deductions Sales salaries Income tax withheld $39,266 Office salaries 77,250 Social security tax withheld 12,735 $212,250 Medicare tax withheld 3,184 1. All account setups and opening balances required to begin this problem are loaded when you select the problem from the CengageNOW assignment menu. 2. Set the System Date in the lower part of your screen to 12/31/18 (note that you may need to scroll down to see the System Date box). 3. Perform period-end closing. Click on the General Ledger tab and select Generate Closing Entries from the Tasks section of the left menu bar. 4. Display the Post-Closing Trial Balance report and the Balance Sheet. 5. When you are comfortable that you have completed all steps of the problem correctly, click on the Check My Work button near the bottom of your screen if it is available, or click on the Submit Assignment for Grading button in the lower right of your screen. The program will then display the results of the grading, indicating accounts in error with a red X. Note that grading in Cengage Learning General Ledger is based on getting each General Ledger account and customer to its correct ending balance, as well as the reconciliation information, rather than grading journal transactions individually. This means that the order of transactions in the general journal is not graded, so you may add transactions and also delete or correct transactions without penalty if you run into difficulty with the assignment. Unemployment tax rates: State unemployment 5.4% Federal unemployment 0.8% Amount subject to unemployment taxes: State unemployment $5,000 Federal unemployment 5,000 30. Journalized the employer's payroll taxes on the payroll. 14. Journalized the payment of the September 15 note at maturity. 31. The pension cost for the year was $190,400, of which $139,700 was paid to the pension plan trustee Dec Instructions 1. Journalize the selected transactions. 2. Based on the following data, prepare a bank reconciliation for December of the current year: Balance according to the bank statement at December 31, $283,000. Balance according to the ledger at December 31, $245,410. Checks outstanding at December 31, $68,540. Deposit in transit, not recorded by bank, $29,500. Bank debit memo for service charges, $750. A check for $12,700 in payment of an invoice was incorrectly recorded in the accounts as $12,000. 3. Based on the bank reconciliation prepared in (2), journalize the entry or entries to be made by Kornett Company. Use the Miscellaneous Administrative Expense account to record bank service charges. 4. Based on the following selected data, journalize the adjusting entries as of December 31 of the current year: A Estimated uncollectible accounts at December 31, $16,000, based on an aging of accounts receivable. The balance of Allowance for Doubtful Accounts at December 31 was $2,000 (debit). B. The physical inventory on December 31 indicated an inventory shrinkage of $3,300. C. Prepaid insurance expired during the year, $22,820. D. Office supplies used during the year, $3,920. E. Depreciation is computed as follows: Residual Acquisition Useful Life Depreciation Asset Cost Value Date in Years Method Used Buildings $900,000 $ 0 January 2 Double-declining-balance Office Equip. 246,000 26,000 January 3 Straight-line Store Equip 112,000 2,000 July 1 10 Straight-line F. A patent costing $48,000 when acquired on January 2 has a remaining legal life of 10 years and is expected to have value for 8 years. G. The cost of mineral rights was $546,000. Of the estimated deposit of 910,000 tons of ore, 50,000 tons were mined and sold during the year. H. Vacation pay expense for December, $10,500. 1. A product warranty was granted beginning December 1 and covering a one-year period. The estimated cost is 4% of sales, which totaled $1,900,000 in December. J. Interest was accrued on the note receivable received on October 17. 5. Based on the following information and the post-closing trial balance that follows, prepare a balance sheet in report form at December 31 of the current year: The merchandise inventory is stated at cost by the LIFO method. The product warranty payable is a current liability Vacation pay payable: Current liability $7,140 Long-term liability 3360 The unfunded pension liability is a long-term liability Notes payable: Current liability $ 70,000 Long-term liability 630,000 Kornett Company Post-Closing Trial Balance December 31, 2015 Credit Balances Debit Balances 4 500 243,960 100,000 470,000 16,000 320,000 1,875 45,640 13,400 654,925 900,000 36,000 246,000 44,000 112,000 5,000 Petty Cash ............... Cash ....................... ......... Notes Receivable......... Accounts Receivable........ Allowance for Doubtful Accounts................. Inventory ............ . . . ..... Interest Receivable.................. Prepaid Insurance...... Office Supplies............... ....... . Land ........... Buildings ........ .. ..... Accumulated DepreciationBuildings............. Office Equipment ............................. Accumulated Depreciation Office Equipment..... Store Equipment ....................... Accumulated Depreciation Store Equip Mineral Rights ..................................... Accumulated Depletion............... ....... Patents ................ Social Security Tax Payable..................... Medicare Tax Payable........... Employees Federal Income Tax Payable .......... State Unemployment Tax Payable ........... Federal Unemployment Tax Payable Salaries Payable.... Accounts Payable ........ Interest Payable............. Product Warranty Payable...... Vacation Pay Payable............ Unfunded Pension Liability Notes Payable. Common Stock....... Retained Earnings.......... 546,000 30,000 42,000 25,470 4,710 40,000 270 157,000 131,600 28,000 76,000 10,500 50,700 700,000 500,000 1.845,010 3,700,300 3,700 300 Comprehensive Problem 3 Hide the text assignment. Student Instructions Hide the student instructions. Print the text assignment. Print the instructions. Follow the steps below to complete Comprehensive Problem 3 Part 3 using Cengage General Ledger. The problem is in three parts, each graded separately. When you begin the third part, all account balances will be set correctly for the beginning of that part, in order to prevent any previous errors from compounding. To access additional Help, click on the Help button that appears in the lower part of your screen (note that you may need to scroll down and over to see this button). Selected transactions completed by Kornett Company during its first fiscal year ended December 31, 2045, were as follows: Jan. 3. Issued a check to establish a petty cash fund of $4,500 Feb. 26. Replenished the petty cash fund, based on the following summary of petty cash receipts: office supplies, $1,680, miscellaneous selling expense, $570; miscellaneous administrative expense, $880. Apr. 14. Purchased $31,300 of merchandise on account terms 1/10,n/30. The perpetual inventory system is used to account for inventory. May 13. Paid the invoice of April 14 after the discount period had passed. 17. Received cash from daily cash sales for $21,200. The amount indicated by the cash register was $21,240. June 2. Received a 60-day, 8% note for $180,000 on the Ryanair account. Aug. 1. Received amount owed on June 2 note, plus interest at the maturity date. 24. Received $7,600 on the Finley account and wrote off the remainder owed on a $9,000 accounts receiv- able balance. (The allowance method is used in accounting for uncollectible receivables.) Sept. 15. Reinstated the Finley account written off on August 24 and received $1,400 cash in full payment. 15. Purchased land by issuing a $670,000, 90-day note to Zahorik Co, which discounted it at 9%. 17. Sold office equipment in exchange for $135,000 cash plus receipt of a $100,000, 90-day, 9% note. The equipment had a cost of $320,000 and accumulated depreciation of $64,000 as of October 17. Nov. 30 Journalized the monthly payroll for November, based on the following data: Salaries Deductions Sales salaries Income tax withheld $39,266 Office salaries 77,250 Social security tax withheld 12,735 $212,250 Medicare tax withheld 3,184 1. All account setups and opening balances required to begin this problem are loaded when you select the problem from the CengageNOW assignment menu. 2. Set the System Date in the lower part of your screen to 12/31/18 (note that you may need to scroll down to see the System Date box). 3. Perform period-end closing. Click on the General Ledger tab and select Generate Closing Entries from the Tasks section of the left menu bar. 4. Display the Post-Closing Trial Balance report and the Balance Sheet. 5. When you are comfortable that you have completed all steps of the problem correctly, click on the Check My Work button near the bottom of your screen if it is available, or click on the Submit Assignment for Grading button in the lower right of your screen. The program will then display the results of the grading, indicating accounts in error with a red X. Note that grading in Cengage Learning General Ledger is based on getting each General Ledger account and customer to its correct ending balance, as well as the reconciliation information, rather than grading journal transactions individually. This means that the order of transactions in the general journal is not graded, so you may add transactions and also delete or correct transactions without penalty if you run into difficulty with the assignment. Unemployment tax rates: State unemployment 5.4% Federal unemployment 0.8% Amount subject to unemployment taxes: State unemployment $5,000 Federal unemployment 5,000 30. Journalized the employer's payroll taxes on the payroll. 14. Journalized the payment of the September 15 note at maturity. 31. The pension cost for the year was $190,400, of which $139,700 was paid to the pension plan trustee Dec Instructions 1. Journalize the selected transactions. 2. Based on the following data, prepare a bank reconciliation for December of the current year: Balance according to the bank statement at December 31, $283,000. Balance according to the ledger at December 31, $245,410. Checks outstanding at December 31, $68,540. Deposit in transit, not recorded by bank, $29,500. Bank debit memo for service charges, $750. A check for $12,700 in payment of an invoice was incorrectly recorded in the accounts as $12,000. 3. Based on the bank reconciliation prepared in (2), journalize the entry or entries to be made by Kornett Company. Use the Miscellaneous Administrative Expense account to record bank service charges. 4. Based on the following selected data, journalize the adjusting entries as of December 31 of the current year: A Estimated uncollectible accounts at December 31, $16,000, based on an aging of accounts receivable. The balance of Allowance for Doubtful Accounts at December 31 was $2,000 (debit). B. The physical inventory on December 31 indicated an inventory shrinkage of $3,300. C. Prepaid insurance expired during the year, $22,820. D. Office supplies used during the year, $3,920. E. Depreciation is computed as follows: Residual Acquisition Useful Life Depreciation Asset Cost Value Date in Years Method Used Buildings $900,000 $ 0 January 2 Double-declining-balance Office Equip. 246,000 26,000 January 3 Straight-line Store Equip 112,000 2,000 July 1 10 Straight-line F. A patent costing $48,000 when acquired on January 2 has a remaining legal life of 10 years and is expected to have value for 8 years. G. The cost of mineral rights was $546,000. Of the estimated deposit of 910,000 tons of ore, 50,000 tons were mined and sold during the year. H. Vacation pay expense for December, $10,500. 1. A product warranty was granted beginning December 1 and covering a one-year period. The estimated cost is 4% of sales, which totaled $1,900,000 in December. J. Interest was accrued on the note receivable received on October 17. 5. Based on the following information and the post-closing trial balance that follows, prepare a balance sheet in report form at December 31 of the current year: The merchandise inventory is stated at cost by the LIFO method. The product warranty payable is a current liability Vacation pay payable: Current liability $7,140 Long-term liability 3360 The unfunded pension liability is a long-term liability Notes payable: Current liability $ 70,000 Long-term liability 630,000 Kornett Company Post-Closing Trial Balance December 31, 2015 Credit Balances Debit Balances 4 500 243,960 100,000 470,000 16,000 320,000 1,875 45,640 13,400 654,925 900,000 36,000 246,000 44,000 112,000 5,000 Petty Cash ............... Cash ....................... ......... Notes Receivable......... Accounts Receivable........ Allowance for Doubtful Accounts................. Inventory ............ . . . ..... Interest Receivable.................. Prepaid Insurance...... Office Supplies............... ....... . Land ........... Buildings ........ .. ..... Accumulated DepreciationBuildings............. Office Equipment ............................. Accumulated Depreciation Office Equipment..... Store Equipment ....................... Accumulated Depreciation Store Equip Mineral Rights ..................................... Accumulated Depletion............... ....... Patents ................ Social Security Tax Payable..................... Medicare Tax Payable........... Employees Federal Income Tax Payable .......... State Unemployment Tax Payable ........... Federal Unemployment Tax Payable Salaries Payable.... Accounts Payable ........ Interest Payable............. Product Warranty Payable...... Vacation Pay Payable............ Unfunded Pension Liability Notes Payable. Common Stock....... Retained Earnings.......... 546,000 30,000 42,000 25,470 4,710 40,000 270 157,000 131,600 28,000 76,000 10,500 50,700 700,000 500,000 1.845,010 3,700,300 3,700 300