Paragraph Styles Table 1: Historical data for test purposes FY (m) Production Average Unit Length Diameter Launch System Nomendature Quantity Cost (SM) (mm) Weight (kg) AIM-120 A-C AMRAAM 270 0.347 FY04 3.7 177.8 152 MGM-140A ATACMS 789 0.782 FYQ2 3.96 609.6 1700 XM-141 BOM 253 0.014|FYOS 0.823 81.28 7.3 RIM-162A ESSM 261 1.64 FY05 3.81 254 2971 AGM-114K HELLFIRE II 220 0.099|FY03 1.65 177.8 45.31 AGM-158A JASSM 71 0.632 FY01 4.27 457.2 1021 JAVEUN 4271 0.091 FY06 1.22 1271 12.25 GBU-31/32 JDAM 21249 0.03 FY06 3.9 457.2 932.5 AGM-154A-CISOW 35 0.807|FYOZ 4.08 335.28 483 AGM-114L LB HELLFIRE 2350 0.099 FYOZ 1.74 177.8 491 M-26 MLRS ER 485 0.393 FY01 3.69 228.6 AGM-1198 PENGUIN 10 1.053 FY04. 3.05 284.48 385.5 AGM-130A-C POWERED GBU-15 18 1.094 | EYOP 3.93 457.2 1323 PREDATOR 358 0.129 FY03 0.88 152.4 11 RIM-116A RAM 81 0.51FYD 2.81 127 73.5 AGM-142A-DRAPTOR 14 1.482 FYO2 5.76 520.71 1361 CBU-97/B SFW 281 0.451 FY04 232 406.4 421 AIM-9X SIDEWINDER 157 0.465|FYDS 2.89 127 86 AGM BAH SLAM-ER 41 0.971FYDG 4.36 342.9 663.51 RIM-156A SM-2 ER 33 4.23 FY01 6.55 34798 1497 RIM GEC SM-2 MR 88 1.764FYON 4.69 3479 706 RGM-109 TAC TOMAHAWK 29 2.358 EYA 5.58 51816 1814.41 BGM-1094-D TOMAHAWK 0.751FYOS 625 518.16 14514 293 1. (6 points) Normalize the Average Unit Cost of each data point to FY21SM using the attached Inflation Indices on page 4 (also provided in a separate file). Attach a printout of your results. 2. (12 points) Using the transformed data from Problem 1, calculate the unit theory theoretical first unit costs (Tl) for each data point. Assume each program experienced an 85% learning rate. Attach a printout of your results. 3. (20 points) Now that you have a database of Tls, lengths, diameters, and launch weights, develop a CER of the form Y = ax that predicts TI. Try each independent variable, one at a time, and choose the best CER. Use GERM. Attach a printout of your results, and be sure to indicate the best CER and its relevant fit statistics. 194 1977 DEEO CEO SUSU WPN Miopon Proc. N1507) NAVY Base Your 2073 Budget Budget Year Fiscal Inflation Rew Weighte Year Year Rates d index Indes Rates 15770 3.935 01528 0 1686 01622 1921 01650 01767 01694 40 1972 3.8% 0.1724 16 01779 490 293 410 01796 0 1950 1579 5.60% 5.72% 1999 0.2112 0 2002 815 1975 8813 2067 0.2204 02158 62 1976 65% 0 2200 02413 0224 7. 356 02281 0.2531 0.2434 4.7% 3.7 02362 0.2680 02576 592 1978 6.80 02525 02997 028 1181% 1929 872 02749 03171 10213 1990 11 RON 0903 0300 1017 11.COM 03400 04059 03904 1902 14 0001 04402 04239 1983 9.00 0.42 Od 04 MOON 0615 0.484 0.4664 40N 04772 047 40 2.9% 1993 OM 05165 04 09350 05142 10 od 05 057 1990 400 OS XAN AN 0612 OS 259 0.000 20N 1000 6192 DE 06 000 15 6436 06 1 1936 06711 DAS 124 0.02 0500 100 OR 067 0.00 . C.COM 0.00 23 LA DON 1701 D. ay 0720 1OON O 02 0727 SIF 0777 20 1108 07200 GAL 20 OP 22 24 ODS 1 -A NOVE NONG NOC NE NOZ NOVE NIDE NO NE SO catro O COMO VO 401 SO SZSO WO GORD 190 1 BE NOLE NO 067 WIT WIT TO NOT OCT O co MITED THEO ZO WE TE HENO WO Paragraph Styles Table 1: Historical data for test purposes FY (m) Production Average Unit Length Diameter Launch System Nomendature Quantity Cost (SM) (mm) Weight (kg) AIM-120 A-C AMRAAM 270 0.347 FY04 3.7 177.8 152 MGM-140A ATACMS 789 0.782 FYQ2 3.96 609.6 1700 XM-141 BOM 253 0.014|FYOS 0.823 81.28 7.3 RIM-162A ESSM 261 1.64 FY05 3.81 254 2971 AGM-114K HELLFIRE II 220 0.099|FY03 1.65 177.8 45.31 AGM-158A JASSM 71 0.632 FY01 4.27 457.2 1021 JAVEUN 4271 0.091 FY06 1.22 1271 12.25 GBU-31/32 JDAM 21249 0.03 FY06 3.9 457.2 932.5 AGM-154A-CISOW 35 0.807|FYOZ 4.08 335.28 483 AGM-114L LB HELLFIRE 2350 0.099 FYOZ 1.74 177.8 491 M-26 MLRS ER 485 0.393 FY01 3.69 228.6 AGM-1198 PENGUIN 10 1.053 FY04. 3.05 284.48 385.5 AGM-130A-C POWERED GBU-15 18 1.094 | EYOP 3.93 457.2 1323 PREDATOR 358 0.129 FY03 0.88 152.4 11 RIM-116A RAM 81 0.51FYD 2.81 127 73.5 AGM-142A-DRAPTOR 14 1.482 FYO2 5.76 520.71 1361 CBU-97/B SFW 281 0.451 FY04 232 406.4 421 AIM-9X SIDEWINDER 157 0.465|FYDS 2.89 127 86 AGM BAH SLAM-ER 41 0.971FYDG 4.36 342.9 663.51 RIM-156A SM-2 ER 33 4.23 FY01 6.55 34798 1497 RIM GEC SM-2 MR 88 1.764FYON 4.69 3479 706 RGM-109 TAC TOMAHAWK 29 2.358 EYA 5.58 51816 1814.41 BGM-1094-D TOMAHAWK 0.751FYOS 625 518.16 14514 293 1. (6 points) Normalize the Average Unit Cost of each data point to FY21SM using the attached Inflation Indices on page 4 (also provided in a separate file). Attach a printout of your results. 2. (12 points) Using the transformed data from Problem 1, calculate the unit theory theoretical first unit costs (Tl) for each data point. Assume each program experienced an 85% learning rate. Attach a printout of your results. 3. (20 points) Now that you have a database of Tls, lengths, diameters, and launch weights, develop a CER of the form Y = ax that predicts TI. Try each independent variable, one at a time, and choose the best CER. Use GERM. Attach a printout of your results, and be sure to indicate the best CER and its relevant fit statistics. 194 1977 DEEO CEO SUSU WPN Miopon Proc. N1507) NAVY Base Your 2073 Budget Budget Year Fiscal Inflation Rew Weighte Year Year Rates d index Indes Rates 15770 3.935 01528 0 1686 01622 1921 01650 01767 01694 40 1972 3.8% 0.1724 16 01779 490 293 410 01796 0 1950 1579 5.60% 5.72% 1999 0.2112 0 2002 815 1975 8813 2067 0.2204 02158 62 1976 65% 0 2200 02413 0224 7. 356 02281 0.2531 0.2434 4.7% 3.7 02362 0.2680 02576 592 1978 6.80 02525 02997 028 1181% 1929 872 02749 03171 10213 1990 11 RON 0903 0300 1017 11.COM 03400 04059 03904 1902 14 0001 04402 04239 1983 9.00 0.42 Od 04 MOON 0615 0.484 0.4664 40N 04772 047 40 2.9% 1993 OM 05165 04 09350 05142 10 od 05 057 1990 400 OS XAN AN 0612 OS 259 0.000 20N 1000 6192 DE 06 000 15 6436 06 1 1936 06711 DAS 124 0.02 0500 100 OR 067 0.00 . C.COM 0.00 23 LA DON 1701 D. ay 0720 1OON O 02 0727 SIF 0777 20 1108 07200 GAL 20 OP 22 24 ODS 1 -A NOVE NONG NOC NE NOZ NOVE NIDE NO NE SO catro O COMO VO 401 SO SZSO WO GORD 190 1 BE NOLE NO 067 WIT WIT TO NOT OCT O co MITED THEO ZO WE TE HENO WO