Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. describe the various forecasting methods. what are

Describe the various forecasting methods. What are the steps needed to develop a forecast? Explain how...

90.2K

Verified Solution

Question

Accounting

Describe the various forecasting methods. What are the stepsneeded to develop a forecast? Explain how you could use Excel tohelp develop a forecast. Provide an example of an Excel forecastfor a three year period on any one income statement or balancesheet account.

Answer & Explanation Solved by verified expert
3.9 Ratings (670 Votes)
Forecasting is the process of making predictions of the futurebased on past and present data and most commonly by analysis oftrendsVarious of forecasting methods are1Qualitative methodQualitative forecasting techniques aresubjective based on the opinion and judgment of consumers andexperts they are appropriate when past data are not availableThey are usually applied to intermediate or longrange decisionsExamples of qualitative forecasting methods are informed opinionand judgment the Delphi method market research and historicallifecycle analogy2Quantitative methodQuantitative forecasting models are usedto forecast future data as a function of past data They areappropriate to use when past numerical data is available and whenit is reasonable to assume that some of the patterns in the dataare expected to continue into the future These methods are usuallyapplied to short or intermediaterange decisions Examples ofquantitative forecasting methods are last period demand simple andweighted NPeriod moving averages simple exponential smoothingpoisson process model based forecasting and multiplicative seasonalindexes Previous research shows that different methods may lead todifferent level of forecasting accuracy For example GMDH neuralnetwork was found to have better forecasting performance than theclassical forecasting algorithms such as Single Exponential SmoothDouble Exponential Smooth ARIMA and backpropagation neuralnetwork3Average approachIn this approach the predictions of allfuture values are equal to the mean of the past data This approachcan be used with any sort of data where past data    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Transcribed Image Text

Describe the various forecasting methods. What are the stepsneeded to develop a forecast? Explain how you could use Excel tohelp develop a forecast. Provide an example of an Excel forecastfor a three year period on any one income statement or balancesheet account.

Other questions asked by students

Q

Aria Acoustics, Inc., (AAI) projects unit sales for a new seven-octave voice emulation implant as follows: Year Unit...

Finance
Q

O 5 O thymine OH hydrogen bonds H N 3 Sugar phosphate backbone NH guanine...

Biology
Q

water A resistor of resistance R carries a variable current The current decreases with time...

Physics
Q

20 Determine all vectors v that are orthogonal to u 11 2

Basic Math
Q

Find the partial fraction decomposition of the given rational expression.16x + 34/4x + 12x +...

Basic Math
Q

weights for all Boer goats is 2 81 kg A veterinary service has hired you...

Statistics
Q

Mean 72 standard deviation 19 a What is the probability that student 53 b What...

Statistics
Q

Data for the next 3 questions: Riley Company Company provides supplemental retirement benefits...

Accounting
Q

Which of the following represents a connection between the statement of retained earnings and the...

Accounting
Q

Which of the following is not good advice to give someone preparing a dashboard of...

Accounting
Q

You have just been hired by FAB Corporation, the manufacturer of a revolutionary new garage...

Accounting
Q

In many countries, especially with expected inflation, inflation targeting is the objective of central banks....

Finance