Calculate the Slope and Intercept for the following data. Note that the data is random, and may be different than previous question attempts. Answer to the nearest whole number, with no commas (ex: 1234) 655 705 627 603 618 883 873 1,003 1,017 1,207 slope: intercept The recipe for the sauce is the percentage of each ingredient used in the sauce. To find the flavor rating of a given recipe, the weighted average score of the flavor is used, with the weight determined by the percentage of ingredients. As an example, Colossal Supermarket has one custom sauce made of 10% bullion, 5% sugar, 40% Base Sauce 1, no Base Sauce 2, and 45% Base Sauce 3. Colossal Supermarket's sauce would have a Savory score of 29.4 (0.10 100+ 0.05'0+ 0.40 35+ 0'5 +0.45* 12). The Sweet score would be 174 (0.10'0+ 0.05 150 + 0.400 +0:15 +0.45 22). This same method of calculating the flavor works for richness and spice as well as the cost per gallon No price is listed for sugar in the recipe. Sugar prices have varied because of some political issues in the last few months. A history of the sugar cost is shown below. Month Cost of Sugar October $6,61 November $7.33 December $6.55 $7.10 January February 57.36 $7.25 March April $7.91 May 56.04 The management team has asked you to develop a model that can be used to determine the best recipe for sauces for any customers flavor profile, Customers are typically price sensitive, so keep the cost as low as Dossible Assignment Graph the sugar cost. Determine which forecasting methods are appropriate and inappropriate, Forecast the sugar cost for June. Use two distinctly different and appropriate forecasting methods to forecast the cost. Show me that you can use multiple methods correctly, not just the same method two different ways. Determine which forecast method is best based on it's historical accuracy. Develop a model to find the best recipe for a given flavor profile Watch out for the hidden constraint Use your forecast for sugar cost and Solver to find the best recipe for Pearson Grocery Save your model showing the solution to the problem along with Answer, Sensitivity, and Limits reports. Be sure to color code the model appropriately Submit the model via Moodle. Be sure to clearly indicate your answers to the questions. Questions What is the predicted cost of sugar for June? What recipe is best for Pearson Grocery