Advanced: Formulation of initial tableau and interpretation of final tableau The Alphab Group has five divisions A,
Question:
Advanced: Formulation of initial tableau and interpretation of final tableau The Alphab Group has five divisions A, B, C, D and E. Group management wish to increase overall group production capacity per year by up to 30 000 hours. Part of the strategy will be to require that the minimum increase at any one division must be equal to 5% of its current capacity. The maximum funds available for the expansion programme are £3 000000.
Additional information relating to each division is as follows:
A linear programme of the plan has been prepared in order to determine the strategy which will maximise additional contribution per annum and to provide additional decision-making information. The Appendix to this question shows a print-out of the LP model of the situation.
Required:
(a) Formulate the mathematical model from which the input to the LP programme would be obtained.
(b) Use the linear programme solution in the Appendix in order to answer the following:
(i) State the maximum additional contribu¬
tion from the expansion strategy and the distribution of the extra capacity between the divisions. (3 marks)
(ii) Explain the cost to the company of providing the minimum 5% increase in capacity at each division. (3 marks)
(iii) Explain the effect on contribution of the limits placed on capacity and investment.
(2 marks)
(iv) Explain the sensitivity of the plan to changes in contribution per hour.
(4 marks)
(v) Group management decide to relax the 30000 hours capacity constraint. All other parameters of the model remain unchanged. Determine the change in strategy which will then maximise the increase in group contribution. You should calculate the increase in contribu¬ tion which this change in strategy will provide. (6 marks)
(vi) Group management wish to decrease the level of investment while leaving all other parameters of the model (as per the Appendix) unchanged.
Determine and quantify the change in strategy which is required indicating the fall in contribution which will occur.
(6 marks)
(c) Explain the limitations of the use of linear programming for planning purposes.
Step by Step Answer:
