Unit 3 - Solve the following problems *** this is an individual LA*** 1. Weekly sales of ten-grain bread at the local organic food market are in the table below. Based on this data, forecast week 9 using a five-week moving average. Week Sales 1 415 2. 389 3 3 420 382 5 410 6 432 7 405 8 421 2. Given an actual demand of 61, a previous forecast of 58, and an alpha of 3, what would the forecast for the next period be using simple exponential smoothing? 2. Given an actual demand of 61, a previous forecast of 58, and an alpha of.3, what would the forecast for the next period be using simple exponential smoothing? 3. Marie Bain is the production manager at a company that manufactures hot water heaters. Marie needs a demand forecast for the next few years to help decide whether to add new production capacity. The company's sales history (in thousands of units) is shown in the table below. Use exponential smoothing with trend adjustment, to forecast demand for period 6. The initial forecast for period 1 was 11 units; the initial estimate of trend was 0. The smoothing constants are a = 3 and B = 3. Period Actual 1 12 N 15 Period Actual 1 12 N 15 3 3 16 st 16 5 18 6 20 4. An innovative restaurateur owns and operates a dozen "Ultimate Low-Carb" restaurants in Ontario. His signature item is a cheese-encrusted beef medallion wrapped in lettuce. Sales (X, in millions of dollars) is related to profits (Y, in hundreds of thousands of dollars) by the regression equation Y = 8.21 +0.76X. What is your forecast of profit for a store with sales of $40 million? $50 million? 1 12 2. 15 3 16 4 16 5 5 18 6 20 4. An innovative restaurateur owns and operates a dozen "Ultimate Low-Carb" restaurants in Ontario. His signature item is a cheese-encrusted beef medallion wrapped in lettuce. Sales (X, in millions of dollars) is related to profits (Y, in hundreds of thousands of dollars) by the regression equation Y = 8.21 +0.76 X. What is your forecast of profit for a store with sales of $40 million? $50 million? Submit your individual assignments to Moodle before