Question

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