Read the following scenario (attached) and use the Week 4 Assignment Template [XLSX] to complete this assignment. (attached) Specific directions are included in the template. Make sure to complete all tabs for Parts 1 and 2 and follow the directions given in each. Note that you must add functionality to the appropriate spreadsheets to make the proper calculations.