Question: Following are the data on demand for white bread loaves at a bakery. Day Loaves 1 2 1 0 2 2 1 1 3 2
Following are the data on demand for white bread loaves at a bakery.
Day Loaves
a Develop a linear trend equation for the above data on demand for white bread loaves at a bakery use of Excels Trendline, with display Equation on chart option, is recommended and use it to forecast demand on day Round the final answers to decimal places.
Y
x
Forecast demand on day
b The variations around the linear trend line seem to have above and belowtheline runs. Therefore, use trendadjusted exponential smoothing with alpha and beta to model the bread demand. Use the first four days to estimate the smoothed initial trend that you use for periods and use the increase from day to day divided by Also, use A to estimate S Start forecasting day What is the forecast for day Round the final answers to decimal places.
Period TAFt
Forecast for day
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
