In: Accounting
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
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 SolutionsSaxon 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
Latest Questions
ADVERTISEMENT
|