Could you answer in detail below Spreadsheet Modelling question:

Identify a problem statement where one or more decision$($s$)$ need to be made or where a situation

needs to be evaluated. Provide a detailed description of the problem citing appropriate sources for

your information$/$data and specify the assumptions you are making. Prepare the influence diagram,

black$-$box diagram and model layout$/$design for the problem.

$$ Implement the base case model in Excel. How did you select the base case values?

$$ Perform suitable what$-$if analyses to get a better insight about the problem at hand. How does such

an analysis help you with the decision or evaluation of the situation?

$$ Can you apply optimization techniques to your problem? If yes, how? If no$,$ why not?