Using the Excel data provided, determine the Dec 2015 forecast for Ruston based only on the trend and then again with the seasonal component included, if any exists (Table 2). Management believes that the load for Ruston (Table 1) will remain steady at Dec 2015 levels through 2016 and beyond. Using the forecasted load value for Ruston, determine the optimal X and Y coordinates for your facility.
Question 1
What is the Forecast for Dec 2015 based only on the trendline? (Ignore seasonal and cyclical effects). Enter your result rounded to one decimal place.
Question 2
What is the seasonal forecast for Dec 2015? Enter your answer rounded to one decimal place.
Question 3
Facility Location: What is the X-coordinate for the optimal location? Use only the trend for Dec 2015 for Ruston. Enter your answer rounded to one decimal place.
Question 4
Facility Location: What is the Y-coordinate for the optimal location? Use only the trend for Dec 2015 for Ruston. Enter your answer rounded to one decimal place.