Assume that you are working in a software development company. The company is trying to decide whether or not to submit two project proposals for developing two new software products: DSS1 and ERP2 for a government department. The company has the following three options : a. Submit proposal A for developing DSS1 only; or b. Submit proposal B for developing ERP2 only; or c. Submit proposal C for developing both DSS1 and ERP. There are initial costs for submitting these proposals. These costs are recovered from the product price if a proposal is successful (approved). However, if the proposal is rejected (unsuccessful) the company will have made a loss. The cost of submitting proposal A is 50,000. The component supply cost if this proposal is successful would be 18,000. The cost of submitting proposal B only is 14,000. The component supply cost if this proposal is successful would be 12,000. The cost of submitting proposal C is 55,000. The component supply cost if this proposal is successful would be 24,000. Based on subjective assessment, the probabilities of getting proposals successful with particular product prices were estimated as shown below:

Option	Proposed price	Probability of getting the proposal successful
proposal A for developing DSS1	130,000	0.80
proposal B for developing ERP2	70,000	0.85
proposal C for developing both DSS1 and ERP	190,000	0.75

a) Construct a decision table using MS Excel to find the best option. b) Use Excel Goal Seek Feature to find out what proposal price will make the expected vlaue for the best option found in (a) reach 10000. c) Use Excel's Scenario Manager analysis tool to run the following Scenarios:

Option	Proposed price	Probability of getting the proposal successful
Scenario 1	Scenario 2	Scenario 3
proposal A for developing DSS1	150,000	0.80	0.80	0.75
proposal B for developing ERP2	90,000	0.85	0.85	0.65

proposal C for developing both DSS1 and ERP

200,000

0.95

0.72

0.50

The steps and marks for each step are given below:

Task	Marks
Identify Decision Variables	10
Formulate Objective Function	10
Constructing a decision table using MS Excel	30
Construct a decision table using MS Excel	15
Conducting Scenario analysis	15
Report and Result	20
Total	100