Does the managements technique outperform the trend projection model? Write abusinessmemo to the management teamand summarize your findings.In writing the memo, you should assume that the upper managers have no knowledge ofsuchconcepts asMAD, MAPE, MSE, or TS. Thus you should be focusing on the business interpretation and weave a story, rather than the detailed calculation. The memo should be written in plain language so thatanyone without forecasting background canunderstand it. The memo should not exceed page

error. Actual n 12 0.0900 MAD 0.0629 MSE 48 2979.166667 0.03225 0.0205 MAPE 3.25% 0.0657 TS 12 0.0019 0.0146 0.0203 100% % . .00 123 Default (Ari... 10 B I . A . Es ... | fx B C D E F G MAPE 2818.92 TS 4.96 Forecast demand Error Absolute Error Squared Error Absolute error! Actual 1 910 1000 90 90 8100 0.0900 MAD 2 1043 1113 70 70 4900 0.0629 MSE 3 1245 1271 26 26 676 0.0205 MAPE 4 1350 1445 95 95 9025 0.0657 TS 5 1555 1558 3 3 9 0.0019 6 1624 1648 24 24 576 0.0146 7 1689 1724 35 35 1225 0.0203 8 1806 1850 44 44 1936 0.0238 9 1823 1864 41 41 1681 0.0220 10 2041 2076 35 35 1225 0.0169 11 2113 2167 54 54 2916 0.0249 12 2132 2191 59 59 3481 0.0269 19331 19907 576 576 35750 0.0289 8 1797.78 52.22 52.22 2726.42 9 1903.98 -39.98 39.98 1598.06 10 8 9 10 11 12 1850 1864 2076 2167 2191 2010.17 65.83 65.83 4334.03 2116.36 50.64 50.64 2564.66 2222.55 -31.55 31.55 995.31 11 12 13 1 next year 14 2 next year a. 2328.74 2434.93 Total 245.02 592.24 33827.02 n 12 MAD 49.35 49.35 MSE 2818.92 MAPE 2818.92 2818.92 4.96 TS signment 2 Edit View Insert Format Data Tools Add-ons Help 2 Share Last edit was 4 minut... 100% $ % .0 .00 123 Default (Ari... 10 B IS A . B D E G Month Forecast Error Absolute Values 1 1054.45 Absolute value of Error Square of Error -54.45 54.45 2964.64 -47.64 47.64 2269.51 1160.64 2 3 Demand 1 1000 2 1113 3 1271 4 1445 5 1558 4.17 4.17 17.39 1266.83 1373.02 4 71.98 71.98 5180.95 5 1479.21 78.79 78.79 6207.53 6 1648 1585.40 62.60 62.60 3918.38 6 7 7 1724 1691.59 32.41 32.41 1050.15 8 8 1797.78 52.22 52.22 2726.42 9 9 1903.98 39.98 1598.06 -39.98 65.83 10 1850 1864 2076 2167 2191 10 2010.17 65.83 4334.03 50.64 50.64 2564.66 11 12 11 12 -31.55 31.55 995.31 2116.36 2222.55 2328.74 2434.93 a. 13 1 next year 14 2 next year Total 245.02 592.24 33827.02 n 12 HAN AF