Question

In: Finance

An industrial engineer proposed the purchase of an RFID Fixed-Asset Tracking System for the company's warehouse...

An industrial engineer proposed the purchase of an RFID Fixed-Asset Tracking System for the company's warehouse and weave rooms. The engineer felt that the purchase would provide a better system of locating cartons in the warehouse by recording the locations of the cartons and storing the data in the computer. The estimated investment, annual operating and maintenance costs, and expected annual savings are as follows:

-Cost of equipment and installation: $85,500

-Project life: 6 years

-Expected salvage: $6,000

-Investment in working capital (fully recoverable at the end of the project life): $15,000

-Expected annual savings on labor and materials: $65,800

-Expected annual expenses: $9,150

-Depreciation method: five-year MACRS

The firm's marginal tax rate is 35%.

( Determine the net after-tax cash flow over the projects life )

( Compute the IRR for this investment )

( At MARR = 18% is the project acceptable? )

To be done in excel with formulas please

Solutions

Expert Solution

Below is the image showing calculation of IRR and  net after-tax cash flow over the projects life :

If MARR is 18% the project is acceptable as IRR is greater than cost of Capital.


Related Solutions

"An industrial engineer proposed the purchase of an RFID Fixed-Asset Tracking System for the company's warehouse...
"An industrial engineer proposed the purchase of an RFID Fixed-Asset Tracking System for the company's warehouse and weave rooms. The engineer felt that the purchase would provide a better system of locating cartons in the warehouse by recording the locations of the cartons and storing the data in the computer. The estimated investment, annual operating and maintenance costs, and expected annual savings are as follows: -Cost of equipment and installation: $159,300 -Project life: 6 years -Expected salvage: $16,000 -Investment in...
"An industrial engineer proposed the purchase of an RFID Fixed-Asset Tracking System for the company's warehouse...
"An industrial engineer proposed the purchase of an RFID Fixed-Asset Tracking System for the company's warehouse and weave rooms. The engineer felt that the purchase would provide a better system of locating cartons in the warehouse by recording the locations of the cartons and storing the data in the computer. The estimated investment, annual operating and maintenance costs, and expected annual saving are as follows: -Cost of equipment and installation: $180,300 -Project life: 6 years -Expected salvage: $13,000 -Investment in...
You have been hired to evaluate an accounting information system for fixed asset inventory tracking to...
You have been hired to evaluate an accounting information system for fixed asset inventory tracking to determine if proper controls and security are present for financial reporting. You notice the company has a number of items in inventory but there does not seem to be any pattern to the data they collect. For example, some items have a location or department where the item is located others do not, some items have a tracking tag, others do not, etc. How...
An industrial engineer is considering two assets to be purchased by a company. Asset A will...
An industrial engineer is considering two assets to be purchased by a company. Asset A will have an initial cost of $90,000, an annual operating and maintenance cost of $32,000, and a $6,000 salvage value. Asset B will have a first cost of $135,000, an annual operating and maintenance cost of $25,000, and a $17,500 salvage value. Which one should be selected? Use a 15-year study period and an annual interest rate of 8%. Draw the cash flow diagrams. Always...
Three different methods for assembling a product were proposed by an industrial engineer. To investigate the...
Three different methods for assembling a product were proposed by an industrial engineer. To investigate the number of units assembled correctly with each method, 30 employees were randomly selected and randomly assigned to the three proposed methods in such a way that each method was used by 10 workers. The number of units assembled correctly was recorded, and the analysis of variance procedure was applied to the resulting data set. The following results were obtained: SST=10,740; SSTR=4,540 a. Set up...
Three different methods for assembling a product were proposed by an industrial engineer. To investigate the...
Three different methods for assembling a product were proposed by an industrial engineer. To investigate the number of units assembled correctly with each method, 30 employees were randomly selected and randomly assigned to the three proposed methods in such a way that each method was used by 10 workers. The number of units assembled correctly was recorded, and the analysis of variance procedure was applied to the resulting data set. The following results were obtained: SST is 10, 760 SSTR...
Three different methods for assembling a product were proposed by an industrial engineer. To investigate the...
Three different methods for assembling a product were proposed by an industrial engineer. To investigate the number of units assembled correctly with each method, 30 employees were randomly selected and randomly assigned to the three proposed methods in such a way that each method was used by 10 workers. The number of units assembled correctly was recorded, and the analysis of variance procedure was applied to the resulting data set. The following results were obtained: SST is 10, 760 SSTR...
Three different methods for assembling a product were proposed by an industrial engineer. To investigate the...
Three different methods for assembling a product were proposed by an industrial engineer. To investigate the number of units assembled correctly with each method, 30 employees were randomly selected and randomly assigned to the three proposed methods in such a way that each method was used by 10 workers. The number of units assembled correctly was recorded, and the analysis of variance procedure was applied to the resulting data set. The following results were obtained: SST = 10,780; SSTR =...
Three different methods for assembling a product were proposed by an industrial engineer. To investigate the...
Three different methods for assembling a product were proposed by an industrial engineer. To investigate the number of units assembled correctly with each method, 27 employees were randomly selected and randomly assigned to the three proposed methods in such a way that each method was used by 9 workers. The number of units assembled correctly was recorded, and the ANOVA was performed on the resulting data set. The following results were obtained: SST = 10,400; SSTR = 4,700. State the...
Three different methods for assembling a product were proposed by an industrial engineer. To investigate the...
Three different methods for assembling a product were proposed by an industrial engineer. To investigate the number of units assembled correctly with each method, 15 employees were randomly selected and randomly assigned to the three proposed methods in such a way that each method was used by 5 workers. The number of units assembled correctly was recorded, and the analysis of variance procedure was applied to the resulting data set. What is the rejection region for the ANOVA test using...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT