Question

In: Finance

Saxon Products, Inc., is investigating the purchase of a robot for use on the company’s assembly...

Saxon Products, Inc., is investigating the purchase of a robot for use on the company’s assembly line. Selected data relating to the robot are provided below:

Cost of the robot $ 1,550,000
Installation and software $ 405,000
Annual savings in inventory carrying costs $ 222,000
Annual increase in power and maintenance costs $ 42,000
Salvage value in 5 years $ 71,000
Useful life 5 years

Engineering studies suggest that use of the robot will result in a savings of 23,000 direct labor-hours each year. The labor rate is $18 per hour. Also, the smoother work flow made possible by the use of automation will allow the company to reduce the amount of inventory on hand by $412,000. This inventory reduction will take place at the end of the first year of operation; the released funds will be available for use elsewhere in the company. Saxon Products has a 23% required rate of return.


Click here to view Exhibit 13B-1 and Exhibit 13B-2, to determine the appropriate discount factor(s) using tables.

Required:

1. Determine the annual net cost savings if the robot is purchased. (Do not include the $412,000 inventory reduction or the salvage value in this computation.)

2-a. Compute the net present value of the proposed investment in the robot.

2-b. Based on these data, would you recommend that the robot be purchased?

3-a. Assume that the robot is purchased. However, due to unforeseen problems, software and installation costs were $87,000 more than estimated and direct labor could only be reduced by 18,500 hours per year, rather than the original estimate of 23,000 hours. Assuming that all other cost data is accurate, what would a postaudit suggest is the actual net present value of this investment?

3-b. Does it appear that the company made a wise investment?

4-a. Which of the following are intangible benefits associated with the new automated equipment?

4-b. Based on your analysis in Requirement 3 above, compute for the president the minimum dollar amount of annual cash inflow that would be needed from the benefits in part 4(a) for the automated equipment to yield a 23% rate of return.

Solutions

Expert Solution

1.Annual net cost savings if the robot is purchased

Cost Saved
Annual savings in inventory carrying costs $222000
Direct labor cos(23000*18/hr) $414000
Total savings $636000

2a NPV

cost
cost of the Robot 1550000
Installation 405000
Total cost 1955000
Depreciation per annum (1955000-71000)/5years) 376800
Outflow initial investment Year 1 Year2 Year3 Year4 Year 5
Initial cost 1955000
Increase in power per annum 42000 42000 42000 42000 42000
Total (B) 1955000 42000 42000 42000 42000 42000
Inflow
Annual savings in inventory 222000 22000 222000 222000 222000
Labor cost savings 414000 414000 414000 414000 414000
Inventory holding cost savings 412000
Total 1048000 636000 636000 636000 636000
(A-B)Net cash flow (1955000) 1006000 594000 594000 594000 594000
Discount factor @23% 0 .813 .661 .537 .437 .355
Discounted cash flows (1955000) 817878 392634 318978 259578 210870

so Npv =1999938-1955000 =44938

2b)Since NPV is positive we accept the proposal

3a

Outflow initial investment Year 1 Year2 Year3 Year4 Year 5
Initial cost 1955000+87000
Increase in power per annum 42000 42000 42000 42000 42000
Total (B) 2042000 42000 42000 42000 42000 42000
Inflow
Annual savings in inventory 222000 222000 222000 222000 222000
Labor cost savings(18500*18) 333000 333000 333000 333000 333000
Inventory holding cost savings 412000
Total 967000 555000 555000 555000 555000
(A-B)Net cash flow (2042000) 925000 513000 513000 513000 513000
Discount factor @23% 0 .813 .661 .537 .437 .355
Discounted cash flows (2042000) 752025 339093 275481 224181 182115

so Npv =1772895-2042000 =-269105

3b) No, Here the decision of company was wrong because here NPV is negetive


Related Solutions

