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

  Costs of turnover within a health services organization

examine the costs of turnover within a health services organization such as a hospital or a skilled nursing facility.

  Explain how you would target specific consumer groups

As a small-business owner with a variety of both wholesale and retail products, Express your approach to developing market segmentation and explain how you would target specific consumer groups to purchase your products.

  Explain what is adidas'' corporate strategy

Explain what is Adidas' corporate strategy? Was there a communal strategic approach utilized in managing the company's line-up of sporting goods businesses prior to its 2005-2006 restructuring

  Work problems are quite interesting

Work problems are quite interesting - and sometimes counterintuitive. The key is to remember that the group will be faster than any of them working alone.

  Direction of action and effort persistance

The direction of action, the intensity of effort, and effort persistence.

  Explain when does concentration of production make sense

Explain When does concentration of production make sense and Compare and contrast counterpurchase agreements and offset arrangements

  Value of industrial and organizational psychologists

Organizations often consider on-staff industrial/organizational psychologists as cost with no revenue return.

  Construct a pareto diagram

A major music club collected information on the causes for returned shipments during a quarter. Results are: Wrong selection 50,000; wrong address 68,000; refused 195,000;

  Proliferation and fragmentation of the health professions

What are the desirable and undesirable aspects of this fragmentation and should actions be taken to slow or stop this trend? If so, what should be done and how can it be achieved?

  A production procedure is known to produce a particular item

A production procedure is known to produce a particular item in such a way that 5 percent of these are defective.

  The contract among press publishing and boardwalk books

Press Publishers sold 100 copies of a fresh hardback book entitled Business Law to Boardwalk Books. The contract among Press Publishing and Boardwalk Books provides in relevant part that Boardwalk may return to Press any unused copies of the book ..

  Multinational organization recognise their hr mission

Using Coca-Cola as a multinational organization recognise their HR mission statement and information on their career-related web pages. Write 1000 word paper and describe if the organization has addressed the following items from a global perspect..

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