SmartExpert

(118)

$30/per page/Negotiable

About SmartExpert

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Business & Finance See all
Accounting,Business & Finance,Economics,English,HR Management,Math Hide all
Teaching Since: Apr 2017
Last Sign in: 57 Weeks Ago, 3 Days Ago
Questions Answered: 7570
Tutorials Posted: 7352

Education

  • BS,MBA, PHD
    Adelphi University/Devry
    Apr-2000 - Mar-2005

Experience

  • HOD ,Professor
    Adelphi University
    Sep-2007 - Apr-2017

Category > Business & Finance Posted 17 Sep 2017 My Price 6.00

Forecasting Exercise

Forecasting Exercise

You are the supply chain manager for an electronics-manufacturing company. In this assignment, you will use the following data to obtain forecasts for your company through various forecasting techniques.

Quarter

Forecast

Actual Demand

Error

4Q 2008

200

220

  

1Q 2009

220

215

  

2Q 2009

215

210

  

3Q 2009

210

220

  

4Q 2009

220

225

  

1Q 2010

225

240

  

2Q 2010

240

255

  

3Q 2010

  

260

  

4Q 2010

  

270

  

1Q 2011

      

Consolidate the results of the following problems in a 2page report in a Microsoft Word document. Do not use Microsoft Excel utilities for this assignment.

  • Using the three quarters moving average, find out the forecasts for 3Q 2010, 4Q 2010, and 1Q 2011.
  • Compute the forecasts for 3Q 2010, 4Q 2010, and 1Q 2011 using exponential smoothing with a smoothing factor of 0.6.
  • Compute the forecasts for all quarters of 2010 using the three quarter weighted moving average, with the most recent data weighted at 0.5, the second-most recent data weighted at 0.35, and the third-most recent data weighted at 0.15.
  • Using the data provided in the above table, explain what forecasting techniques are being used for 2008 and the first two quarters of 2009.
  • Computed the forecasting error using the exponential smoothing technique.
  • Computed the forecasting error using the weighted smoothing average method.
  • On the basis of your calculations, explain which technique provides the most accurate forecast for your company. Explain your answer with critical reasoning.

Using the APA format, cite the sources you use on a separate page.

 

Answers

SmartExpert
(118)
Status NEW Posted 17 Sep 2017 02:09 PM My Price 6.00

For-----------eca-----------sti-----------ng -----------Exe-----------rci-----------se -----------  -----------

Attachments

file 1505658525-Forecasting Exercise.docx preview (631 words )
F-----------ore-----------cas-----------tin-----------g E-----------xer-----------cis-----------e -----------Usi-----------ng -----------the----------- th-----------ree----------- qu-----------art-----------ers----------- mo-----------vin-----------g a-----------ver-----------age-----------, f-----------ind----------- ou-----------t t-----------he -----------for-----------eca-----------sts----------- fo-----------r 3-----------Q 2-----------010-----------, 4-----------Q 2-----------010-----------, a-----------nd -----------1Q -----------201-----------1. ----------- An-----------swe-----------r: -----------Cal-----------cul-----------ati-----------on -----------of -----------for-----------eca-----------st -----------usi-----------ng -----------“-----------Mov-----------ing----------- av-----------era-----------ge -----------met-----------hod-----------”-----------: -----------For-----------mul-----------a i-----------s: ----------- -----------Yea-----------r F-----------ore-----------cas-----------t -----------4Q -----------200-----------8 2-----------00 ----------- 1Q----------- 20-----------09 -----------220----------- 2-----------Q 2-----------009----------- 21-----------5 -----------3Q -----------200-----------9 2-----------10 ----------- 4Q----------- 20-----------09 -----------220----------- 1-----------Q 2-----------010----------- 22-----------5 -----------2Q -----------201-----------0 2-----------40 ----------- 3Q----------- 20-----------10 -----------228----------- 4-----------Q 2-----------010----------- 23-----------1 -----------1Q -----------201-----------1 2-----------33 ----------- Fo-----------r 3-----------Q 2-----------010----------- Fo-----------rec-----------ast----------- = -----------(22-----------0+2-----------25+-----------240-----------)/3----------- = -----------228----------- &a-----------mp;-----------amp-----------; s-----------o o-----------n -----------  ----------- Co-----------mpu-----------te -----------the----------- fo-----------rec-----------ast-----------s
Not Rated(0)