Answered: Quarter 1 2 3 1 11 14 17 2 20 23 26 3…

Quarter 1 2 3 1 11 14 17 2 20 23 26 3 29 32 35 4 38 41 44 Compute seasonal relatives for this quarterly data. a. Use the SA method.

Marketing

20th Edition

ISBN:9780357033791

Author:Pride, William M

Publisher:Pride, William M

Chapter6: Target Markets: Segmentation And Evaluation

Section: Chapter Questions

Problem 17DRQ: Under what conditions might a firm use multiple forecasting methods?

See similar textbooks

Related questions

Q: 1. a.) What is forecasting? b. Explain the importance of forecasting for managers like you? c.) What…

A: Forecasting is simply analyzing and evaluating the past or present data to determine or predict the…

Q: Given the following data, use exponential smoothing(a = 0.2) to develop a demand forecast. Assume…

A: Given data Exponential smoothing (a) or α= 0.2 Initial time period (F1) = 5 To develop the demand…

Q: Following are two weekly forecasts made by two different methods for the number of gallons of…

A: Given - Week Forcast Actual Demand 1 0.95 0.72 2 1.08 1.00 3 0.95 1.07 4 1.22 0.97

Q: a) Is there a strong linear trend in sales over time? b) Fill in the table with what Bob and Sherry…

A: Using excel for performing regression with Sales as the dependent variable and period as independent…

Q: Following are two weekly forecasts made by two different methods for the number of gallons of…

A: Formula to solve this problem: - MAD=Sum of errornMSE = Sum of Squared errorn

Q: (4) Weekly demand for dry pasta at a supermarket chain is as follows Week Demands 1 517 2 510…

Q: (4-b). Use simple exponential smoothing with α = 0.6 to forecast the tire sales for September…

A: Forecasting sales refers to the prediction of future sales using previous data to estimate the…

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

A: Solution Moving average considers the average of the past data. The average can be of three periods…

Q: a. Plot the monthly sales data. Do you observe any trend, cycles or random variations? b. Forecast…

A: Forecasting is a technique that uses recorded data as inputs to make instructed estimates that are…

Q: Forecasted Year Sales Sales 2005 455 415.00 2006 510 427.00 2007 516 451.90 2008 570 471.13 2009 585…

A: Given that: Smoothing constant = 0.6 Starting Forecast = 415 and Year Sales 2005 455 2006 510…

Q: Week 1 2 3 4 5 6 7 8 9 10 Demand 20 21 27 37 26 29 36 20 25 28 The forecast for weeks 2 through 10…

A: Forecasting is the procedure of doing estimations of upcoming activities on the basis of past and…

Q: Assignment What if we use a 3-month simple moving average? Kroger sells (among other stuff) bottled…

Q: What factors make forecasting at Deckers particularly challenging? Howcan forecasts be made for…

A: There are two-fold challenges, and they are The company plans to expand the brands that have…

Q: 1. Develop a 5-month moving average for the below given. What will be the forecast month 15? Compute…

A: Moving Average is an important method to forecast the estimation, based on historical data, in…

Q: This a 4 part question that am confused about. Please show the work by hand not excel. 4-1 Sales of…

A: Note: I have answered for 4-1 only. Kindly post the other question separately. Hence, the sales in…

Q: Do you think that Hard Rock Cafemakes use of time horizons when forecasting?

A: What is Forecasting ? Anticipating is a method that utilizes chronicled information as contributions…

Q: a) The forecast for weeks 2 through 10 using exponential smoothing with a = 0.55 and a week 1…

A: Exponential smoothing formula : Ft = At-1*α + (1- α)*Ft-1 Error = Actual value - Forecasted value…

Q: When a new busines is startered, or a patent idea needs fundig, venture capitalst or investment…

A: Whenever a new business is initiated, funding forms the pre-requisite and approaching to the venture…

Q: Explain the trade-off between responsiveness and stability in a forecasting system that uses…

