The Mechanical Components Division manager asks you to recommend a make/buy decision on a major automotive subassembly that is currently purchased externally for a total of $3.9 million this year. This cost is expected to continue rising at a rate of $300,000 per year. Your manager asks that both di­rect and indirect costs be included when in-house manufacturing (make alternative) is evaluated. New equipment will cost $3 million, have a salvage of $0.5 million and a life of 6 years. Estimates of materials, labor costs, and other direct costs are $1.5 million, per year. Typical indirect rates, bases, and expected usage are shown. Perform the AW evaluation at MARR = 12% per year over a 6-year study period. Show both hand and spreadsheet solutions.


Determine AW for Make and Buy alternatives. Make has annual indirect costs.

Hand solution: Make: Indirect cost computation



AWmake = -3,000,000(A/P,12%,6) + 500,000(A/F,12%,6) – 1,500,000 – 1,595,000

= -3,000,000(0.24323) + 500,000(0.12323) -3,095,000

= $-3,763,075



AWbuy = -3,900,000 – 300,000(A/G,12%,6)

= -3,900,000 – 300,000(2.1720)

= $-4,551,600



Select make alternative



Spreadsheet solution: Select make alternative.

Trades & Technology

You might also like to view...

These diagrams are drawn as a series of lines and symbols that represent the electrical current path and the components of the circuit, but they may not show the individual wires or connections of an electrical circuit. These diagrams, however, show the electrical relationship of components.

a. pictorial diagram b. schematic diagram c. one-line diagram d. wiring diagram

Trades & Technology

A milling machine with enhanced CNC controls that allow for high-speed machining of free-form parts was purchased 2 years ago for $195,000. The company wants to purchase a recently available faster model with control up to 8 axes for $240,000. The presently owned machine can be sold today for $105,000. Its operating cost over the past 2 years has been $30,000 per year. The value that should be used as P for the presently owned ma­chine is: (choose one)

(a) $240,000 (b) $195,000 (d ) $30,000

Trades & Technology

The USDA shares its food safety mission with HHS

Indicate whether the statement is true or false

Trades & Technology

Site analysis of a possible plant growing enterprise should be done:

A. after deciding what to grow but before planting. B. after planting to make sure you have done everything correctly. C. before acquisition of the site. D. after acquisition of the site but before planting.

Trades & Technology