Master of Science in Finance and Banking

AUTOMATED DECISION MAKING IN BUSINESS AND ECONOMICS

Davide Erminio Pirino

Teaching material

Data

» Code for Portfolio Frontier
data inserimento: 2026-10-13 15:29:42

» Sales_representative
data inserimento: 2026-09-26 15:11:48

» EmployeeData_OilCompany
data inserimento: 2026-09-26 15:11:48

» wholesaler_data
data inserimento: 2026-09-26 15:11:48

» exam_platform_reliability_markov
data inserimento: 2026-09-26 15:11:48

» Piviot_system_comparison
data inserimento: 2026-09-26 15:11:48

» warehouse_congestion_markiov
data inserimento: 2026-09-26 15:11:48

» fraud_review_queque_markov
data inserimento: 2026-09-26 15:11:48

» US_elections
data inserimento: 2026-09-26 15:11:43

» Titanic
data inserimento: 2026-09-26 15:11:43

» Property_portfolio_UK
data inserimento: 2026-09-26 15:11:43

» Property_portfolio_US
data inserimento: 2026-09-26 15:11:43

» Education_and_working_conditions
data inserimento: 2026-09-26 15:11:43

» World_bank_indicator
data inserimento: 2026-09-26 15:11:43

» Airplane_crashes
data inserimento: 2026-09-26 15:11:43

» Air_quality
data inserimento: 2026-09-26 15:11:43

» pivot_system_comparison
data inserimento: 2026-09-26 15:11:43

» BlueCoastAid_Template
data inserimento: 2026-09-26 15:11:43

» BlueCoastAid_Template_SOLVED
data inserimento: 2026-09-26 15:11:43

» Checkout_lane_staffing
data inserimento: 2026-09-26 15:11:43

» Corporate Employees data
data inserimento: 2026-09-26 15:11:43

» Online_retail
data inserimento: 2026-09-26 15:11:43

» portfolio_optimization_no_xslm
data inserimento: 2026-10-13 14:05:22

Instructions for setting the ribbon

» How to activate the Developer in Excel (macOS)
data inserimento: 2023-12-22 18:12:42

» How to activate the Developer in Excel (Windows)
data inserimento: 2023-12-22 18:12:46

» How to activate the Solver in Excel (macOS)
data inserimento: 2023-12-22 18:12:52

» How to activate the Solver in Excel (Windows)
data inserimento: 2023-12-22 18:12:57

Iterative_computations_templates

» Copeland_Galai.
data inserimento: 2026-03-24 11:51:28

» Copeland_Galai_SOLVED
data inserimento: 2026-03-24 18:07:11

» market_microstructure_model
data inserimento: 2026-03-24 12:29:00

» market_microstructure_SOLVED
data inserimento: 2026-03-24 18:07:58

» The_employee_bonus_problem
data inserimento: 2026-03-24 11:51:41

» The_greenhouse_heating_problem_SOLVED
data inserimento: 2026-03-24 11:51:52

» Two_cabin_room_problem_SOLVED
data inserimento: 2026-03-24 18:08:42

» Water_tank_problem_SOLVED
data inserimento: 2026-03-24 18:11:13

MOODLE

» How to log in
data inserimento: 2024-02-27 11:31:44

SLIDES

» Lecture 1: introduction to pivot tables.
data inserimento: 2026-09-14 17:23:55

» Lecture 2: tutorials on pivot tables.
data inserimento: 2026-09-16 18:16:08

» Lecture 3: markov chains, Simpson paradox and pivot tables
data inserimento: 2026-09-21 19:20:51

» Lecture 4: markov chains tutorials
data inserimento: 2026-09-24 14:53:13

» Lecture 5: foundations of VBA for EXCEL
data inserimento: 2026-09-24 14:52:26

» Lecture 6: VBA for decision-making
data inserimento: 2026-09-28 17:44:09

» Lecture 7: VBA for decision-making, part II
data inserimento: 2026-09-30 10:11:25

» Lecture 8: Solver foundations
data inserimento: 2026-09-30 17:11:43

» Lecture 9: Solver. The diet problem, the staff scheduling problem.
data inserimento: 2026-10-02 10:34:47

» Lecture 10: Solver. Integer optimality.
data inserimento: 2026-10-06 16:23:23

» Lecture 11: Solver and VBA for multiple optimizations.
data inserimento: 2026-10-07 16:14:21

» Lecture 12: Multiple objective functions, shortfalls and the minimum worst-shortfall compromise
data inserimento: 2026-10-08 18:14:25

» Lecture 13: Linked decision variables and optimal flows on networks
data inserimento: 2026-10-12 17:18:14

» Lecture 14: Newtork flow continued and Portfolio Optimization
data inserimento: 2026-10-13 16:16:32

» Lecture 15: Evolutionary solver
data inserimento: 2026-10-14 17:02:38

» Lecture 16: Cash flows, net present values and internal rate of return
data inserimento: 2026-10-15 18:04:24

Solutions of the mock exam

» Red wine producer problem
data inserimento: 2026-03-30 13:56:54

» Sardinia 12-node shortest path
data inserimento: 2026-03-30 17:09:46

Solver Exercises

» The outsourcing problem solved
data inserimento: 2026-03-25 19:12:45

» The tower problem solved
data inserimento: 2026-03-25 19:12:06

Template for Net Present Values

» Break even problem
data inserimento: 2026-03-18 14:06:13

» Cash flows Green Tech
data inserimento: 2026-03-18 13:26:16

» Geometric time series template
data inserimento: 2026-03-18 13:26:50

» NPV_monotonic_and_more
data inserimento: 2026-03-25 18:45:54

» NPV_monotonic_and_more
data inserimento: 2026-03-18 17:33:10

» The_bridge_problem
data inserimento: 2026-03-19 15:00:41

Templates for Pro Forma Financial Statements

» Cash_plug_and_projection_SOLVED
data inserimento: 2026-03-25 17:11:16

» Cash_plug_and_projection
data inserimento: 2026-03-25 15:39:35

» First_pro_forma
data inserimento: 2026-03-25 15:38:18