Demand data for a certain raw material in a workshop is given as follows: 2 3...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Demand data for a certain raw material in a workshop is given as follows: 2 3 4 6 7 8 Periods 1 Demand 62 126 81 44 120 76 42 5 58 (a) Using Microsoft Excel, plot the demand data. (b) Among the simple, double, and triple exponential smoothing methods which one would you choose to forecast demand in the coming periods? Why? (c) Based on the method which you suggest in part (b), forecast the demand during periods 11 and 12 (make all necessary initializations and choose 0.10 as the value of each smoothing constant whenever you need them). (d) Suppose that actual demand during period 9 turned out to be 58 units, how would you revise your forecasts for periods 11 and 12? Demand data for a certain raw material in a workshop is given as follows: 2 3 4 6 7 8 Periods 1 Demand 62 126 81 44 120 76 42 5 58 (a) Using Microsoft Excel, plot the demand data. (b) Among the simple, double, and triple exponential smoothing methods which one would you choose to forecast demand in the coming periods? Why? (c) Based on the method which you suggest in part (b), forecast the demand during periods 11 and 12 (make all necessary initializations and choose 0.10 as the value of each smoothing constant whenever you need them). (d) Suppose that actual demand during period 9 turned out to be 58 units, how would you revise your forecasts for periods 11 and 12?
Expert Answer:
Answer rating: 100% (QA)
The detailed answer for the above question is provided below Answer a To plot the demand data in Microsoft Excel you can follow these steps Open Micro... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these general management questions
-
Use data from Appendix D to establish for the reaction 2 N 2 O 4 (g) + O 2 (g) 2 N 2 O 5 (g): (a) r G at 298 K for the reaction as written; (b) K at 298 K. TABLE D.1 Ground-State Electron...
-
You are an independent consultant, providing strategy, execution, and project management services to several clients, across a variety of different project types. Your skills are valued by these...
-
Modify Index to make a program IndexByKeyword that takes a file name from the command line and makes an index from standard input using only the keywords in that file. Note: Using the same file for...
-
P and S waves from an earthquake travel at different speeds, and this difference helps in locating the earth quake epicenter (where the disturbance took place) (a) Assuming typical speeds of 8.5 km/s...
-
Read Selected Reference A6 that describes an OR study done for Texaco. (a) Summarize the background that led to undertaking this study. (b) Briefly describe the user interface with the decision...
-
Using the variance data for Menounos Manufacturing Co., prepare an income statement through gross profit for the year ended December 31, 20Y6. Assume the company sold 3,000 units at $100 per unit.
-
Wood County Hospital consumes 1,000 boxes of bandages per week. The price of bandages is $35 per box, and the hospital operates 52 weeks per year. The cost of processing an order is $15 and the cost...
-
Create this gui on java that supports rational calculations using this code as the logic, make it look like the picture below. Will thumbs up . public class Rational extends Object implements...
-
On October 1, 2016, Culver Corp. issued $936,000, 8%, 10-year bonds at face value. The bonds were dated October 1, 2016, and pay interest annually on October 1. Financial statements are prepared...
-
Let f(t)= [1,4]: Find the average value on the given interval. Let f(x) = 9-x ; x 0; a = 8. a) Show that f is a one-to-one function, b) Find (f)'(a), c) Find f-(x), d) Calculate (f-)'(x) and verify...
-
The liquid phase reaction given below A+B2C is carried out adiabatically in a CSTR. A and B are fed to the reactor at 200C together with a diluent (with a molar ratio of A:B:D=1:1:3 ). Calculate the...
-
An investor purchases a stock for $50 and a put for $0.50 with a strike price of $46. The investor sells a call for $0.50 with a strike price of $59. What is the maximum profit and loss for this...
-
The partnership starting up and the old one is dissolved. Does that also mean you have to close the books and post to the capital accounts or can you continue to the normal year end and close the...
-
Compare and contrast two popular Case Management Software for Canadian Immigration.
-
Lucy's Music Emporium purchased $50 million in fixed assets in January and their accountant told them that they would have to depreciate the assets over 20 years (they use the same depreciation...
-
1) Explain the difference between the common misconception that people might have about how tax brackets work and how they actually work. 2) It's helpful to know the background of how much you owe in...
-
10m solution. If Ka(HA) = 10 then pOH of solution will be [Given : log4=0.6] (A) 6.7 (B) Greater than 6.7 & less than 7.0 (C) Greater 7.0 & less than 7.3 (D) Greater than 7.3
-
Deborah purchases a new $30,000 car in 2012 to use exclusively in her business. If Deborah does not elect to expense or take bonus depreciation in 2012 and holds the car until it is fully...
-
How are qualified dividends taxed in 2012? Please give the two rates of tax which apply to qualified dividends, and specify when each of these rates applies._________________________...
-
Patty Bayan is a single taxpayer living at 543 Space Drive, Houston, TX 77099. Her Social Security number is 466-33-1234. For 2012, Patty has no dependents, and her W-2 from her job at a local...
-
How can environmental agents that do not cause gene mutations contribute to cancer?
-
With regard to genotypes, what is a true-breeding organism?
-
With regard to biological evolution, which of the following statements is incorrect? Explain why. A. During its lifetime, an animal evolves to become better adapted to its environment. B. The process...
Study smarter with the SolutionInn App