Collins Industries, a manufacturer of parts for the automotive industry, closes its books and prepares financial...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Collins Industries, a manufacturer of parts for the automotive industry, closes its books and prepares financial statements at the end of each year. Collins Industries has the following trial balance of accounts at December 31, 2011: Cash and marketable securities Accounts and notes receivable Raw materials inventory-all direct materials (12/31/2010) Work-in-process inventory (12/31/2010) Finished goods inventory (12/31/2010) Property, plant, and equipment (net) Accumulated Depreciation Accounts payable Notes payable (Due March 31, 2012) Bonds payable (6% per annum, due December 31, 2015) Paid -in capital Retained Earnings Sales Collins Industries Trial Balance of Account Balances 31-Dec-11 Purchases of direct materials Discounts Direct labor Indirect factory labor Office salaries Sales salaries Utilities Property taxes Rent Maintenance and repairs, factory equipment Insurance expense Depreciation expense Freight expenses for materials purchases and sales Finished goods warehousing costs Quality inspection-manufacturing Bond interest expense Interest expense (notes payable) Totals Debit 40,000 260,000 20,000 180,000 175,000 2,006,941 682,650 10,000 325,006 100,000 150,000 50,000 120,000 23,000 10,000 40,000 120,000 80,000 43,000 25,000 64,000 22,500 10,750 Credit 780,656 40,000 50,000 500,000 100,000 1,046,441 2,040,750 4,557,847 4,557,847 Your examination of the records of Collins Industries for 2011 provided you with the following information: 1) Sales totalling $150,000 were invoiced and recorded as sales revenue in January 2012. The order was finished and shipped from our warehouse on December 20, 2011. The customer's warehouse received the shipment on December 27, 2011. Uninsured damages of $10,000 occurred to the merchandise. The customer was granted an allowance for the $10,000 of goods on December 28 and was told to destroy the damaged merchandise. No cash was collected in 2011. 2) The $50,000 note with a maturity date of March 31, 2012 was renewed on April 1, 2011, at an annual rate of 6%, payable at maturity. No interest has been accrued as of December 31, 2011. 3) A bill for property taxes of $12,000 (for the period November 1, 2011 - October 31, 2012) was paid in October, 2011 and recorded in "Property taxes". Eighty percent of all property taxes are for the manufacturing facilities and 20% percent are for the administrative offices, sales offices, and corporate vehicles used by the administration. 4) Bonds are payable at 6% per annum. Interest is paid quarterly on the first business day after the end of each quarter (assume 30 days in each month). 5) Freight expenses included freight-in costs of $30,000 for materials purchases and freight-out costs for sales to customers $13,000. 6) Finished goods warehousing costs were rents paid for warehouses to store finished goods prior to shipment to customers. 7) Insurance expense included an $80,000 payment for insurance coverage for the period July 1, 2011 - June 30, 2012). Of all the insurance expense, 70% relates to manufacturing and 30% relates to sales and administrative functions. 8) The Discount account includes sales discounts to customers of $40,000 and discounts from suppliers for purchases of direct materials for $30,000. 9) Our direct laborers were used to install and test new manufacturing equipment (300 hours at $20 per hour). The supplier invoice on the equipment is already recorded. The new equipment is depreciated using straight-line depreciation, with a four-year useful life and no salvage value. The new equipment was fully installed and the company began using it October 1, 2011. Five thousand dollars of parts were taken from inventory and used by contractors to overhaul an older piece of manufacturing equipment. The equipment was fully depreciated and its useful life will be extended by the overhaul for an additional 4 years with no expected salvage value. Collins uses straight-line depreciation. The overhaul was finished and equipment was put into use on March 1, 2011. 10) Unrecorded accrued wages at December 31, 2011 were as follows: Direct labor wages $40,000 15,000 15,000 Office salaries Sales salaries 11) Ending inventory balances from a physical inventory at December 31, 2011 were as follows: Raw materials inventory $25,000 $200,000 Work-in-process inventory Finished goods inventory $130,000 12) 2011 depreciation expense already recorded on assets should be allocated based on the following percentages: $25,000 $35,000 $20,000 $80,000 Manufacturing plant Manufacturing equipment Office Equipment Total 13) Sixty percent of the utilities are for manufacturing operations and the remaining 40% is for the administrative and selling offices 14) Collins assumes a tax rate of 21%. Requirements: 1. Prepare journal entries as necessary to record the additional information provided for 2011 2. Prepare an adjusted trial balance for Dec. 31, 2011. 3. Prepare a Schedule of Cost of Goods Manufactured for Collins Industries for 2011. 4. Prepare an Income Statement for Collins Industries for 2011. 5. Preparation of the adjusted trial balance, schedule of cost of goods manufactured, and income statement should be inter-related so that changes in adjustments are reflected in the adjusted trial balance and automatically flow through to the financial statements. Collins Industries, a manufacturer of parts for the automotive industry, closes its books and prepares financial statements at the end of each year. Collins Industries has the following trial balance of accounts at December 31, 2011: Cash and marketable securities Accounts and notes receivable Raw materials inventory-all direct materials (12/31/2010) Work-in-process inventory (12/31/2010) Finished goods inventory (12/31/2010) Property, plant, and equipment (net) Accumulated Depreciation Accounts payable Notes payable (Due March 31, 2012) Bonds payable (6% per annum, due December 31, 2015) Paid -in capital Retained Earnings Sales Collins Industries Trial Balance of Account Balances 31-Dec-11 Purchases of direct materials Discounts Direct labor Indirect factory labor Office salaries Sales salaries Utilities Property taxes Rent Maintenance and repairs, factory equipment Insurance expense Depreciation expense Freight expenses for materials purchases and sales Finished goods warehousing costs Quality inspection-manufacturing Bond interest expense Interest expense (notes payable) Totals Debit 40,000 260,000 20,000 180,000 175,000 2,006,941 682,650 10,000 325,006 100,000 150,000 50,000 120,000 23,000 10,000 40,000 120,000 80,000 43,000 25,000 64,000 22,500 10,750 Credit 780,656 40,000 50,000 500,000 100,000 1,046,441 2,040,750 4,557,847 4,557,847 Your examination of the records of Collins Industries for 2011 provided you with the following information: 1) Sales totalling $150,000 were invoiced and recorded as sales revenue in January 2012. The order was finished and shipped from our warehouse on December 20, 2011. The customer's warehouse received the shipment on December 27, 2011. Uninsured damages of $10,000 occurred to the merchandise. The customer was granted an allowance for the $10,000 of goods on December 28 and was told to destroy the damaged merchandise. No cash was collected in 2011. 2) The $50,000 note with a maturity date of March 31, 2012 was renewed on April 1, 2011, at an annual rate of 6%, payable at maturity. No interest has been accrued as of December 31, 2011. 3) A bill for property taxes of $12,000 (for the period November 1, 2011 - October 31, 2012) was paid in October, 2011 and recorded in "Property taxes". Eighty percent of all property taxes are for the manufacturing facilities and 20% percent are for the administrative offices, sales offices, and corporate vehicles used by the administration. 4) Bonds are payable at 6% per annum. Interest is paid quarterly on the first business day after the end of each quarter (assume 30 days in each month). 5) Freight expenses included freight-in costs of $30,000 for materials purchases and freight-out costs for sales to customers $13,000. 6) Finished goods warehousing costs were rents paid for warehouses to store finished goods prior to shipment to customers. 7) Insurance expense included an $80,000 payment for insurance coverage for the period July 1, 2011 - June 30, 2012). Of all the insurance expense, 70% relates to manufacturing and 30% relates to sales and administrative functions. 8) The Discount account includes sales discounts to customers of $40,000 and discounts from suppliers for purchases of direct materials for $30,000. 9) Our direct laborers were used to install and test new manufacturing equipment (300 hours at $20 per hour). The supplier invoice on the equipment is already recorded. The new equipment is depreciated using straight-line depreciation, with a four-year useful life and no salvage value. The new equipment was fully installed and the company began using it October 1, 2011. Five thousand dollars of parts were taken from inventory and used by contractors to overhaul an older piece of manufacturing equipment. The equipment was fully depreciated and its useful life will be extended by the overhaul for an additional 4 years with no expected salvage value. Collins uses straight-line depreciation. The overhaul was finished and equipment was put into use on March 1, 2011. 10) Unrecorded accrued wages at December 31, 2011 were as follows: Direct labor wages $40,000 15,000 15,000 Office salaries Sales salaries 11) Ending inventory balances from a physical inventory at December 31, 2011 were as follows: Raw materials inventory $25,000 $200,000 Work-in-process inventory Finished goods inventory $130,000 12) 2011 depreciation expense already recorded on assets should be allocated based on the following percentages: $25,000 $35,000 $20,000 $80,000 Manufacturing plant Manufacturing equipment Office Equipment Total 13) Sixty percent of the utilities are for manufacturing operations and the remaining 40% is for the administrative and selling offices 14) Collins assumes a tax rate of 21%. Requirements: 1. Prepare journal entries as necessary to record the additional information provided for 2011 2. Prepare an adjusted trial balance for Dec. 31, 2011. 3. Prepare a Schedule of Cost of Goods Manufactured for Collins Industries for 2011. 4. Prepare an Income Statement for Collins Industries for 2011. 5. Preparation of the adjusted trial balance, schedule of cost of goods manufactured, and income statement should be inter-related so that changes in adjustments are reflected in the adjusted trial balance and automatically flow through to the financial statements.
Expert Answer:
Related Book For
Corporate Financial Accounting
ISBN: 978-1305653535
14th edition
Authors: Carl S. Warren, James M. Reeve, Jonathan Duchac
Posted Date:
Students also viewed these accounting questions
-
The following bank reconciliation was prepared as of June 30, 20Y7: A. Identify the errors in the bank reconciliation. B. Prepare a corrected bank reconciliation. Poway Co. Bank Reconciliation For...
-
The following bank reconciliation was prepared for Dakota Co. a. Identify the errors in the preceding bank reconciliation. b. Prepare a corrected bank reconciliation. DAKOTA CO. Bank Reconciliation...
-
The following bank reconciliation statement was drawn up on 30 April 2017 in the books of Pikinini Traders: Bank reconciliation statement on 30 April 2017 Amount (R) R2 600 Details Balance as per...
-
Which sets of lines can be removed without stopping the code from compiling and while printing the same output? (Choose three.) A. Lines 15 and 17 B. Lines 16 and 23 C. Lines 17, 18, and 22 D. Line...
-
What is the. difference between a eurobond and a foreign bond, and why do two types of international bonds exist?
-
As it turns out, a research assistant has just finished running the experiment described in Exercise 15.10 without having carried out any power calculations. He tried to run 20 subjects in each...
-
Following are observed frequencies for five categories: a. Compute the expected frequencies for testing H0 : p1 = 0.3, p2 = 0.25, p3 = 0.2, p4 = 0.15, p5 = 0.1. b. One of the observed frequencies is...
-
How is an organization like an iceberg? Use the iceberg metaphor to describe the field of organizational behavior.
-
Use the following information for the Exercises below. Year 1 total cash dividends Year 2 total cash dividends Year 3 total cash dividends Year 4 total cash dividends $ 18,800 27,700 245,000 395,000...
-
Show that the probability that the period of f(x)=a x mod M is odd is at most 1/2.
-
For this assignment, you will analyze two different branded products from similar markets (for example, two different brands of soda, cars, clothing, etc.) to demonstrate your understanding of brand...
-
Which of the following is the shortest path from v to v5? 3 1 V4 O A. v2, v1, v5 OB. v2, v4, v5 OC. v2, v3, v4, v5 2 1 9 4 3
-
[Related to the Making the Connection] An article in the New York Times observed that "the Glass-Steagall Act... forced the separation of investment banking from commercial banking..." And:...
-
To dynamically change a reference line using a parameter action, you first create a reference parameter. Next, add a parameter action for it . Finally, ` _ _ _ _ _ ` . Select an answer: Add a URL...
-
During 2 0 2 3 , Indiana Inc. paid $ 1 0 0 for amounts owed from purchasing supplies on account during 2 0 2 2 . During 2 0 2 3 the company purchased additional supplies on account costing $ 4 0 0 ....
-
3. This questions concerns the foundations of model checking. For Parts (a) and (b) consider the following Bchi automaton over the alphabet {a, b}. a, b 3 a b a a b 2 a (a) Give an w-word that is...
-
1. A sailboat moves north for a distance of 15.00 km when blown by a wind from the exact southeast with a force of 3.00 104 N. The sailboat travels the distance in 1.0 h. How much work was done by...
-
For Problem estimate the change in y for the given change in x. y = f(x), f'(12) = 30, x increases from 12 to 12.2
-
A building with a cost of $1,200,000 has an estimated residual value of $250,000, has an estimated useful life of 40 years, and is depreciated by the straight-line method. (A) What is the amount of...
-
The major fixed assets for each business include aircraft, sorting and handling facilities, delivery vehicles, and information technology. The sales and average book value of fixed assets reported on...
-
List any errors you can find in the following partial balance sheet: Napa Vino Company Balance Sheet December 31, 20Y6 Assets Current assets: 78,500 Cash Notes receivable Interest receivable 300,000...
-
Your client is BigC Ltd, a large private firm with offices in all major cities of the UK. BigC specialises in selling concentrated fruit juices to UK and overseas buyers. This is the first year your...
-
Which of the following controls would be most effective in assuring that recorded purchases are free of material misstatements? (a) Purchase orders, goods received notes and suppliers invoices are...
-
The accounts receivable confirmation statistics working paper (index B-3) that appears over was prepared by an Audit Assistant Peter Porter, during the 20XI year audit of Western Water Ltd, a...
Study smarter with the SolutionInn App