Question: please make it clear and correct answer please make different solution that isnt like in chegg that's all the question there is no data dont



please make it clear and correct answer please make different solution that isnt like in chegg
that's all the question
there is no data
dont know please help me
2. Consider Brockville Brackets (BB) from Question 1 but assume that it has has a contract to produce the car assemblies for an indefinite period. If it does not move the robot, the operating and maintenance costs will be higher than expected. If it moves the robot (at a cost of $25 000), the operating and maintenance costs are expected to be what were originally expected for the robot. Furthermore, BB expects to be able to obtain new versions of the existing robot for an indefinite period in the future, each is expected to have an installation cost of $50 000. Q2 ANSWER: a) Construct a spreadsheet table showing the EAC(total costs) if Brockville Brackets keeps the current robot in its current position for n more years, n_1,...,9. (5 POINTS) 3 year old Defender: Additional EAC years Salvage Maintenance Capital Maintenance Tota! EAC EAC b) Construct a spreadsheet table showing the EAC(total costs) if Brockville Brackets moves the current robot and then keeps it for n more years, n_1,..., 9. (5 POINTS) Moving the existing robot (challenger): Additional EAC EAC years Salvage Maintenance Capital Maintenance EAC Total c) Construct a spreadsheet table showing the EAC(total costs) if Brockville Brackets is to buy a new robot and keep it for n years, n_1,..., 9. (5 POINTS) Defender, when new: EAC EAC EAC Year Salvage Maintenance Capital Maintenance Total d) On the basis of your answers for parts (a) through (c), what do you advise Brockville Brackets to do? (5 POINTS) 2. Consider Brockville Brackets (BB) from Question 1 but assume that it has has a contract to produce the car assemblies for an indefinite period. If it does not move the robot, the operating and maintenance costs will be higher than expected. If it moves the robot (at a cost of $25 000), the operating and maintenance costs are expected to be what were originally expected for the robot. Furthermore, BB expects to be able to obtain new versions of the existing robot for an indefinite period in the future, each is expected to have an installation cost of $50 000. Q2 ANSWER: a) Construct a spreadsheet table showing the EAC(total costs) if Brockville Brackets keeps the current robot in its current position for n more years, n_1,...,9. (5 POINTS) 3 year old Defender: Additional EAC years Salvage Maintenance Capital Maintenance Tota! EAC EAC b) Construct a spreadsheet table showing the EAC(total costs) if Brockville Brackets moves the current robot and then keeps it for n more years, n_1,..., 9. (5 POINTS) Moving the existing robot (challenger): Additional EAC EAC years Salvage Maintenance Capital Maintenance EAC Total c) Construct a spreadsheet table showing the EAC(total costs) if Brockville Brackets is to buy a new robot and keep it for n years, n_1,..., 9. (5 POINTS) Defender, when new: EAC EAC EAC Year Salvage Maintenance Capital Maintenance Total d) On the basis of your answers for parts (a) through (c), what do you advise Brockville Brackets to do? (5 POINTS)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
