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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!