Problem $1.[$Ref: Lecture $2\mathrm{.}1$ through $2\mathrm{.}5]$

An elementary school in Topeka is tasked with documenting their expenses for Budget purposes. The data collected with respect to the school's categorical expenses are tabulated in the worksheet titled 'Budget Detail'. The summarized budget details that are required to be presented to the Board of Education $($BOE$),$ requesting additional funding is included in the worksheet named 'Budget Summary'.

$($a$)$ Follow the Lectures $2\mathrm{.}1$ through $2\mathrm{.}3$ to fill up the various cells with calculation results, obtained from appropriate Excel functions. Start with populating the Budget Detail worksheet. $-35$ Points

$($b$)$ Now move to the 'Transportation Payments' worksheet tab, and obtain the Payment information, monthly $-$ Per bus and for all buses respectively $($Should use the PMT Excel Function$)-20$ Points

$($c$)$ Now use the information in both 'Budget Detail' and 'Transportation payments' worksheets in the 'Budget Summary' worksheet to obtain the amount of money that is remaining $/$ deficit. Complete the 'Budget Summary Worksheet as explained in the lecture. $-30$ Points

$($d$)$ If the calculations in $($c$)$ show a positive balance $($more money remaining when compared to the BOE grant$)$ then explain how you would like to use that amount for the school this year? If the calculations show a deficit amount, explain if you have a strategy to reduce the costs or request for additional funding from the BOE. $-15$ Points$\backslash$table$[[\backslash$table$[[$Annual School Budget Report$],[$for Topeka Elementary$]]],[,,50,000$