Assumption $1$ Assume there will be $4000$ visits, each visit will yield $$1,400\mathrm{.}00$ of revenue Assumption $2$ Assume the pharmaceutical sales for this facility is $5000$ units @$$10\mathrm{.}10$ per unit Assumption $3$ Antically transportation revenue is based on $350$ patients a@ $$315$ per patient Assumption $4$ Physician salaries total $$500,000\mathrm{.}00$ Assumption $5$ RN salaries total $$310,000\mathrm{.}00$ Assumption $6$ Staff Salaries total $$275,000\mathrm{.}00$ Assumption $7$ Social Security contribution $$75,000\mathrm{.}00$ Assumption $8$ Medical Supplies purchases total $$205,000$ Assumption $9$ Housekeeping supplies purchased total $$$175,000\mathrm{.}00$ Assumption $10$ Office supplies purchased total $$56,000$ Based on the above information prepare an operating budget in EXCEl and use an inflationary figure of $1\mathrm{.}07\%$ for $4$ quarters in $2025.$ You should have $4$ columns, qtr $1,$ qtr $2,$ qtr$3,$ qtr $4$ Assumptions Qtr $1$ Qtr $2$ Qtr $3$ Qtr $4$