1 Acme Lumber Products 2 Wood Glue Usage (in pounds) 3 4 5 6 7 1-Jan-2005...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1 Acme Lumber Products 2 Wood Glue Usage (in pounds) 3 4 5 6 7 1-Jan-2005 2-Jan-2005 3-Jan-2005 4-Jan-2005 5-Jan-2005 6-Jan-2005 7-Jan-2005 8-Jan-2005 9-Jan-2005 10-Jan-2005 11-Jan-2005 12-Jan-2005 13-Jan-2005 14-Jan-2005 15-Jan-2005 19 16-Jan-2005 20 17-Jan-2005 21 18-Jan-2005 22 19-Jan-2005 23 20-Jan-2005 24 21-Jan-2005 25 22-Jan-2005 26 23-Jan-2005 27 24-Jan-2005 28 25-Jan-2005 29 26-Jan-2005 30 27-Jan-2005 31 28-Jan-2005 32 29-Jan-2005 33 30-Jan-2005 34 31-Jan-2005 35 1-Feb-2005 8 9 10 11 12 13 14 15 16 17 18 36 37 2056 2014 1995 1875 2135 2098 2051 2198 1935 1899 2054 2130 2155 2065 2144 2130 2189 1972 2058 1981 2055 2002 2064 2113 2141 2059 2065 2005 2164 2122 2095 1. In the Week 3 module you will find a file Labeled Homework 1 forecasting.xls. Cut and paste the data from this sheet into you OWN spreadsheet. Use this data to complete the forecasting assignment. 2. Perform a Forecast for February 1, 2005 using the 6 methods discussed in class: Naïve, Simple Moving Average, Weighted Moving Average, Exponential Smoothing, Regression (including needed charts), and Regression Tool. 3. Create a summary sheet comparing the following methods: Naïve, SMA, WMA, ES, ES with Solver, Regression. 4. On the summary sheet, include a recommendation of the method you would use along with justification. 5. Using Solver, an Excel tool, minimize the MAD cell in the ES forecast by changing the Alpha. (Remember the rules for Alpha?) 6. When you have completed the assignment submit it to the appropriate drop box on the course shell. Needed Information SMA: Perform the forecast for 5 periods WMA weights: W1-3.5, W2-2.5, W3=2, W4=1 ES: Alpha = .5 1 Acme Lumber Products 2 Wood Glue Usage (in pounds) 3 4 5 6 7 1-Jan-2005 2-Jan-2005 3-Jan-2005 4-Jan-2005 5-Jan-2005 6-Jan-2005 7-Jan-2005 8-Jan-2005 9-Jan-2005 10-Jan-2005 11-Jan-2005 12-Jan-2005 13-Jan-2005 14-Jan-2005 15-Jan-2005 19 16-Jan-2005 20 17-Jan-2005 21 18-Jan-2005 22 19-Jan-2005 23 20-Jan-2005 24 21-Jan-2005 25 22-Jan-2005 26 23-Jan-2005 27 24-Jan-2005 28 25-Jan-2005 29 26-Jan-2005 30 27-Jan-2005 31 28-Jan-2005 32 29-Jan-2005 33 30-Jan-2005 34 31-Jan-2005 35 1-Feb-2005 8 9 10 11 12 13 14 15 16 17 18 36 37 2056 2014 1995 1875 2135 2098 2051 2198 1935 1899 2054 2130 2155 2065 2144 2130 2189 1972 2058 1981 2055 2002 2064 2113 2141 2059 2065 2005 2164 2122 2095 1. In the Week 3 module you will find a file Labeled Homework 1 forecasting.xls. Cut and paste the data from this sheet into you OWN spreadsheet. Use this data to complete the forecasting assignment. 2. Perform a Forecast for February 1, 2005 using the 6 methods discussed in class: Naïve, Simple Moving Average, Weighted Moving Average, Exponential Smoothing, Regression (including needed charts), and Regression Tool. 3. Create a summary sheet comparing the following methods: Naïve, SMA, WMA, ES, ES with Solver, Regression. 4. On the summary sheet, include a recommendation of the method you would use along with justification. 5. Using Solver, an Excel tool, minimize the MAD cell in the ES forecast by changing the Alpha. (Remember the rules for Alpha?) 6. When you have completed the assignment submit it to the appropriate drop box on the course shell. Needed Information SMA: Perform the forecast for 5 periods WMA weights: W1-3.5, W2-2.5, W3=2, W4=1 ES: Alpha = .5
Expert Answer:
Answer rating: 100% (QA)
Formula D5 C4 Naive forecast E9 AVERAGEC4C8 SMA forecast F8 C735C625C52C4352521 WMA forecast G5 G4C4... View the full answer
Related Book For
Marketing Research An Applied Orientation
ISBN: 978-0136085430
6th edition
Authors: Naresh K Malhotra
Posted Date:
Students also viewed these accounting questions
-
In Appendix A, you will find a table titled 10-Year Summary of Financial and Operating Results for Home Depot. Review the various performance measures listed in the table. Choose at least one measure...
-
In Appendix A, you will find a table titled "Five-Year Summary of Financial and Operating Results" for Home Depot. Review the various performance measures listed in the table. Choose at least one...
-
Consider the data: x 3 4 5 6 7 y 8 13 12 14 16 a. Sketch a scatter plot. b. If one pair of (x, y) values is removed, the correlation for the remaining four pairs equals 1. Which pair is it? c. If...
-
The following are the major balance sheet classifications: Current assets (CA) Current liabilities (CL) Long-term investments (LTI) Long-term liabilities (LTL) Property, plant, and equipment (PPE)...
-
A company purchased an oil well for $50,000. It is estimated that 100,000 barrels can be extracted from the well. What is the depletion expense assuming 30,000 barrels are extracted and sold?
-
The van has weight W v and center of gravity at G v . It carries fixed load Wl which has center of gravity at G l . If the van is traveling at speed v, determine the distance it skids before...
-
What are the fundamental differences between two-stroke and four-stroke engines?
-
Integration by parts is required. The probability density function for the diameter of a drilled hole in millimeters is for mm. Although the target diameter is 5 millimeters, vibrations, tool wear,...
-
A wheel of 100 cm diameter, 1000 N weight is resting against a block of 25 cm height. Find minimum force P at angle 45 with horizontal when the wheel is just on the point of climbing the block. P...
-
1. Clearly, if Fitz-Simmons clientele have good supplier relationships, they have worked at supplier development. If they want to maintain those relationships with their suppliers, what are some...
-
One gram of a drug was given to a patient by IV administration. Shortly after (following quick distribution and before any significant elimination has occurred), its plasma concentration was found to...
-
Find the amount of periodic payment necessary for each deposit to a sinking fund in Problems 35-46. Amount Needed A 36. Frequency n $25,000 annually Rate r 1% Time t 5 yr
-
Evaluate the expressions in Problems 11-18. \(\sum_{k=1}^{5}(-2)^{k-1}\)
-
In Problems 23-34, find the value of each annuity at the end of the indicated number of years. Assume that the interest is compounded with the same frequency as the deposits. Amount of Deposit m 31....
-
Imagine that you are in charge of a cycle hire business in a holiday resort. You have 50 cycles available for hire. Some customers hire cyles for one day; others take them for up to one week. Write...
-
Find the requested values in Problems 5-10. \(S_{3}\) when \(s_{n}=8 \cdot 5^{n}\)
-
This will address the significant issues that any entrepreneur must confront when starting a new business. Identify what you know and what information gaps exist regarding the online sales of the...
-
In the operation of an automated production line with storage buffers, what does it mean if a buffer is nearly always empty or nearly always full?
-
What is the main difference between a standard test market and a controlled test market?
-
Present a classification of hypothesis-testing procedures.
-
Define an appropriate marketing research problem corresponding to the management decision problem you identified in question 2. In question 2 discuss the role of marketing research in helping Intel...
-
Let \(Y\) be distributed according to the \(\operatorname{gamma}(265)\) distribution. (a) Find \(\mathrm{E}[Y]\). (b) Find \(\operatorname{Var}[Y]\). (c) Find \(P(Y>5)\)
-
In order to determine how e ective a magazine is at reaching its target audience, a market research company selects a random sample of people from the target audience and interviews them. Out of the...
-
Let \(Y\) be distributed according to the gamma(12 4) distribution. (a) Find \(\mathrm{E}[Y]\). (b) Find \(\operatorname{Var}[Y]\). (c) Find \(P(Y\)
Study smarter with the SolutionInn App