Question
Offered Price $20.00

IE 341 Transportation & Logistics Engineering, Fall 2014 PROJECT #2

Question # 00040702
Subject: Engineering
Due on: 01/07/2015
Posted On: 01/06/2015 05:27 PM

Rating:
4.1/5
Expert tutors with experiences and qualities
Posted By
Best Tutors for school students, college students
Questions:
15718
Tutorials:
15379
Feedback Score:

Purchase it
Report this Question as Inappropriate
Question
WHAT TO DO: As a first step in the teams decision making, you should forecast the quarterly demand for
each of the two types of containers for the years 2010 to 2012. Based on historical trends, demand is expected
to continue to grow until 2012, after which it expected to plateau. Julie must select the appropriate forecasting
method and estimate the likely forecast error.
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? Why? Explain by typing your answer in the EXCEL file
submitted. Hint: Plot of the quarterly demand (versus time) for clear and black plastic containers will
help you to determine on the forecasting method.
WHAT TO SUBMIT: One of the team members should submit a SINGLE EXCEL file (.xls OR .xlsx only)
including all the TEAM MEMBERS NAMES/IDs in the file through the IE341-Project2-Fall2014-EXCEL
File Submission available under Assignments in Blackboard. Failure of submission will result in a 0 mark
for the project. You can use the Week08-Forecasting-InClassExercise.xlsx (under Course Materials in
Blackboard) as a template for your answer. Note that for parts (a), (b), (c), (d), (e) and (f), you should have
separate worksheets in the same file. No need to submit your answers as a printout (as I will only mark your
EXCEL file only.)
Tutorials for this Question
Available for
$24.00

IE 341 Transportation & Logistics Engineering, Fall 2014 PROJECT #2

Tutorial # 00039840
Posted On: 01/06/2015 05:28 PM
Posted By:
Best Tutors for school students, college students expertden
Expert tutors with experiences and qualities
Questions:
15718
Tutorials:
15379
Feedback Score:
Report this Tutorial as Inappropriate
Tutorial Preview …Engineering, xxxx…
Attachments
IE_341_Transportation_Logistics_Engineering,_Fall_2014_PROJECT_#2.xlsx (32.32 KB)
Preview: based xx exponential xxxxxxxxx methodForecast3) Forecast xxxxx exponential smooting.....
Purchase this Tutorial @ $24.00 *
* - Additional Paypal / Transaction Handling Fee (3.9% of Tutorial price + $0.30) applicable
Loading...