Saxon Products, Inc., is investigating the purchase of a robot for use on the company’s assembly...
Saxon Products, Inc., is investigating the purchase of a robot for use on the company’s assembly line. Selected data relating to the robot are provided below: Cost of the robot $ 1,900,000 Installation and software $ 480,000 Annual savings in inventory carrying costs $ 216,000 Annual increase in power and maintenance costs $ 36,000 Salvage value in 5 years $ 76,000 Useful life 5 years Engineering studies suggest that use of the robot will result in a savings of 31,000...
Saxon Products, Inc., is investigating the purchase of a robot for use on the company’s assembly...
Saxon Products, Inc., is investigating the purchase of a robot for use on the company’s assembly line. Selected data relating to the robot are provided below: Cost of the robot $ 1,950,000 Installation and software $ 485,000 Annual savings in inventory carrying costs $ 217,000 Annual increase in power and maintenance costs $ 37,000 Salvage value in 5 years $ 77,000 Useful life 5 years Engineering studies suggest that use of the robot will result in a savings of 32,000...
A financial services firm is interested in investigating the cost of exporting a company’s products in...
A financial services firm is interested in investigating the cost of exporting a company’s products in 4 regions worldwide. The financial analysts collect data of the cost associated with compliance of the economy’s customs regulations to export a shipment in 10 countries (in US$) selected from each of 4 regions. They would like to investigate whether the average costs of exporting differ across the four regions. Which method of analysis is appropriate for answering the question of the financial analysts?...
The cylindrical coordinate robot on a factory’s assembly line is shown in a top view (Figure P4.2).
The cylindrical coordinate robot on a factory’s assembly line is shown in a top view (Figure P4.2). The 50-N force acts on a workpiece being held at the end of the robot’s arm. Express the 50-N force as a vector in terms of unit vectors i and j that are aligned with the x- and y-axes.   Figure P4.2
1. Aaron’s Robot Factory, Tire Repair, and Dictionary Emporium, Inc. can produce 47 robot butlers, 282...
1. Aaron’s Robot Factory, Tire Repair, and Dictionary Emporium, Inc. can produce 47 robot butlers, 282 dictionaries, or some combination of the two. Draw a production possibilities frontier with robot butlers on the y-axis and dictionaries on the x-axis, and title and label the diagram appropriately. Assume constant marginal opportunity costs. a. Clearly show at least one point that is attainable, unattainable, efficient, and inefficient. b. Describe tradeoffs for Aaron’s firm. Specifically, what is the opportunity cost of producing 1...
Wilson Industries produces an assembly used in the production of various products. The assembly is sold...
Wilson Industries produces an assembly used in the production of various products. The assembly is sold to various manufacturers throughout the United States. The unit selling price is $ 175.00. A projected sales forecast (in units) follows:                                     January           18,000                                                                         February         24,000                                     March              30,000                                                 April                 37,000                                     May                 32,000 The following information pertains to production policies and manufacturing specifications followed by Wilson Industries: a.    Finished goods inventory on January 1st was 5,400 units. The desired ending...
A) Marvel Parts, Inc., manufactures auto accessories. One of the company’s products is a set of...
A) Marvel Parts, Inc., manufactures auto accessories. One of the company’s products is a set of seat covers that can be adjusted to fit nearly any small car. The company has a standard cost system in use for all of its products. According to the standards that have been set for the seat covers, the factory should work 1,065 hours each month to produce 2,130 sets of covers. The standard costs associated with this level of production are: Total Per...
An​ auto-part manufacturing company is considering the purchase of an industrial robot to do spot​ welding,...
An​ auto-part manufacturing company is considering the purchase of an industrial robot to do spot​ welding, which is currently done by skilled labor. The initial cost of the robot is ​$300 comma 000​, and the annual labor savings are projected to be ​$150 comma 000. If​ purchased, the robot will be depreciated under MACRS as a​ seven-year recovery property. This robot will be used for five years after which the firm expects to sell it for ​$70 comma 000. The​...
An industrial engineer is considering two robots for purchase by a fiber optic manufacturing company. Robot...
An industrial engineer is considering two robots for purchase by a fiber optic manufacturing company. Robot X will have a first cost of $125,000, an annual maintenance and operation (M&O) cost of $40,000, and a $60,000 salvage value. Robot Y will have a first cost of $145,000, an annual M&O cost of $33,000, and a $65,000 salvage value. Which should be selected on the basis of an annual worth comparison of 9% per year? Use a 3-year study period. Interest...
An​ auto-part manufacturing company is considering the purchase of an industrial robot to do spot​ welding,...
An​ auto-part manufacturing company is considering the purchase of an industrial robot to do spot​ welding, which is currently done by skilled labor. The initial cost of the robot is $250,000, and the annual labor savings are projected to be $125,000. If​ purchased, the robot will be depreciated under MACRS as a​ seven-year recovery property. This robot will be used for five years after which the firm expects to sell it for $50,000. The​ company's marginal tax rate is 25%...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT