Business Question

Hello , i have this busniness assignment , the instruction’s are clear , i need simple work and without ai please no complex work. You need to solve the excel i sent you