Logo
Home Study Material Contact Search
AI Chat FREE
  1. mathematics
  2. basic math
  3. moving averages.  use the below actual sales to

Moving Averages.  Use the below actual sales to calculate a three-year average which will be used as the...

90.2K

Verified Solution

Question

Basic Math

  1. Moving Averages.  Use the belowactual sales to calculate a three-year averagewhich will be used as the forecast for next periods (chapter 14,text).
  2. Exponential Smoothing. Use the same data toforecast sales for the next periods with ?=.40 (chapter 14,text).
  3. Regression Analysis on Excel. Draw a scattergraph from Insert/Graph/Scatter graph selections in Excel (chapter15, text).

Month

Actual Sales

1

3050

2

2980

3

3670

4

2910

5

3340

6

4060

7

4750

8

5510

9

5280

10

5504

11

5810

12

6100

Answer & Explanation Solved by verified expert
4.1 Ratings (768 Votes)
Moving AveragesUse the belowactual sales to calculate a threeyear    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: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Advance Math
1.2K views

Using the power series method solve the given IVP. (The answer will include the first four...

Finance
1.2K views

Why is working capital a particularly important area of concern for financial managers? At least 200 words.

Electrical Engineering
1.2K views

True or false 1- Thermally light building, usually refers to a building that is very well insulated. True False 2-...

Physics
1.2K views

If you were conducting the wire and compass experiment (Part A) near the equator instead...

Geometry
1.2K views

Find an equation for the graph Type the equation of the given graph in the...

Statistics
1.2K views

In a clinical trial of a drug intended to help people stop smoking 133 subjects...

Calculus
1.2K views

Find the arc length of the polar curve described by r 10 10 cos 0

Accounting
1.2K views

What evidence should the auditor gather to determine whether the client's estimate of the allowance...

Accounting
1.2K views

Tree Seedlings has the following current-year purchases and sales for its only product. Date January...

Accounting
1.2K views

[The following information applies to the questions displayed below. Grayson is in the 24 percent...

Accounting
1.2K views

The following data was prepared by the Pharoah Company. Total Variable Fixed Sales price $22/unit...

Finance
1.2K views

Question 9 4 pts General Motors (GM) issued a 10-year bond 2 years ago with...