DEPARTMENT PERFORMANCE TRACKING $(2$ questions$)$: John, our department head, needs to provide an overview to the company's leadership team regarding the savings that our department has been having. He asked for our help to prepare a summary. $1$ Based on the run$-$rate savings and on the project implementation dates, calculate the total $2015$ in$-$year savings across all projects.

$>$ Run$-$rate savings $=12$ month savings starting on the date of the implementation of the project

$>2015$ in$-$year savings $=$ the savings that the project will deliver within the $2015$ calendar year $($January $1$st to December $31$st$)$

$>$ For example, a project that has a run$-$rate savings of $$1\mathrm{.}0$M and is implemented on February $1$st will have a $2015$ in$-$year savings of $$912$K $($there are $333$ days of the year remaining; $$1\mathrm{.}0$M$/365$ days $*333$ days remaining $=$ $$912$K savings within $2015)$ Go to dep sumart for Answer$2$ Please fill out the summary tab with the required information to present to the leadership team. Use conditional formatting to format the "TOTAL ALL PROJECTS" column based on whether it is above or below the target. $($See "Dept Summary" tab$)$