Question: a. Develop a linear trend equation for the above data on demand for white bread loaves at a bakery fuse of Excers trendine, with displiry

a. Develop a linear trend equation for the above data on demand for white bread loaves at a bakery fuse of Excers trendine, with displiry Equation on chart eption, is recommended, and use is to forecast demand on day 16 . (Round the final answers to 2 decimal places. Forecast demsed on day 16 b. The variabans around the linear tiend the seem to have above- and below-the-4ine runs, Therefore, vive trend-adjusted exponantlal smoothing with =0.3 and =02 to model the bread demand Uso the tive four days to estimate the smoothed intial trend thet you use for periods 4 and 5 cuse the increase from day 1 to day 4 divided by 3 . Also, use A4 to estimate s4. Start forecanting day 5 . What is the forecast for day 16 ? (Round the final answers to 2 decimal places) \begin{tabular}{ll} 9 & 253 \\ 9 & 256 \\ 16 & 261 \\ 11 & 277 \\ 12 & 280 \\ 13 & 286 \\ 14 & 296 \\ 15 & 3a9 \\ \hline \end{tabular} a. Develop a thear trend equation for the obove data on demand for whise breadilowivs at a bekery (use-of Excers Trencline, with display Equation on chart option, is recommended), and use it to forccast demand on day 16 . (Round the final answers to 2 decima! places. Y= Forecast demand on dxy b. The varations around the linear trend line seem to hove above- and below-the-jine runs, Therefore, use trendidjusted exponential smoothing with =0.3 and =0.2 to modot the bread demand. Use the trist four days to estimate the smoothed initial trend that you use for periods 4 and 5 fuse the increase from dary 1 to day 4 divided by 3 . Aso, use A4 to estimate 54 - 5tart forecorting doy 5 . Whot is the forecast for day 16 ? (Round the finat answers to 2 decimat ptaces.) Forecast for doy 16
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
