Question: What should be the formula in B7? A B 1 Variable Costs $ 8,400,000 2 Fixed Costs $ 1,750,000 3 Unit Sales $ 200,000 4
What should be the formula in B7?
| A | B | |
| 1 | Variable Costs | $ 8,400,000 |
| 2 | Fixed Costs | $ 1,750,000 |
| 3 | Unit Sales | $ 200,000 |
| 4 | Price per unit | $ 70 |
| 5 | Variable Costs Per Unit | $ 42 |
| 6 | Target EBIT | $ 1,000,000 |
| 7 | Units to Reach Target EBIT | ??????? |
A) B2+B6/B4-B5
B) (B2+B6)/B4-B5
C) (B2+B6)/(B4-B5)
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
