ON EXCEL:

1.ACCOUNTS FOR THE CORRECT NUMBER OF DEALS

2.COMPUTES GOVERNMENT AGGREGATION SCORE FOR ALL COMBINATIONS

3.COMPUTES DRIVERS SCORE FOR ALL COMBINATION

4.PROVIDES A PLOT OF GOVERNMENT AND DRIVERS AGGREGATE SCORE. IDENTIFIES EFFICIENT FRONTIER

5.IDENTIFY THE MOST EFFICIENT DEAL.

6. IDENTIFY THE PROPOSAL DEAL

7. CLEALY STATE OF ALL ASSUMPTIONS

8.PROVIDES A SUMMATION THAT INCLUDES REASONING FOR SELECTION OF MOST EFFICIENT AND PROPOSED DEAL

The Truck Drivers' Dispute Case Study A non-EU European country has recently been paralyzed by the direct action of truck drivers who are angry at a package of regulations that the government is considering introducing. Discussion between the government and representatives of the truck drivers is now taking place at a secret location to try to resolve the dispute. Three issues need to be resolved: 1. the maximum number of hours the drivers can legally drive per day, 2. whether or not the government will introduce a special fuel tax and 3. whether or not charges will be made against ten drivers who have been arrested during the dispute. The possible number of driving hours that could be agreed are given below, together with the chief government negotiator's rough assessment of the values which each side would place on each outcome (100 = best outcome, 0 = worst outcome). Max. No. of driving hours Drivers' value Government value 11 100 0 10 60 80 9 40 90 8 0 100 For the fuel tax issue, only two levels are possible - either the tax will be imposed or not. However, for the arrested drivers three outcomes are possible i) serious charges ii) minor charges and iii) charges dropped. Estimates of the values that the negotiating parties put on these outcomes are set out below. Level of charges Drivers' value Government value Serious 0 100 Minor 80 90 No charges 100 0 The government's negotiator has also estimated weights to reflect the relative importance that the parties attach to swings from the worst to best position on each issue. For the drivers avoiding reducing the maximum number of driving hours from 11 to 8 is thought to be the most important swing. Avoiding the introduction of the fuel tax is thought to be only 10% as important as this, while the reduction of the level of charges against the arrested workers from serious to no charges is 50% as important. For the government introducing the fuel tax is the most important swing. Reducing the maximum number of driving hours from 11 to 8 is 60% as important as this, while avoiding reducing the level of charges against the drivers from serious to no charges is only 40% as important. The following tentative deal has been reached: 1. Reduce the maximum number of driving hours to 9 2. Impose the fuel tax 3. Make no charges against the arrested drivers. Question Apply decision analysis to the truck drivers' negotiation problem and advise the participants on their decision problem. Clearly state any assumptions you have made