Q8. Consider instead the \% profit to sales. (a) What is DTGC's profit per kit? (b) What is the revised \$C? Use this revised $C to figure out RLS (i) in \#kits and (ii) in dollars? (must use =roundup in calculating \#RLS and then calculate $RLS =#RLS USP per kit of DTGC) Q9. What is the size of the 2021 total market in the number of kits? Hence, what is DTGC's target \% market share units for (a) breakeven, (b) \$profit goal, and (c) \% profit goal? Q10. What is the size of the 2021 total market in dollars? Hence, what is DTGC's target \% market share dollars for (a) breakeven, (b) \$profit goal, and (c) \% profit goal? A B 53 OUTPUTS SECTION 54 55 Question 1 56 Weighted Unit Selling Price retail 57 Unit Selling Price wholesale 58 Unit Selling Price DTGC $$$97.0068.7946.78 59 60 Question 2 61 Unit Selling Price DTGC using markup chain $46.78 62 63 Question 3 \begin{tabular}{r|l|rr} 64 & Material and labor UVC & $ & 21.05 \\ 65 & Packaging and Shipping UVC & $ & 2.52 \\ 66 & Commission UVC & $ & 3.27 \\ 67 & Therefore, UVC of a kit & $ & 26.85 \end{tabular} 68 69 Question 4 72 73 Question 5 \begin{tabular}{r|l|rr} 74 & Loan repayment and maintenance & $ & 70,000.000 \\ 75 & New salesforce salary & $ & 288,000.00 \\ 76 & New salesforce travel & $ & 88,000.00 \\ 77 & Direct mail pieces cost & $ & 81,000.00 \\ 78 & In flight magazine advertising & $ & 72,000.00 \\ 79 & Trade show registration & $ & 42,000.00 \\ \hline 80 & Trade show staffing & $ & 18,000.00 \\ \hline 81 & Total Fixed Costs & $ & 659,000.000 \end{tabular} 82 83 Question 6 84 \#BEP, number of kits to be sold for BEP 85 \$BEP, \$ sales of kits BEP 33,064$1,546,738.61 86 87 Question 7 \begin{tabular}{l|l|r} 88 & Tortal Fixed Costs plus \$ Profit Goal & $949,000.000 \\ 89 & \#RLS, number of kits to be solved for \$ Profit & 47,614 \\ 90 & \$RLS, \$ Sales of kits for \$ Profit Goal & $2,227,389.67 \end{tabular} 91 92 Question 8 93 Desired \$ profit per kit to achieve \% profit to sales goal 94 Revised \$C of a kit 95 \#RLS to achieve \%profit to sales goal 96 \$RLS to achieve \% profit to sales goal 97 98 Question 9 99 Size of the total market in units for 2021 100% market share for \#BEP 101 \% market share for \#RLS for \$ Profit Goal 102 \% market share for \#RLS for \% profit to sales goal A 104 Question 10 105 Size of the total market in $ for 2021 106 \% market share for \$BEP 107 \% market share for \$RLS for \$ Profit Goal 108 \% market share for \$RLS for \% profit to sales goal Q8. Consider instead the \% profit to sales. (a) What is DTGC's profit per kit? (b) What is the revised \$C? Use this revised $C to figure out RLS (i) in \#kits and (ii) in dollars? (must use =roundup in calculating \#RLS and then calculate $RLS =#RLS USP per kit of DTGC) Q9. What is the size of the 2021 total market in the number of kits? Hence, what is DTGC's target \% market share units for (a) breakeven, (b) \$profit goal, and (c) \% profit goal? Q10. What is the size of the 2021 total market in dollars? Hence, what is DTGC's target \% market share dollars for (a) breakeven, (b) \$profit goal, and (c) \% profit goal? A B 53 OUTPUTS SECTION 54 55 Question 1 56 Weighted Unit Selling Price retail 57 Unit Selling Price wholesale 58 Unit Selling Price DTGC $$$97.0068.7946.78 59 60 Question 2 61 Unit Selling Price DTGC using markup chain $46.78 62 63 Question 3 \begin{tabular}{r|l|rr} 64 & Material and labor UVC & $ & 21.05 \\ 65 & Packaging and Shipping UVC & $ & 2.52 \\ 66 & Commission UVC & $ & 3.27 \\ 67 & Therefore, UVC of a kit & $ & 26.85 \end{tabular} 68 69 Question 4 72 73 Question 5 \begin{tabular}{r|l|rr} 74 & Loan repayment and maintenance & $ & 70,000.000 \\ 75 & New salesforce salary & $ & 288,000.00 \\ 76 & New salesforce travel & $ & 88,000.00 \\ 77 & Direct mail pieces cost & $ & 81,000.00 \\ 78 & In flight magazine advertising & $ & 72,000.00 \\ 79 & Trade show registration & $ & 42,000.00 \\ \hline 80 & Trade show staffing & $ & 18,000.00 \\ \hline 81 & Total Fixed Costs & $ & 659,000.000 \end{tabular} 82 83 Question 6 84 \#BEP, number of kits to be sold for BEP 85 \$BEP, \$ sales of kits BEP 33,064$1,546,738.61 86 87 Question 7 \begin{tabular}{l|l|r} 88 & Tortal Fixed Costs plus \$ Profit Goal & $949,000.000 \\ 89 & \#RLS, number of kits to be solved for \$ Profit & 47,614 \\ 90 & \$RLS, \$ Sales of kits for \$ Profit Goal & $2,227,389.67 \end{tabular} 91 92 Question 8 93 Desired \$ profit per kit to achieve \% profit to sales goal 94 Revised \$C of a kit 95 \#RLS to achieve \%profit to sales goal 96 \$RLS to achieve \% profit to sales goal 97 98 Question 9 99 Size of the total market in units for 2021 100% market share for \#BEP 101 \% market share for \#RLS for \$ Profit Goal 102 \% market share for \#RLS for \% profit to sales goal A 104 Question 10 105 Size of the total market in $ for 2021 106 \% market share for \$BEP 107 \% market share for \$RLS for \$ Profit Goal 108 \% market share for \$RLS for \% profit to sales goal
