A machine costing $209,600 with a four-year life and an estimated $16,000 salvage value is installed in Luther Company's factory on January 1. The factory manager estimates the machine will produce 484,000 units of product during its life. It actually produces the following units: 122,900 in Year 1, 123,100 in Year 2, 120,800 in Year 3, 127.200 in Year 4. The total number of units produced by the end of Year 4 exceeds the original estimate–this difference was not predicted. (The machine cannot be depreciated below its estimated salvage value.) Required: Compute depreciation for each year (and total depreciation of all years combined) for the machine under each depreciation method. (Round your per unit depreciation to 2 decimal places. Round your answers to the nearest whole dollar.) Complete this question by entering your answers in the tabs below. Units of Production Straight Line DDB Compute depreciation for each year (and total depreciation of all years combined) for the machine under the Double- declining-balance. End of Period DDB Depreciation for the Period Beginning of Period Book Value Depreciation Depreciation Rate Accumulated Book Value Year Expense Depreciation % 1 % % 3 Total < Units of Production

A machine costing $209,600 with a four-year life and an estimated $16,000 salvage value is installed in Luther Company's factory on January 1. The factory manager estimates the machine will produce 484,000 units of product during its life. It actually produces the following units: 122,900 in Year 1, 123,100 in Year 2, 120,800 in Year 3, 127.200 in Year 4. The total number of units produced by the end of Year 4 exceeds the original estimate–this difference was not predicted. (The machine cannot be depreciated below its estimated salvage value.) Required: Compute depreciation for each year (and total depreciation of all years combined) for the machine under each depreciation method. (Round your per unit depreciation to 2 decimal places. Round your answers to the nearest whole dollar.) Complete this question by entering your answers in the tabs below. Units of Production Straight Line DDB Compute depreciation for each year (and total depreciation of all years combined) for the machine under the Double- declining-balance. End of Period DDB Depreciation for the Period Beginning of Period Book Value Depreciation Depreciation Rate Accumulated Book Value Year Expense Depreciation % 1 % % 3 Total < Units of Production

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter9: Depreciation (deprec)

Section: Chapter Questions

Problem 1R: Dunedin Drilling Company recently acquired a new machine at a cost of 350,000. The machine has an...

See similar textbooks

Similar questions

