As Ford Motor Company retools an old truck assembly plant in Michigan to produce a fue lefficient economy model, the Ford Focus. Ford and its suppliers are seeking additional sources for
light, long-life transmissions. Automatic transmission component manufacturers use highly finished
dies for precision forming of internal gears and other moving parts. Two United States–
based vendors make the required dies. Use the per unit estimates below and a MARR of 12% per
year to select the more economical vendor bid. Show both hand and spreadsheet solutions.