Problems 1 and 2 are finished as shown, plz help solve problem 3. Thank you

Problem 1 The table below shows the last 28 months' sales volumes of Company A. Make forecasts for the next six months. It is up to the student to pick whatever forecast method fits the case. 1. List the forecasts for the next six months. 2. What approach is used to create the forecast? Why you think this approach is the best choice (be specific)? Table 1- Sales of Product X in the Last 28 Months A D 1 11 12 13 14 15 2 3 4 5 Ali 6 7 8 9 16 17 18 19 20 21 22 23 24 25 26 10 11 12 13 14 15 16 B C Month Sales of product 17-Apr 160 17-May 150 17-Jun 156 17-Jul 190 17-Aug 260 17-Sep 272 17-Oct 80 17-Nov 164 17-Dec 154 18-Jan 160 18-Feb 188 18-Mar 250 18-Apr 270 18-May 84 18-Jun 168 18-Jul 154 18-Aug 166 18-Sep 192 18-Oct 270 18-Nov 280 18-Dec 74 19-Jan 174 19-Feb 164 19-Mar 196 19-Apr 206 19-May 288 19-Jun 288 19-Jul 96 19-Aug 19-Sep 19-Oct 19-Nov 19-Dec 19-Jan E Forecasted Sales 172.86 $ 173.95 $ 175.05 $ 176.14 $ 177.24 $ 178.33 $ 179.43 $ 180.52 $ 181.62 $ 182.71 $ 183.81 $ 184.90 $ 186.00 $ 187.10 $ 188.19 $ 189.29 $ 190.38 $ 191.48 $ 192.57 $ 193.67 $ 194.76 $ 195.86 $ 196.95 $ 198.05 $ 199.14 $ 200.24 $ 201.33 $ 202.43 $ 203.52 $ 204.62 $ 205.71 $ 206.81 $ 207.90 $ 209.00 $ F Fixed Cost 25,928.57 26,092.86 26,257.14 26,421.43 26,585.71 26,750.00 26,914.29 27,078.57 27,242.86 27,407.14 27,571.43 27,735.71 27,900.00 28,064.29 28,228.57 28,392.86 28,557.14 28,721.43 28,885.71 29,050.00 29,214.29 29,378.57 29,542.86 29,707.14 29,871.43 30,035.71 30,200.00 30,364.29 30,528.57 30,692.86 30,857.14 31,021.43 31,185.71 31,350.00 17 18 19 20 21 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 llllll 22 23 24 25 26 27 28 WIN 29 30 31 32 33 34 Problem 2 (continued from P1) Company A wants to build a new facility to cover the forecast demand of Product X in problem 1. Product X has variable cost = $150 per unit and revenue = $300 per unit. Based on the forecasting result in Problem 1, find the Fix Cost Value that will result breakeven of the monthly forecasts (there should be six of them). Show your work for credit. Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 Fixed Cost that Will Result Break Even Points $ 30,528.57 $ 30,692.86 $ 30,857.14 $ 31,021.43 $ 31,185.71 $ 31,350.00 Problem 3 (continued from P2) If the company can outsource the product for the cost of $250 per unit (with the max outsource capacity of 80 units). What would be the optimized capacity plan? Show the analysis to justify your recommendation (explain why your recommendation is the best option). Problem 1 The table below shows the last 28 months' sales volumes of Company A. Make forecasts for the next six months. It is up to the student to pick whatever forecast method fits the case. 1. List the forecasts for the next six months. 2. What approach is used to create the forecast? Why you think this approach is the best choice (be specific)? Table 1- Sales of Product X in the Last 28 Months A D 1 11 12 13 14 15 2 3 4 5 Ali 6 7 8 9 16 17 18 19 20 21 22 23 24 25 26 10 11 12 13 14 15 16 B C Month Sales of product 17-Apr 160 17-May 150 17-Jun 156 17-Jul 190 17-Aug 260 17-Sep 272 17-Oct 80 17-Nov 164 17-Dec 154 18-Jan 160 18-Feb 188 18-Mar 250 18-Apr 270 18-May 84 18-Jun 168 18-Jul 154 18-Aug 166 18-Sep 192 18-Oct 270 18-Nov 280 18-Dec 74 19-Jan 174 19-Feb 164 19-Mar 196 19-Apr 206 19-May 288 19-Jun 288 19-Jul 96 19-Aug 19-Sep 19-Oct 19-Nov 19-Dec 19-Jan E Forecasted Sales 172.86 $ 173.95 $ 175.05 $ 176.14 $ 177.24 $ 178.33 $ 179.43 $ 180.52 $ 181.62 $ 182.71 $ 183.81 $ 184.90 $ 186.00 $ 187.10 $ 188.19 $ 189.29 $ 190.38 $ 191.48 $ 192.57 $ 193.67 $ 194.76 $ 195.86 $ 196.95 $ 198.05 $ 199.14 $ 200.24 $ 201.33 $ 202.43 $ 203.52 $ 204.62 $ 205.71 $ 206.81 $ 207.90 $ 209.00 $ F Fixed Cost 25,928.57 26,092.86 26,257.14 26,421.43 26,585.71 26,750.00 26,914.29 27,078.57 27,242.86 27,407.14 27,571.43 27,735.71 27,900.00 28,064.29 28,228.57 28,392.86 28,557.14 28,721.43 28,885.71 29,050.00 29,214.29 29,378.57 29,542.86 29,707.14 29,871.43 30,035.71 30,200.00 30,364.29 30,528.57 30,692.86 30,857.14 31,021.43 31,185.71 31,350.00 17 18 19 20 21 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 llllll 22 23 24 25 26 27 28 WIN 29 30 31 32 33 34 Problem 2 (continued from P1) Company A wants to build a new facility to cover the forecast demand of Product X in problem 1. Product X has variable cost = $150 per unit and revenue = $300 per unit. Based on the forecasting result in Problem 1, find the Fix Cost Value that will result breakeven of the monthly forecasts (there should be six of them). Show your work for credit. Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 Fixed Cost that Will Result Break Even Points $ 30,528.57 $ 30,692.86 $ 30,857.14 $ 31,021.43 $ 31,185.71 $ 31,350.00 Problem 3 (continued from P2) If the company can outsource the product for the cost of $250 per unit (with the max outsource capacity of 80 units). What would be the optimized capacity plan? Show the analysis to justify your recommendation (explain why your recommendation is the best option)