Good Morning

I need help writing a deep analysis for these cases, thank you.

Retirement Planning Savings Accumulation for retirement Age 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 Current salary $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 145,000.00 147,900.00 150,858.00 153,875.16 156,952.66 160,091.72 163,293.55 166,559.42 169,890.61 173,288.42 176,754.19 180,289.27 183,895.06 187,572.96 191,324.42 195,150.91 199,053.93 203,035.01 207,095.71 211,237.62 215,462.37 219,771.62 224,167.05 228,650.39 233,223.40 237,887.87 242,645.63 247,498.54 252,448.51 Amount contributed to retirement by employer $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 8,700.00 8,874.00 9,051.48 9,232.51 9,417.16 9,605.50 9,797.61 9,993.57 10,193.44 10,397.31 10,605.25 10,817.36 11,033.70 11,254.38 11,479.47 11,709.05 11,943.24 12,182.10 12,425.74 12,674.26 12,927.74 13,186.30 13,450.02 13,719.02 13,993.40 14,273.27 14,558.74 14,849.91 15,146.91 Tyler's contribution $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 6,000.00 6,120.00 6,242.40 6,367.25 6,494.59 6,624.48 6,756.97 6,892.11 7,029.96 7,170.56 7,313.97 7,460.25 7,609.45 7,761.64 7,916.87 8,075.21 8,236.71 8,401.45 8,569.48 8,740.87 8,915.68 9,094.00 9,275.88 9,461.40 9,650.62 9,843.64 10,040.51 10,241.32 10,446.15 Savings after retirement Current savings at Savings at the end of Gross savings at the starting of the year the year end of the year $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 259,000.00 284,060.00 310,416.40 338,126.94 367,251.77 397,853.59 429,997.73 463,752.22 499,187.99 536,378.90 575,401.92 616,337.22 659,268.31 704,282.19 751,469.50 800,924.62 852,745.87 907,035.65 963,900.62 1,023,451.87 1,085,805.07 1,151,080.70 1,219,404.22 1,290,906.29 1,365,722.96 1,443,995.91 1,525,872.65 1,611,506.80 1,701,058.31 Retirement accumulation at the age of 65 Considering his annual expenses and tax deducted from his withdrawals , his retirement funds longs up to his age The amount remains after his 88 the year is The total income tax paid up to the age 88 is If the income waived to retired people, his funds long to survive up to the age $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 269,360.00 295,422.40 322,833.06 351,652.01 381,941.84 413,767.74 447,197.64 482,302.31 519,155.51 557,834.06 598,418.00 640,990.70 685,639.04 732,453.48 781,528.28 832,961.60 886,855.70 943,317.08 1,002,456.65 1,064,389.94 1,129,237.27 1,197,123.93 1,268,180.39 1,342,542.54 1,420,351.88 1,501,755.74 1,586,907.56 1,675,967.08 1,769,100.64 $ 1,794,693.70 88 years $ $ 82,343.60 310,500.00 93 years $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 259,000.00 284,060.00 310,416.40 338,126.94 367,251.77 397,853.59 429,997.73 463,752.22 499,187.99 536,378.90 575,401.92 616,337.22 659,268.31 704,282.19 751,469.50 800,924.62 852,745.87 907,035.65 963,900.62 1,023,451.87 1,085,805.07 1,151,080.70 1,219,404.22 1,290,906.29 1,365,722.96 1,443,995.91 1,525,872.65 1,611,506.80 1,701,058.31 1,794,693.70 Age 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 Savings at the start Expenses of the of the year current year $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 1,794,693.70 1,741,929.51 1,687,582.39 1,631,604.86 1,573,948.01 1,514,561.45 1,453,393.29 1,390,390.09 1,325,496.79 1,258,656.70 1,189,811.40 1,118,900.74 1,045,862.76 970,633.65 893,147.66 813,337.09 731,132.20 646,461.16 559,250.00 469,422.50 376,900.17 281,602.18 183,445.25 82,343.60 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 90,000.00 90,000.00 90,000.00 90,000.00 90,000.00 90,000.00 90,000.00 90,000.00 90,000.00 90,000.00 90,000.00 90,000.00 90,000.00 90,000.00 90,000.00 90,000.00 90,000.00 90,000.00 90,000.00 90,000.00 90,000.00 90,000.00 90,000.00 90,000.00 Savings after income tax deductions Savings after expenses $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 1,704,693.70 1,651,929.51 1,597,582.39 1,541,604.86 1,483,948.01 1,424,561.45 1,363,393.29 1,300,390.09 1,235,496.79 1,168,656.70 1,099,811.40 1,028,900.74 955,862.76 880,633.65 803,147.66 723,337.09 641,132.20 556,461.16 469,250.00 379,422.50 286,900.17 191,602.18 93,445.25 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 1,691,193.70 1,638,429.51 1,584,082.39 1,528,104.86 1,470,448.01 1,411,061.45 1,349,893.29 1,286,890.09 1,221,996.79 1,155,156.70 1,086,311.40 1,015,400.74 942,362.76 867,133.65 789,647.66 709,837.09 627,632.20 542,961.16 455,750.00 365,922.50 273,400.17 178,102.18 79,945.25 Gross savings at the end of the year $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Total 1,741,929.51 1,687,582.39 1,631,604.86 1,573,948.01 1,514,561.45 1,453,393.29 1,390,390.09 1,325,496.79 1,258,656.70 1,189,811.40 1,118,900.74 1,045,862.76 970,633.65 893,147.66 813,337.09 731,132.20 646,461.16 559,250.00 469,422.50 376,900.17 281,602.18 183,445.25 82,343.60 Income tax deductions $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 13,500.00 13,500.00 13,500.00 13,500.00 13,500.00 13,500.00 13,500.00 13,500.00 13,500.00 13,500.00 13,500.00 13,500.00 13,500.00 13,500.00 13,500.00 13,500.00 13,500.00 13,500.00 13,500.00 13,500.00 13,500.00 13,500.00 13,500.00 310,500.00 If no tax deductions, the amount in his account $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 1,704,693.70 1,663,134.51 1,620,328.54 1,576,238.40 1,530,825.55 1,484,050.32 1,435,871.83 1,386,247.98 1,335,135.42 1,282,489.48 1,228,264.17 1,172,412.09 1,114,884.46 1,055,630.99 994,599.92 931,737.92 866,990.05 800,299.76 731,608.75 660,857.01 587,982.72 512,922.20 435,609.87 355,978.16 273,957.51 189,476.23 102,460.52 12,834.34 Investment Strategy at T. Anderson Inc Client Investment Clients Index Old Clients Index New $ $ $ 800,000 0.05 0.055 Recommended Portofolio Allocation Growth Fund Income Fund Money Market Fund $ $ $ $ 248,889 160,000 391,111 800,000 Anticipated Annual Yield $ $ $ $ Risk Tolerance Index Fund Allocation Growth Fund Income Fund Money Market Fund $ $ $ $ 293,333 160,000 346,667 800,000 $ $ $ $ 44,800 20,000 29,333 94,133 11.77% $ Projected Annual Yield 52,800 20,000 26,000 98,800 12.35% 0.05 $ 0.055 Applecore 1 Cost/Wk ($000) 0 1 Customer 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 2 $5.0 44 9 1 0 1 1 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 1 0 0 0 0 0 0 0 0 1 0 1 0 1 0 0 0 0 3 $8.0 44 9 2 0 0 0 0 0 0 1 0 0 0 0 0 0 1 0 0 0 0 0 1 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 1 0 0 0 0 0 1 0 1 4 $3.5 43 10 3 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 1 0 0 1 0 0 0 1 0 0 1 0 0 1 1 1 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 Website 5 $5.5 44 9 4 0 1 0 0 0 0 0 0 0 1 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 1 0 1 1 0 0 1 0 0 0 0 0 0 0 1 0 0 0 0 0 0 1 0 0 0 0 6 $7.0 37 16 Website 5 0 0 0 1 1 0 0 1 1 0 0 0 1 0 0 0 1 0 1 0 0 0 0 0 1 0 0 0 0 1 0 0 0 1 1 0 1 0 0 0 0 1 0 1 0 0 1 0 0 0 0 0 1 7 $4.5 41 12 6 0 0 0 1 0 0 0 0 0 1 1 0 0 1 0 1 0 0 1 0 0 1 1 0 0 0 0 0 1 0 0 0 0 0 1 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 8 $6.0 46 7 7 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 1 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 1 1 1 0 0 0 0 1 0 0 0 0 0 0 0 9 $5.0 44 9 8 0 0 0 0 0 0 0 1 0 1 0 0 0 0 1 0 0 0 0 1 0 0 0 0 1 0 1 0 0 0 0 1 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 $3.0 50 3 9 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 10 $2.2 42 11 10 1 0 0 0 0 1 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 1 0 0 0 1 0 0 1 0 0 0 0 0 0 0 0 0 0 1 0 0 1 0 0 0 0 0 1 0 1 44 44 9 9 43 10 44 9 37 16 41 12 46 7 44 9 50 3 42 #VALUE! 11 #VALUE! Max( Sp=10,000) Subject to: V1=1 V2=0 Sp=X1V1+X2V2 where Sp is total promotion budget V1= regular visitors to site V2=irregular visitors to site X1 and X2 are promotion spending on V1 and V2 respectively 1 Cost/Wk ($ 0 1 2 $5.0 44 9 53 3 $8.0 44 9 53 $3.5 43 10 53 Sp=10,000 106 66 151 Website 4 5 $5.5 $7.0 44 37 9 16 53 53 6 7 $4.5 41 12 53 Number of Customers 96 76 118 8 9 $6.0 46 7 53 $5.0 44 9 53 $3.0 50 3 53 10 $2.2 42 11 53 88 106 177 241 CustomersBudget 53 5,000 106 10,000 170 15,000 180 20,000 185 25,000 189 30,000 192 35,000 Budget 250 200 150 Custome rs Budget 100 50 0 0 10,000 20,000 30,000 40,000 Budget , Yes, the figure is monotomic decreasing as the budget allocation increases in intervals of $5,000 Reason The number of customer attracted for each additional $5,000 added decreases as the amount of promotion funds rises