Answer
e.Yes, it is cost effective to switch suppliers as total cost reduces from $3.744 to $3.060 and hence Groundz should switch. Please check the calculations.
The answer and procedures of the exercise are attached in a microsoft excel document.
Explanation
Please consider the data provided by the exercise. If you have any question please write me back. All the exercises are solved in a single sheet with the formulas indications.