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...
-
What is a temporary difference? Give two examples.
-
The adjusted trial balance for Marine Fishing Centre is as follows: Instructions a. Prepare an income statement for the year ended March 31, 2024. b. Prepare a statement of owners equity. The owner,...
-
Bernardino Santos-Rodiguez was piloting a boat owned by his friend, Raul Viera-Torres, in waters near Guayama, Puerto Rico. The boat was equipped with a hydraulic steering system manufactured by...
-
Elvira Industries had the following transactions. 1. Borrowed $5,000 from the bank by signing a note. 2. Paid $2,500 cash for a computer. 3. Purchased $450 of supplies on account. Instructions (a)...
-
Contemporary psychoanalysis has undergone a paradigm shift from drive reduction to the relational model. The most fundamental difference between relational and classical forms of psychoanalysis is...
-
Questions : How can you provide Acme with more space in their facility to accommodate growth in the short term? 2. From an operational aspect how can Acme overcome the issues of lost online sales to...
-
Axe applies overhead to production at a predetermined rate equal to 80 of direct labour cost Job No 9, the only job still in process at the end of May, has been charged with direct labour of $1,000....
-
Hamdellah earned $1,000 on an investment she held for 2 years at 6.5% p.a. What was the principal amount that she invested? What was the maturity value of the investment at the end of the investment...
-
The center of mass of a 100 kg person is 4 m away from the center of mass of a 2 kg sandwich. What is the magnitude of the gravitational pull on the person from the sandwich? What would the radius of...
-
In January of Year 1, Jill, the landowner-lessor, and Aleanna Resources ("AR"), the lessee, enter into a standard oil and gas lease with Jill receiving a bonus of $300,000 and retaining a 1/8...
-
An audit against which reporting mechanism will demonstrate that an organization has an adequate security control design. Who should perform the gap analysis following an audit?
-
Consider a BPSK receiver operating in a Rayleigh (slow and frequency-flat) fading channel (no diversity) with the average BER= 10-. Find % of time (or users) when instantaneous error rate exceeds 10-.
-
Use the derivative to identify the open intervals on which the function is increasing or decreasing. Verify your result with the graph of the function. (Ent P(x) = increasing decreasing Need Help?...
-
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.
-
The truss shown in figure 1.30 has two elements. The members are made of the aluminum hollow square cross section. The outer dimension of the square is \(12 \mathrm{~mm}\), and the inner dimension is...
-
Solve the onedimensional heat conduction problem 6 using the RayleighRitz method. For the heat conduction problem, the total potential can be defined as Use the approximate solution...
-
Consider a system of rigid bodies connected by springs as shown in figure 2.20. The bodies are assumed to move only in the horizontal direction. Further, we consider only the static problem, and...
Study smarter with the SolutionInn App