A: Forecasting is the process of making assumptions of the future on the basis of past and present data…

Q: A large Portland manufacturing would like to forecast the monthly demand for a piece of…

A: Given that: Month Actual Demand 1 14 2 17 3 20 4 21 5 25

Q: Consider the data below which includes sales data and the forecasts that would have been made using…

A: Given data is

Q: ii. The last seven weeks of sales at KC car dealership can be seen in Table 2 below. Table 2 Week…

A: Week Sales 1 25 2 30 3 27 4 31 5 27 6 29 7 30 8

Q: 4. Simple Exponential Smoothing: Use a smoothing parameter, α = 0.3. Month Ft 1 2 3 4 5 678 9 10 No.…

A: Exponential smoothing is a forecasting model which using the actual demand and forecasting f=demand…

Q: The MAD for Method 1 = enter your response here thousand gallons (round your response to three…

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

Q: Period 1 2 3 4 5 6 1. Compute the four period moving average forecast for period 6 and 7. Assume the…

Q: Distinguish between Planning and Forecasting. Answer must briefly.

A: Future demand is the forecasted demand for the products and services expected from the customers.

Q: The following data show the number of liters of gasoline sold by Mackrin's in Colorado for the past…

A: a) It is clear from the results that Exponential smoothing forecast model provides the Lowest mean…

Q: 1. Discuss the differences between Qualitative and Quantitative forecasting models. How do…

A: Since you have asked multiple questions, we will solve the first question for you. If you want any…

Q: g Calcuiate fore cost sales for June using each of the fo llowing method: - i) Naive Method 1) 3…

A: Forecasting is the process of predicting future data based on previous or past data and information.…

Q: Given the following data of actual sales and forecast for the five months: Month 1, Month 2, Month…

A: Given data is

Q: Problem 1: Sheet 1 a) Find on the Internet a time series, which contains at least 20 entries.…

A: Find the Time series data below: Note that, the below data was collected from the website…

Q: Use exponential smoothing with smoothing constant 0.4 to complete the table. b) Forecast the next…

A: THE ANSWER IS AS BELOW:

Q: Passenger miles flown on Northeast Airlines, a commuter firm serving the Boston hub, are shown for…

A: Given-

Q: 4. What is the difference between trend and seasonality in time series data? 5. Here are the errors…

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

Q: Exponential Smoothing, Exponentially Smoothed MAD, and Tracking SignalThe XYZ Company was flooded by…

A: Formula:

Q: My question is: How do you Calculate a moving average forecast using the last 2 and 4 dates of stay.…

A: A moving average, which is the average of any subset of values, is a method for gaining a general…

Q: 3. The weekly demand for units manufactured by the Orion Company Limited has been as follows: Week 1…

A: Formula:

Q: QUESTIONS All Ans to 3 Decimal Places Use the Naiive method to forecast for Feb -Aug 2021 2…

A: As per our guidelines, we are supposed to answer only three sub-parts if multiples sub-parts are…

Q: 4. A new car dealership is considering opening branches in three of the largest cities in the state.…

A: Forecasting is the practice of predicting future events by focusing on long-term trends. Basically,…

Q: Assume that you have three forecasting models. For the first, MAD = 2.5, for the second, the MSE…

A: Answer : OPTION D ( One cannot conclude )

Q: National mixer, Inc. sells can openers. Monthly sales for a seven-month period were as follows:…

A: Find the Given details below: Given details: Month Sales (000 units) Feb 19 March 18…

Q: Gasoline sales Times Series week sales (1000s of gallons 1 17 2 21 3 19 4 23 5 18 6…

A: Find the Given details below: Given details: week sales (1000s of gallons) 1 17 2 21 3 19…

Q: The least squares regression method question - rounds your answer to two decimal points.please find…

A: Using least squares method regression method means we need to fit a line where number of accidents…

Q: D.) compute MAPE for each data set. Which forecast appears to be more accurate?

