MGT425 (Course Name: Spreadsheet Decision Modeling)

Please don't write by hand

if you can put reference please

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

2)How to calculate forecast error?

3)How to calculate forecast weighted moving average?

4)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