BUDGETING AND FORECASTING WEEK 1: LAB ASSIGNMENT

Requirements:

Moving Averages. Use the below actual sales to calculate a three-year average which will be used as the forecast for next periods (chapter 14, text).
Exponential Smoothing. Use the same data to forecast sales for the next periods with α=.40 (chapter 14, text).
Regression Analysis on Excel. Draw a scatter graph from Insert/Graph/Scatter graph selections in Excel (chapter 15, text).
Month

Connect with a professional writer in 5 simple steps

Please provide as many details about your writing struggle as possible

Academic level of your paper

Type of Paper

When is it due?

How many pages is this assigment?

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

 

“Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!”


BUDGETING AND FORECASTING WEEK 1: LAB ASSIGNMENT was first posted on November 2, 2019 at 4:12 pm.
©2019 "Maths Work Help". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement. Please contact me at admin@mathsworkhelp.com