A: Forecasting is the process in which estimation of future demand is determined using the previous or…

Q: 4. A major bank is considering installing ATMs at all locations of a grocery store chain. What…

A: Inventory management is a tool used to sourcing and distributing both raw materials and finished…

Q: Q.2.2 Compare and contrast between the grassroots forecasting technique and the Delphi method. Q.2.2…

A: The grassroots strategy asks those nearest to the end client to figure out what they will sell in…

Q: Imagine you work for a breakfast cereal company that makes prepared products that are served cold.…

A: Here we have to know the specific interest of the customers .This can be conceivable by the interest…

Q: 1 demand of cotton(intones) by Westham textile S.C are shown below year 1 2 3 4 6 7 8 Actual demand…

A: Given information, Year Actual Demand 1 10 2 11 3 13 4 15 5 14 6 16 7 18 8 20

Q: 3. National Mixer, Inc., sells can openers. Monthly sales for a seven-month period were as follows:…

A: Note: - Since we can answer only up to three subparts we will answer the first three subparts (a, b…

Q: Determine the Mean Absolute Deviation Using a= 0.20. Period Demand Forecast 20 2 35 20 46 23 4 40…

A: Mean Absolute Deviation (MAD) indicating the average value of absolute errors. Absolute error is the…

Concept explainers

Forecasting

Forecasting is a methodology that uses historical data as inputs to make well-informed predictions about the course of future trends. Forecasting is the method of making forecasts based on historical and current data, most commonly by trend analysis. In the business world, forecasting is a basic statistical task. Forecasting is used by businesses to decide how to allocate their budgets or prepare for expected expenditures in the future. Forecasts help managers formulate and execute production plans by providing forecasts. The primary goal of forecasting is to make accurate predictions.

Question

Quarter 1 2 3
1 11 14 17
2 20 23 26
3 29 32 35
4 38 41 44

Compute seasonal relatives for this quarterly data.
a. Use the SA method.

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

a) Compute seasonal relatives using SA method:

VIEW

