QuestionUsing a suitable moving average method, find the trend values. The numbers of guests (in hundreds) who checked-in to a popular resort for the duration ofthree years are shown in the following table:Number of guests (hundreds)QuarterThirdFirstFourthYear20192020Second87621078011174151202110013598175 The table below summarizes the years of experience and monthly sales of 8 marketingofficers.Years of experience, XMonthly sales (RM*000), Y349.121110979881110102136118100

Note: - Since the exact question that has to be answered is not specified, we will answer only the…

The numbers of guests (in hundreds) who checked-in to a popular resort for the duration of three years are shown in the following table: Number of guests (hundreds) Quarter Third Year 2019 First Second 87 Fourth 62 107 151 175 2020 80 111 74 2021 100 135 98

The numbers of guests (in hundreds) who checked-in to a popular resort for the duration of three years are shown in the following table: Number of guests (hundreds) Quarter Third Year 2019 First Second 87 Fourth 62 107 151 175 2020 80 111 74 2021 100 135 98

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: Question 1. Question : (TCOs 6 and 8) What is the approximate forecast for July using a 40-month…

A: Forecasting is a prediction or estimate about future circumstances utilizing previous and present…

Q: The monthly sales for Otter Batteries, Inc., were as follows: Plot the monthly sales data. Forecast…

A: XSales13025033046657066576087098010991111012120

Q: The following tabulations are actual sales and forecasts for 6 months. What is ME (Mean Error) at…

A: To find: The Mean error at the end of the June. Formula used: The expression for the mean error is,…

Q: QUESTION 12 A company has experienced the following quarterly sales for the past eight quarters…

Q: In a U.S. News & World Report survey, universities were classified and coded as : (1) Large Public,…

A: Since the classification is based on size and type, the survey will be able to identify the…

Q: Question Completion Status: QUESTION 1 List nested geographic units used by the United States Census…

A: The question is related to list nested geographic units used by the united states census bureau in…

Q: Daily demand for sandwiches at a local deli is shown in the table. Using a 3 period weighted moving…

A: A Weighted Moving Average puts more weight on current data and less on past data. This is done by…

Q: Problem 7 At Treasure Wine Estates in Napa, CA the Sales and Marketing Department have developed a…

A: Given data is Linear trend equation: Ft=90+12.5t A linear trend equation can be formed by taking the…

Q: 25. What is this year's forecast using exponential smoothing with alpha = 0.4, if year 2007's…

A: Exponential smoothing is an established technique used in time series forecasting to estimate future…

Q: False

A: Introduction- ADemand-driven Supply Chain (DDSC) is described as a deliver chain control technique…

Q: Year Bushels Simple Exp. Smoothing Forecast Trend Factor Adjusted Exp. Smoothing Forecast 1 48…

A: To calculate the simple exponential and adjusted forecasting values, we must calculate the alpha and…

Q: EXERCISE 9 - FORECASTING Question 1 The following data summarizes the historical demand for a…

A: Given- Month Actual Demand March 20 April 25 May 40 June 35 July 30 August 45

Q: Question #2 Month Demand 1 45 2 48 3 43 4 48 5 49 6 54 7 47 8 50 9 46 10 47…

A: Inthe steps given below, I explain the step-by-step process. Please follow those steps. If it is…

Q: Successful Companies examine the future outcome using previous evidence."Does RMG in Bangladesh…

A: RMG ( Ready-made garments ) is one of the major drivers of the economy of Bangladesh. Bangladesh is…

Q: Operations Management CH 3 Question 14 Harlen Industries has a simple forecasting model: Take the…

A: Given data is

Q: Problem 4 - do both a three period moving average and an exponential smoothing forecast with an…

A: Forecasting is the process of predicting the future demand based on the previous data and demand.

Q: the Select an answer increases by The regression equation approximates the wither height by the…

A: WE ARE ALLOWED TO DO ONE QUESTION AT A TIME. THUS, I AM ATTEMPTING QUESTION IN FIRST PICTURE WITH…

Q: Market planning, Inc. a marketing research firm, has obtained the prescription sales data for 20…

A: While choosing a regression model, it is important to assess how well the autonomous factors…

Q: An organization uses a business intelligence system to predict products that tend to be purchased…

A: RFM (Recency,Frequency,Monetary) Analysis is the method which uses the Quantitative data of the…

Q: FC.51 Madison Memorial Hopsital is considering purchasing a new ambulance. The decision will rest…

A: Moving average Forecasting: Moving average forecast is a forecasting technique that is used to…

