The following table shows the actual demand observed over the last 11 years:Year1Demand 82935This exercise contains only parts b, c, and d.b) Using the 3-year moving average, provide the forecast from periods 4 through 12 (round your responses to one decimal place).YearForecast45410651376787119814109811101312118

Planning and inventory are used in management and production using forecasting to determine how many…

Answered: The following table shows the actual…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Sales of tablet computers at Ted Glickman's electronicsstore in Washington, D.C., over the past 10 weeks are shownin the ta ble below: a) Forecast demand for each week, including week 10, usingexponential smoothing with a = .5 (in itial forecast = 20).b) Compute the MAD.c) Compute the tracking signal.
Given: Year Demand 1 7 2 9 3 5 4 9 5 Predict the value for Year 5: 2 year moving average What is MSE for 2 year moving average? 2 year moving average using 0.6 (weight for the oldest period) and 0.4(weight for most recent period Exponential smoothing, =0.2 and forecast for Year 1 = 5 Linear trend Which forecast method has the least amount of error using MAD? What is the coefficient?
6. Consider the following data table. (12 Points) a) Forecast demand using exponential smoothing with an apha of 0.25, and an initial forecast of 128.0 for period 1. b) Calculate the MAD and MSE. Period Real demand 130 138 129 140 3 4 5 133
UltraPure used two different techniques (F1 and F2) to forecast demand for cases of bottled water. Actual demand and the two sets of forecasts are in the table below. PREDICTED DEMAND Period Demand F1 F2 1 68 67 60 2 75 67 67 3 70 71 70 4 74 69 72 5 69 71 77 6 72 70 77 7 80 72 75 8 78 75 83 a. Compute MAD for each set of forecasts. Given your results, which forecast appears to be more accurate? (Round your answers to 2 decimal places.)
A plumbing repair company has 3 employees and must choose which of 3 jobs to assign each to (each employee is assigned to exactly one job and each job must have someone assigned). Each employee can perform each job, but the cost to perform any given job can vary. The following table shows the cost for each employee to perform each job. Employee A Employee B Employee C Job 1 48 45 44 Job 2 43 35 45 Job 3 51 51 50 Solve this assignment problem in Excel to find the lowest cost solution and answer the following questions: Which employee is assigned to job 1? (Click to select) Employee A Employee B Employee C Which employee is assigned to job 2? (Click to select) Employee A Employee B Employee C Which employee is assigned to job 3? (Click to select) Employee A Employee B Employee C What is the minimum cost to complete all three jobs?
Given the following original forecast and actual data: Month Actual Forecast Jan 600 Feb 475 Mar 550 Apr 575 May 643 Jun 662 Jul ??? ??? Using a 2 month weighted moving average with weights of 75% for the previous month and 25% for two months back, what is the forecast for July. Round your answer to 1 decimal place. 400 -- —— ——
pls help
Given the following original forecast and actual data: Month Actual Forecast Jan 600 Feb 475 Mar 550 Apr 575 May 643 Jun 662 Jul ??? ??? Using a 2 month weighted moving average with weights of 75% for the previous month and 25% for two months back, what is the forecast for July. Round your answer to 1 decimal place. 400 -- —— ——
Cadbury started an in-depth study to forecast customer demand based on data it previously recorded. Management at the global brand started recording sales data in two forms: yearly, & quarterly. The following tables show the recorded data for the past five years: Year Actual Demand 2017 128 2018 148 2019 161 2020 149 2021 137 Quarter 2017 2018 2019 2020 2021 1 30 39 42 36 33 2 42 41 47 34 45 31 33 41 42 31 25 35 31 37 28 The forecasted demand for the 2nd Quarter of year 2022 is * 18.25 43.45 25.18 目目
Problem 5 You are trying to determine what forecast method to use. Based upon the following historical data, calculate the following forecast and specify what procedure you would utilize. MAY JUNE MONTH JANUARY FEBRUARY MARCH APRIL DEMAND 62 65 67 68 71 73 MONTH JULY AUGUST SEPTEMBER OCTOBER NOVEMBER DECEMBER DEMAND 76 78 78 80 84 85 a. Calculate the simple three-month moving average for periods 4 to 12. b. Calculate the weighted three-month moving average for periods 4 to 12. Use weights of 0.50, 0.30, and 0.20 for the most recent, second most recent, and third most recent periods, respectively. c. Calculate the single exponential smoothing forecast for periods 2 to 12 using an initial forecast (F₁) of 61 and a of 0.30. d. Calculate the exponential smoothing with trend component forecast for periods 2 to 12 using an initial trend forecast (T₁) of 1.8, and initial exponential smoothing forecast (F₁) of 60, an a of 0.30 and ō of 0.30. e. Calculate the MAD for the forecasts made by each…
Historical sales data is shown below. Week Actual Forecast 1 328 300 2 272 3 245 4 223 5 205 6 Using alpha (α) = 0.2, what is the exponential smoothing forecast for period 6? Note: Round your answer to 2 decimal places. Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
ABC Inc. sells patio sets. Monthly sales for a seven-month period were as follows: Month Sales (000) Unites Feb 19 Mar 18 Apr 15 May 20 Jun 18 Jul 22 Aug 20 Forecast September sales volume using a weighted average approach using 0.60 for August, 0.30 for July, and 0.10 for June.

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS