Load the Solver add$-$in$,$ and create two more scenarios as follows:

$$ 'Optimistic' scenario $-$ the Grand Total is $$7,000,000.$

$$ 'Pessimistic' scenario $-$ the Grand Total is $$5,000,000.$