**North Dakota Electric Company Demand Forecasting**The North Dakota Electric Company estimates its demand trend line (in millions of kilowatt hours) using the equation:\[ D = 77.0 + 0.43Q, \]where $ Q $ represents the sequential quarter number, starting with $ Q = 1 $ for the winter of Year 1. Additionally, the energy demand is adjusted using multiplicative seasonal factors as outlined in the table below:| Quarter | Factor (Index) ||---------|----------------|| Winter | 0.80 || Spring | 1.20 || Summer | 1.40 || Fall | 0.60 |**Energy Use Calculation for Year 26 (Quarters 101-104):**In Year 26, the energy use for each of the quarters, starting with winter, can be calculated. Please round your responses to one decimal place:| Quarter | Energy Use ||---------|------------|| Winter | || Spring | || Summer | || Fall | |Calculate the energy use by applying the seasonal factors to the demand trend line for each quarter.

The concept used here is forecasting using linear trends and seasonal relatives.

Answered: North Dakota Electric Company estimates…

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

For the Hawkins Company, the monthly percentages of all shipments received on time over the past 12 months are: Monthly Proportion of All Shipments Received On Time 80 81 85 83 84 86 85 85 82 81 85 84 Estimate the average of MSE of a three-month moving average and an exponential smoothingfor α = 0.3. Group of answer choices 1.24 2.4 3.56 4.25 4.58
The manager wants to forecast the month 6's sales using the following historical data: Months Month 1 Month 2 Month 3 Month 4 Month 5 Sales 20 25 32 35 38 Please use the weight 0.45 for Month 5, weight 0.25 for Month 4, weight 0.2 for Month 3, and weight 0.1 for Month 2 to use the weighted moving average to forecast the demand of Month 6. Month 5 = 0.1*(25) +0.2*(32) + .25* (35) divided by 0.1 +0.2 +1.25 -17.65/0.55 = 32.09 Month 6= 0.1* (25) +0.2* (32) +0.25 (35) +0.45* (38) divided by 0.1 +0.2+0.45 = 34.75
Miles Filtration, Inc. provides maintenance services for water filtration systems throughout Southern Florida. Customers contact Johnson with requests for maintenance service on their water filtration systems. To estimate service time and the service cost, Johnson’s managers want to predict the repair time necessary for each maintenance request. Hence, repair time in hours is the dependent variable. Repair time is believed to be related to three factors: the number of months since the last maintenance service, the type of repair problem (mechanical or electrical), and the repairperson who performs the repair (Donna Newton or Bob Jones). Data for a sample of 10 service calls are reported in the following table: Develop the multiple regression equation to predict repair time, given the number of months since the last maintenance service, the repairperson, and the type of repair. What are the interpretations of the estimated regression parameters? What does the coefficient of…
A company has observed the following demand during the past 10 months forone of its popular products. In ExcelMonth Demand1 602 803 404 805 1206 707 1108 1209 8010 100 a Plot these data on a graph. Do you observe any pattern such astrend, seasonal, cyclical, or random variations in the data? b Compute 3-month moving average forecasts from Month 4 to 11.Plot the forecast in the same graph that you generated in part a. c Compute forecasts from Months 4 to 11 using exponentialsmoothing. Assume that F4 = 80 and α = 0.2. Plot these forecasts on the samegraph that you generated in part b. d Compare the forecasts that you generated using MAD. Whichseems to be the superior forecasting technique?
A careful analysis of the cost of operating an automobile was conducted by accounting manager Dia Bandaly. The following model was developed: y = 3,600+ 0.16x, where y is the annual cost and x is the miles driven. a) If the car is driven 15,000 miles this year, the forecasted cost of operating this automobile = $ b) If the car is driven 26,000 miles this year, the forecasted cost of operating this automobile = $ (enter your response as a whole number). (enter your response as a whole number).
George has forecasted that annual demand for his sailboats in year 5 will equal 6,000 sailboats Based on the given data and using the multiplicative seasonal model, the demand level for George's sailboats in the spring of year 5 will be nothing sailboats (enter a whole number). 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.
George Kyparisis owns a company that manufactures sailboats. Actual demand for George's sailboats during each of the past four seasons was as follows: Year D 2 1,240 1,440 2,140 770 George has forecasted that annual demand for his sailboats in year 5 will equal 6,000 sailboats. Based on the given data and using the seasonal model, the demand level for George's sailboats in the spring of year 5 will be a whole number and round all intermediate calculations to two decimal places). Season Winter Spring Summer Fall 1 1,440 1,560 1,040 680 3 1,080 1,620 2,040 650 4 960 1,540 1,960 500 sailboats (enter your final answer as
N
A company wants to forecast demand using the weighted moving average. If the company uses three prior yearly sales values (i.e., the year 2014 = 155, the year 2015 = 140 and year 2016 = 170), and we want to weight the year 2014 at 30%, the year 2015 at 35% and year 2016 at 40%, which of the following is the weighted moving average forecast for the year 2017? 170 158 O 164 O 160
The actual number of patients at Providence Emergency Medical Clinic for the first six weeks of this year follows: Week Actual No. of Patients 1 65 68 77 59 66 75 23456 2 5 6 Clinic administrator Dana Schniederjans wants you to forecast patient numbers at the clinic for week 7 by using this data. You decide to use a weighted moving average method to find this forecast. Your method uses four actual demand levels, with weights of 0.500 on the present period, 0.250 one period ago, 0.125 two periods ago, and 0.125 three periods ago. a) What is the value of your forecast? The value of the forecast is patients (round your response to two decimal places). b) If instead the weights were 40, 20, 10, and 10, respectively, how would the forecast change? OA. The value of the forecast will decrease. B. The value of the forecast will remain the same. C. The value of the forecast will increase. c) What if the weights were 0.40, 0.30, 0.20, and 0.10, respectively? Now what is the forecast for week 7?…
Harlen Industries has a simple forecasting model: Take the actual demand for the same month last year and divide that by the number of fractional weeks in that month. This gives the average weekly demand for that month. This weekly average is used as the weekly forecast for the same month this year. This technique was used to forecast eight weeks for this year, which are shown in the following tables along with the actual demand that occurred. The following eight weeks show the forecast (based on last year) and the demand that actually occurred (picture attached): Calculate the MAD and tracking signal for each week.
The quarterly demand for smartphones at a retailer is as show. Year Quarter Demand 1 I 513 1 II 932 1 III 1509 1 IV 1902 2 I 693 2 II 1163 2 III 1857 2 IV 2469 Forecast the quarter 1 demand for year 3 using the following models: 4-quarter simple moving average. Simple exponential smoothing with α = 0.1. We assume that the forecasted value of quarter 1 is 500. Which method is the most accurate and why?

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