This is an example of Exponential Smoothing with Trend Adjustment. The goal is to compute an...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
This is an example of Exponential Smoothing with Trend Adjustment. The goal is to compute an exponentially smoothed average to adjust inventory (+/-) to account for lags. formula for Forecast and another formula for trend. Home Depot Demand for Lighting Fixtures Use an alpha of 0.5 and a beta of 0.9 Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 1. What is the Bias? 2. What is the MAD? 15 14 19 25 17 12 21 18 11 3. What is the MSE? Do you want to minimize or maximize the MSE? Why? 4. What is the MAPE? 5. What kind of conclusions can you make about the data? 6. Now change the alpha value to 0.1. How does this impact the data? Is your forecast more or less accurate and why? 7. Using the last problem as your reference data: Let's introduce a seasonality factor, assume the demand increases to 25 in Month 8 and 30 in Month 9. The uptick in construction creates a high demand for light fixtures. What happens to your data? 8. As the Inventory Manager for Home Depot, do you recommend increasing/decreasing or holding constant the last model volumes? Why or why not? What are some possible errors in accepting one method over another? 9. Distinguish the differences between column B (Initial Demand) and Column F (The Forecast Including Trend. Highlight a few key facts regarding the impact of an adjusted forecast on initial demand forecasts.) This is an example of Exponential Smoothing with Trend Adjustment. The goal is to compute an exponentially smoothed average to adjust inventory (+/-) to account for lags. formula for Forecast and another formula for trend. Home Depot Demand for Lighting Fixtures Use an alpha of 0.5 and a beta of 0.9 Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 1. What is the Bias? 2. What is the MAD? 15 14 19 25 17 12 21 18 11 3. What is the MSE? Do you want to minimize or maximize the MSE? Why? 4. What is the MAPE? 5. What kind of conclusions can you make about the data? 6. Now change the alpha value to 0.1. How does this impact the data? Is your forecast more or less accurate and why? 7. Using the last problem as your reference data: Let's introduce a seasonality factor, assume the demand increases to 25 in Month 8 and 30 in Month 9. The uptick in construction creates a high demand for light fixtures. What happens to your data? 8. As the Inventory Manager for Home Depot, do you recommend increasing/decreasing or holding constant the last model volumes? Why or why not? What are some possible errors in accepting one method over another? 9. Distinguish the differences between column B (Initial Demand) and Column F (The Forecast Including Trend. Highlight a few key facts regarding the impact of an adjusted forecast on initial demand forecasts.)
Expert Answer:
Answer rating: 100% (QA)
1 What is the B ias ANS WER The bias is the difference between the actual value and the forecast ed value In this case the bias would be the difference between the actual demand and the forecast ed de... View the full answer
Related Book For
Posted Date:
Students also viewed these economics questions
-
1 How does this company structure differ from a matrix approach to organisational design? 2 What do the remaining employees of Semco do now? How is their role likely to change as this process...
-
Determine CPI, ETC (1), and EAC. Activity Total PV 1 2 3 4 5 6 7 8 9 10 11 12 13 14 1 6 6 2 20 10 10 3 30 9 6 6 6 3 4 20 8 2 5 5 5 16 4 4 4 4 6 18 9 9 7 8 4 4 Status Report: Ending Period 5 Task %...
-
(1) Given A and i. (1a) Find the equivalent amount at the end of year 1. (1b) Find the equilvalent amount at the end of year B. (2) Given X and i, Find the annual equivalent A from year S to 8. *...
-
Understanding the history and background of your company gives you valuable insights as to what to do and what not to do going forward. A brief written summary of the background and history of the...
-
An individual planning to retire at the end of three years has savings of approximately S212,000. In his planning, he uses a thirty-year life expectancy in retirement. He calculates his spending...
-
If the population of town B is 50% greater than the population of town A, and the population of town C is 20% greater than the population of town A, then what percent greater is the population of...
-
Following results refer to a test on petrol engine : I.P. \(=32 \mathrm{~kW} ;\) B.P. \(=27 \mathrm{~kW} ;\) speed \(=1200 \mathrm{rpm}\) b.s.f.c. \(=0.25 \mathrm{~kg} / \mathrm{kWh} ;\) C.V. of fuel...
-
Adam and Arin Adams have collected their personal income and expense information and have asked you to put together an income and expense statement for the year ended December 31, 2012. The following...
-
What are the Ethical Considerations for remuneration approaches? Do you agree with the excessive CEO compensation? Please provide an example and justify your answer. Define restricted stocks. Provide...
-
On January 1, 2021, DC Ltd. issued bonds with a maturity value of $8 million when the market rate of interest was 4%. The bonds have a coupon (contractual) interest rate of 5% and mature on January...
-
For many years the Acme Company carried on business as a manufacturer of consumer products. In 2 0 1 8 , it embarked on an ambitious program of expansion that involved the acquisition of a new plant...
-
The entrance of a science museum features a funnel into which marbles are rolled one at a time. The marbles circle around the wall of the funnel, eventually spiraling down into the neck of the...
-
Derive an equation for the concentration of organic matter (A) at any time t if the decomposition dCA dt of A is given by the differential equation t; k= specific decay rate constant. Initial...
-
A 4.7 kg block is lifted vertically by a force of 287 N. What is its acceleration? Assume g=9.81 m/s 2 . Provide your answer in m/s 2 and round to the nearest two decimal places.
-
= A block (m = 4kg) slides on an inclined surface (0 30) and is connected on one side to a spring (k = 50N/m). The coefficient of kinetic friction between the block and the incline is 0.2. The block...
-
A long cylindrical wire of radius R = 3.0 mm carries a steady current lo = 30 A that is uniformly distributed through the cross section of the wire. Calculate the magnetic field at a point 1.8 mm...
-
Find the inverse of the given function. f(x) = 6x-7 8
-
Players A, B, and C toss a fair coin in order. The first to throw a head wins. What are their respective chances of winning?
-
Determine whether the statement is true or false. Justify your answer. 1. The Binomial Theorem could be used to produce each row of Pascal's Triangle. 2. A binomial that represents a difference...
-
In a high school graduating class of 128students, 52 are on the honor roll. Of these, 48 are going on to college. Of the 76 students not on the honor roll, 56 are going on to college. What is the...
-
1. The number of letter pairs that can be formed in any order from any two of the first 13 letters in the alphabet (A-M) is an example of a permutation. 2. The number of permutations of n elements...
-
Create a complete stable pattern by using the tips and heuristics provided in this chapter.
-
Develop the following systems using the fairness pattern: 1. Tax fairness: A tax platform based on an ideal that aims to create a system of taxation that is fair, clear, and equivalent for all...
-
BOs make this pattern stable and extendible. Do you agree?
Study smarter with the SolutionInn App