ASSIGNMENTS:

Conduct one variable data table analysis for Net Profit After Taxes $($NPAT$)$ for $2025$ by varying SGR on the following set of rates: $15\mathrm{.}0\%,16\mathrm{.}0\%,17\mathrm{.}0\%,18\mathrm{.}0\%,19\mathrm{.}0\%,20\mathrm{.}0\%$

Q$1.$ Find the SGR value which yields the highest NPAT.

Let the above value be the value for SGR in this question. In this second question, we conduct two$-$variable data table analysis by varying Salary & Benefits on the set of rates: $25\mathrm{.}0\%,26\mathrm{.}0\%,27\mathrm{.}0\%,28\mathrm{.}0\%,29\mathrm{.}0\%,30\mathrm{.}0\%$; and varying Advertising on the set: $2\mathrm{.}5\%,3\mathrm{.}0\%,3\mathrm{.}5\%,4\mathrm{.}0\%.$ Altogether there are $24$ combinations.

Q$2.$ Identify which combination of values yields the highest value of NPAT.

Q$3.$ Show the Pro Forma income statement based on the SGR$.$