The Sun Devils Corporation is deciding which of two forecasting models to use. The forecasts for the two models and actual demand are provided below: MAD MAPE RSFE What does the RSFE indicate? Model 1 tends to -Select- Model 2 tends to -Select- Which forecast is better? Why? -Select- % Compute the MAD, MAPE, and RSFE for the two forecasting methods. Do not round intermediate calculations. Round your answers for the MAD and MAPE to two decimal places and for the RSFE to the nearest whole number. Use a minus sign to enter a negative value, if any. Accuracy measure Model 1 Model 2 MODEL 1 MODEL 2 MONTH SALES FORECASTFORECAST 1 155 2 200 3 210 4 195 5 160 6 170 7 145 8 175 9 170 10 175 % 140 220 205 210 150 160 170 170 forecasts demand. forecasts demand. 155 185 180 215 185 185 135 185 125 190 145 165 is better because it provides a -Select- MAD, MAPE, and absolute value of RSFE.

Consider the following time series data: Construct a time series plot. What type of pattern exists in the data? Develop a three-week moving average for this time series. Compute MSE and a forecast for week 7. Use α = 0.2 to compute the exponential smoothing values for the time series. Compute MSE and a forecast for week 7. Compare the three-week moving average forecast with the exponential smoothing forecast using α = 0.2. Which appears to provide the better forecast based on MSE? Explain. Use trial and error to find a value of the exponential smoothing coefficient α that results in a smaller MSE than what you calculated for α = 0.2.

using the chart, how much should the call option worth. please show how to solve this in excel and the formulas

I'm working through a practice assignment with an answer key and I'm getting Answer A for question 4 but the answer key for this one says the answer is C. Can someone work through this one and show me how its done please? For questions 3-4, consider the following table. Investment Investment cost at i = 0 Revenue at t = 1 Revenue at t= 3. 180 200 -200 50 -300 149 Table 1 Suppose that you need to choose between two investment options A and B. Given that the persistent anmual interest rate is 5 percent, which investment option would yiel a higher value? (a) Option A. (b) Option B. (c) Both options would yield the same value. (d) Not enough information.

The following payoff table shows profit for a decision analysis problem with two decision alternatives and three states of nature:     State of Nature Decision Alternative S1 S2 S3 d1 200 150 150 d2 250 150 100   The probabilities for the states of nature are P(s1) = 0.55, P(s2) = 0.25, and P(s3) = 0.2.   (a) What is the optimal decision strategy if perfect information were available?   S1 :   S2 :   S3 :       (b) What is the expected value for the decision strategy developed in part (a)? If required, round your answer to one decimal place.         (c) Using the expected value approach, what is the recommended decision without perfect information?           What is its expected value? If required, round your answer to one decimal place.         (d) What is the expected value of perfect information? If required, round your answer to one decimal place.

By using only those factors given in interesttables, find the values of the factors that follow,which are not given in your tables. Show the relationship between the factors by using factor notation, andcalculate the value of the factor. Then compare thesolution you obtained by using the factor formulaswith a direct calculation of the factor values.For example, (F/P, 8%, 38) =(F/P, 8%, 30) (F/P, 8%, 8) = 18.6253.(a) (P/F, 8%, 67)(b) (A/P, 8%, 42)(c) (P/A, 8%, 135)

Indicate how the internal rate of return is calculated using the factor. (answer is in % format) Please don't give solution in an image format thank u

Assume there are 3,600 cases in the validation dataset, and 12% of these cases have a value of 1 for churn (the primary/positive event). Questions a) to c) are based on data for the 3,600 cases (see table below). Depth (% Contacted) Model Cumulative Gain Cumulative Lift Decision Tree 34.42 6.84 Logistic Regression Neural Network 20.19 4.01 34.62 6.88 Decision Tree Logistic Regression Neural Network 10 64.90 6.06 10 36.06 3.15 10 62.50 5.54 Decision Tree 15 73.96 1.82 Logistic Regression Neural Network 15 49.04 2.62 15 82.21 3.97 Decision Tree Logistic Regression 20 78.39 0.87 20 59.13 2.01 Neural Network 20 86.54 0.86 a) Which model has the highest Cumulative Lift at a depth of 20%? What is the lift? b) If the Cumulative Gain at a depth of 10% for the Decision Tree is converted to number of primary/positive event cases, what will be the number of cases? Show your calculation. c) If the Cumulative Gain at a depth of 15% for the Neural Network model is converted to number of…

Choose the letter/s of the correct answer/s. In Plant Design, one is required to compute for one time-independent and one time-dependent market indicator.Which of the following pairs will provide a better market analysis?A. Payback Period & Breakeven PointB. Capitalized Cost & Payback PeriodC. Discounted Payback Period & Annual WorthD. Inflation Rate & ROI

Please model the following decision in a spreadsheet, optimize it using MS-Excel Solver, and then upload that spreadsheet by attaching it to this question. I will grade this question on the accuracy of your () spreadsheet model (decision variables, objective, and constraints), (i) Solver parameters, (i optimal solution. Partial credit is available. The personnel-planning problem of Lexington Bank. The main branch of Lexington Bank is open for retail business from 8:00 AM to 4:00 PM on weekdays. The staffing requires from 8 to 15 tellers on duty depending on the time of day, as indicated in the following table. Time Period Minimum No. of Tellers 8:00 AM - 10:00 AM 10:00 AM - 12:00 PM 12:00 PM - 2:00 PM 10 15 2:00 PM - 4:00 PM 12 Full-time tellers work 8 consecutive hours (from 8:00 AM to 4:00 PM) at $15 per hour. Part-time workers work 4 consecutive hours at $8 per hour starting at 8:00 AM, 10:00 AM, or 12:00 noon. Assume workers never take breaks. Union regulations require that all…