Q: Auto sales at Carmen's Chevrolet are shown below. Using a 3-week weighted moving average (w₁-0.5,…

A: Forecasting is a technique used to predict future outcomes on the basis of past data. In businesses…

Q: Operations Management CH 3 QUESTION 22 Tucson Machinery, Incorporated, manufactures numerically…

A: Given data:

Q: You work for BMW as a planner. BMW is expecting to increase its annual sales for BMW- X5 in year…

A: BMW-X5 sales are increasing by 10% every quarter looking at as per the given data. let us clarify…

Q: (a) What are the optimal values? (b) Develop a visualization comparing the forecasts with the…

A: There are many methods to find the optimal forecasted values like the moving averages method,…

Q: If the forecasted value of the time series variable for one period is 28.5 and the actual value…

A: Forecasted value = 28.5 Actual value = 32

Q: Question 11 Time series forecast analyze data obtained from past experience True False

A: Time series forecasting is a bit of a dark horse in the field of data science: it's one of the most…

Q: In time series analysis, how do the mean absolute percentage error, the mean squared error, and the…

A: Time series analysis can be defined as an analysis of a sequence of observations or data points that…

Q: Sales of Volkswagen's popular Beetle have grown steadily at auto dealerships in Nevada during the…

A: Linear regression is a statistical modeling method used to establish a relationship between a…

Q: QUESTION 5 Choose the answer with the best match. Elements of a Good Forecast, Meaningful:…

A: “Since you have posted a question with multiple sub parts, we will provide the solution only to the…

Q: Friday Using this table above, solve for Mean Squared Error (MSE) the last 2 decimals example…

A: Forecasting is a technique used to predict future outcomes on the basis of past data. In businesses…

Q: 1 39 44 40 4 45 38 43 7 39 a) Forecast sales using 4-week weighted moving averages with weights…

A: A) The weights of the 4 periods are respectively 0.4,0.3,0.2,0.1 and their sum is 1Calculation of 4…

Q: Identify two business situations where the Delphi method might be used to generate forecasts. Can…

A: The Delphi approach (also known as the Delphi procedure or process) is a way of gathering expert…

Q: QUESTION 4 In an effort to reduce energy costs, a major university has installed more efficient…

A: This question is part of Six sigma Business statistics and It fall within General business and…

Q: Question 2 Chad and James are two veteran sales executives who have been working for a…

A: Forecasting is essential to any business because it facilitates the making of well-informed future…

Q: Suppose sales for the past 6 months have been 119, 82, 103, 117, 116, and 97 Using a smoothing…

A: As per the exponentially smoothening: Ft = (Ft-1) + a {(At-1) - (Ft-1)} Ft = Forcast for period…

Q: Forecasting is utilized in which of the following areas? A) product demand B. process design (c) new…

A: Efficiency is the ability to reduce or eliminate the wastage of resources, money, and time in an…

Q: Q. Cypress River Landscape Supply is a large wholesale supplier of landscaping materials in Georgia.…

A: SCM refers to the management of movement corresponding with goods and services supply including all…

Q: MA forecast for as many periods as possible before calculating the CFE. Group of answer choices…

A: A moving average can be stated as the statistics that grab or captures the average transformations…

Q: Use an exponential smoothing model with a =.4 to forecast issues remediated for periods 6-10.…

A: Forecasting is a technique used to predict future outcomes on the basis of past data. In business…

Q: QUESTION # 7 A small restaurant offers tacos to their patrons. One of their specialties is the Mega…

A: Given Information: a) The forecasted demand for using a moving average with n = 3 is :

Q: Question 18 A tire company needs a forecast for studded tires in the next forecast period. The…

A: Given: A smoothing constant of alpha = 0.20. The demand for the most recent period = 100 The…

Q: Cluster analysis is often used for what business purpose? Question 12 options: Predicting…

A: Clustering is the process of grouping the data of the observation under one head. This is done when…

Q: he point in the supply chain where the business switches from forecast-driven to demand-driven is…

A: answer is

Question

Question

Using a suitable moving average method, find the trend values.

The numbers of guests (in hundreds) who checked-in to a popular resort for the duration of
three years are shown in the following table:
Number of guests (hundreds)
Quarter
Third
First
Fourth
Year
2019
2020
Second
87
62
107
80
111
74
151
2021
100
135
98
175

The table below summarizes the years of experience and monthly sales of 8 marketing
officers.
Years of experience, X
Monthly sales (RM*000), Y
3
4
9.
12
11
10
97
98
81
110
102
136
118
100

