Using the factory energy cost data in the table below, find the best moving average and...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Using the factory energy cost data in the table below, find the best moving average and exponential smoothing models. Year 1 2 3 4 5 6 7 8 9 10 11 12 Energy Costs 15,349.04 15,416.94 15,928.82 16,611.47 16,916.86 16,830.85 16,812.27 17,103.12 16,852.33 17,839.58 18,187.11 18,776.38 18,870.58 18,911.72 19,324.33 Find the best number of years to use in a moving average forecast based on MSE. Do not round intermediate calculations. Round your answers to two decimal places. 13 14 15 Number of years 2 3 4 MSE The -Select- model is better. Find the best single exponential smoothing model by evaluating the MSE from 0.1 to 0.9, in increments of 0.1. Do not round intermediate calculations. Round your answers to two decimal places. Alpha 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 MSE The model based on a smoothing constant of -Select- is the best. Compare the forecasting ability of the best moving average and single exponential smoothing models with a regression model. The regression equation is Y = 15,085.93 + 278.69(Year) with MSE = 93,860.98. Which model would you choose based on MSE? The -Select- model should be chosen. Using the factory energy cost data in the table below, find the best moving average and exponential smoothing models. Year 1 2 3 4 5 6 7 8 9 10 11 12 Energy Costs 15,349.04 15,416.94 15,928.82 16,611.47 16,916.86 16,830.85 16,812.27 17,103.12 16,852.33 17,839.58 18,187.11 18,776.38 18,870.58 18,911.72 19,324.33 Find the best number of years to use in a moving average forecast based on MSE. Do not round intermediate calculations. Round your answers to two decimal places. 13 14 15 Number of years 2 3 4 MSE The -Select- model is better. Find the best single exponential smoothing model by evaluating the MSE from 0.1 to 0.9, in increments of 0.1. Do not round intermediate calculations. Round your answers to two decimal places. Alpha 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 MSE The model based on a smoothing constant of -Select- is the best. Compare the forecasting ability of the best moving average and single exponential smoothing models with a regression model. The regression equation is Y = 15,085.93 + 278.69(Year) with MSE = 93,860.98. Which model would you choose based on MSE? The -Select- model should be chosen.
Expert Answer:
Related Book For
OM operations management
ISBN: 978-1285451374
5th edition
Authors: David Alan Collier, James R. Evans
Posted Date:
Students also viewed these general management questions
-
If the focal length of a lens is 3 centimeters and the image distance is 5 centimeters from the lens, what is the distance from the object to the lens?
-
Lillian Jordon is considering using some of the cash generated from her mail-order business to open a retail store. The fixed investment in the store is expected to be $3.5 million. The investment...
-
A manufacturer purchases a part for use at both of its plants-one at Roseville, California, the other at Akron, Ohio. The part is available in limited quantities from two suppliers. Each supplier has...
-
Which of the following statements about an acquiescence is correct? a. Acquiescences are published only for certain regular decisions of the U.S. Tax Court. b. The IRS does not issue acquiescences to...
-
Find the minimum and maximum deflection angles for a light ray passing through a glass prism with refracting angle = 60.
-
Write the symbols for the probability that a player is a great hitter, given that the player is an infielder. On a baseball team, there are infielders and outfielders. Some players are great hitters,...
-
For testing H0 : 1 = 2 versus H1: 1 2, we observe s1 = 9.3, s2 = 2.1, n1 = 6, and n2 = 13. Test at the significance level = 0.05. a. Find the critical value. b. Do you reject H0?
-
Why are value-added activities defined from a customer viewpoint?
-
10. You own $1,000,000 principal value of a bond. The average one-day change in the price of the bond +0.3% of price (i.e. 0.003). The standard deviation of one-day 0.5% of price (i.e. 0.005). (6...
-
Create a concept map that depicts your assumptions and findings of the theory-practice gap. You are a staff nurse working in an intensive care unit and assigned to care for a 75-year-old African...
-
A pen stand made of wood is in the shape of a cuboid with four conical depressions to hold pens. The dimensions of the cuboids are 15 cm by 10 cm by 3.5 cm. The radius of each of the depressions is...
-
4. A projectile is fired at an angle from the top of a cliff as shown in the diagram below. A graph is created of the projectile's vertical motion while it is in the air and is shown here. a. (2) Use...
-
Steve invests in a circus production. The cost includes an overhead of $36,000, plus production costs of $5000 per performance. A sold-out performance brings in $8000. Let x represent the number of...
-
chidrens tickets are $20.00 adult tickets are $43.00 attendance was 1,100 profit was $35,800 how many chidren and how many adults
-
Analyze output. What do the measures tell you? Is your data skewed? Does it exhibit kurtosis? What is the interquartile range? What insights about the data you have chosen do you derive from this...
-
A lunch menu consists of 4 different kinds of sandwiches, 5 different kinds of soup, and 3 different drinks. How many choices are there of ordering a sandwich, soup and drink?
-
Complete the following requirements for the given information: Define decision variable. must include unit size and time frame develop the objective function find the constraints use excel silver...
-
What is the difference between adsorption and absorption?
-
Discuss some forecasting issues that you encounter in your daily life. How do you make your forecasts?
-
Refer to Exhibit 7.7 and recomputed the total value-added and non-value-added time and cost given the following new information. If a restaurant uses iPads to place orders and notify waiters when the...
-
Research radio frequency identification devices (RFID) and provide examples of how they are or might be used to improve productivity in operations.
-
Using Program14.m(fourth-order Runge-Kutta method), solve Problem 11.18 with \(c=1\). Data From Problem 11.18:- Using the central difference method, find the response of the two-degree-of-freedom...
-
Using Program15.m (central difference method), solve Problem 11.20. Data From Problem 11.20:- The equations of motion of a two-degree-of-freedom system are given by \(2 \ddot{x}_{1}+6 x_{1}-2...
-
Using Program16.m(Houbolt method), solve Problem 11.20. Data From Problem 11.20:- The equations of motion of a two-degree-of-freedom system are given by \(2 \ddot{x}_{1}+6 x_{1}-2 x_{2}=5\) and...
Study smarter with the SolutionInn App