Question Instructions: Complete all the sub-parts. Typed solution needed (either in Word or in excel). Handwritten solution will not be accepted. If you are submitting the solution in excel, make sure you use all the excel formulas and functions. Do not use AI.