Business Analytics

Question part

Comments

Total Mark

47

A

The report does not address the question at all. The mathematical model is mostly correct in the Excel file, except for the door constraint. However there is no evidence of Solver being used to obtain the optimal solution. The graph is incomplete, since objective function is needed and feasible region needs to be highlighted.

(out of 20)

12

B

There is some reasoning as of why the marketing campaign should not take place. However we also need quantitative evidence from Solver to support the idea. There is no evidence of any computation of optimal results in the Excel file.

(out of 6)

3

C

New labour hour is correctly computed as 60,000. The answer is correct but could be more focused.

(out of 6)

6

D

No answer provided

(out of 6)

0

E

New constraints are stated correctly. The optimal result is not reported fully.

(out of 6)

4

F

The answer was given but without any computation or evidence. The explanation of “not optimal resource” does not make sense.

(out of 6)

1

G

Optimal solution is correct but the profit is wrong. There is no evidence of such computation in the Excel file either.

(out of 6)

3

H

The constraint is updated but the optimal solution is wrong. There is no evidence of such computation in the Excel file either.

(out of 6)

1

I

The answer is correct in a sense that there is no solution if the demand for Leisure Cruiser is fully met. The discussion is not entirely relevant.

(out of 6)

5

J

No concrete answer is provided. There is some arguments about why advertising campaign and extra labour hours are not needed.

(out of 6)

2

K

The sensitivity report is not generated correctly. There is some comparison between different profit levels associated with different mixes of products.

(out of 16)

5

Presentation

The report does not address the questions asked at all. Instead there is irrelevant description/ analysis that is completely unrelated from the Excel file. The structure is clear. The Executive summary provides various solutions in a quite confusing manner. The conclusion mentions analysis that have not been discussed or undertaken in the main body.

(out of 10)

5