Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions