Question: MAxx Inc. during the past six weeks indicate the number of jobs requests: WEEK 1 2 3 4 5 6 Requests (Actual) 46 40 38

MAxx Inc. during the past six weeks indicate the number of jobs requests:

WEEK

1

2

3

4

5

6

Requests (Actual)

46

40

38

42

44

45

Required: Predict the number of requests for Week 7 using each of the following methods:

a.. A four-period moving average.

b. Exponential smoothing with a = .40. Forecast for Week 1 was 50.

2. Two independent methods of forecasting based on judgment and experience have been prepared each month for the past 11 months

Compute MAD and MSE for each forecast.

The forecasts and actual sales are as follows:

Month

SALES (ACTUAL)

FORECAST I

FORECAST II

1

780

770

778

2

789

785

788

3

794

790

792

4

780

784

798

5

778

770

774

6

772

768

770

7

765

761

759

8

775

771

775

9

786

784

788

10

790

788

788

11 795 800 795

3. An electronics company is looking to develop a regression model to predict the number of units sold for a special running watch. Data is provided below:

Sales (units)

Price ($)

Advertising ($)

500

100

50

480

120

40

485

110

45

510

103

55

490

108

40

488

109

30

496

106

45

a. Should this company use both price and promotion dollars, or just one of them only, to determine the sales? Perform data analysis and Explain. b. Use the model you determined (multiple regression) to predict sales if price is set at $125 and advertising is $55.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!