11-33 Equipment upgrade versus replacement. (A. Spero, adapted) The TechGuide Company produces and sells 7,500 modular computer desks per year at a selling price of $750 each. Its current production equipment, purchased for $1,800,000 and with a five-year useful life, is only two years old. It has a terminal disposal value of $0 and is depreciated on a straight-line basis. The equipment has a current disposal price of $450,000. However, the emergence of a new molding technology has led TechGuide to consider either up- grading or replacing the production equipment. The following table presents data for the two alternatives: Home Insert Page Layout Formulas Data A B 1 Upgrade 2 One-time equipment costs $3,000,000 3 Variable manufacturing cost per desk $ 150 4 Remaining useful life of equipment (in years) 3 5 Terminal disposal value of equipment $ 0 Review Replace $4,800,000 $ 75 3 $ 0 All equipment costs will continue to be depreciated on a straight-line basis. For simplicity, ignore income taxes and the time value of money. 1. Should TechGuide upgrade its production line or replace it? Show your calculations. 2. Now suppose the one-time equipment cost to replace the production equipment is somewhat nego- tiable. All other data are as given previously. What is the maximum one-time equipment cost that Tech- Guide would be willing to pay to replace rather than upgrade the old equipment? 3. Assume that the capital expenditures to replace and upgrade the production equipment are as given in the original exercise, but that the production and sales quantity is not known. For what production and sales quantity would TechGuide (i) upgrade the equipment or (ii) replace the equipment? 4. Assume that all data are as given in the original exercise. Dan Doria is TechGuide's manager, and his bonus is based on operating income. Because he is likely to relocate after about a year, his current bonus is his primary concern. Which alternative would Doria choose? Explain. 2