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

Related Solutions

A process control manager is considering two ro­bots to improve materials-handling capacity in the production of rigid shaft couplings that make dissimilar drive components.
A process control manager is considering two ro­bots 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
ADVERTISEMENT