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

Q

1 Write as a single power Express your answers with positive exponents a 5 5...

Basic Math
Q

An All-Pro defensive lineman is in contract negotiations. The team has offered the following salary structure:...

Finance
Q

how do i find the percentage of total value

Accounting
Q

Solomon Company is a retail company that specializes in selling outdoor camping equipment. The company is...

Accounting
Q

2 What are some similarities and differences that you noticed between transcription and replication

Biology
Q

A bead of mass m is attached to lower end of a light inextensible thread...

Physics
Q

new In the twentieth century it was a common practice in Southern California for houses...

Statistics
Q

Why use three libraries development, test and production in information technology function?

Accounting
Q

In incremental analysis: A) all cost are relevant if they change between alternatives. B) only...

Accounting
Q

Find and download the basic financial statements of a citys website and analyze the two...

Accounting
Q

Carlberg Company has two manufacturing departments, Assembly and Painting. The Assembly department started 11,100 units...

Accounting
Q

PR 7-4B Periodic inventory by three methods The beginning inventory for Dunne Co. and data...

Accounting