2. 4.26 Virgin Galactic is considering two materials for certain parts in a reusable space vehicle: carbon fiber reinforced plastic (CFRP) and fiber reinforced ceramic (FRC). The costs are shown below. Which should be selected on the basis of a present worth comparison if MARR = 10% per year?

(a) Solve using tabulated factors. (b)

(Spreadsheet exercises) Solve using single-cell functions.

(c) Using your spreadsheet functions, will the selection change if the estimated life of the CFRP material is 4, rather than 2, years?

Table Summary: Table divided into 3 columns with the headings marked from left to right as:
Material; CFRP; and FRC.
Material CFRP FRC First cost, $ −205, 000 −235, 000 Maintenance cost, $/year −29, 000 −27, 000 Salvage value, $ 2,000 20,000 Life, years 2 4