Question: please solve the questions in excel and provide excel file. 1) San Jose State University had received the following number of applications to its Engineering

please solve the questions in excel and provide excel file.

please solve the questions in excel and provide

1) San Jose State University had received the following number of applications to its Engineering program in the last 5 years. a) What would the 2021 forecast be if made at the end of 2020, using two year moving average method. b) Generate a forecast of demand for the year 2022, using two year moving average method. Calculate MAD, MSE. c) Apply exponential smoothing with a smoothing constant of 0.9 to generate a forecast for demand in 2022. Consider the forecast same as demand for 2017. Calculate MAD \& MSE. d) What would the 2022 forecast be if made at the end of 2021, using exponential smoothing with =.2 and a forecasted value of 12,000 applications for the year 2017? e) Which of these forecasts do you prefer and why? 2) Therano a healthcare company, has collected the following sales data. a) Forecast for the month of July using Nave method. Calculate MAD \& MSE. b) Forecast for the month of May using 3-month moving average. Calculate MAD \& MSE Assume that the base value at the end of month 2 was 125 and the trend value was 10. Using =0.2 and =0.4, answer the following questions. c) What is the forecast for month of May made at the end of April? d) What is the forecast for July made as of the end of June? e) What is the forecast for August made as of the end of July? f) Which of these forecasts do you prefer and why

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!