A manufacturing firm redesigns its premier product to benefit from material standardization. The change will entail re-tooling costs. The firm conducts a cost benefit analysis on four possible options. Option 1 is to make no change at all. Options 2, 3, and 4 represent different re-tooling configurations involving different materials:
Option 1Option 2Option 3Option 4
Re-tooling Costs (Year 1)$0$800,000$1,000,000$1,200,000
Material Costs
Year 151,000,000$700,000$650,000$600,000
Year 2$1,100,000$750,000$700,000$650,000
Year 3SI,200,000$800,000$750,000$700,000
Year 451,300,000$850,000$800,000$750,000
Year 551,400,000$900,000$850,000$800,000
Total$6,000,000$4,000,000$3,750,000$3,500,000
Labor Costs
Year 1$1,000,000$700,000$650,000$600,000
Year 2$1,100,000$770,000$715,000S660,000
Year 3$1,210,000$847,000$786,500$726,000
Year 4$1,331,000$931,700$865,150$798,600
Year 5$1,464,100$1,024,870$951,665$878,460
Total$6,105,100$4,273,570$3,968,315$3,663,060
In addition to this, there will be a cost of $3.5 million in lost production during Year 1, should any of the re-tooling options (2, 3, or 4) be selected.
The firm wants to rank the options in order of financial preference, from the best option to the worst. Based on this information, how should the four options be ranked?