promote company’s newly created cryptocurrency

Final Exam – BAN 5573, Clark University, Spring 2022
Problem 1) Assume that you are hired in Jonas Blockchain that is a Blockchain startup company. Your
manager planned to promote company’s newly created cryptocurrency in Massachusetts. There five major
media outlets for this marketing promotion: Social Medias, TV shows, Newspapers, Radio, and Sport
Sponsorship. The ads are intended to reach seven different cities of: Worcester, Boston, Springfield, Lowell,
Salem, Cambridge, and Pittsfield.
The following table provides the number of previous exposures obtained in each of the cities in the media

Exposure obtained by investing 1000$ in the media outlets in the cities
Worcester Boston Springfield Lowell Salem Cambridge Pittsfield
Social Medias 5,000 10,000 40,000 10,000 2,000
TV shows 5,000 25,000 5,000 8,000
Newspapers 25,000 8,000 5,000
Radio 10,000 5,000 5,000
Sport Sponsorship 8,000 5,000 10,000 10,000 4,000

The next table explain the minimum required exposures in each city. The last row shows the saturation cap.
The company thinks exposure beyond this cap has no value.

Exposure constraints in each city
Worcester Boston Springfield Lowell Salem Cambridge Pittsfield
required exposure
30,000 35,000 65,000 110,000 45,000 15,000 10,000
Saturation Cap 75,000 65,000 110,000 150,000 70,000 35,000 60,000

1-1) How much money should be spent in each media if you are limited to 15,000$ (50 points)?
Final Exam – BAN 5573, Clark University, Spring 2022
1-2) Identify the binding constraints (10 points).
Instructions & Hints:
1- You are open to have your own considerations. However, exclude having integer values to be able
to report binding constrains.
2- Use a text file (preferably MS-World) to explain your taught process and writing your constraints
and answering part “b”. This is the report file part that you upload.
3- You are open to employ either Excel or LINGO to execute. You should upload this execution file
and the results should be in accordance with your report file.
4- If there is an empty cell, it means you do not have any previous information, then disregard that
5- Do not worry if you have a lot of decision variables or you have a long objective function. There
are some innovative ways that you can have a smaller objective function but it is not necessary to
have a short objective function.
Problem 2) Find “titanic.csv” predict survival of passengers (40 points).
Instructions & Hints:
1- Your evaluation is based on your efforts in data preparation and prediction
2- Submit a Knime workflow (python and R are acceptable, too) and report text file.
3- In your report, you can explain your taught process and what you did.
4- If you have some modification in your “titanic.csv” file outside of Knime, then explain what you
did in the report file and upload your modified file, too. I should be able to replicate your workflow
then I should have the input file if you modified it.
5- This is your data dictionary:
PassengerId: identification number of each passenger
Survived: Survival (0 = No, 1 = Yes)
Pclass: Ticket class (1 = 1st, 2 = 2nd, 3 = 3rd)
Name: passenger name
Sex: Sex
Age: Age in years
Sibsp: # of siblings / spouses aboard the Titanic
Parch: # of parents / children aboard the Titanic
Ticket: Ticket number
Fare: Passenger fare
Cabin: Cabin number
Embarked: Port of Embarkation (C = Cherbourg, Q = Queenstown, S = Southampton)

Final Exam – BAN 5573, Clark University, Spring 2022
General Instructions of the Final Exam:
1- This is an individual exam; then professionalism is expected. It includes never sharing your taught
process with others.
2- You can ask your questions through Class chatroom and emails.
3- The exam supposed to have 24hours to return but it is already extended. The exam is downloadable
from noon 5/2/2022 and must be returned by 23:59 5/4/4/2022. Since it is already extended, no late
return is accepted.
4- The exam has 100 points and it accounts for 35% of credits in the course. For more information,
please check your syllabus.