Question

A firm has determined that its average level of sales (St) per week in thousands of...

A firm has determined that its average level of sales (St) per week in thousands of dollars during a given year depends on the previous year's level of sales (St–1), the previous year's level of advertising (At–1) per month in thousands of dollars, and the previous year's rate of annual industry growth (Gt-1) in percentage terms. In the previous period, the firm's average level of sales was $35 thousand, advertising was $5 thousand, and the rate of growth in the industry was 2 percent. The firm estimated the following econometric model:

St = 10 + 0.75St–1 + 0.55At–1 +2.00Gt–1

i. Forecast the level of sales in the current period.

ii. Calculate and interpret the firm’s sales elasticity with respect to the previous year’s level of rate of growth in the industry (Gt-1).

iii. Assume Moving Average method was also used to forecast sales for the current year. If the Moving Average method has a RMSE of 2.5 while the Econometric Model above has a RMSE of 2.0, which method is more accurate, and why?

Homework Answers

Answer #1

St = 10 + 0.75St–1 + 0.55At–1 +2.00Gt–1

i)

We have St-1=$35 (thousands)

At-1=$5 (thousands)

Gt-1=2

St=10+0.75*35+0.55*5+2*2=43

Forecast sale in current period is $43 thousand.

II)

Differentiate St with respect to Gt-1, we get

dSt/d(Gt-1)=2.0

Sale elasticity with respect to previous year growth level=[dSt/d(Gt-1)]*[(Gt-1)/St]=2*2/43=0.093

Absolute value of sale elasticity is 0.093. It is less than 1, we can say it inelastic in this range.

It means that sale in current period will increase by 0.093 percent for every 1% rise in growth level in previous level.

c)

Lower RSME means that predicted values are closer to the observed values. It means that Econometric model gives the close predictions in this case.

  

Know the answer?
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
Similar Questions
Suppose a company has the following sales for the last six months (January – June): Month...
Suppose a company has the following sales for the last six months (January – June): Month Period Sales January 1 16 February 2 25 March 3 20 April 4 20 May 5 31 June 6 35 July 7 26 August 8 (a) Use this information to answer the following 7 questions: 6.Using January through July values, develop a linear trend equation for this time series (to 4 decimals). Please write the equation in the proper form. 7.Using your answer from...
Suppose a company has the following sales for the last six months (January – June): Month...
Suppose a company has the following sales for the last six months (January – June): Month Period Sales January 1 16 February 2 25 March 3 20 April 4 20 May 5 31 June 6 35 July 7 26 August 8 (a) Use this information to answer the following 7 questions: ques 1 given the information above 1.Use exponential smoothing (a= 0.10) to forecast the sales for August (to 2 decimals). What is the value? 2. Compute the MSE for...
The Municipal Government has asked you to forecast the sales tax revenue it will collect in...
The Municipal Government has asked you to forecast the sales tax revenue it will collect in 2017, 2018 and 2019. Data on revenue in recent years is presented below. Year Q1 Q2 Q3 Q4 TOTAL 2012          695          788          809       1,302 $3,594 2013          896          941       1,018       1,677 $4,532 2014       1,037          929       1,353       2,090 $5,409 2015       1,067       1,081       1,574       2,143 $5,865 2016       1,147       1,161...
Estimating Share Value Using the DCF Model Following are the income statement and balance sheet for...
Estimating Share Value Using the DCF Model Following are the income statement and balance sheet for Texas Roadhouse for the year ended December 29, 2015. a. Assume the following forecasts for TXRH’s sales, NOPAT, and NOA for 2016 through 2019. Forecast the terminal period values assuming a 1% terminal period growth rate for all three model inputs: Sales, NOPAT, and NOA. Round your answers to the nearest dollar. Reported Forecast Horizon Terminal $ thousands 2015 2016 2017 2018 2019 Period...
Sales Budget Alger Inc. manufactures six models of leaf blowers and weed eaters. Alger's budgeting team...
Sales Budget Alger Inc. manufactures six models of leaf blowers and weed eaters. Alger's budgeting team is finalizing the sales budget for the coming year. Sales in units and dollars for last year follow: Product Number Sold Price ($) Revenue LB-1 14,700 32 $ 470,400 LB-2 18,000 20 360,000 WE-6 25,200 15 378,000 WE-7 16,200 10 162,000 WE-8 6,900 18 124,200 WE-9 4,000 22 88,000 Total $1,582,600 In looking over the previous year's sales figures, Alger's sales budgeting team recalled...
Problem 1: Auto sales at Carmen’s Chevrolet are shown below. Develop a 3-week moving average. Week...
Problem 1: Auto sales at Carmen’s Chevrolet are shown below. Develop a 3-week moving average. Week Auto Sales 1 8 2 10 3 9 4 11 5 10 6 13 7 - Problem 2: Carmen’s decides to forecast auto sales by weighting the three weeks as follows: Weights Applied Period 3 Last week 2 Two weeks ago 1 Three weeks ago 6 Total Problem 3: A firm uses simple exponential smoothing with to forecast demand. The forecast for the week...
Sales Budget Alger Inc. manufactures six models of leaf blowers and weed eaters. Alger's budgeting team...
Sales Budget Alger Inc. manufactures six models of leaf blowers and weed eaters. Alger's budgeting team is finalizing the sales budget for the coming year. Sales in units and dollars for last year follow: Product Number Sold Price ($) Revenue LB-1 14,700 32 $ 470,400 LB-2 18,000 20 360,000 WE-6 25,200 15 378,000 WE-7 16,200 10 162,000 WE-8 6,900 18 124,200 WE-9 4,000 22 88,000 Total $1,582,600 In looking over the previous year's sales figures, Alger's sales budgeting team recalled...
Question text Estimating Share Value Using the DCF Model Following are the income statement and balance...
Question text Estimating Share Value Using the DCF Model Following are the income statement and balance sheet for Texas Roadhouse for the year ended December 29, 2015. a. Assume the following forecasts for TXRH’s sales, NOPAT, and NOA for 2016 through 2019. Forecast the terminal period values assuming a 1% terminal period growth rate for all three model inputs: Sales, NOPAT, and NOA. Round your answers to the nearest dollar. Reported Forecast Horizon Terminal $ thousands 2015 2016 2017 2018...
Derby Company has sales of $300,000 and profit margin of 9%. It pays $18,000 as dividends....
Derby Company has sales of $300,000 and profit margin of 9%. It pays $18,000 as dividends. Its assets total $200,000 and total equity is $120,000. Calculate its sustainable growth rate. A firm with annual sales of $450 million cut its average collection period from 60 days to 45 days. By how much is the accounts receivable balance change? Indicate decrease by negative and write answer in millions of dollars.
Alger Inc. manufactures six models of leaf blowers and weed eaters. Alger's budgeting team is finalizing...
Alger Inc. manufactures six models of leaf blowers and weed eaters. Alger's budgeting team is finalizing the sales budget for the coming year. Sales in units and dollars for last year follow: Product Number Sold Price ($) Revenue LB-1 14,700 32 $ 470,400 LB-2 18,000 20 360,000 WE-6 25,200 15 378,000 WE-7 16,200 10 162,000 WE-8 6,900 18 124,200 WE-9 4,000 22 88,000 Total $1,582,600 In looking over the previous year's sales figures, Alger's sales budgeting team recalled the following:...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT