The outcomes of the components show that our current budget allows for a savings rate of 5.9%. This is a fairly good savings fee. The absolute reference shown for cell D2 prevents the cell from changing when the method is…