Question: Please help! with calculations begin{tabular}{|c|c|c|c|} hline multicolumn{3}{|c|}{ Description } & multirow{2}{*}{ Per Unit } hline Unit Sales for 2024 & & & hline


\begin{tabular}{|c|c|c|c|} \hline \multicolumn{3}{|c|}{ Description } & \multirow{2}{*}{ Per Unit } \\ \hline Unit Sales for 2024 & & & \\ \hline Sales Revenue & $ & 3,801,720 & 5,663 \\ \hline Variable Costs & & 1,877,720 & 3,611 \\ \hline Contribution Margin & & 1,924,000 & 2,052 \\ \hline Fixed Costs & & 410,500 & \\ \hline Operating Income & $ & 1,513,500 & \\ \hline Breakeven & s & - & \\ \hline Target Profit & $ & 670,000 & \\ \hline \end{tabular} Use the contribution margin approach to compute the change in net operating income if the selling price increases by 2%, variable costs increase by 5% and because of these decisions sales fall by 95 units. Reference the DATA cell(s) in your formula below. Format as a number. Always refer to the original data. Use the Excel ROUNDUP function to obtain whole units if applicable New Operating Income change in Operating Income Requirement 14 Use the contribution margin approach to compute the change in net operating income if the selling price per unit increases by $25 per unit and because of this decision sales volume decreases by 55 units. Reference the DATA cell(s) in your formula below. Format as number. Use the Excel ROUNDUP function to obtain whole units if applicable Requirement 15 Use the contribution margin approach to compute the change in net operating income if the sales increase by 6% and advertising spending is increased by $6,000. Reference the DATA cell(s) in your formula below. Format as a number. Always refer to the original data. Use the Excel ROUNDUP function to obtain whole units if applicable Requirement 16 Use the contribution margin approach to calculate margin of safety in dollars, as a percent and in units. Reference the DATA cell(s) in your formula below. Format as a number. Always refer to the original data. Use the Excel ROUNDUP function to obtain whole units if applicable Requiroment 17 Use the contribution margin approach to calculate operating leverage. What is the estimated percent increase in net income if sales increase 15% ? What is the New Operating Income
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
