For this assignment you ars using Miarosoft Excel to perform a life cycle cost analysic on system XYZ conaidering the following factors. System XYZ is installed

in an eircreft that will be deployed at four operationsl beses. Esch bese will have a meximum force level of $12$ sircraft with the beses being activated in series $($

bese $1$ at the end of year $3$ for operation in year $4,$ base $2$ at the end of year $4$ for operation in year $5,$ bese $3$ at the end of year $5$ for operation in year $6,$ and

base $4$ at the end of year $6$ for operation in year $7).$ The total number of system XYZ$\text{'}$s in operation are as shown in the table below. $($Note$,$ that there is a

decline in the number of units required beginning in year B$).$ Also, note over production in yeser $7$ sa some XYZ systems are kept at the Depot as spare units to

put in operation when needed. Year Number $1234567891000010204060553525$ System XYZ ia a newly designed configurstion peckaged in three

units $($Unit A$,$ Unit B$.$ and Unit C$).$ The specified requirements for each of the units are shown in the Figure below. The only system level msintensence thet is

reauired is configurstion of unit $B$ following a corrective maintenance action of this unit. The configuration tskes $15$ minutes to complete. The sverage System

XYZ utiliation is $4$ hours per dsy$,365$ dsys per yes. One of the sircraft crew members will be sasigned to operate several different syatems throughout flight,

and it is assumed that $10\%$ of the crew member's time is sllocated to System XYY$.$ Relative to the maintenance concept, System XYZ incorporstes a buit $-$ in

self test that ensble: rapid system checkout and fault isolation to the unit level. No extemal support equipment is requirsd at the sircraft. In the event of a no

go condition, the fault is iaclated to the unit, and the applicable unit is removed, repleced with a scere, snd the damaged unit is sent to the intermediate

level maintenence shop $($located at the operationsl base$)$ for repair. The corrective maintenence time for esch unit includes the remove and replace action as

well as repair of the unit to restore it to operstion. This unit repair is accomplished by identifying modules within the unit that are demeged and replacing the

modules to restore the unit to operstion. Therefore, the corrective maintenance involve: removal and replacement of the unit and the module replacement,

below the unit level, to restore the unit to operation. The restored unit is placed beck into inventory for use as speres. The replaced $/$ dameged modules, below

the unit level, are dacarded. Scheduled $($preventive$)$ maintenance is accomplished on Unit A in the intermediate shop every fo montha. No depot maintenance

ia required; however, the depot does provide beckup supply and support function: sa required. The requirements for system XYZ dictate the program profile

shown in the figure on the next page. Asaume thet the life cycle coat are broken down into three categories represented by blocks in the program profile.

Provide solution to this this life cycle analysic uaing the attsched template. In essence provide cost for each of the $10$ years of operation in each of the

categories summsrized sbove and numbered as follows RDT & E COST: $1.$ System XYZ RDT&E sub totel cost $2.$ System XYZ RDT&E aupport equipment sub

total cost Production Cost $3.$ Production &$.$ Manufacturing coat for unit A$,$ B and C $4.$ Production Support Equipment $5.$ Spers Units Operationa &$.$

Maintenance $6.$ System Cperation Cost $7.$ Maintenance Labor Coat B$.$ Maintenence Material &$.$ Spares Cost Calculate these costs based on the criteris number

$1$ through $8$ and defined in the problem. Show all work on subsequent worksheets to substantiate cost calculations. Also, for total cost, celsulate net present

values at $10\%$ discount rate sasuming year $1$ is time $0.$ Calculate esch individual year NPV valus as well sa total value and incorporate onto the spreadsheet

template. Additional factors and figures are included in screenahot. Plesse use the following solution table: Year Cost Category $12345678910$ Total $1.$

System XYZ R$.$DT&E Sub Total $2.$ R$.$DT$8$E Support Equipment Sub Total Sub Total RDTBE $3.$ System XYZ Production Subtotal $4.$ Production Support Eauipment

Subtotal S$.$ Spare Units Sub Totsl Sub Totel Production $6.$ Total Opersting Coat Sub Total $7.$ Total System Level Msintenance Coat Sub Total $8.$ Total.

Mainteance Material Coat Sub Total Operationa & Maintenance Totsla Totals Q $10\%$ Discount