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

Explain the difference between IPv4 and IPv6 addressing schemes and discuss that how many different IPv4...

Advance Math
Q

Cone Corporation is in the process of preparing its December 31, 2018, balance sheet. There are...

Accounting
Q

If W amount of heat in J will be generated in the circuit shown in...

Physics
Q

A 24 kg mass is undergoing simple harmonic motion with anamplitude of 25 cm. If...

Physics
Q

how many miles can you deduct ? jan 1 2022 june 30 2022 she drove...

Accounting
Q

I am missing an account for this jounral entry and, can not get the numbers...

Accounting
Q

Suppose Sam and Sons purchases $1,100,000 of 7% annual bonds of Clarkson Corporation at face...

Accounting
Q

Which of the following is not an error that would cause the trial balance to...

Accounting
Q

Exercise 6-17A (Algo) Asset replacement-opportunity cost LO 6-5 Baird Freight Company owns a truck that...

Accounting
Q

Your uncle named you beneficiary of his life insurance policy. The insurance company gives you...

Accounting
Q

Only (c) and (d) are needed, thanks! Problem 6 (3 points each)...

Finance
Q

Goldfarb owns a 500 acre tract of land known as Blackacre. He executes a deed...

Finance