Question
In: Accounting
A process control manager is considering two robots to improve materials handling capacity in the production...
A process control manager is considering two robots to improve materials handling capacity in the production of rigid shafts. Robot X has a first cost of $84,000, an annual M&O cost of $31,000, a $40,000 salvage value, and will improve revenues by $96,000 per year. Robot Y has a first cost of $146,000, an annual M&O cost of $28,000, a $47,000 salvage value, and will increase revenues by $119,000 per year. The company's MARR is 15% per year and it uses a 3-year study period for economic evaluations. Which one should the manager select a) on the basis of ROR values b) on the basis of incremental ROR values c) Which is the correct selection basis?
Solutions
Expert Solution
| Answer: | ||||||
| a) | Net present value of Robot X | |||||
| Year 0 | Year 1 | Year 2 | Year 3 | |||
| Revenue | $ 96,000.00 | $ 96,000.00 | $ 96,000.00 | |||
| Add: | Salvage | $ 40,000.00 | ||||
| A | Total | $ - | $ 96,000.00 | $ 96,000.00 | $ 136,000.00 | |
| Less: | ||||||
| Initial cost | $ 84,000.00 | |||||
| M&O cost | $ 31,000.00 | $ 31,000.00 | $ 31,000.00 | |||
| B | Total | $ 84,000.00 | $ 31,000.00 | $ 31,000.00 | $ 31,000.00 | |
| C=A-B | Cash flow | $ (84,000.00) | $ 65,000.00 | $ 65,000.00 | $ 105,000.00 | |
| D | Discount @ 15% | 1 | 0.8696 | 0.7561 | 0.6575 | |
| C*D | Present value of cash flow | $ (84,000.00) | $ 56,521.74 | $ 49,149.34 | $ 69,039.20 | |
| Net present value | $ 90,710.28 | |||||
| Net present value of Robot Y | ||||||
| Year 0 | Year 1 | Year 2 | Year 3 | |||
| Revenue | $ 119,000.00 | $ 119,000.00 | $ 119,000.00 | |||
| Add: | Salvage | $ 47,000.00 | ||||
| A | Total | $ - | $ 119,000.00 | $ 119,000.00 | $ 166,000.00 | |
| Less: | ||||||
| Initial cost | $ 146,000.00 | |||||
| M&O cost | $ 28,000.00 | $ 28,000.00 | $ 28,000.00 | |||
| B | Total | $ 146,000.00 | $ 28,000.00 | $ 28,000.00 | $ 28,000.00 | |
| C=A-B | Cash flow | $ (146,000.00) | $ 91,000.00 | $ 91,000.00 | $ 138,000.00 | |
| D | Discount @ 15% | 1 | 0.8696 | 0.7561 | 0.6575 | |
| C*D | Present value of cash flow | $ (146,000.00) | $ 79,130.43 | $ 68,809.07 | $ 90,737.24 | |
| Net present value | $ 92,676.75 | |||||
| On the basis of ROR the manager should select Robot Y as it has greater NPV of $92,676.75. | ||||||
| b) | On the basis of intremental ROR | |||||
| Year 0 | Year 1 | Year 2 | Year 3 | |||
| Incremental revenue (Robot Y- Robot X) | $ 23,000.00 | $ 23,000.00 | $ 23,000.00 | (119000-96000) | ||
| Add: | Incremental Salvage | $ 7,000.00 | (47000-40000) | |||
| A | Total | $ - | $ 23,000.00 | $ 23,000.00 | $ 30,000.00 | |
| Less: | ||||||
| Incremental Initial cost | $ 62,000.00 | (146000-84000) | ||||
| Inremental M&O cost | $ (3,000.00) | $ (3,000.00) | $ (3,000.00) | (28000-31000) | ||
| B | Total | $ 62,000.00 | $ (3,000.00) | $ (3,000.00) | $ (3,000.00) | |
| C=A-B | Cash flow | $ (62,000.00) | $ 26,000.00 | $ 26,000.00 | $ 33,000.00 | |
| D | Discount @ 15% | 1 | 0.8696 | 0.7561 | 0.6575 | |
| C*D | Present value of cash flow | $ (62,000.00) | $ 22,608.70 | $ 19,659.74 | $ 21,698.04 | |
| Net present value | $ 1,966.47 | |||||
| On the basis of incremental ROR Robot Y should be selected as it has an incremental NPV of $1,966.47 | ||||||
ekkarill92 answered 2 years agoRelated Solutions
A process control manager is considering two robots to improve materials-handling capacity in the production of rigid shaft couplings that make dissimilar drive components.
A process control manager is considering two robots to improve materials-handling capacity in the production of rigid shaft couplings that make dissimilar drive components. Robot X has a first cost of $90,000, an annual M&O cost of $31,000, and $43,000 salvage value, and it will improve revenues by $96,000 per year. Robot Y has a first cost of $146,000, an annual M&O cost of $28,000, and $47,000 salvage value, and it will increase revenues by $128,000 per year. The company’s...
TAD Inc is considering two equipment alternatives to improve the production process and serve more customers....
TAD Inc is considering two equipment alternatives to improve the
production process and serve more customers. The financial
estimates for each alternative are displayed in the following
table:
Equipment A
Equipment B
Initial cost
$50k
$106.31k
Annual benefit/Year
$16k
$24k
Salvage Value
$ 9k
$0
Internal Rate of Return Manzer Enterprises is considering two independent investments: A new automated materials handling...
Internal Rate of Return
Manzer Enterprises is considering two independent
investments:
A new automated materials handling
system that costs $900,000 and will produce net cash inflows of
$300,000 at the end of each year for the next four years.
A computer-aided manufacturing system
that costs $775,000 and will produce labor savings of $400,000 and
$500,000 at the end of the first year and second year,
respectively.
Manzer has a cost of capital of 8 percent.
The present value tables provided...
Internal Rate of Return Manzer Enterprises is considering two independent investments: A new automated materials handling...
Internal Rate of Return Manzer Enterprises is considering two
independent investments:
A new automated materials handling system that costs $900,000
and will produce net cash inflows of $300,000 at the end of each
year for the next four years.
A computer-aided manufacturing system that costs $775,000 and
will produce labor savings of $400,000 and $500,000 at the end of
the first year and second year, respectively.
Manzer has a cost of capital of 8 percent.
The present value tables provided...
• A MAJOR POTENTIOMETER MANUFACTURER IS CONSIDERING TWO ALTERNATIVES FOR NEW PRODUCTION MACHINES WITH CAPACITY TO...
• A MAJOR POTENTIOMETER MANUFACTURER IS CONSIDERING TWO
ALTERNATIVES FOR NEW PRODUCTION MACHINES WITH CAPACITY TO PRODUCE
20 000 UNITS PER DAY. ONE ALTERNATIVE IS FOR A HIGH-CAPACITY
AUTOMATED PRODUCTION MACHINE CAPABLE OF PRODUCING 20 000 UNITS PER
DAY WHEN OPERATED FOR THREE SHIFTS PER DAY. A QUARTER-TIME EMPLOYEE
WOULD BE ASSIGNED TO MONITOR THE MACHINE (EMPLOYEE WOULD MONITOR
OTHER MACHINES AT THE SAME TIME). WITH THE THREE-SHIFT SCHEDULE
THIS WOULD BE EQUIVALENT TO A THREE-QUARTER-TIME EMPLOYEE.
• A SECOND...
You are the manager of a project to improve the billing process at your firm. The...
You are the manager of a project to improve the billing process
at your firm. The table below contains the data you will need to
conduct a cost analysis of the project. Indirect costs are $1600
per week, and penalty costs are $1200 per week after week 12.
a- What is the minimum-cost schedule for this project?
b- What is the difference in total project costs between the
earliest completion time of the project using "normal" times and
the minimum-cost...
Materials are added at the beginning of a production process, and ending work in process inventory...
Materials are added at the beginning of a production process,
and ending work in process inventory is 40% complete with respect
to conversion costs. Use the information provided to complete a
production cost report using the weighted-average method.
Costs to Account For
Beginning inventory: materials
$11,000
Beginning inventory: conversion
20,000
Direct material
46,200
Direct labor
75,000
Applied overhead
42,340
Total costs to account for
$194,540
Units to Account For
Beginning work in process
4,000
Units started into production
22,000
Transferred...
A particular production process requires two types of raw materials to produce the end product. Each...
A particular production process requires two types of raw
materials to produce the end product. Each unit of finished product
requires three units of raw material A and 2 units of raw material
B, plus processing costs of $35. For the purpose of valuing
inventory, raw material A and B are recorded together in one
account and should be considered together when determining cost and
net realizable value. The following provides information on
inventories at fiscal 2019 year-end: Inventory item...
The Company uses a single department production process. Materials are added at the start of the production...
The Company uses a single department production
process. Materials are added at the start of the
production process and labor and overhead are added as indicated.
The Company records have the following information for the month of
November:
UNITS:
Beginning WIP: 2/3 complete for labor; 1/3 complete for
overhead 12,000
units
Units started in
process 40,000
units
Units
completed 44,000
units
Ending WIP: 50% complete for labor; 25% complete for
overhead 8,000
units
PRODUCTION COSTS:
Work in Process, Beginning of the
Month:
Materials $
32,000
Labor 20,000
Overhead 9,400 61,400
Current...
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...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Do you agree that Social Loafing is similar to Theory X. Give an example to support...
- Computing Cost of Goods Sold and Ending Inventory. Bartov Corporation reports the following beginning inventory and...
- SQL FORMAT (11-13 are completed and correct) -- 11. what are the names of all students...
- You have been hired as a capital budgeting analyst by Advent Sports, a sporting goods firm...
- DESCRIBE WHAT HAPPENS WHEN WE BECOME CONSCIOUS OF SOMETHING. WHAT HAS TO HAPPEN FOR CONSCIOUS AWARENESS...
- 3) You are rolling a 12 sided die 8 times. a) What is the size for...
- explain the difference between quantitative and qualitative research strategies. Provide an example of a crime based...
ADVERTISEMENT