You are working in the accounting department of a manufacturing firm that has purchased a new...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You are working in the accounting department of a manufacturing firm that has purchased a new high-tech piece of machinery. The purchase price of the machinery (not including taxes) was $175,000, sales tax was $15,750, and installation and setup costs totalled $2,250. The CFO of the company would like to understand how various methods of depreciating the asset would affect the company's income in the current and future years. You have been tasked with answering this question. Additional Information: The company's fiscal year = calendar year. The machine was purchased on January 1, 2021. Due to its modular design, the machine can be easily repaired and have its components upgraded/replaced as necessary. Thus, management expects its useful life to be 27 years. Management expects to sell the machine after 27 years for $17,500. The depreciation methods that are being considered are straight line, double declining balance (*with a switch to straight-line when straight-line would result in higher depreciation*), sum-of-the-years-digits, and units of production. The machine is expected to produce 15,000 units of output in each of the first 18 years it is in service, and 7,500 units of output in each of the last 9 years of service. Required: 1 On each of the respective tabs, prepare the machinery depreciation schedule for the respective depreciation method. At a minimum, each schedule should have columns for year, depreciation expense, accumulated depreciation, and net book value. These columns would show each of these amounts for each respective year (depreciation expense for the year, and A/D and net book value at the end of a given year). You will need to hard-code information related to the asset on each tab so that you can reference this information in your tables. Do this on each tab to the side or above the table, not in the table itsself. Do not hard-code amounts in any tables - use formulas and cell referencing. Full credit will not be awarded if amounts are hard-coded in tables. a. Straight Line Depreciation Cost: Salvage Value: Depreciable Basis: Useful Life: Annual Depreciation Expense: Year Depreciation Expense Accumulated Depreciation Net Book Value You are working in the accounting department of a manufacturing firm that has purchased a new high-tech piece of machinery. The purchase price of the machinery (not including taxes) was $175,000, sales tax was $15,750, and installation and setup costs totalled $2,250. The CFO of the company would like to understand how various methods of depreciating the asset would affect the company's income in the current and future years. You have been tasked with answering this question. Additional Information: The company's fiscal year = calendar year. The machine was purchased on January 1, 2021. Due to its modular design, the machine can be easily repaired and have its components upgraded/replaced as necessary. Thus, management expects its useful life to be 27 years. Management expects to sell the machine after 27 years for $17,500. The depreciation methods that are being considered are straight line, double declining balance (*with a switch to straight-line when straight-line would result in higher depreciation*), sum-of-the-years-digits, and units of production. The machine is expected to produce 15,000 units of output in each of the first 18 years it is in service, and 7,500 units of output in each of the last 9 years of service. Required: 1 On each of the respective tabs, prepare the machinery depreciation schedule for the respective depreciation method. At a minimum, each schedule should have columns for year, depreciation expense, accumulated depreciation, and net book value. These columns would show each of these amounts for each respective year (depreciation expense for the year, and A/D and net book value at the end of a given year). You will need to hard-code information related to the asset on each tab so that you can reference this information in your tables. Do this on each tab to the side or above the table, not in the table itsself. Do not hard-code amounts in any tables - use formulas and cell referencing. Full credit will not be awarded if amounts are hard-coded in tables. a. Straight Line Depreciation Cost: Salvage Value: Depreciable Basis: Useful Life: Annual Depreciation Expense: Year Depreciation Expense Accumulated Depreciation Net Book Value
Expert Answer:
Answer rating: 100% (QA)
Question a StraightLine depreciation Cost 193000 Salvage value 17500 Useful life 27 Annua... View the full answer
Related Book For
Managerial Accounting
ISBN: 9781259275814
11th Canadian Edition
Authors: Ray H Garrison, Alan Webb, Theresa Libby
Posted Date:
Students also viewed these finance questions
-
You work in the accounting department of a major flat-screen television manufacturer. Demand for your product is very high. These televisions sell for $2,000 each. An offer has arrived on your desk...
-
This chapter included an example of a manufacturing firm that had problems with employee theft of tools. The company decided that it would search every employees lunch box at the end of each shift....
-
You work in the accounting department of a company. Your company purchased the XYZ company six months ago, which recently incurred a 50% decline in revenues due to the lapsing of a key legal patent....
-
Wealthy Manufacturing Company purchased 40 percent of the voting shares of Diversified Products Corporation on March 23, 20X4. On December 31, 20X8, Wealthy Manufacturings controller attempted to...
-
What is a digital signature?
-
If a ball is thrown straight up into the air, what is its acceleration as it moves upward? What is its acceleration when it reaches its highest point and is stopped at an instant?
-
During 2009, Newfoundland Corp. earned income from continuing operations of \(\$ 135,000\). The company also sold a segment of the business (discontinued operations) at a loss of \(\$ 30,000\) and...
-
Pup Noir, a private investigation firm, investigated 90 cases in December and had the following costs: direct labor, $190 per case; and service overhead of $20,840. Service overhead for October was...
-
5. Meera Ltd has furnished you the following data: Budgeted No. of working days 25 Production in units 20,000 Fixed overheads 30,000 Actual 27 22,000 31,000 Budgeted fixed OH rate is `1 per hour. In...
-
Case : Karl and June Monroe
-
Micro Ovens is a business that manufactures and sells a variety of microwave ovens and airfryers. As part of the business objective to provide the state-of-the-art products and offer their customers...
-
Evaluate the effectiveness of various ground improvement techniques, such as vibro-compaction, deep soil mixing, and geosynthetics, in enhancing the stability of weak or problematic soils. What...
-
2. The human skeleton consists of 206 bones. There are 106bones in the wrists, hands, ankles and feet. What is the advantageof having this many bones? Explain. 3. List some differences between the...
-
A year ago in Oslo Airport I checked in to an SAS flight. One airline kiosk issued a boarding pass, another punched out a luggage tag, then a computer screen showed me how to attach it and another...
-
1.A vial of isophane insulin for subcutaneous injection contains100 units/ml. How many units are there in a 0.7 ml dose? 2.The initial adult dose of metformin, an antihyperglycemicdrug, is 1000...
-
Claire purchased 200 common shares of Clairco Ltd. in 2015 for $100. It is now 2017 and Claire would like to step down from running the company full time and let her child, Junior, take over....
-
Weddings Inc. recorded a $300 telephone bill last month on account. This month the payment is made. How should this transaction be recorded? Decrease cash; increase expense Decrease cash; decrease...
-
Linda Lopez opened a beauty studio, Lindas Salon, on January 2, 2011. The salon also sells beauty supplies. In January 2012, Lopez realized she had never filed any tax reports for her business and...
-
What is the difference between raw materials inventory and work in process inventory? Are they included on the balance sheet or income statement?
-
Rosman Company has an opportunity to pursue a capital budgeting project with a five-year time horizon. After careful study, Rosman estimated the following costs and revenues for the project: The new...
-
What are the three approaches to improving ROI?
-
Flow occurs in a rectangular channel of \(6 \mathrm{~m}\) width and has a specific energy of \(3 \mathrm{~m}\). Plot accurately the relation between depth and specific energy. Determine from the...
-
A rectangular channel carries a discharge of \(10 \mathrm{ft}^{3} / \mathrm{s}\) per foot of width. Determine the minimum specific energy possible for this flow. Compute the corresponding flow depth...
-
Flow in the channel of Problem 11.15 has a specific energy of \(4.5 \mathrm{ft}\). Compute the alternate depths for this specific energy. Data From Problem 11.15 11.15 A rectangular channel carries a...
Study smarter with the SolutionInn App