Passenger miles flown on Northeast Airlines, a commuter firm serving the Boston hub, are shown for the past 12 weeks:2 321 19Week1Actual Passenger Miles (in thousands) 17WeekForecasted Passenger Miles(in thousands)a) Assuming an initial forecast for week 1 of 17,000 miles, use exponential smoothing to compute miles for weeks 2 through 12. Use α = 0.2 (round your responsesto two decimal places).10114 5 6 7 8 923 18 16 20 18 22 20 1521346717.00 17.00 17.80 18.04 19.03 18.83 18.265818.61918.49 19.191012221112

Ans) We will use alpha = 0.2 with initial forecast = 17000 miles or 17 ( in 1000's)

Answered: Passenger miles flown on Northeast…

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

The sale data is shown as follows: Month 1: 11 Month 2: 52 Month 3: 95 Using Weighted Simple Moving Average method (Month 1: 0.2; Month 2: 0.3; Month 3: 0.5) to forecast the sales of Month 4: ________ (Round your answer to the nearest integer)
Provide instead: 3 Positive and 3 negative outcomes for forecasting 3 Positive and 3 negative outcomes for queuing model
Problem 3-31 (Algo) The following are sales revenues for a large utility company for years 1 through 11. Forecast revenue for years 12 through 15. Because we are forecasting four years into the future, you will need to use linear regression as your forecasting method. (Enter your answers In mlons.) YEAR REVENJE (MILLIONS) $4,875.0 5,865.7 5,523.4 5,729.9 5,500.9 5,190.0 $5,097.2 5,112.3 5,553.8 5,734.4 5,863.5 1 2 10 11 Period Forecast 12 13 14 15
Given the following forecast and steady regular output of 550 every month, what total cost would result if overtime is limited to a maximum of 40 units a month, and subcontracting is limited to a maximum of 10 units a month? Unit costs are: Regular output $20 Overtime $30 Subcontract $25 Average Inventory $10 Backlog $18 Month 1 2 3 4 5 6 Forecast 540 540 570 590 650 680
Figure shows summer air visibility measurements for Denver, Colorado. The acceptable visibility standard is 100, with readings above 100 indicating clean air and good visibility, and readings below 100 indicating temperature inversions caused by forest fires, volcanic eruptions, or collisions with comets.a. Is a trend evident in the data? Which time-series techniques might be appropriate for estimating the average of these data?b. A medical center for asthma and respiratory diseases located in Denver has great demand for its services when air quality is poor. If you were in charge of developing a short-term (say, 3-day) forecast of visibility, which causal factor(s) would you analyze? In other words, which external factors hold the potential to significantly affect visibility in the short term?c. Tourism, an important factor in Denver’s economy, is affected by the city’s image. Air quality, as measured by visibility, affects the city’s image. If you were responsible for development of…
5
What is the fundamental distinction between a weighted average travelling and exponential smoothing?
Using the table, what is the paid occupancy percentage for the month? Month November Rooms in 300 Hotel Paid Rooms 5,497 Occupied 5,697 Rooms Paid Guests 5,948 Total Hotel $2,157,893 Revenue 63.30% 61.08% 59.11% 61.26%
1
Please simply fill out the chart
10.3. The Ashton Furniture Company manufactures coffee tables and chests of drawers. Last year the company’s cost of goods sold was $3,700,000, and it carried inventory of oak, pine, stains, joiners, and brass fixtures, work-in-process of furniture frames, drawers and wood panels, and finished chests and coffee tables. Its average inventory levels for a 52-week business year were as follows: Raw Materials Average Inventory Unit Cost Oak 8000 $6.00 Pine 4500 4.00Brass fixtures 1200 8.00Stains 3000 2.00Joiners 900 1.00 Work-in-Process Frames 200 $30Drawers 400 10Panels 600 50Chests…
Forecasting and Demand Management process in a mining industry

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

Passenger miles flown on Northeast Airlines, a commuter firm serving the Boston hub, are shown for the past 12 weeks: 2 3 21 19 4 5 6 23 18 Week Actual Passenger Miles (in thousands) 1 17 7 16 20 8 18 9 22 10 20 11 12 15 22