Purchase Solution

Forecasting: Calculate water usage for four quarters 2009.

Not what you're looking for?

Ask Custom Question

Water company projects demand trend line to be:

d= 77+0.43Q

Q = sequential quarter number and Q=1 for winter 1984. Multiplicative seasonal factors are as follows:

Quarter Factor (Index)
Winter 0.8
Spring 1.1
Summer 1.4
Fall 0.7

What is water usage for four quarters 2009.

Purchase this Solution
Solution Summary

Provides steps necessary to calculate water usage.

Solution Preview

Q for

Spring 09 = 98 [ it is 98th quarter if we consider Winter 1984 to be first ...

Solution provided by:
Gaurav Agarwal, MS
Education
  • BE, Bangalore University, India
  • MS, University of Wisconsin-Madison
Recent Feedback
  • "Your explanation to the answers were very helpful."
  • "What does 1 and 0 means in the repair column?"
  • "Went through all of the formulas, excellent work! This really helped me!"
  • "try others as well please"
  • "Thank you, this helped a lot. I was not sure how to plug in those numbers to a formula. This was a great help. Now I have to figure out how to explain cost of capital is used in net present value analysis, and how cost of capital is used in net present value analysis. This stuff gets confusing."
Purchase this Solution
Free BrainMass Quizzes
Basics of corporate finance

These questions will test you on your knowledge of finance.

Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

Motivation

This tests some key elements of major motivation theories.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

View More Free Quizzes
Related BrainMass Solutions

  • Forecasting in operations management

    Forecasting can be categorized into four basic types namely, time series analysis, qualitative analysis, causal relationship, and simulation. The qualitative analysis for forecasting purpose includes Delphi method, panel consensus, etc.

  • Statistics forecasting with dependent and independent variables

    After the quarterly sales data for both the years have been calculated, we shall have to calculate the seasonal indices.

  • Forecasting Problems

    of Davis's Department Store has used time-series extrapolation to forecast retail sales for the next four quarters.

  • intercept in each of the four quarters

    For T-ratio for coefficient of 'D3' is -8.233, which is smaller than -2.04, hence coefficient of 'D3' is statistically significant. b. Calculate the intercept in each of the four quarters.

  • TSA trend

    Use a TSA trend (linear regression) analysis from Excel Chart to produce a graph and forecast for the next two quarters. Show how much variance (R-square) is accounted for and the formula for the forecast. 2.

  • Forecasting with seasonal component

    80433 Forecasting with seasonal component Quarterly billing for water usage is shown below.

  • Business Statistics Problems

    Monthly water usage for a business as measured in 100s of cubic feet are as follows: Quantity (in 100's cubic feet) January 17 February 24 March

  • Forecast

    This is what I have so far: Year 5 214 247 243 292 225 Since data has been given for the four different quarters for each year, the best forecasting technique for this data will be the method of seasonally adjusted forecasting.

  • Forecasting, Time Series

    Develop a linear trend equation for the time series. b. Graph the time series and the linear trend equation. c. What appears to be happening to capital expenditures? What is the forecast one year, or four quarters, into the future?

View More Related Solutions