Formulae to compute the seasonal relatives:

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 2 images

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 file P13_42.xlsx contains monthly data on consumer revolving credit (in millions of dollars) through credit unions. a. Use these data to forecast consumer revolving credit through credit unions for the next 12 months. Do it in two ways. First, fit an exponential trend to the series. Second, use Holts method with optimized smoothing constants. b. Which of these two methods appears to provide the best forecasts? Answer by comparing their MAPE values.
ces Obtain estimates of quarter relatives for these data using the centered moving average method. ( decimal points and standardize the final seasonal relatives so their total is four.) Quarter Demand Year 1 2 3 4 1 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 16 20 35 49 31 36 65 74 50 52 92 86 61 Quarter 1 2 3 4 1 2 3 4 1 2 3 4 1 Year MA 2 MA₂ Demand/MA2
15 5 Two independent methods of forecasting based on judgment and experience have been prepared each month for the past 10 months. The forecasts and actual sales are as follows: 1 Month Sales Forecast 1 835 845 2 1 2 3 4 5 6 7 8 9 10 Forecast 850 820 785 840 815 840 785 800 Forecast 835 830 840 790 815 785 770 835 a. Compute the MSE and MAD for each forecast. (Round your answers to 2 decimal places.) MSE MAPE F1 MAPE F2 805 785 Answer is complete but not entirely correct. MAD 2,942.50 x Forecast 2 765 830 1,125.60 x 815 830 800 806 775 810 815 805 4.2153 X % 3.4380 % 22.50✔ Return to question 28.40✔ b. Compute MAPE for each forecast. (Round your intermediate calculations to 5 decimal places and final answers to 4 decimal places.) > Answer is complete but not entirely correct. c. Prepare a naive forecast for periods 2 through 11 using the given sales data. Compute each of the following; (1) MSE, (2) MAD, (3) tracking signal at month 10, and (4) 2s control limits. (Negative values should…
9 10 38 36 39 Month 1 2 4 5 7 11 12 Flat-Screen Sales 30 32 30 39 33 34 34 30 36 a) Determine the one-step-ahead flat-screen sales forecasts for the first month of next year using 3- and 5-month moving averages. b) Using a 5-month moving average, determine the one-step-ahead flat-screen forecasts for the 7th through 12th months. Compute the MAD. c) Suppose that exponential smoothing is used with a smoothing constant alpha = 0.1 to forecast flat-screen sales for the 7th through 12th months. d) Based on MAD which method did better?
A) What is forecasting? B) describe types of forecasting C) Decribe the relationship of forecasting types with product life cycle (PLC)
Asvnch Problem - Statistical Forecasting Data Set – Eunice BC Fashion Monthly Sales, in million units. Year Total Sales Year Total Sales 2010 38 2016 43 2011 41 2017 40 2012 40 2018 45 2013 45 2019 47 2014 50 2020 42 2015 42 2021 48 Questions: a. Find the naïve forecast. b. Use the 3 years moving average forecast. c. Have a 5 years weighted moving average. d. Develop forecast using exponential smoothing with a = 0.2. e. Determine the trend line equation and present the forecast. f. Find the best forecast for year 2022. Note: Use the first 5 years as the training samples and the last 5 years as the forecasting samples. Solve it in Excel Sheet/Sheet with Equations as possible.
2. An operation specialist used two forecast methods to forecast demand for a certain word processing software package. Actual demand and his corresponding predictions are shown below: Month Sales Forecast A Forecast B January 60 February 25 60 March 54 50 42 April 36 30 55 May 45 45 35 June 60 20 Which forecast method would you recommend if using MAD as the accuracy measurement? Select one: a. Forecast A b. Forecast B c. No preference.
4. The sales (in millions of dollars) for a 15-month period are as follows. Month Sales Month Sales 390 9 470 2 565 10 1000 3 395 11 490 450 12 485 490 13 525 560 14 550 7 420 15 530 8. 565 a. Compare a three-month moving average forecast with an exponential smoothing forecast. Use a = 0.2. Find MSE for both methods. b. Which provides the better forecasts based on MSE? C. Find the forecast for the next month using the best forecast method. 5.
Use quantitative methods for the data shown below: Period 1 2 3 4 5 6 7 Observation 24 34 36 37 41 44 45 i) Naïve method: ii) Three period moving average iii) Three period Weighted moving average iiii)Four-period Moving Average iiiii)Four-period Weighted Moving Average b. Plot the original time series and comment on the appropriateness of a linear trend.
4.6 The monthly sales for Telco Batteries, Inc., were as follows: Month Sales 20 January February March 21 15 14 April Мay 13 June 16 17 July August September October 18 20 20 November 21 December 23 a) Plot the monthly sales data. b) Forecast January sales using each of the following: i) Naive method. ü) A 3-month moving average. iii) A 6-month weighted average using .1, .1, .1, .2, .2, and .3, with the heaviest weights applied to the most recent months. iv) Exponential smoothing using an a = .3 and a September forecast of 18. v) A trend projection.
The following table shows the quarterly sales (RM'000) for Afeef Café for the past 3 years. Quarter Year 1 2 4 2019 11 17 10 18 2020 19 24 17 29 2021 23 38 31 33 Based on the above data. (b) Calculate the seasonal indices using the multiplicative model.
3. A mobile phone store owner wants to predict the demand for mobile phones in October based on the following historical sales data: Month- April May June. July August September Number of phones sold. 100, 140- 110. 150. 120. 160- a. What is this month's forecast using Naive approach b. Using 3-Month Moving Average, develop forecasts for October's demand c. Using 5-Month Moving Average, develop forecasts for October's demand d. When making moving average forecasts, is it better to use a larger time span? -