Managerial Economics: Applications, Strategies and Tactics (MindTap Course List)
14th Edition
ISBN: 9781305506381
Author: James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 5, Problem 7E
The Questor Corporation has experienced the following sales pattern over a 10-year period:
- Compute the equation of a trend line (similar to Equation 5.4) for these sales data to
forecast sales for the next year. (Let - Use a first-order exponential smoothing model with a w of 0.9 to forecast sales for the year 2014.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
You own a restaurant near the beach. Business has been growing each
year, but obviously spikes during the summer months. A regression
produces the following equation:
M = 30,000 + 530t + 1,000S
Where M is monthly sales, t is years past 2010, and S is a dummy variable
for the summer months. If the month is June, July, or August, insert a "T".
If not, the value for S is zero.
What are the predicted sales for June 2026?
Enter as a value.
solve within 30 mins.
With a new chef and a creative menu, Café Venetian has witnessed a huge surge in sales. The following data show a portion of daily
sales (in $) at Café Venetian in the first 100 days after the changes.
Day
Sales
1
226
2
185
100
1,737
pictureClick here for the Excel Data File
a-1. Estimate the exponential trend model. (Negative values for regression coefficients should be indicated by a minus sign. Round
your answers to 2 decimal places.)
Predictor Variable
Constant
Day
Coefficient
0.00
a-2. Use the estimated model to forecast for the 101st day. (Do not round coefficient estimates. Round final answer to 2 decimal
places.)
Forecast for the 101 day
Chapter 5 Solutions
Managerial Economics: Applications, Strategies and Tactics (MindTap Course List)
Ch. 5 - The forecasting staff for the Prizer Corporation...Ch. 5 - Prob. 2ECh. 5 - Metropolitan Hospital has estimated its average...Ch. 5 - Prob. 4ECh. 5 - A firm experienced the demand shown in the...Ch. 5 - The economic analysis division of Mapco...Ch. 5 - The Questor Corporation has experienced the...Ch. 5 - Bell Greenhouses has estimated its monthly demand...Ch. 5 - Savings-Mart (a chain of discount department...Ch. 5 - Prob. 1.1CE
Ch. 5 - Plot the logarithm of arrivals for each...Ch. 5 - Logarithms are especially useful for comparing...Ch. 5 - Prob. 1.4CECh. 5 - In attempting to formulate a model of the...Ch. 5 - Estimate the double-log (log linear) time trend...Ch. 5 - Prob. 2.1CECh. 5 - Prob. 3.1CECh. 5 - Prob. 3.2CECh. 5 - Prob. 3.3CE
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, economics and related others by exploring similar questions and additional content below.Similar questions
- Assume that the relationship between new car prices (P) and population (N) in Southern California is given by: P = 13 N0.80 Based on your knowledge of non-linear regressions and logarithm properties, what is the effect on new car prices if the population in Southern California increases by 5%? An increase of 4 dollars An increase of 4 percent. An increase of 13 percent. An increase of 17 percent.arrow_forwardConsider the following estimated regression model relating annual salary to years of education and work experience. Estimated Salary=10,160.10+3147.75(Education)+1230.34(Experience) Suppose an employee with 8 years of education has been with the company for 20 years (note that education years are the number of years after 8th grade). According to this model, what is his estimated annual salary?arrow_forwardYear Quarter Revenue Q1 4.80 Q2 4.56 2015 Q3 4.88 Q4 4.91 Q1 5.37 Q2 4.99 2016 Q3 5.24 Q4 5.71 Q1 5.73 Q2 5.29 2017 Q3 5.66 Q4 5.70 Q1 6.07 Q2 6.03 2018 Q3 6.31 Q4 6.30 Q1 6.60 Q2 6.31 2019 Q3 6.82 Q4 6.75 Q1 7.10 Q2 6.00 2020 Q3 4.20 Q4 6.20arrow_forward
- Questions 6 & 7: A model for the Consumer Price Index (CPI) for the period July 2005 (t = 0) to March 2006 (t = 8), where t is in months, is given by the function, (t) = 0.06t³ -0.8t² +3.1t + 195 Use the model to answer Questions 6 and 7 below.arrow_forwardThe table shows the yield (in bushels per acre) and the total production (in millions of bushels) for corn in a country for selected years since 1950. Let x represent years since 1900. Find a logarithmic regression model (y = a + b In x) for the yield. Estimate the yield in 2029. The regression model is y=+()Inx. (Round to one decimal place as needed.) ~ Year 1950 1960 1970 1980 1990 2000 2010 X Yield 50 60 70 80 90 100 110 41 54 85 96 110 146 158arrow_forwardYou are using exponential smoothing to forecast demand. For September, suppose you forecasted 165 units and actually sold 178 units. If you use an alpha value of 0.2. what will be the exponential smoothing forecast for October?arrow_forward
- Using the trend adjusted projected method and given the following S15-0.991 T15x 115=5.33+(0.01387)t The forecast demand for period 15?arrow_forwardA firm experienced the demand shown in the following table. Fill in the table by preparing forecasts based on a five-year moving average, a three-year moving average, and exponential smoothing (w = 0.9 and w=0.3). (Note: The exponential smoothing forecasts may be begun by assuming Ŷ+1=Y₁-) Moving Average Exponential Smoothing Year Actual Demand (5-year) (3-year) (W = 0.9) (W = 0.3) 2000 900 2001 885 2002 875 2003 870 2004 870 2005 875 2006 885 2007 900 2008 920 2009 945 44.4444 2010 The following table shows the square errors, (Y-1), for forecasts from 2005 through 2009. Fill the table by calculating the root mean square error (RMSE) for each of the methods. Square Error Moving Average Exponential Smoothing Year (5-year) (3-year) (W = 0.9) (W = 0.3) 2005 25 9 25 25 2006 100 169 100 36 2007 625 529 256 361 2008 1,600 1,089 484 1,089 2009 3,025 1,849 729 2,304 RMSE Based on the RMSE criterion, which of the forecasting methods is the most accurate? Exponential smoothing (w = 0.9) ○…arrow_forwardConsider the following OLS regression results, In(y)-1.79+0.62ln(x), R² -0.26. A three percent increase in x is associated with an approximate percent increase in y (round to one decimal place).arrow_forward
- A researcher has a sample of 6 annual observations {94, 104, 102, 99, 111 and 107} for the CPI in country Z for the period 2015 to 2020, and wants to forecast CPI for the years 2021, 2022 and 2023. The researcher uses 3 different forecasting models: A, B and C. Model A is an AR(1) model with no drift and with an estimated autoregressive coefficient = 0.7. Model B is a MA(1) model with no constant and with an estimated MA coefficient = -0.4 (note the minus !). Model C is a random walk model with no drift. The error terms over the 2015-2020 period were estimated to have the values: {3, -1, 2, 4, -3, 1}. a. Compute the 2021, 2022 and 2023 forecasted values for the consumer price index based on the three models. Show the formulas and the details of your calculations, and explain all the related symbols. b. Suppose that the actual values of the CPI over the 2021, 2022 and 2023 were {108, 114, 105}. Calculate the Root mean square error of the three model forecasts over the 2021-2023…arrow_forward1. Suppose that we are interested in measuring the relationship between hourly wage and output productivity in the U.S economy. Variables hrwage(t) and outphr(t) denote the average hourly wage and output productivity in the U.S economy for year t. We start by estimating the model specification shown in equation (1) below: log(hrwage) = Bo + B₁ log(outphre) + ut. where log(.) denotes the natural logarithm and ut is the error term. (a) Provide a brief interpretation of parameters 0 and 1 in (1).arrow_forwardQuestion 3 The number of tons of brake assemblies received at an auto parts distribution center last month was 625. The forecast tonnage was 650 for last month. The company uses a simple exponential smoothing model with a smoothing constant of 0.46 to develop its forecasts. What will be the company's forecast for the next month? Add your answerarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Managerial Economics: Applications, Strategies an...EconomicsISBN:9781305506381Author:James R. McGuigan, R. Charles Moyer, Frederick H.deB. HarrisPublisher:Cengage Learning
Managerial Economics: Applications, Strategies an...
Economics
ISBN:9781305506381
Author:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris
Publisher:Cengage Learning
Forecasting: Exponential Smoothing, MSE; Author: Joshua Emmanuel;https://www.youtube.com/watch?v=k_HN0wOKDd0;License: Standard Youtube License