1 pts Question 50 What do you call a coefficient when even a small change in its value in the objective function can change the optimal solution? out of the range O optimal O minimal within the range O sensitive The Program Head of the University wants to forecast the student enrollments for this academic year based on the following historical data: Year Enrollments 5 yrs ago 8,000 4 yrs ago 9,500 3 yrs ago 10.000 2 yrs ago 11.200 Last year 12.500 What is the forecast for this year using exponential smoothing with alpha -0.5, if the forecast for four years ago was 9.000 11.456 11.400 11.394 11.393 11.500 An analyst is creating a spreadsheet to calculate each employee's total wages for a time period. After completing the model, the analyst feels there is an error. Interpret the formula information shown below to determine which of the following statements is TRUE. A B D 1 2 Wage 11.5 per hour 3 4 Employee Hours Total Wages 5 1 40 -$B$2'AS 6 35 $B$2 A6 7 3 28 =$B$2 A7 8 4 17 $B$2 A8 $B$2 A9 9 5 25 The model is incorrect because it is using the wrong wage information The model is incorrect because it is using the wrong information for the employee hours. The model is incorrect because it is using the wrong information both for the employee hours and wage information. The model is incorrect, but it is impossible to determine why. There is no error in the model. Question 28 1 pts Which of the following statements about a "good" spreadsheet model is FALSE? O Agood model will always give the correct result. None of the choices is false. O A good model has data entered in only one location. O A good model is easy to understand. O A good model is easy to modify