Montello Inc. purchases a delivery truck for $15,000. The truck has a salvage value of $3,000 and is expected to be driven for 120,000 miles. Montello uses the units-of-production depreciation method and in year one it expects to use the truck for 23,000 miles. Calculate the annual depreciation expense.
St. Johns Medical Center (SJMC) has five medical technicians who are responsible for conducting cardiac catheterization testing in SJMCs Cath Lab. Each technician is paid a salary of 36,000 and is capable of conducting 1,000 procedures per year. The cardiac catheterization equipment is one year old and was purchased for 250,000. It is expected to last five years. The equipments capacity is 25,000 procedures over its life. Depreciation is computed on a straight-line basis, with no salvage value expected. The reading of the catheterization results is conducted by an outside physician whose fee is 120 per test. The technicians report with the outside physicians note of results is sent to the referring physician. In addition to the salaries and equipment, SJMC spends 50,000 for supplies and other costs needed to operate the equipment (assuming 5,000 procedures are conducted). When SJMC purchased the equipment, it fully expected to perform 5,000 procedures per year. In fact, during its first year of operation, 5,000 procedures were run. However, a larger hospital has established a clinic in the city and will siphon off some of SJMCs business. During the coming years, SJMC expects to run only 4,200 cath procedures yearly. SJMC has been charging 850 for the procedureenough to cover the direct costs of the procedure plus an assignment of general overhead (e.g., depreciation on the hospital building, lighting and heating, and janitorial services). At the beginning of the second year, an HMO from a neighboring community approached SJMC and offered to send its clients to SJMC for cardiac catheterization provided that the charge per procedure would be 550. The HMO estimates that it can provide about 500 patients per year. The HMO has indicated that the arrangement is temporaryfor one year only. The HMO expects to have its own testing capabilities within one year. Required: 1. Classify the resources associated with the cardiac catheterization activity into one of the following: (1) committed resources, or (2) flexible resources. 2. Calculate the activity rate for the cardiac catheterization activity. Break the activity rate into fixed and variable components. Now, classify each activity resource as relevant or irrelevant with respect to the following alternatives: (1) accept the HMO offer, or (2) reject the HMO offer. Explain your reasoning. 3. Assume that SJMC will accept the HMO offer if it reduces the hospitals operating costs. Should the HMO offer be accepted? 4. Jerold Bosserman, SJMCs hospital controller, argued against accepting the HMOs offer. Instead, he argued that the hospital should be increasing the charge per procedure rather than accepting business that doesnt even cover full costs. He also was concerned about local physician reaction if word got out that the HMO was receiving procedures for 550. Discuss the merits of Jerolds position. Include in your discussion an assessment of the price increase that would be needed if the objective is to maintain total revenues from cardiac catheterizations experienced in the first year of operation. 5. Chandra Denton, SJMCs administrator, has been informed that one of the Cath Lab technicians is leaving for an opportunity at a larger hospital. She met with the other technicians, and they agreed to increase their hours to pick up the slack so that SJMC wont need to hire another technician. By working a couple hours extra every week, each remaining technician can perform 1,050 procedures per year. They agreed to do this for an increase in salary of 2,000 per year. How does this outcome affect the analysis of the HMO offer? 6. Assuming that SJMC wants to bring in the same revenues earned in the cardiac catheterization activitys first year less the reduction in resource spending attributable to using only four technicians, how much must SJMC charge for a procedure?
A machine costing 350,000 has a salvage value of 15,000 and an estimated life of three years. Prepare depreciation schedules reporting the depreciation expense, accumulated depreciation, and book value of the machine for each year under the double-declining-balance and sum-of-the-years-digits methods. For the double-declining-balance method, round the depreciation rate to two decimal places.
The activity of moving materials uses four forklifts, each leased for 18,000 per year. A forklift is capable of making 5,000 moves per year, where a move is defined as a round trip from the plant to the warehouse and back. During the year, a total of 18,000 moves were made. What is the cost of the unused capacity for the moving goods activity? a. 5,400 b. 1,800 c. 7,200 d. 3,600
During the current year, Arkells Inc. made the following expenditures relating to plant machinery. Renovated five machines for $100,000 to improve efficiency in production of their remaining useful life of five years Low-cost repairs throughout the year totaled $70,000 Replaced a broken gear on a machine for $10,000 A. What amount should be expensed during the period? B. What amount should be capitalized during the period?
Dunedin Drilling Company recently acquired a new machine at a cost of 350,000. The machine has an estimated useful life of four years or 100,000 hours, and a salvage value of 30,000. This machine will be used 30,000 hours during Year 1, 20,000 hours in Year 2, 40,000 hours in Year 3, and 10,000 hours in Year 4. With DEPREC5 still on the screen, click the Chart sheet tab. This chart shows the accumulated depreciation under all three depreciation methods. Identify below the depreciation method that each represents. Series 1 _____________________ Series 2 _____________________ Series 3 _____________________ When the assignment is complete, close the file without saving it again. Worksheet. The problem thus far has assumed that assets are depreciated a full year in the year acquired. Normally, depreciation begins in the month acquired. For example, an asset acquired at the beginning of April is depreciated for only nine months in the year of acquisition. Modify the DEPREC2 worksheet to include the month of acquisition as an additional item of input. To demonstrate proper handling of this factor on the depreciation schedule, modify the formulas for the first two years. Some of the formulas may not actually need to be revised. Do not modify the formulas for Years 3 through 8 and ignore the numbers shown in those years. Some will be incorrect as will be some of the totals. Preview the printout to make sure that the worksheet will print neatly on one page, and then print the worksheet. Save the completed file as DEPRECT. Hint: Insert the month in row 6 of the Data Section specifying the month by a number (e.g., April is the fourth month of the year). Redo the formulas for Years 1 and 2. For the units of production method, assume no change in the estimated hours for both years. Chart. Using the DEPREC5 file, prepare a line chart or XY chart that plots annual depreciation expense under all three depreciation methods. No Chart Data Table is needed; use the range B29 to E36 on the worksheet as a basis for preparing the chart if you prepare an XY chart. Use C29 to E36 if you prepare a line chart. Enter your name somewhere on the chart. Save the file again as DEPREC5. Print the chart.
Montello Inc. purchases a delivery truck for $25,000. The truck has a salvage value of $6,000 and is expected to be driven for 125,000 miles. Montello uses the units-of-production depreciation method, and in year one the company expects the truck to be driven for 26,000 miles; in year two, 30,000 miles; and in year three, 40,000 miles. Consider how the purchase of the truck will impact Montellos depreciation expense each year and what the trucks book value will be each year after depreciation expense is recorded.
During the current year, Arkells Inc. made the following expenditures relating to plant machinery. Renovated seven machines for $250,000 to improve efficiency in production of their remaining useful life of eight years Low-cost repairs throughout the year totaled $79,000 Replaced a broken gear on a machine for $6,000 A. What amount should be expensed during the period? B. What amount should be capitalized during the period?
Gimli Miners recently purchased the rights to a diamond mine. It is estimated that there are one million tons of ore within the mine. Gimli paid $23,100,000 for the rights and expects to harvest the ore over the next ten years. The following is the expected extraction for the next five years. Year 1: 50,000 tons Year 2: 90,000 tons Year 3: 100,000 tons Year 4: 110,000 tons Year 5: 130,000 tons Calculate the depletion expense for the next five years, and create the journal entry for year one.
Utica Machinery Company purchases an asset for 1,200,000. After the machine has been used for 25,000 hours, the company expects to sell the asset for 150,000. What is the depreciation rate per hour based on activity?
St. Johns River Shipyards welding machine is 15 years old, fully depreciated, and has no salvage value. However, even though it is old, it is still functional as originally designed and can be used for quite a while longer. A new welder will cost 182,500 and have an estimated life of 8 years with no salvage value. The new welder will be much more efficient, however, and this enhanced efficiency will increase earnings before depreciation from 27,000 to 74,000 per year. The new machine will be depreciated over its 5-year MACRS recovery period, so the applicable depreciation rates are 20.00%, 32.00%, 19.20%, 11.52%, 11.52%, and 5.76%. The applicable corporate tax rate is 25%, and the project cost of capital is 12%. What is the NPV if the firm replaces the old welder with the new one?
Grandorf Company replaced the engine in a truck for 8,000 and expects the new engine will extend the life of the truck two years beyond the original estimated life. Related information is provided below. Cost of truck 65,000 Salvage value 5,000 Original estimated life 6 years The truck was purchased on January 1, 20-1. The engine was replaced on January 1, 20-6. Using straight-line depreciation, compute depreciation expense for 20-6.