Julie must select the appropriate forecasting method

Assignment Help Business Management
Reference no: EM13105365

Q. As a first step in the teams decision making, they want to forecast quarterly demand for each of the two types of containers for the years 2003 to 2005. Based on historical trends, demand is expected to continue to grow until 2005, after which it is expected to plateau. Julie must select the appropriate forecasting method and estimate the likely forecast error. Which method should she choose?

Use the following methods to forecast quarterly demand for the years 2010 to 2012 in EXCEL:

(a) Moving Average (b) Exponential Smoothing method (c) Exponential Smoothing with Trend (d) Time Series Decomposition 

(e) For parts (a), (b) and (c), also compute the: i. forecasting errors (MAD, MSE, MAPE). ii. standard error of forecast (SF), “Bias” and “Tracking Signal”, iii. also assuming normally distributed forecast errors, 90% confidence range for the 2010-2012 forecasts (i.e., using ??90% = 1.28).

(f) Which method should she choose?


Attachment:- PROJECT2-A Case Study-SPC Forecasting-BB.pdf

Reference no: EM13105365

Questions Cloud

Explain the development of cisco systems from perspective : Explain the internal forces for change that seem to be affecting Cisco Systems. Explain the development of Cisco Systems from the perspectives of incremental change, strategic change and transformational change.
How many electrons must be removed : An object has a charge of -4.3 ?C. How many electrons must be removed so that the charge becomes +2.8 C?
Effect of confidence levels on confidence intervals : The NAEP test was also given to a sample of 1077 women of ages 21 to 25 years. Their mean quantitative score was 275. Take it as known that the standard deviation of all individual scores is = 60.
How does technology transport for the united parcel service : It's a cold day in December and John Davis a veteran driver in Atlanta for United Parcel Service Inc., checks his handheld device as well as discovers he's in for a busy day- more than 500 packages to deliver a task that until lately
Julie must select the appropriate forecasting method : demand is expected to continue to grow until 2005, after which it is expected to plateau. Julie must select the appropriate forecasting method and estimate the likely forecast error. Which method should she choose?
Define magnitude of the electric force that acts on particle : A particle has a charge of +1.7 ?C and moves from point A to point B, a distance of 0.12 m. The particle experiences a constant electric force, and its motion is along the line of action of the force. The difference between the particle's electric..
Determine the weekly product yield of file cabinets : The Wallace Stationery Company purchases paper from the Seaboard Paper Company. Wallace produces stationery that require 1,415,000 sq. yards of stationery per year.
Confidence level to determine the population proportion : A high school counselor is interested in the percentage of students who will be going to college. She randomly picks 60 students and finds that 53 will be going to college. Use a 95% confidence level to find the population proportion.
Explain how your organization achieve these characteristics : Explain how would I know if the organization was making progress towards becoming a learning organization? Select four characteristics that are most compelling to you and the organization. Explain how can your organization achieve these characteristi..

Reviews

Write a Review

Business Management Questions & Answers

  Show the consumer expectations

Consumer expectations - Compare and contrast Ford and Toyota and discuss how and why one organization kept pace

  Web experienced phenomenal advertising

Provide an article for Web experienced phenomenal advertising growth in recent years but is now dropping off. Why might that be true?".

  Analysis of cost of equity

why don't financial managers use as little debt as possible to keep the cost of equity down - Analysis of Cost of equity

  Do you believe which the complex task of management

Do you believe which the complex task of management can be boiled down to a few principles? Or will there always be so many personality and situational variables involved which the practice of management will remain more of an art than a science?"

  United states saving bonds payable at last mortgage bank

Nelson gave buchert the subsequent instrument dated july 6 1988 one year after date I promise to pay the order of dale buchert one thousand dollars in united states saving bonds payable at last mortgage bank.

  Burdens of proof for civil cases and criminal cases

What are the different burdens of proof for civil cases vs. criminal cases?

  What specific demographic factors should you consider

When presenting a new product, service or program to an organization, what specific demographic factors should you consider about audience or members of organization for your presentation.

  Inference of meaning of data

who had recently returned items showed 400 thought the policy was fair, 32 thought it took too long to complete the transaction, and the remainder had no opinion.

  Xplain statutes and regulations governing florida attorneys

Explain Statutes and regulations governing Florida attorneys prohibit targeted solicitations to victims and their relatives for thirty days following an accident or disaster

  Structure and importance of a project phase review meeting

Explain the structure and importance of a project phase review meeting. Select three areas that need to be reviewed by the project manager and explain why.

  Explain the return on the common stock

The return on the common stock on New Image Products are quite cyclical. In a boom economy the stock is expected to return 32 percent in comparison to 14 percent in a normal economy as well as a negative 28 percent in a recessionary period

  Explain type of sampling

Study to explore young people's perceptions of their neighborhoods: type of sampling - Questions for the interview were based on previous neighborhood studies by Bryant, Chawla, and Spilsbury.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd