Question 1. The dean of a school of business is forecasting total student enrollment for this year(2019)'s summer session classes based on the following historical data:YEARTOTAL ENROLLMENTy2,0002,2002,8003,0002015201620172018 b) What is this year's forecast using a three-year weighted moving average with weights of 0.5,0.3, and 0.2?

The concept of Operation Management: Operation management is the management that applies to a…

Answered: b) What is this year's forecast using a…

Business

Operations Management

b) What is this year's forecast using a three-year weighted moving average with weights of 0.5, 0.3, and 0.2?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Q: The following gives the number of accidents that occurred on Florida State Highway 101 during the…

A: Least square regression model consider Y=a+bx. Here, a indicating intercept and b indicating the…

Q: Given the following history, use a three-quarter moving average to forecast the demand for the third…

A: In operations management, Forecasting serves as a navigating tool for ships traversing uncharted…

Q: What are the similarities and differences between ridge regression and forecasting?

A: A Small Introduction about Regression Regression analysis is used to predict a continuous dependent…

Q: The Carbondale Hospital is considering the purchase of a new ambulance. The decision will rest…

A: 2 year moving average is calculate by the sum of last two year and divided with number of moving…

Q: a) Using a 2-year moving average, the forecast for year 6 = miles (round your response to the…

A: Forecastin's primary goal of forecasting is to decrease uncertainty and make corrective decisions by…

Q: How did you get 106 for 7/1/2021? For the forecast, how would you calculate an exponential…

A: Exponential smoothing is a forecasting model which considering the actual demand and forecasting…

Q: Year Mileage 1 3,000 2 4,050 3 3,450 4 3,800 5 3,800 a) Using a 2-year moving average, the forecast…

A: A forecasting model is a mathematical or statistical tool used to predict or estimate future values…

Q: nformation, What will be - forecast of June, using month weighted moving erage with the following…

A: Given Information:

Q: Think of an industry or company other than automotive that relies heavily on forecasting accuracy.…

A: Forecasting is completely based on past data, unlike predictions that are based on instinct, or…

Q: Based on the following equation for a moving average forecast, what would have been the three week…

A: Here, each week has the revenue data, I will apply the 3-week moving average technique, the 6-week…

Q: The Bayside Fountain Hotel is adjacent to County Coliseum, a 24,000- seat arena that is home to the…

A: A time series method called exponential smoothing forecasting uses an exponentially weighted moving…

Q: The analytics department is researching the past five years of their company's sales to better…

A: Step 1: Identify the formula for Mean Absolute Deviation (MAD)MAD = ∑|e|/nwhere:∑|e| = total of all…

Q: What is a time series and the rationale for forecasting based on a time series analysis?

A: Forecasting refers to the prediction of the future based on some evidence or a strong base.…

Q: (a) Given the following historical data, which do you think would be better to use? (Round answers…

A: MAD refers to the mean of absolute deviation of forecast and demand Exponential smoothing formula =…

Q: a) Using a 2-year moving average, the forecast for year 6= 3800 miles (round your response to the…

A: Forecasting is predicting the uncertainty of the future. This can be in the context of sales or…

Q: Assume that the initial forecast for February is 65.0 (in $ thousands) and the initial trend…

A: There are various methods of forecasting. One of the methods is the trend-adjusted exponential…

Q: Which qualitative forecasting technique was developed to ensure that the input from every…

A: Delphi method.

Q: a) Using a 2-year moving average, the forecast for year 6= miles (round your response to the nearest…

A: YearMileage13100240503340043800537506

Q: he hotel has experi nced the following occupancy rates for ne past the coliseum opened. Compute an…

A: Forecasting refers to making predictions or estimations regarding future outcomes. Forecasting is…

Question

b) What is this year's forecast using a three-year weighted moving average with weights of 0.5,
0.3, and 0.2?

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.

Similar questions

