Purchase Solution

Quantitative analysis:Forecasting techniques.

Not what you're looking for?

Ask Custom Question

Develop a sales volume forecast using the least squares method *and* one other forecasting method.

One forecast method must be using the least squares method, the second can use any other normal forecasting method.

Provide the two sales volume forecasts in excel format, each with data shown and a graph.

Smoothing constant for average 0.3 Smoothing constant for trend 0.4

Quarter Sales

3Q 2008 90,000
4Q 2008 95,000
1Q 2009 98,000
2Q 2009 96,000
3Q 2009 102,000
4Q 2009 99,000
1Q 2010 118,000
2Q 2010 109,000
3Q 2010 124,000.

Purchase this Solution
Solution Summary

The problem deals with forecasting sales using least squares and moving average technique.

Solution provided by:
Chidi Ngene, M. Sc.
Education
  • B. Sc., University of Nigeria
  • M. Sc., London South Bank University
Recent Feedback
  • "Thank you."
  • "thank you Chidi Ngene.. if you have any APA references would be great"
  • "Thank you so much for your help, your explanations were easy to understand and apply!"
  • "are you able to highlight the equations used either on the xlsx or a word doc as to how each graph was formed- overall looks fine i just need help understanding this myself"
  • "Chidi Ngene, M. Sc. Was extremely helpful as without the help and guidance I would have failed, but with the help I passed. I still have a lot to learn and in need of the guidance to understand and learn more on the subject. I would recommend Chidi Ngene and BrainMass to anyone that are in need of help. Thank you!!"
Purchase this Solution
Free BrainMass Quizzes
SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

IPOs

This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)

View More Free Quizzes
Related BrainMass Solutions

  • Advanced Marketing Approaches

    Some prefer to use the Qualitative techniques while others prefer to use the Quantitative techniques. However, both the methods of research have their own advantages.

  • Quantitative Research Techniques using Statistics

    --What quantitative research techniques/statistics would you recommend for ABC Complete Kitchens, Inc.? Keep in mind, the quantitative research techniques applies towards an empirical observation on the basis of mathematical expression.

  • Quantitative Statistical Techniques

    498794 Quantitative Statistical Techniques Summarize a quantitative research article. Be sure to state how you know the techniques were quantitative. Discuss one strength and one weakness of the statistical techniques discussed.

  • Different Market Research Techniques

    market research techniques are provided.

  • British Petroleum: Risk Management

    Quantitative risk tools and techniques for British Petroleum are data gathering, probability distribution, and representational techniques. Quantitative tools also include getting estimates from experts.

  • Mixed Method and Action Research Review

    The quantitative data collection techniques used The qualitative data collection techniques used Whether the way the data were collected corresponded with the mixed-method strategy used (for example, whether the data were in fact collected sequentially

  • Using Both Qualitative And Quantitative Research Methods

    Qualitative techniques identify trends in small communities facing significant challenges from isolated problems while the quantitative method delivers the "big picture" on a medical issue.

  • Qualitative, quantitative, and mixed methods research studies

    Because of the fact that conventional techniques failed to yield the results to definitively determine the hypothesis, researchers instead focused upon a standardization approach that allowed researchers to employ quantitative techniques and tests to

  • Technology Forecasting

    The choice of TF techniques can be classified among the quantitative and the qualitative or judgemental based techniques.

  • ◦The quantitative data collection techniques used ◦The qualitative data collection techniques used ◦Whether the way the data were collected corresponded with the mixed-method strategy used (for example, whether the data were in fact collected sequentially

View More Related Solutions