Expert Solution

This question has been solved!

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

SEE SOLUTION Check out a sample Q&A here

Step 1 - Introduction

VIEW

Step 2 - Forecasting using seasonal moving average

VIEW

Step by step

Solved in 2 steps with 3 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

Operations Management CH 3 Question 14 Harlen Industries has a simple forecasting model: Take the actual demand for the same month last year and divide that by the number of fractional weeks in that month. This gives the average weekly demand for that month. This weekly average is used as the weekly forecast for the same month this year. This technique was used to forecast eight weeks for this year, which are shown in the following tables along with the actual demand that occurred. The following eight weeks show the forecast (based on last year) and the demand that actually occurred:
What are the disadvantages and advantages of moving average technique and simple exponential smoothing?
Question 21 Using the moving average can create some problems in the forecast. Which of the following is NOT a problem related to using the moving average? Increasing n smooths the forecast but makes it less sensitive to changes The forecast is created with very little data, likely not reflecting the requirements very accurately Requires extensive historical data O Does not forecast trends well
QUESTION 2 In an effort to reduce energy costs, a major university has installed more efficient lights as well as automatic sensors that turn the lights off when no movement is present in a room. Historically, the cost of lighting an average classroom for 1 week has been $265. To determine whether the changes have signficantly reduced costs, the university takes a sample of 50 classrooms. They find that the average cost for 1 week is $247 with a standard deviation of $60. When testing the hypothesis (at the 5% level of significance) that the average energy use has decreased from the past, what is the test statistic? (please round your answer to 2 decimal places)
Question 1 Forecasting calculation X Month Sales (y)(000 units) 1 Feb. 19 2 Mar. 18 3 Apr. 15 4 May 20 5 Jun. 18 6 Jul. 22 7 Aug. 20 8 Sep a. Using a 5-month moving average, calculate September sales b. Calculate September sales Using a 3-month weighted moving average (weights are 0.60, 0.30. 0.10). c. Calculatate Exponential Smoothing (assume February sale is 19) sales in September (alpha 0.2, that means 1-0.2 = 0.8) d. Using regression analysis, what is Y (September sales) if X is 8? (use data> data analysis button> regression)
please answer in excel Jean’s Copiers sells and repairs photocopy machines. The manager needs weekly forecasts of service calls so that she can schedule the personnel. The manager uses α = 0.3 for exponential smoothing, and the forecast for the first week was 24 calls. The manager also uses 3 weekly moving averages technique. a) Using 3 period moving averages, forecast the number of calls for week 7. b) Using exponential smoothing, forecast the number of calls for week 7. c) Compare these two forecasting techniques using Mean Squared Errors (MSE) measure. Which one is better?
QUESTION 4 Suppose the following are the seasonal indices for the first three quarters of the year for a quarterly series: Quarter Seasonal Index Q1 72.4 Q2 85.3 Q3 109.6 Remember that the seasonal indices should average 100 so you should be able to infer the seasonal index for Q4. Furthermore, suppose that the estimated coeffcients from a regression of the deseasonalized series on Time are given below: Coefficients Intercept 2,506 Time 71.3 If the original value of the series in a Q1 was 2,040, then what is the seasonally adjusted value? (please round your answer to 1 decimal place)
Assume that your stock of sales merchandise is maintained based on the forecast demand. If the distributor's sales personnel call on the first day of each month, compute your forecast sales by each of the three methods requested here. June July August ACTUAL 144 184 210 a. Using a simple three-month moving average, what is the forecast for September? Note: Round your answer to 2 decimal places. Forecast for September b. Using a weighted moving average, what is the forecast for September with weights of 0.30, 0.40, and 0.30 for June, July, and August, respectively? Note: Do not round intermediate calculations. Round your answer to 2 decimal places. Forecast for September
Which of the following is NOT a typical application of analytics in operations and supply chain management? Question 4 options: Capacity and scheduling Logistics and sourcing All of these choices are typical applications. Forecasting
The moving average forecast method should only be used with time series data demonstrating a linear trend. Question 17 options: True False
Time period Actual sales 1 18 2 22 If the forecasting value of period 3 is 19.6 using exponential smoothing, the smoothing constant is what?
q. 15 Calculate the accuracy of your MA forecasts using MAD. What does the result tell you? Group of answer choices a. There is a bias towards over forecasting b. There is a bias towards under forecasting c. On average forecasts miss by 15% d. On average forecasts miss by 2 e. MAD does not provide any useful information without a CFE calculation to compare with