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...
-
Find the coefficients that balance the following equations. a. O2 + PCl3 POCl3 b. P4 + N2O P4O6 + N2 c. As2S3 + O2 As2O3 + SO2 d. Ca3(PO4)2 + H3PO4 Ca(H2PO4)2
-
Day Street Delis owner is disturbed by the poor profit performance of his ice cream counter. He has prepared the following profit analysis for the year just ended. Sales ....................... $...
-
How long have you been working in your current position?
-
The vice president of operations of I4 Computers Inc. is evaluating the performance of two divisions organized as investment centers. Invested assets and condensed income statement data for the past...
-
Multiple Choice Question One indication of financial weakness is that Multiple choice question. the fair value of the firm's debt is higher than the book value. current cash from operations is more...
-
You are considering a purchase of a 4-plex, which is located in a desirable neighborhood. The cost of the property is $500,000. Effective rents are expected to average $1500 per month. Every resident...
-
Completing the CREATE TABLE statements Address Column Data Type Rules addressID INT IDENTITY addressLine VARCHAR(100) NOT NULL suburb VARCHAR(50) NOT NULL postcode VARCHAR(10) NOT NULL region...
-
6. In the double-slit interference experiment, SS1-SS2, as shown in figure 2.6, the double-slit was illuminated by monochromatic light with wavelength, and the interference fringes were formed on the...
-
80 kg patient is given a radioactive dose of 99Tc with the half-life 6 hours. The activity of the solution at the injection moment is A = 5.3x10 Bq. 99 Tc releases 143 keV photons and the RBE is 0.80...
-
21. Calculate the heat energy required to melt 8 kg of ice (Latent heat of fusion 3.34e5 J/kg). A. 2672000 J B. 3376316.722 J C. 1905304.128 J D. 2186520.004 J E. 1422067.935 J Mui.
-
12. Calculate the momentum of an object of mass 12 kg if its kinetic energy is 10 J. A. 12.796 kg m/s B. 26.048 kg m/s C. 2.087 kg m/s D. 23.465 kg m/s E. 15.492 kg m/s
-
The data listed below are claimed for a power cycle operating between hot and cold reservoirs at 500C and 10C, respectively. For each case, determine whether the cycle operates reversibly, operates...
-
If the distance of the object is 250 cm and the distance of the image is 140 cm, I say that the focal length is 390 cm. A. True B. False
-
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...
-
The "fun size" of a Snickers bar is supposed to weigh 20 grams. Because the penalty for selling candy bars under their advertised weight is severe, the manufacturer calibrates the machine so the mean...
-
According to the American Community Survey, the mean travel time to work in Collin County, Texas, in 2013 was 27.5 minutes. The Department of Transportation reprogrammed all the traffic lights in...
-
(a) Determine the critical value(s) for a right-tailed test of a population mean at the \(\alpha=0.01\) level of significance with 15 degrees of freedom. (b) Determine the critical value(s) for a...
Study smarter with the SolutionInn App