Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 Cost per Unit | $42 |
| 6 | Target EBIT | $1,000,000 |
| 7 | Units to Reach Target EBIT | ? |
Group of answer choices
=(B2+B6)/B4-B5
=(B2+B6)/(B4-B5)
=B2+B6/B4-B5
=B2+B6/(B4-B5)
=(B2-B6)/(B4+B5)
Step 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
Applied Quantitative Finance
Authors: W.; T. Kleinkow; G. Stahl Hardle
1st Edition
3540434607, 978-3540434603
