Question: I NEED EXCEL SOLVER SOLUTION!! Q1. (6 Marks) The U.S. government is attempting to determine whether immigrants should be tested (by a non-clairvoyant expert) for

I NEED EXCEL SOLVER SOLUTION!! Q1. (6 Marks) The

I NEED EXCEL SOLVER SOLUTION!!

Q1. (6 Marks) The U.S. government is attempting to determine whether immigrants should be tested (by a non-clairvoyant expert) for a contagious disease. Assume that the decision will be made on a financial basis. Furthermore, assume that each immigrant who is allowed to enter the United States and has the disease costs the country $100,000. Also, each immigrant who is allowed to enter the United States and does not have the disease will contribute $10,000 to the national economy. Finally, assume that x percent of all potential immigrants have the disease. The U.S. government can choose to admit all immigrants, admit no immigrants, or test immigrants for the disease before determining whether they should be admitted or not. It costs T dollars to test a person for the disease, and the test result is imperfect and is either positive or negative. A person who does not have the disease always tests negative. However, 10% of all people who do have the disease test negative. The government's goal is to maximize the expected net financial benefits per potential immigrant. = a. If x 10%, what is the largest value of T at which the U.S. government will choose to test potential immigrants for the disease? b. How does your answer to the question in part a change if x increases to 15%? c. If x = 5% and T = $500, what is the government's optimal strategy

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!