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

  Illustrate what is one legitimate example of organizing

Illustrate what is one legitimate example of organizing which the department manager may never encounter or may perhaps encounter only once in a great while

  What is managing change as well as organizational learning

What is Managing Change as well as Organizational Learning? Focus on the higher skills of applying, analyzing, evaluating and creating

  Explain what are some human resource challenges

Explain What are some human resource challenges and How would a good human resources department meet these challenges?

  Did linda express, implied or apparent authority to sell

Jack runs a baseball card shop. Linda, who knows little or nothing about baseball or baseball cards, agrees to run the shop for Jack while he went out for dinner. Jack provides Linda the following instructions.

  Are annual sales increasing-decreasing and by how much

A cosmetics manufacturer's marketing department has developed a linear trend equation which can be used to predict annual sales of its popular Hand & Foot Cream.

  Sales are expected to peak somewhat quickly

however the rate of growth has slowed. Sales are expected to peak somewhat quickly in the U.S. Based on this information cellular phones are in what stage of the product life cycle in the U.S.?

  Based on the book and other credible sources explain why

People have been cold calling for year, but some have found it to be ineffective. Based on the book and other CREDIBLE sources, explain why might this be the case?

  Describe the elements of the claim of intentional infliction

Describe the elements of the claim of intentional infliction of emotional distress. Estimate the actual elements of the claim and cite your source.

  Illustrate what type of contract buyer requirements

The buyer relies upon the expertise of the seller to confirm which the particular product will meet the buyer's requirements.This is an example of illustrate what type of contract also Explain why?

  Problem on ethics-morality and leadership

Did AWB executives abuse their position in making payments to the Iraqi regime in contravention of the UN sanctions?The foreign corruption practices act, and the equivalents in many countries, make it a crime to pay bribes to foreign government of..

  Microsoft hope its new way of organizing

In Illustrate ways does Microsoft hope its new way of organizing will help it to continually improve its competences also technology.

  Describe clarification of organizational culture

Describe Clarification of Organizational Culture - What are the observable aspects of organization culture?

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