Hello,

What formula can I use to fill the remaning values and answer the questions 3A-3F? I have to use the Margin %, G&A % and Bonus %

\begin{tabular}{|c|c|} \hline 3A) & Which employee generated the highest profit for the company? \\ \hline (3B) & Did your company at least break even? \\ \hline 3C) & What was the total bonus you paid out in year 2 ? Round to two decimal places. \\ \hline 3D) & At what bonus % would you break even given actual sales results? Round to at least 4 decimal places. \\ \hline 3E) & What bonus \% would allow you to earn an additional $500,000 versus last year? Round to at least 4 decimal places. \\ \hline 3F) & Copy and paste vour chart below per the instructions. \\ \hline \end{tabular} \begin{tabular}{|c|c|} \hline 3A) & Which employee generated the highest profit for the company? \\ \hline (3B) & Did your company at least break even? \\ \hline 3C) & What was the total bonus you paid out in year 2 ? Round to two decimal places. \\ \hline 3D) & At what bonus % would you break even given actual sales results? Round to at least 4 decimal places. \\ \hline 3E) & What bonus \% would allow you to earn an additional $500,000 versus last year? Round to at least 4 decimal places. \\ \hline 3F) & Copy and paste vour chart below per the instructions. \\ \hline \end{tabular}