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: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

1) A football player has the following new contracts options. All are guaranteed. If the discount rate...

Finance
Q

Conscious Capitalism - Bikes Simulation I am sure individually each of you are happy/unhappy about the...

Finance
Q

6. Label and describe each step in the light-dependent reactions including all of the electron receptors.

Biology
Q

Problem 1. When Abe graduated from Texas A&M, he bought a diamond ring with a golden...

Basic Math
Q

Q A copper wire of uniform cross sectional area 3 x 10 6 m carries...

Physics
Q

Bernadette is making a quilt. She needs 4 square yards of green fabric, 3 square...

Geometry
Q

Brandon s retirement fund has an accumulated amount of 50 000 If it has been...

Basic Math
Q

A faucet can fill a bathtub in 6 minutes. The drain can empty the tub...

Basic Math
Q

Jim is competing on a game show He has 6 number tiles in front of...

Statistics
Q

Garcia Company sells snowboards. Each snowboard requires direct materials of $114, direct labor of $44,...

Accounting
Q

Analyzing and Computing Issue Price, Treasury Stock Cost, and Shares Outstanding Following is the stockholders'...

Accounting
Q

Red Herring will receive $11,000 a year for the next 18 years as a result...

Finance