Demand history for the past three years is shown below.QuarterQ1Q2Q3Q4Q1Q2Q3Q4Q1Q2Q3Q4YearDemand185217Year 1310251194196Year 2320301189207Year 3330256Round your answer to three decimal places.What is the seasonal index for Q1?

A seasonal index is an index value assigned to each period of the time series within a year that…

Answered: Demand history for the past three years…

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

Needs all
Prepare a graph of the monthly forecasts and average forecast demand for Chicago Paint Corp., a manufacturer of specialized paint for artists. Compute the demand per day for each month (round your responses to one decimal place). Month January February March April May June July August September October November December Choose the correct graph of the forecast demands below. OA Production Days 2222222222 23 19 20 21 20 23 21 20 19 Demand Forecast 950 1,050 1,250 1,350 1,300 1,300 1,250 1,150 1,050 1,000 1,000 950 Demand per Day 325
1. Lenovo uses the ZX-81 chip in some of its laptop computers. The prices for the chip during the last 4 months were as follows: Month Price Per Chip January $1.80 February $1.67 March $1.70 April $1.85 a) Using a 2-month moving average, calculate the forecast for March and April (round your responses to two decimal places). Month Mar Apr Forecast $enter your response here $enter your response here
Assume the weight is 0.6 for the most recent period; 0.2 for the second most recent; 0.1 for the third most recent; and 0.1 for the fourth most recent period. Using the four-period weighted moving average technique to predict the demand in February 2019. Find the X and Y values. Dt Ft Period Demand Four-period weighted Moving Average 2014 September 9400 October 10300 November 11200 December 4998 2015 January 9800 7209 February 9555 X March 9800 Y Group of answer choices X = 9899.8; Y = 9778.2 X = 9312.8; Y = 9555.2 X = 9029.6; Y = 9312.8 X = 9555.0; Y = 9313.7 X = 9872.4; Y = 9029.4
For the data below, answer the following four questions: Period Demand 1 58 2 59 3 60 4 61 What would be the simple moving average forecast for the 5th period? 68.2 58 60.7 59.5 61
The number of internal disk drives (in millions) made at a plant in Taiwan during the past 5 years follows: F Year 4 Disk Drives 142 164 196 204 216 B a) Using simple linear regression, the forecast for the number of disk drives to be made next year-isk drives (round your response to one decimal place)
Plot these forecasts AND the original demand data on graph paper or spreadsheet. Use a key to distinguish among your three lines. Please use the graph in the attached picture for the answer.
The following shows five months forecast demand and the corresponding actual demand for certain product.
I posted this question and it's been 18 hours that it still hasn't been answered. I only need the last two questions please (:
i need the answer quickly
Exercise 1: You are the operations manager at the company Servicios de Salud, Inc., which provides care services to the elderly. An important aspect of your job is ensuring that nursing homes have a healthy inventory of nutritional drinks for residents. Below is the historical demand for the product for one year: Month Historical demand (boxes) Forecasted demand (boxes) January 300 February 340 March 370 April 410 ¿? May 470 ¿? June 570 ¿? July 630 ¿? August 720 ¿? September 640 ¿? October 460 ¿? November 420 ¿? December 390 ¿? a. Calculate the average demand for each period from April to December using the 3-month simple moving average. Presents calculations and findings in a clear and organized manner. b. Discuss any trends or patterns observed in the calculated moving average demand values. c. Make an interpretation of the results and their implications for forecasting…
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.)

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

Demand history for the past three years is shown below. Year Quarter Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Demand 185 217 Year 1 310 251 194 196 Year 2 320 301 189 207 Year 3 330 256 Round your answer to three decimal places. What is the seasonal index for Q1?