The forecast for dec 2015 based only on the trendline

Assignment Help Management Theories

Reference no: EM13713708

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.

Reference no: EM13713708

Questions Cloud

A company used three different selection methods : A company used three different selection methods to select entry level business process analyst: 1. Structured interviews (validity coefficient 0.62) 2. Mental Ability Test (validity coefficient 0.54) 3. Work sample (validity coefficient 0.50)..

What is the ph of the buffer at 25 degrees celcius : A buffer is made by mixing 5.0 mL of 4.0 M NH3 (aq) with 15mL of 2.4 M NH4Cl(aq). What is the pH of the buffer at 25 degrees Celcius, if the base ionization constant of ammonia is 1.8*10^-5 and the ion product of water is 1.0*10^-14 at this temper..

Problem related to the molar concentration of ammonia : Theoretical values of pH and [H+] if the experimental value of pH is 11.12 and the molar concentration of ammonia is 0.100

The forecast for dec 2015 based only on the trendline : 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..

What is the empirical formula of the compound : What is the empirical formula of the compound containing 41.4% carbon, 3.4% hydrogen, and 55.2% oxygen by mass. What is the empirical formula for the compound containing 30.4% nitrogen and 69.6% oxygen by mass

What is the mass percentage of oxygen in ethanol : What is the molecular formula for the compound containing 30.4% nitrogen and 69.6% oxygen by mass and having a molar mass of 92.0 g

Calculate the ph of the solution after acid have been added : A 25.0-mL sample of a 0.090 M solution of aqueous trimethylamine is titrated with a 0.11 M solution of HCl. Calculate the pH of the solution after 10.0, 20.0, and 30.0 mL of acid have been added; pKb of (CH3)3N = 4.19 at 25*C

The gas sample at the new volume and pressure is : The volume of the gas sample is decreased to 8.0 L while its pressure is increased to 403 mm Hg. If the ideal gas law is obeyed, the temperature of the gas sample at the new volume and pressure is

User Account

All Pages