Question
Provide solution using Word or excel with all the necessary calculations.