Question

In: Economics

French Bread Chocolates developed the following quarterly sales forecasting model: Sales = 8.50 + 0.150 TIME...

French Bread Chocolates developed the following quarterly sales forecasting model:

Sales = 8.50 + 0.150 TIME - 2.70 Q1 + 1.20 Q2 + 3.5 Q3

where TIME is time period. (time is zero in the fourth quarter of 2009, time is 1 in the first quarter of 2010 and 2 in the second quarter of 2010 etc.) and Q1, Q2, and Q3 are quarterly dummy variables.

Forecast French Broad Chocolate's sales for each quarter of 2022.

Solutions

Expert Solution

Quarter Year Time
4 2009 0
1 2010 1
2 2010 2
3 2010 3
4 2010 4
1 2011 5
2 2011 6
3 2011 7
4 2011 8
1 2012 9
2 2012 10
3 2012 11
4 2012 12
1 2013 13
2 2013 14
3 2013 15
4 2013 16
1 2014 17
2 2014 18
3 2014 19
4 2014 20
1 2015 21
2 2015 22
3 2015 23
4 2015 24
1 2016 25
2 2016 26
3 2016 27
4 2016 28
1 2017 29
2 2017 30
3 2017 31
4 2017 32
1 2018 33
2 2018 34
3 2018 35
4 2018 36
1 2019 37
2 2019 38
3 2019 39
4 2019 40
1 2020 41
2 2020 42
3 2020 43
4 2020 44
1 2021 45
2 2021 46
3 2021 47
4 2021 48
1 2022 49
2 2022 50
3 2022 51
4 2022 52

Q1, Q2 and Q3 are quartely dummy variables.

When quarter is 1st, then Q1 = 1. Q2=Q3=0

When quarter is 2nd, then Q2 =1, Q1 = Q3 =0

When quarter is 3rd, then Q3=1, Q1=Q2 =0

When Quarter is 4th, then Q1=Q2 = Q3 = 0.

French Board Chocolate's sales for 1st quarter of 2022.

Sales = 8.50 + 0.150 TIME - 2.70 Q1 + 1.20 Q2 + 3.5 Q3

put TIME = 49, Q1 = 1, Q2 = Q3 =0

Sales = 8.50 + 0.150(49) - 2.70(1) + 1.20(0) + 3.5(0)

Sales = 8.50 + 7.35 - 2.70 + 0 + 0

Sales = 13.15

French Board Chocolate's sales for 2nd quarter of 2022.

Sales = 8.50 + 0.150 TIME - 2.70 Q1 + 1.20 Q2 + 3.5 Q3

put TIME = 50, Q2 = 1, Q1 = Q3 =0

Sales = 8.50 + 0.150(50) - 2.70(0) + 1.20(1) + 3.5(0)

Sales = 8.50 + 7.5 - 0 + 1.20 + 0

Sales = 17.2

French Board Chocolate's sales for 3rd quarter of 2022.

Sales = 8.50 + 0.150 TIME - 2.70 Q1 + 1.20 Q2 + 3.5 Q3

put TIME = 51, Q3 = 1, Q2 = Q1 =0

Sales = 8.50 + 0.150(51) - 2.70(0) + 1.20(0) + 3.5(1)

Sales = 8.50 + 7.65 - 0 + 0 + 3.5

Sales = 19.65

French Board Chocolate's sales for 4th quarter of 2022.

Sales = 8.50 + 0.150 TIME - 2.70 Q1 + 1.20 Q2 + 3.5 Q3

put TIME = 52, Q1 = Q2 = Q3 =0

Sales = 8.50 + 0.150(52) - 2.70(0) + 1.20(0) + 3.5(0)

Sales = 8.50 + 7.8 - 0 + 0 + 0

Sales = 16.3


Related Solutions

Consider the following quarterly time series. The regression model developed for this data set that has...
Consider the following quarterly time series. The regression model developed for this data set that has seasonality and trend is as follows, yˆt = 864.08 + 87.8Qtr1t + 137.98Qtr2t + 106.16Qtr3t + 28.16t Compute the quarterly forecasts for next year based on the regression model? Quarter Year 1 Year 2 Year 3 1 923 1112 1243 2 1056 1156 1301 3 1124 1124 1254 4 992 1078 1198
a. Fama and French (1993) developed a three-factor asset pricing model. What are the three risk...
a. Fama and French (1993) developed a three-factor asset pricing model. What are the three risk factors in the Fama and French three-factor model? (1.5 marks) b. What risks the three factors can capture? c. What stocks are described as “value” and “growth” stocks under theoretical framework of Fama and French (1993)? d. Carhart (1997) extended the Fama and French three-factor model to a four-factor model. What is the fourth factor added to the Fama and French three-factor model? What...
A time series model is a forecasting technique that attempts to predict the future values of...
A time series model is a forecasting technique that attempts to predict the future values of a variable by using only historical data on that one variable. Here are some examples of variables you can use to forecast. You may use a different source other than the ones listed (be sure to reference the website). There are many other variables you can use, as long as you have values that are recorded at successive intervals of time. Currency price GNP...
Below you are given the first five values of a quarterly time series of sales. Year...
Below you are given the first five values of a quarterly time series of sales. Year Quarter Time Series Value Yt 1 1 36 2 24 3 16 4 20 2 1 44 21. Refer to data above. When a naïve method is used, what is the forecast on the sales in Quarter 2 of Year 2. a. 20 b. 44 c. 27 d. 30 22. Refer to data in Q21. When a three-quarter moving average is used, what is...
Adams Manufacturing Company established the following standard price and cost data: Sales price $ 8.50 per...
Adams Manufacturing Company established the following standard price and cost data: Sales price $ 8.50 per unit Variable manufacturing cost $ 3.70 per unit Fixed manufacturing cost $ 2,800 total Fixed selling and administrative cost $ 600 total Adams planned to produce and sell 2,200 units. Actual production and sales amounted to 2,400 units. Assume that the actual sales price is $8.15 per unit and that the actual variable cost is $3.95 per unit. The actual fixed manufacturing cost is...
Polished Marketing. is forecasting that next year’s sales of Happy-Time Vitamins will decline from $122 million...
Polished Marketing. is forecasting that next year’s sales of Happy-Time Vitamins will decline from $122 million to $106 million. Polished Marketing estimates that cash requirements will be 1% of sales, inventory will be 10% of sales, receivables will be 7% of sales, and payables will be 8% of sales. Depreciation is expected to be 8% of sales, and the tax rate is 35%. How will next year’s net working capital requirement be affected?
Forecasting with the Parsimonious Method and Estimating Share Value Using the DCF Model Following are the...
Forecasting with the Parsimonious Method and Estimating Share Value Using the DCF Model Following are the income statement and balance sheet for Cisco Sytems for the year ended July 30, 2016. Cisco Sytems Consolidated Statements of Income Years Ended December ($ millions) July 30, 2016 July 25, 2015 Revenue Product $37,254 $37,750 Service 11,993 11,411 Total revenue 49,247 49,161 Cost of sales Product 14,161 15,377 Service 4,126 4,103 Total cost of sales 18,287 19,480 Gross margin 30,960 29,681 Operating expenses...
Which of the following considerations is a factor in deciding which forecasting model a firm should...
Which of the following considerations is a factor in deciding which forecasting model a firm should choose? Question 3 options: Accuracy required All of the above Analyst availability Data availability Time horizon to forecast
A computer manufacturer has developed a regression model relating his sales (Y in $10,000s) with three...
A computer manufacturer has developed a regression model relating his sales (Y in $10,000s) with three independent variables. The three independent variables are price per unit (Price in $100s), advertising (ADV in $1,000s) and the number of product lines (Lines). Part of the regression results is shown below. Coefficient Standard Error Intercept 1.0211 22.8752 Price -0.1524 0.1411 ADV 0.8849 0.2886 Lines -0.1463 1.5340 Analysis of Variance Source of Variation Degrees of Freedom Sum of Squares Regression 2708.61 Error (Residuals) Required:...
A computer manufacturer has developed a regression model relating his sales (Y in $10,000s) with three...
A computer manufacturer has developed a regression model relating his sales (Y in $10,000s) with three independent variables. The three independent variables are price per unit (Price in $100s), advertising (ADV in $1,000s) and the number of product lines (Lines). Part of the regression results is shown below. Coefficient Standard Error Intercept 1.0211 22.8752 Price -0.1524 0.1411 ADV 0.8849 0.2886 Lines -0.1463 1.5340 Analysis of Variance Source of Variation Degrees of Freedom Sum of Squares Regression 2708.61 Error (Residuals) Required:...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT