Please do not give solution in image format thanku Question 8The manager of the Petroco Service Station wants to forecast the demand fogasoline next month so that the proper number of gallons can be orderedfrom the distributor. The owner has accumulated the following data ondemand for unleaded gasoline from sales during the past 10 months.Compute an exponentially smoothed forecast with an a value of .30.According to the result from Excel and/or POM-QM, the forecast for themonth of January would be (type number only, two decimals)MonthOctoberNovemberDecemberJanuaryFebruaryMarchAprilMayJuneJuly733.25Gasoline Demanded (gal.)8007256305006456907308101,200980

Forecasts serve as benchmarks against which actual outcomes can be measured by a company. Comparing…

Answered: The manager of the Petroco Service…

Contemporary Marketing

18th Edition

ISBN:9780357033777

Author:Louis E. Boone, David L. Kurtz

Publisher:Louis E. Boone, David L. Kurtz

Chapter14: Pricing Strategies

Section14.2: Forecasting Demand

Problem 1LO

See similar textbooks

Similar questions

Under what conditions might a firm use multiple forecasting methods?
Q1) Forecasting is both art and science. Describe the situations where we use Qualitative forecasting techniques and quantitative forecasting techniques
Question 1 ) The monthiy sales Of yamizí Battery company are asfollows:- Month Jales 2000 2100 1500 1400 1300 Calcuiate fore cost sales for June using each of the fo llowing method: - i) Naive Method 1M 3 Month Simple moving averoger Ti) Exponentral smoothing using an a =0:3 cand may forecast of 1600 units.
QUESTION 2:The manager of YTL Computers wants to develop next year’s quarterly forecasts of salesrevenue for its brand laptops. The sales are seasonal and the company believes that thefollowing most recent eight quarters of sales should be representative of next year’ssales: Year Quarter Sales (millions of dollars) 1 1 9.2 1 2 5.4 1 3 4.3 1 4 14.1 2 1 10.3 2 2 6.4 2 3 5.4 2 4 16.0 Determine the forecast of next year’s quarterly sales revenue for this line of laptops.Show all your workings.
Question 03 Suppose you sell stylish leather bags targeting young office going people who can use your bags to carry laptops and necessary stuff. You have already launched leather bags in February of this year and now based on the demand results of last 7 months, you want to predict the demand for your bags for the month of September. Hence, you want to select the right forecasting techniques and you are considering 2 period Moving Average, Naive technique and Exponential Smoothing (use any value between .10 - .15 as the value of alpha). Now figure out the better forecasting technique among 2 period Moving Average, Naive technique and Exponential Smoothing by doing the error calculation with the help of MAD, MSE, MAPE. Period Demand 2period Moving Average (Demand forecast) Naive technique (Demand forecast) Exponential Smoothing (Demand forecast) February 70 75 ** ** March 74 78 ** ** April 80 ** ** ** May 88 ** ** ** June…
Month Demand Sept. 78 Oct. 80 Nov. 77 Dec. 85 Jan. Based on the time series data presented above, do the forecasts using 2-month moving average (2-MA) and single exponential smoothing (SES) with a = 0.4, and answer the following questions: %3D (i) What is the mean absolute deviation (MAD) for 2-MA? (ii) What is the mean absolute deviation (MAD) for SES a = 0.4 ? (iii) Based on what you got, which method is more accurate?
Given November actual demand of 61, November forecast of 58, and an alpha of 0.4, November trend value +1.03, Beta of 0.3 what would the forecast including trend (FIT) for the December period be using exponential smoothing model 2? Select one: a. 62.03 b. cannot be found c. 68.76 d. 65.72
Question DEMAND FOR FERTILIZER YEAR (1,000S OF BAGS) 1 4 2 6 3 4 4 5 5 10 6 8 7 7 8 9 9 12 10 14 11 15 Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table: Develop a trend line for the demand for fertilizer using any computer software. For these three forecasts, 3-year moving average, a weighted moving average, and a trend line, which one would you use? Explain your answer. Use exponential smoothing with a smoothing constant of 0.3 to forecast the demand for fertilizer given. Assume that last period’s forecast for year 1 is 5,000 bags to begin the procedure. Would you prefer to use the exponential smoothing model or the weighted average model developed? Explain your answer.
Font Paragraph Styles Question 3 Consider the following from an estate agent's business nationally: Month Houses Sold Jan Feb Mar 380 360 390 Apr May June July Aug Sep Oct 400 390 380 394 454 460 460 Nov Dec 430 370 a) Calculate the three point moving averages (quarters) and seasonal variation for the above data b) Define moving averages and how they're useful in forecasting (use Harvard referencing) c) At races, your horse, White Rum, has a probability of 1/20 of coming 1st, 1/10 of coming 2nd and a probability of 4 in coming 3rd. First place pays $5,000 to the winner, second place $4,000 and third place $1,350. Hence, is it worth entering the race if it costs $1050?
Q3) Discuss Qualitative forecasting technique. Explain the situations where we use Qualitative methods. Discuss Delphi forecasting method and its challenge.
Question 3: Jane is trying to forecast demand for her store, using moving average with n=2, Fill in the missing cells with correct values and find average error for first quarter and second quarter of year 2000 E Enroll- Year Quarter ment Forecast Error Abs Error 1997 313 3. 2 285 4 3 312 5. 4 339 6. 1998 1 359 7 320 356 385 6. 10 1999 396 367 11 397 12 423 13 14 2000 1 15 2000 3412M4
There is a bias towards under forecasting, though we cannot determine from the data provided whether that is severe bias or not O There is a severe bias towards under forecasting O Bias is negligible in this case Question 22 A MAD (Mean Absolute Deviation) of 17.3 suggests which of the following? O There is an over-forecasting bias of 17.3 O The standard deviation for the forecast data is 17.3 O All forecasts fall within 17.3 of the actual data O On average, the forecasts miss by 17.3 O Without knowing the average, the MAD is useless 0 日

SEE MORE QUESTIONS

Recommended textbooks for you

Contemporary Marketing

Marketing

ISBN:

9780357033777

Author:

Louis E. Boone, David L. Kurtz

Publisher:

Cengage Learning

Marketing

ISBN:

9780357033791

Author:

Pride, William M

Publisher:

South Western Educational Publishing

Contemporary Marketing

Marketing

ISBN:

9780357033777

Author:

Louis E. Boone, David L. Kurtz

Publisher:

Cengage Learning

Marketing

ISBN:

9780357033791

Author:

Pride, William M

Publisher:

South Western Educational Publishing

SEE MORE TEXTBOOKS