a Develop a linear trend equation for the following 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 16 b, The variations around the linear trend line seem to have above and below the line runs Therefore, use trend adjusted exponential smoothing with a 3 and Icirc sup2 2 to model the bread demand Use tire first four days to estimate the initial smoothed series (use the average of the first four days) and smoothed trend (use tire increase from day 1 to day 4 divided by 3) Start forecasting day 5 What is the forecast for day 16 Loats Da Loats Loafs 1 200 2214 3211 4 5 235 6 232 248 8 250 9 253 10 207 281 12275 13 280 288 15 310 228

Question: a. Develop a linear trend equation for the following data on demand for white bread loaves at a bakery (use of Excels Trendline, with display

a. Develop a linear trend equation for the following data on demand for white bread loaves at a bakery (use of Excel€™s Trendline, with display Equation on chart option, is recommended), and use it to forecast demand on day 16.

b, The variations around the linear trend line seem to have above- and below-the-line runs. Therefore, use trend-adjusted exponential smoothing with a = .3 and Î² = .2 to model the bread demand. Use tire first four days to estimate the initial smoothed series (use the average of the first four days) and smoothed trend (use tire increase from day 1 to day 4 divided by 3). Start forecasting day 5. What is the forecast for day 16?

Loats Da Loats Loafs 1 ...-200 2214 3211 4 5 .235 6 . 232 248 8 .. 250 9. 253 10 207 281 12275 13 . 280 288 15. 310 228

Step by Step Solution

★★★★★

3.34 Rating (169 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a Y 7x 19547 Forecasted demand for day 16 is Y 16 19547 ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

686-B-M-L-O-M (4660).docx

120 KBs Word File

Students Have Also Explored These Related Management Leadership Questions!

a. Obtain the linear trend equation for the following data on new checking accounts at Fair Savings Bank and use it to predict expected new checking accounts for periods 16 through 19. b. Use...

A BMW car dealer in Sicilia, Italy, has the following monthly new car sales data for January through December 2014. The dealer believes that new car sales follow a monthly seasonal pattern and...

Develop a trend equation for the net sales ($ million) for Home Depot. Consider both a linear trend and a nonlinear trend. Which one would you select and why? Given the trend equation you selected,...

L04 7. a. Develop a linear trend equation for the following data on demand for white bread loaves at a bakery (use of Excel's Trendline, with display equation on chart option, is recommended), and...

Question 2: Demand Forecasting I [25] a. Develop a linear trend equation for the following data on demand for white bread loaves at a bakery and use it to forecast demand on day 16. Use Excel's...

a. Develop a linear trend equation for the following data on demand for white bread loaves at a bakery and use it to forecast demand on day 16. Use Excel's Trendline with display equation on chart...

7. a. Develop a linear trend equation for the following data on demand for white bread loaves at a bakery (use of Excel's Trendline, with display equation on chart option, is recommended), and use it...

a. Develop a linear trend equation for the following 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...

a . Develop a linear trend equation for the following data on demand for white bread loaves at a bakery ( use of Excel's Trendline, with Display Equation on Chart option, is recommended ) , and use...

a. Develop a linear trend equation for the above data on demand for white bread loaves at a bakery (use of Excel's Trendline, with display Equation on chart option, is recommended), and use it to...

Given an array array[], its starting position l and its ending position r. Sort the array using Bucket Sort algorithm. Input: N = 10 array[] = {10 9 7 8 6 2 4 3 5 1} Output: 1 2 3 4 5 6 7 8 9 10

a. On 12 January 2012, Eugene acquired a piece of land for RM2,000,000, paying stamp duty of RM30,000 and professional fees of RM20,000. On 1 March 2014, Eugene transferred the land to her husband,...

18. Define the following terms. a. Basic earnings per share. b. Potentially dilutive security. c. Diluted earnings per share. d. Complex capital structure. e. Potential ordinary shares.

Buster's draft financial statements for the year to 31 October 20X5 report a loss of $1,486. When he prepared the financial statements, Buster did not include an accrual of $1,625 and a prepayment of...

The following is a list of activities/work packages and their precedence and duration, for a new-plant start-up project. Draw the precedence network, calculate earliest and latest times, and...

At the top of the next page are the required activities of the fire protection bid package of the building project referred to in Problem 18, including their expected duration (in working days) and...

What effect would decreasing arrival and service variability have on the waiting line?

Claim: The mean pulse rate (in beats per minute) of adult males is equal to 69 bpm. For a random sample of 157 adult males, the mean pulse rate is 70.3 bpm and the standard deviation is 10.6 bpm....

A contractor estimates that maintenance on a new piece of equipment will be $275 for the first month and it will increase by 0.5% each month afterwards. However, the contractor is offered a service...

see image for questions This is a simplied example, but it represents a problem that comes up frequently: given a set of uncertain inputs and a limited budget, which of them matter enough to warrant...