Business Finance Homework Help

I’m trying to learn for my Excel class and I’m stuck. Can you help?

Answer the following questions:

1) Define the different between linear and nonlinear optimization with example each? 

: 

2) 

A- How to calculate forecast error? (1 mark)

B- Calculate forecast error for December? (1 mark)

Month

Sales

Forecast

Error

September

5500

3000

———

October

7200

4150

———

November

8600

9100

———

December

9300

7900

3) 

A- How to calculate forecast weighted moving average? (1 mark)

B- Apply forecast weighted moving average formula for week 2. (1 mark)

(n = 2, W1 = 0.5, W2 = 0.8)

Week

Demand

1

7000

2

4000

3

3000

4

5000