Cardiff College
College of Arithmetic
Daniel Gartner, PhD, SFHEA
Chair of Operational Analysis
Supply Chain Modelling Resit Coursework
Please ship the coursework submission paperwork to: Daniel Gartner ([email protected]) by Friday, 12th August 2022, 12 (midday) GMT. The coursework could be performed alone or in teams of as much as
2 members. I belief you already know higher with whom you wish to do the coursework or whether or not you favor
doing it alone. Please e-mail your options in a single attachment (ZIP file).
Please just remember to embrace names and scholar IDs of all of your group members in
your electronic mail and coursework paperwork.
Half 1
Contemplate the technology/transmission capability growth drawback in Prof. Jim Luedtke’s slides:
https://cnls.lanl.gov/Exterior/GSSlides2021/Luedtke.pdf slides 2–5. We wish to examine the
Deterministic Mannequin with the Two-Stage Stochastic Downside.
Questions / Duties to finish:
(a) Utilizing MSWord or LATEX, write down the units, indices and parameters, choice variables, goal
perform and constraints for the deterministic drawback.
(b) Increase on (a) and write down the stochastic mannequin and extensions by way of parameters and so forth.
(c) Create an Excel Spreadsheet for the enter parameters (knowledge) of the deterministic drawback. As a
begin, you should utilize the dataset supplied in slide 26 however clearly you calculate the common demand
for the deterministic mannequin.
(d) Create an Excel Spreadsheet for the enter parameters (knowledge) of the stochastic drawback. Once more, you
can use the parameters from slide 26 plus use some random situations / knowledge for the capacities Ci
.
Notice that c) and d) have to match as much as permit a like for like comparability. Meaning the averages
from the stochastic drawback parameters needs to be the anticipated values used within the deterministic
drawback.
(e) Implement the Deterministic Mathematical Mannequin in Excel utilizing OpenSolver1
(f) Implement the Two-stage stochastic Mannequin in Excel utilizing OpenSolver1
(g) Run each fashions and supply the target perform worth and the worth of all choice variables. Present assessments concerning the usefulness of each the deterministic and stochastic mannequin, comparable
to Maggioni and Wallace (Annals of OR, 2012, https://hyperlink.springer.com/article/10.1007/
s10479-Zero10-0807-x).
1
You probably have a Mac and OpenSolver doesn’t work, please use Excel Solver. Nonetheless, the variety of
constraints is proscribed to 200. So you must preserve the scale of your drawback small to make the mannequin work.
Half 2
COVID-19 has disrupted provide chains world-wide. Utilizing not more than four (4) A4 pages (LATEXor
Phrase), please full the next duties:
ˆ Create a framework of not more than 5 classes to classify literature within the area of COVID-19
associated provide chain disruptions. We wish to give attention to journal articles and convention proceedings
solely. You might borrow frameworks from that literature.
ˆ Utilizing the scopus.com search engine, discover 10 or extra papers within the Operational Analysis / Management Science literature and classify the papers into your framework.
1
ˆ Clarify in your search
– what papers have in frequent,
– the place analysis gaps are,
– tendencies in analysis, and
– whether or not the fashions have been utilized in practise (present e.g. the names of firms).
2