Answered step by step
Verified Expert Solution
Question
1 Approved Answer
No need to fill out entire chart, just the 4 following questions based on the chart please. Thanks! You are provided with the following data
No need to fill out entire chart, just the 4 following questions based on the chart please. Thanks!
You are provided with the following data for Company A, B, and C. Please answer the questions below by entering a formula into each of the cells marked with a "?" below. \begin{tabular}{|c|c|c|c|} \hline & & & \\ \hline Data & Company A & Company B & Company C \\ \hline Unit sales & 20,000 & 16,000 & 26,000 \\ \hline Selling price per unit & $60 & $80 & $75 \\ \hline Variable expenses per unit & $45 & $55 & $60 \\ \hline Fixed expenses & $240,000 & $100,000 & $290,000 \\ \hline Note: Please enter a formula into each of the cells marke & with a "?" below & & \\ \hline Do not add or delete rows/columns. & & & \\ \hline a) Compute the CM ratio and variable expense ratio. & Company A & Company B & Company C \\ \hline Selling price per unit & ? & ? & \\ \hline Variable expenses per unit & ? & ? & \\ \hline Contribution margin per unit & ?: & ?. & \\ \hline & & & \\ \hline CM ratio & ? & ? & \\ \hline Variable expense ratio & ? & ? & \\ \hline b) Compute the break-even point. & Company A & Company B & Company C \\ \hline Break-even point in units & ? & ? & \\ \hline Break-even point in dollars & ?. & ? & \\ \hline c) Compute the net operating income. & Company A & Company B & Company C \\ \hline Sales & ? & ? & \\ \hline Variable expenses & ? & ? & \\ \hline Contribution margin & ? & ? & \\ \hline Fixed expenses & ? & ? & \\ \hline Net operating income & ? & ? & \\ \hline & ompanies A, & 3 , and & \\ \hline & Company A & Company B & Company C \\ \hline perating in & & & \\ \hline \end{tabular} Please answer the following questions What is the contribution margin per unit for Company C ? $15 $60 $25 $70 What is the variable expense ratio for Company A? 80% 25% 68% 75% What is the break-even point in dollars for Company C ? $530,000 $320,000 $1,450,000 $960,000 What is the net operating income for Company B? $60,000 $20,000 $300,000 $100,000Step 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