The sensitivity report of the above LP problem solved using Excel Solver is as shown below. Variable Cells

Final Name Value

Upper West 206 Ashanti 0 Brong Ahafo 512

Constraints

Final Name Value

Pesticides Available_ 883 Transport Cost 110000

Reduced Cost

0 -1941 0

Shadow Price

_ 0 44

Objective Coefiicient

5000 3000 6000

Constraint R.H. Side

1000_ 110000

Allowable Increase

400 1941 2143

Allowable Increase 1E+30 9652

Allowable Decrease

3000 1E+30 20.4

Allowable Decrease

118_____ 14000___

--_N2x11>.L9_t.25=i1i$I._-_--....-.gQ9--._--_-.l2Z.-..-._._.QQ--.-.-..-...-_.5.91.._._..-.-_.___ Political constraint 1 -653 0 0 1E+30 653

Northem vs Upper West 0 2353 0 233 317

b. What is the amount that is recommended to be sent to the respective regions and what is the total savings expected from following such plan? (3 marks)

c. Will the suggested allocation change if the per gallon savings from Upper West region were to increase by GH 600?

. From the model, there are some pesticides lefi, yet no pesticide is to be sent to the Ashanti region. In your view, what do you think is necessitating. this? (3 marks)

ii. NADMO officials know that it will be a political suicide not to send any pesticide to the Ashanti region although doing so will hurt the overall savings. Suppose they decide to send the pesticides left to the Ashanti region, what impact will this have on the total savings? (3 marks)

e. How will you interpret the shadow price of transportation cost of GH 44