Question

1. Exercise 5.1 The forecasting staff for the Prizer Corporation has developed a model to predict sales of its air-cushioned-ride snowmobiles. The model specifies that sales, S, vary jointly with disposable personal income, Y, and the population between ages 15 and 40,Z, and inversely with the price of the snowmobiles, P. Based on past data, the best estimate of this relationship is: where k has been estimated (from past data) to equal 100 If Y $13,000, Z- $1,200, and P $20,000, what value would you predict for S? $78,000 $74,286 $184,615 S91,000 If P is reduced to $17,500, S to Note: Assume Y and Z remain constant at $13,000 and S1.200, respectively) $161,538 Which of the following is a potential weaknes 1? $84,324 It uses time-series data $104,000 It does not account for seasonal $89,143 It assumes that price and sales are uuveisery Telated

Freds Hardware and Hobby House expects its sales to increase at a constant rate of 6 percent per year over the next three years. Current sales are $300,000 Complete the following table by forecasting sales for each of the next three years Forecasted Sales Year (Dollars) If sales in 2003 were $180,000 and they grew to S300,000 by 2007 (a four-year period), the actual annual compound growth rate was: 18.56% 13.62% 10.76% Which of the following are some of the hazards of employing a constant rate of growth forecasting model? Check all that apply. It is ill-suited to estimate secular trends It ignores seasonal trends. It assumes that there are no cyclical variations.

Year Forecast Actual 2007 2006 2005 2004 2003 2002 1,045 937 829 721 613 505 1,076 974 870 764 656 545 What seasonal adjustment factor would you recommend be used in making future June forecasts? -0.2% 2.7% 55%

Stowe Automotive is considering an offer from the country of Indula to build a plant making automotive parts for use there. In preparation for a final decision, Stowes economists have been hard at work constructing a basic econometric model for Indula to aid the company in predicting future levels of economic activity. Because of the cyclical nature of the automotive parts industry, forecasts of future economic activity are quite important in Stowes decision process. Corporate profits (Pfor all firms in Indula were about $110.00 billion. GDP for the nation is composed of consumption, C, investmentI, and government spending, G. It is anticipated that Induļas federal, state and local governments will spend in the range of $220 billion next year. On the basis of an analysis of recent economic activity in Indula, consumption expenditures are assumed to be $1540 billion plus 80% of national income. National income, Ý, s equal to GDPminus taxes xes aree timated Oheata ateoft ut i Finally, corporate investments have historically equaled S33 billion plus 90% of last years corporate profits P Construct a five-equation econometric model of the state of Induļa A Simple Model of the National Economy of Indula C+I+G GDP T GDP-

A 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 Y +1-Yt ) Moving Average Exponential Smoothing (W 0.9) (3-year) (W 0.3) Year Actual Demand(5-year) 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 1,500 1,545 1,585 1,620 1,650 1,675 1,695 1,710 1,720 1,725 The following table shows the square errors, (Y, - Yt. /), for forecasts from 2005 through 2009 Fill the table by calculating the root mean square error (RMSE) for each of the methods

Fill the table by calculating the root mean square error (RMSE) for each of the methods. Square Error Moving Average Exponential Smoothing Year 2005 2006 2007 2008 2009 RMSE (5-year) 9,025 6,400 4,225 2,500 1,225 (3-year) 3,249 2,209 1,369 729 289 (W- 0.9) 784 529 289 144 36 (W- 0.3) 7,569 6,561 5,184 3,600 2,209 Based on the RMSE criterion, which of the forecasting methods is the most accurate? Exponential smoothing (w -0.3) Five-year moving average Exponential smoothing (w -0.9) Three-year moving average

The Questor Corporation has experienced the following sales pattern over a 10-year period Complete the table using a first-order exponential smoothing model with a w = 09 to forecast sales in 2017. Sales (Y,) Exponential Smoothing (Yt) ear(000) 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 (w-0.9) 139 162 158 168 192 189 200 225 223 235 139

Bell Greenhouses has estimated its monthly demand for potting soil to be the following N-400 +9X where N is the monthly demand for bags of potting soil and X is the time period in months (March 2016 0) Assume this trend factor is expected to remain stable in the foreseeable future. The following table contains the monthly seasonal adjustment factors, which have been estimated using actual sales data from the past five years: Complete the following table by forecasting Bell Greenhouses demand for potting soil in March, June, August, and December 2017. Month March June August December Adjustment Factor (%) Forecast +15 +10 12 The following table shows the forecasted and actual potting soil sales by Bell Greenhouses for April in five different years YearForecast Actual 2017 2016 2015 2014 2013 517 409 301 193 85 538 442 310 207 87

Savings-Mart (a chain of discount department stores) sells patio and lawn furniture. Sales are seasonal, with higher sales during the spring and summer quarters and lower sales during the fall and winter quarters. The company developed the following quarterly sales forecasting model: Y, 6.00+0.600r -2.75Dl, +025D2, +3.5D where predicted sales (in in millions of dolars) in quarter 6.00quly sales (in millions of dollars) whent0 time period (quarter) where the fourth quarter of 2012 -0 first quarter of 2013-1, secon Di1 for first-quarter observations; 0 otherwise D21 for second-quarter observations; 0 otherwise Dit1 for third-quarter observations; 0otherwise Forecast Savings-Marts sales of patio and lawn furniture for each quarter of 2020 Sales Forecast Quarter 2020 First Quarter 2020 Second Quarter 2020 Third Quarter 2020 Fourth Quarter (Millions of dollars)

0 0
Add a comment Improve this question Transcribed image text
Answer #1

(Exercise 5.1 - Prizer)

(a) Predicted value of S = (100 x $13,000 x $1,200) / $20,000 = $78,000

(b) When P = $17,500, S increases to $89,143 [= (100 x $13,000 x $1,200) / $17,500].

(c) A potential weakness is that it does not account for seasonal changes.

NOTE: As HOMEWORKLIB Answering Policy, the 1st question has been answered.

Add a comment
Know the answer?
Add Answer to:
1. Exercise 5.1 The forecasting staff for the Prizer Corporation has developed a model to predict...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Masters Level work....all work must be shown. FORECASTING Forecasting ASSIgnment 1. Given the following data, use...

    Masters Level work....all work must be shown. FORECASTING Forecasting ASSIgnment 1. Given the following data, use a three-quarter moving average to forecast the demand for the third quarter of this year. Note, the first quarter is January, February, and March; the second quarter is April, May, and June; the third quarter is July, August, September, and the 4° quarter is October, November, and December ul ct 50 This year 235 245 255 295 305 295 Answer (Please show your work...

  • b-2. Using the MAD method of testing the forecasting model's performance, plus actual data from 3...

    b-2. Using the MAD method of testing the forecasting model's performance, plus actual data from 3 years ago through the second quarter of this year, how well did the model perform? Based on MAD, an a performs better than an a of (Click to select) c. Using the decomp (Click to select) 0.3 0.2 hod of forecasting, forecast earnings per share for the last two quarters of this year and all four quarters of next year. (Negative values should be...

  • TEST, I need Help A.S.A.P PLease!!! I need to submit this within the next hour and a half. It's...

    1. Regression is always a superior forecasting method to exponential smoothing, so regression should be used whenever the appropriate software is available. (Points :1)TrueFalse2. Time-series models rely on judgment in an attempt to incorporate qualitative or subjective factors into the forecasting model. (Points : 1)TrueFalse3. A trend-projection forecasting method is a causal forecasting method. (Points : 1)TrueFalse4. Qualitative models attempt to incorporate judgmental or subjective factors into the forecasting model. (Points : 1)TrueFalse5. The naive forecast for the next period...

  • Examples 1,2,3 1. Beyond Tea Inc. wants to forecast sales of its menthol green tea. The...

    Examples 1,2,3 1. Beyond Tea Inc. wants to forecast sales of its menthol green tea. The company is considering either using a simple mean or a three-period moving average to forecast monthly sales. Given sales data for the past 10 months use both forecasting methods to forecast periods 7 to 10 and then evaluate each. Which method should they use? Use the selected method to make a forecast for month 11. (Show all calculations .... Please read Examples1, 2, 3...

  • answer 1-3 please don't copy from previous post. good luck Problems #3, 5, 7 (P3) The...

    answer 1-3 please don't copy from previous post. good luck Problems #3, 5, 7 (P3) The owner of the Chocolate Outlet Store wants to forecast chocolate demand. Demand for the preceding four years is shown in the following table: Year Demand (Pounds) 1 68,800 2 71,000 3 75,500 4 71,200 Forecast demand for Year 5 using the following approaches: (1) a three-year moving average; (2) a three-year weighted moving average using .40 for Year 4, .20 for Year 3, and...

  • Year Poverty Rate 1986 10.9 1987 10.7 1988 10.4 1989 10.3 1990 10.7 1991 11.5 1992...

    Year Poverty Rate 1986 10.9 1987 10.7 1988 10.4 1989 10.3 1990 10.7 1991 11.5 1992 11.9 1993 12.3 1994 11.6 1995 10.8 1996 11 1997 10.3 1998 10 1999 9.3 2000 8.7 2001 9.2 2002 9.6 2003 10 2004 10.2 2005 9.9 2006 9.8 2007 9.8 2008 10.3 2009 11.1 According to the Census Bureau, the number of people below the poverty level has been steadily increasing (CNN, September 16, 2010). This means many families are finding themselves there...

  • A company presently has 3 warehouses, each carrying 3,500 units of inventory. With this strategy, the...

    A company presently has 3 warehouses, each carrying 3,500 units of inventory. With this strategy, the company is able to meet its demand at 2.5% stockout rate. The company decides to downsize and keep only 2 warehouses. How many units of inventory will the company need to carry at each of the two warehouses if it wants to continue a 2.5% stockout rate? Instead, the company decides to increase the number of warehouses to 4. How many units of inventory...

  • 1) A company has recorded the demand for a new type of tire for the last...

    1) A company has recorded the demand for a new type of tire for the last five months. Month 1 2 3 4 5 Demand ('00s) 14 17 19 23 24 a) Use a two month moving average to generate a forecast for demand in month 6. b) Apply exponential smoothing with a smoothing constant of 0.9 to generate a forecast for demand for demand in month 6. c) Which of these two forecasts do you prefer and why? 2)...

  • Forecasting Models. This is one problem that requires the use of Excel newly created, blank Excel...

    Forecasting Models. This is one problem that requires the use of Excel newly created, blank Excel file, with no use of copy and pasting anything into the spreadsheet or use any kind of a template. (a) Calculate the forecast of Jeannette's GPA for the fall semester of her senior year using a 3-period moving average. (b) Calculate the forecast of Jeannette's GPA for the fall semester of her senior year using a 3-period weighted moving average, with the weights 1,...

  • Paul has just completed an analysis into the sales of a computer game over the past...

    Paul has just completed an analysis into the sales of a computer game over the past 3 years and the result is shown in the table below (sales are in S 000s): Period Sales Period Sales Sales Year 2007 Year 2008 Year 2009 Period 1 40 38 38 a) b) c) Plot the series. From the raw data, calculate the centred moving averages and plot this on the graph. Comment on both series of data. Use the additive decomposition model...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT