Question

In: Accounting

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 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 $406,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 $406,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 $81,000 more than estimated and direct labor could only be reduced by 25,500 hours per year, rather than the original estimate of 31,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 (a) above for the automated equipment to yield a 23% rate of return.

Garrison 16e Rechecks 2017-11-15

Solutions

Expert Solution

Please give positive ratings so I can keep answering. It would help me a lot. Please comment if you have any query. Thanks!
Saxon Products, Inc.
Workings for Answer 1
Savings in labor cost Amount $ Note
Direct labor-hours           31,000.00 K
Labor-hour rate                  18.00 L
Savings in labor cost        558,000.00 M=K*L
Answer 1 Amount $ Note
Savings in inventory carrying costs        216,000.00
Add: Savings in labor cost        558,000.00 See M
Less: Increase in power and maintenance costs           36,000.00
Annual net cost saving        738,000.00 E
Answer 2-a Y0 Y1 Y2 Y3 Y4 Y5 Note
Cost of equipment    (1,900,000.00)                        -                       -                       -                       -                       -   A
Installation and software       (480,000.00)                        -                       -                       -                       -                       -   B
Salvage Value                         -                          -                       -                       -                       -        76,000.00 D
Annual net cost saving                         -         738,000.00    738,000.00    738,000.00    738,000.00    738,000.00 E
Reduction in the inventory on hand                         -         406,000.00                     -                       -                       -                       -   G
Net cash flows (2,380,000.00) 1,144,000.00    738,000.00    738,000.00    738,000.00    814,000.00 H= Sum of A to G
PV factor at 23%                     1.00                 0.813              0.661              0.537              0.437              0.355 I
PV of Net cash flows (2,380,000.00)       930,081.30    487,804.88    396,589.33    322,430.35    289,133.79 J=H*I
NPV          46,039.65 Sum of J
Answer 2-b
NPV is positive $ 46,039.65 so yes the robot should be purchased.
Workings for Answer 3-a
Savings in labor cost Amount $ Note
Direct labor-hours           25,500.00 N
Labor-hour rate                  18.00 O
Savings in labor cost        459,000.00 P=N*O
Revised Annual net cost saving Amount $ Note
Savings in inventory carrying costs        216,000.00
Add: Savings in labor cost        459,000.00 See P
Less: Increase in power and maintenance costs           36,000.00
Annual net cost saving        639,000.00 E
Answer 3-a Y0 Y1 Y2 Y3 Y4 Y5 Note
Cost of equipment    (1,900,000.00)                        -                       -                       -                       -                       -   A
Installation and software       (561,000.00)                        -                       -                       -                       -                       -   B
Salvage Value                         -                          -                       -                       -                       -        76,000.00 D
Annual net cost saving                         -         639,000.00    639,000.00    639,000.00    639,000.00    639,000.00 E
Reduction in the inventory on hand                         -         406,000.00                     -                       -                       -                       -   G
Net cash flows (2,461,000.00) 1,045,000.00    639,000.00    639,000.00    639,000.00    715,000.00 H= Sum of A to G
PV factor at 23%                     1.00                 0.813              0.661              0.537              0.437              0.355 I
PV of Net cash flows (2,461,000.00)       849,593.50    422,367.64    343,388.32    279,177.50    253,968.87 J=H*I
NPV      (312,504.17) Sum of J
Answer 3-b
Post audit NPV is negative $ 312,504.17 so yes no the company did not make a wise investment.
Answer 4-a
The intangible benefits are:
1. Savings in time. Automation saves times. Company does not depend on the slack of workers. As manual intervention is minimum so company can save lot of time and use it productively.
2. The output will increase because slack time will decrease.
3. Quality of output may increase.
Answer 4-b

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,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...
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