QUESTION

# Coffee Cafe You must design and run an optimization model using Solver Add-in Excel for a coffee caf.

Constraints:

1.     Resources Used < = Resources Available.

2.     If the Milk is not completely used, it will go waste. (You want to avoid this)

3.     You need to use at the minimum 125 tea bags each month.

4.     You need to sell a minimum reasonable amount of each type of beverage. What is the reasonable amount: You need to     decide yourself?

Requirements

1.     Maximum profit; given the constraints and resources available.

3.     Submit your recommendation and the excel sheet on blackboard.

a.     You can write the recommendation in Excel or MS Word (both are acceptable)

Question II

Answer the question for two scenarios

1.     Say that a neural network based model has been constructed to predict the creditworthiness of an applicant for approving Loan. The output of model is in range 0 to 1. With “0” meaning BAD NEWS - Loan NOT Approved and “1” meaning very Good News - Loan Approved.

·        Applicant A receives a score of 0.83

·        Applicant B receives a score of 0.56

·        Applicant C receives a score of 0.26

As a loan approving officer, please rate the applicants under following category: High Risk, Medium Risk or Low Risk and whether you would  approve their loan. Justify your answer?

2.     Say that a neural network based model has been constructed to predict the cancer probability of a patient. The output of model is in range 0 to 1. With “0” meaning BAD NEWS – Patient has cancer and “1” meaning Good News – Patient is completely cancer free.

·        Patient A receives a score of 0.83

·        Patient B receives score of 0.56

·        Patient C receives a score of 0.26

As a physician, how would rate each patient: High Risk, Medium Risk or Low Risk and which patient would you classify as having cancer. Justify your answer?