The following gives the number of accidents that occurred on Florida State Highway 101 during the last 4 months: Month Jan Number of Accidents 25 Feb 48 Mar 64 Apr 100 Using the least-squares regression method, the trend equation for forecasting is (round your responses to two decimal places): y = -1 + 24.10 x Using least-squares regression, the forecast for the number of accidents that will occur in the month of May response as a whole number). = accidents (enter your
Given the following data of actual sales and forecast for the five months: Month 1, Month 2, Month 3, Month 4, Month 5, and Month 6: Month 1 2 3 4 5 6 Actual Sales 50 40 45 55 65 50 Forecast 55 50 (b) Calculate the Mean Square Error (MSE). (a) Calculate the Mean Absolute Percent Error (MAPE). 40 50° 65 40 (c) Calculate the Mean Absolute Deviation (MAD).
The director of the Riley County, Kansas, library systemwould like to forecast evening patron usage for next week.Below are the data for the past 4 weeks: a) Calculate a seasonal index for each day of the week.b) If the trend equation for this problem is y = 201. 74 + .18x,what is the forecast for each day of week 5? Round your forecastto the nearest whole number.
4) A small manufacturing firm has recorded a time series of the cost per unit for the firm's leading product over the past eight years. Year Cost/Unit($) 1 2 3 4 5 6 7 8 20 24.5 28.2 27.5 26.6 30 31 36 a) If you are not given a base value or trend, what would be the forecast for the year 10 made at the end of year 8 (a=0.2, ß=0.4). b) Forecast for the year 9 using 1) 5-month weighted average using 0.1,0.1,0.1,0.2,0.3, with the heaviest weight applied to the recent month 2) Exponential smoothing using a =0.2 and forecast of 21 for year 5 3) If a value was not provided in the question above, what value of a would you choose?
Describe when to use of a time series forecasting techniques and what assumption are made?
A recently introduced product has a positive trend in sales. The product’s sales have increased in each of its first eight weeks on the market. The forecast for week 6 was 1,325 (F6 = 1,325), with A6 = 1,283 and T6 = 42. Using smoothing components α = 0.20 and β = 0.30, develop forecasts for weeks 7 and 8.
Pravinbhai
A police station had to deploy a police officer for an emergency multiple times in the last four evenings. The t below shows the number of emergencies each evening. Weekday Number of calls each day Monday 10 Tuesday 2 Wednesday 12 Thursday 12 (Round your answer to 1 decimal place.) What would be their forecast for the emergencies on Friday using a two-day moving average approach? Forecast for Friday calls
Professor Very Busy needs to allocate time next week to include time for office hours. He needs to forecast the number of students who will seek appointments. He has gathered the following data: Week 6 weeks ago 5 weeks ago 4 weeks ago 3 weeks ago 2 weeks ago Last week # Students 83 110 95 80 65 50 What is this week's forecast using trend-adjusted (double) smoothing with alpha = .5 and beta = .1, if the forecast for last week was 65, the forecast for two weeks ago was 75, and the trend estimate for last week's forecast was -5? 49.3 78.7 51.3 50.6 65.4
One forecasting model was used to forecast demand for a product. The forecasts and the demand are shown in the table below. Use two decimals in your answer. Actual Forecast 1 40 41 2 35 38 3 38 35 4 33 30 The Mean Absolute Deviation (MAD) is O 0.5 2.5 O 1.48 7.01
The Carbondale Hospital is considering the purchase of a new ambulance. The decision will rest partly on the anticipated mileage to be driven next year. The miles driven during the past 5 years are as follows Year Mileage 1 3,100 2 4,000 3 3,450 4 3,850 5 3,750 a) Using a 2-year moving average, the forecast for year 6 = 3800 miles (round your response to the nearest whole number). b) If a 2-year moving average is used to make the forecast, the MAD based on this = 108.3 miles (round your response to one decimal place). (Hint. You will have only 3 years of matched data.) c) The forecast for year 6 using a weighted 2-year moving average with weights of 0.40 and 0.60 (the weight of 0.60 is for the most recent period) = miles (round your response to the nearest whole number)
The sales of Bluetooth Headphones at the Dubai Electronics Enterprises in Jebel Ali, UAE, over the past 4 months have been 100, 110, 120, and 130 units (with 130 being the most recent sales). Develop a moving-average forecast for next month, using the following techniques: 5B. If next month's sales turn out to be 140 units, forecast the following month's sales (months) using a 4-month moving average.