Purchase Solution

forecast quantity

Not what you're looking for?

Ask Custom Question

The following data is the quarterly sales of gasoline in the United States (in millions of barrels during part of the 1980s and the 1990s. Estimate the linear trend and use it to forecast sales for the first quarter of 1992. Note: There are two parts to this question. The first answer looks like S = a +b * T where A an B are constants and t is the time period, i.e. t = 17 for the first quarter of 1992. The second answer is the forecast quantity. Second Hint: use Excel.

Time Quantity Time Quantity
1988.1 11 1990.1 14
1988.2 15 1990.2 18
1988.3 12 1990.3 15
1988.4 14 1990.4 17
1989.1 12 1991.1 15
1989.2 17 1991.2 20
1989.3 13 1991.3 16
1989.4 16 1991.4 19

Purchase this Solution
Solution Summary

Linear Trends are emphasized.

Purchase this Solution
Free BrainMass Quizzes
Economics, Basic Concepts, Demand-Supply-Equilibrium

The quiz tests the basic concepts of demand, supply, and equilibrium in a free market.

Elementary Microeconomics

This quiz reviews the basic concept of supply and demand analysis.

Pricing Strategies

Discussion about various pricing techniques of profit-seeking firms.

Economic Issues and Concepts

This quiz provides a review of the basic microeconomic concepts. Students can test their understanding of major economic issues.

Basics of Economics

Quiz will help you to review some basics of microeconomics and macroeconomics which are often not understood.

View More Free Quizzes
Related BrainMass Solutions

  • Demand Management Problems

    a) What is the EOQ, disregarding the quantity discounts. b) What is the most economical order quantity , considering quantity discounts Question 6: A store sells car batteries.

  • Forecasting and inventory problems

    Using single exponential smoothing with alpha=0.2 and a September forecast=65, calculate a forecast for October. c. Using simple linear regression, calculate the trend line for the historical data.

  • Most important forecast in a master budget

    ANSWERS The most important forecast made in the master budget is the sales forecast. This is so because the budgeted sales quantity in the budgeted period will determine the production budget, administrative and marketing cost budgets.

  • Mathematics - Algebra

    Also, we can forecast the quantity demanded for a price of say, $6. y = -2(6) + 40 = 28 will be the quantity demanded. Thus, the equation y = mx + b, although simple, gives a lot of valuable information in real-life situations.

  • Forecasting Methods

    Provide the algebraic equation for the economic order quantity (EOQ, using AQ, OC, and UHC as variables). Calculate and provide the numerical economic order quantity rounded to the closest whole number. 4.

  • Calculate regression; forecast sales

    Forecast sale for the year 2000 and 2001 Please see the attached files. Discussion and computations provided.

  • Inventory & Forecasting Questions

    ANSWERS ARE IN BLUE Explain how to use seasonal index values to create a forecast.

  • factors that can lead to an unfavorable quantity variance

    Increases in demand due to various factors that were not in management's forecast also cause unfavorable quantity variances. 2. How should variances be used by a company? Variances are always tools for management to analyze.

  • Inventory Management

    Assuming same growth rate forecast for Jul-Aug 2004 can be obtained. Once bi-monthly forecast is available per week demand can be computed by dividing bi-monthly demand by number of weeks (8 weeks).

View More Related Solutions