Answered step by step
Verified Expert Solution
Question
1 Approved Answer
begin{tabular}{|c|c|c|c|c|} hline multicolumn{1}{|c|}{ Base sales } & Margin Rate (% Sales) & G&A Expense Rate excluding Bonus (% Sales) & Bonus Rate (to begin) &
\begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{1}{|c|}{ Base sales } & Margin Rate (\% Sales) & G\&A Expense Rate excluding Bonus (\% Sales) & Bonus Rate (to begin) & Sale Increase (to begin) \\ \hline$2,652,500 & 33.35% & 11.50% & 0.00% & 0.00% \\ \hline$579,571.25 & & & \\ \hline \end{tabular} \begin{tabular}{|lr|r|} \hline & Year 1 & \multicolumn{1}{c|}{ Year 2 } \\ \hline Margin \% & 33.35% & 33.35% \\ \hline G\&A \% & 11.50% & 11.50% \\ \hline Bonus \% & 0.00% & 5.00% \\ \hline \end{tabular} \begin{tabular}{|l|r|r|rr|} \hline Salesperson & \multicolumn{1}{|c|}{Year1Sales(beforebonus)} & \multicolumn{2}{c|}{Year2Sales(afterbonus)} \\ \hline Salesperson 1 & $ & 875,995 & $ & 946,074 \\ \hline Salesperson 2 & $ & 1,183,697 & $ & 1,491,458 \\ \hline Salesperson 3 & $ & 962,288 & $ & 1,000,779 \\ \hline Salesperson 4 & $ & 856,399 & $ & 873,526 \\ \hline Salesperson 5 & $ & 1,239,103 & $ & 1,474,532 \\ \hline Salesperson 6 & $ & 1,232,842 & $ & 1,417,768 \\ \hline Salesperson 7 & $ & 1,356,182 & $ & 1,410,429 \\ \hline Salesperson 8 & $ & 815,084 & $ & 921,044 \\ \hline Salesperson 9 & $ & 1,239,670 & $ & 1,413,223 \\ \hline Salesperson 10 & $ & 1,156,569 & $ & 1,202,831 \\ \hline Salesperson 11 & $ & 827,073 & $ & 901,509 \\ \hline Salesperson 12 & $ & 1,018,172 & $ & 1,028,353 \\ \hline Salesperson 13 & $ & 869,221 & $ & 1,008,296 \\ \hline Salesperson 14 & $ & 976,406 & $ & 1,025,226 \\ \hline Salesperson 15 & $ & 879,819 & $ & 1,020,590 \\ \hline Salesperson 16 & $ & 1,079,606 & $ & 1,403,487 \\ \hline Salesperson 17 & $ & 1,025,090 & $ & 1,127,599 \\ \hline Salesperson 18 & $ & 1,359,048 & $ & 1,549,314 \\ \hline Salesperson 19 & $ & 958,808 & $ & 1,169,745 \\ \hline Salesperson 20 & $ & 1,291,729 & $ & 1,666,330 \\ \hline Salesperson 21 & $ & 1,219,048 & $ & 1,316,571 \\ \hline Salesperson 22 & $ & 866,953 & $ & 1,101,030 \\ \hline Salesperson 23 & $ & 927,162 & $ & 1,103,322 \\ \hline Salesperson 24 & $ & 1,291,976 & $ & 1,472,852 \\ \hline Salesperson 25 & $ & 1,017,060 & $ & 1,169,619 \\ \hline & & & & \\ \hline \end{tabular} Total$26,525,000$30,215,507 Answers Below: \begin{tabular}{|l|l|} \hline 1A) & What is your company's current profit? Round to two decimal places. \\ \hline 1B) & At what bonus \% do you break even with a 10% sales increase? Round to at least 4 decimal places (e.g., 0.0000%) \\ \hline 1C) & What sales increase \% is needed to break even with a 5% bonus? Round to at least 4 decimal places. \\ \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 pasteyour chart below per the instructions. \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{1}{|c|}{ Base sales } & Margin Rate (\% Sales) & G\&A Expense Rate excluding Bonus (\% Sales) & Bonus Rate (to begin) & Sale Increase (to begin) \\ \hline$2,652,500 & 33.35% & 11.50% & 0.00% & 0.00% \\ \hline$579,571.25 & & & \\ \hline \end{tabular} \begin{tabular}{|lr|r|} \hline & Year 1 & \multicolumn{1}{c|}{ Year 2 } \\ \hline Margin \% & 33.35% & 33.35% \\ \hline G\&A \% & 11.50% & 11.50% \\ \hline Bonus \% & 0.00% & 5.00% \\ \hline \end{tabular} \begin{tabular}{|l|r|r|rr|} \hline Salesperson & \multicolumn{1}{|c|}{Year1Sales(beforebonus)} & \multicolumn{2}{c|}{Year2Sales(afterbonus)} \\ \hline Salesperson 1 & $ & 875,995 & $ & 946,074 \\ \hline Salesperson 2 & $ & 1,183,697 & $ & 1,491,458 \\ \hline Salesperson 3 & $ & 962,288 & $ & 1,000,779 \\ \hline Salesperson 4 & $ & 856,399 & $ & 873,526 \\ \hline Salesperson 5 & $ & 1,239,103 & $ & 1,474,532 \\ \hline Salesperson 6 & $ & 1,232,842 & $ & 1,417,768 \\ \hline Salesperson 7 & $ & 1,356,182 & $ & 1,410,429 \\ \hline Salesperson 8 & $ & 815,084 & $ & 921,044 \\ \hline Salesperson 9 & $ & 1,239,670 & $ & 1,413,223 \\ \hline Salesperson 10 & $ & 1,156,569 & $ & 1,202,831 \\ \hline Salesperson 11 & $ & 827,073 & $ & 901,509 \\ \hline Salesperson 12 & $ & 1,018,172 & $ & 1,028,353 \\ \hline Salesperson 13 & $ & 869,221 & $ & 1,008,296 \\ \hline Salesperson 14 & $ & 976,406 & $ & 1,025,226 \\ \hline Salesperson 15 & $ & 879,819 & $ & 1,020,590 \\ \hline Salesperson 16 & $ & 1,079,606 & $ & 1,403,487 \\ \hline Salesperson 17 & $ & 1,025,090 & $ & 1,127,599 \\ \hline Salesperson 18 & $ & 1,359,048 & $ & 1,549,314 \\ \hline Salesperson 19 & $ & 958,808 & $ & 1,169,745 \\ \hline Salesperson 20 & $ & 1,291,729 & $ & 1,666,330 \\ \hline Salesperson 21 & $ & 1,219,048 & $ & 1,316,571 \\ \hline Salesperson 22 & $ & 866,953 & $ & 1,101,030 \\ \hline Salesperson 23 & $ & 927,162 & $ & 1,103,322 \\ \hline Salesperson 24 & $ & 1,291,976 & $ & 1,472,852 \\ \hline Salesperson 25 & $ & 1,017,060 & $ & 1,169,619 \\ \hline & & & & \\ \hline \end{tabular} Total$26,525,000$30,215,507 Answers Below: \begin{tabular}{|l|l|} \hline 1A) & What is your company's current profit? Round to two decimal places. \\ \hline 1B) & At what bonus \% do you break even with a 10% sales increase? Round to at least 4 decimal places (e.g., 0.0000%) \\ \hline 1C) & What sales increase \% is needed to break even with a 5% bonus? Round to at least 4 decimal places. \\ \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 pasteyour chart below per the instructions. \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started