problem: Construct a worksheet with an information table (Suggestion: look in the book for the data table) for Sony Entertainment that analyzes the breakeven point for CD prices between $5 & $10 in .20 increases.
Break Even point = Fixed Expenses [Price per unit - Expense per unit]
Fixed Expenses = $10,000,000 [name this cell & use in formula]
Price per unit = $5.00
Expenses per unit = $2.45
Name the cells for fixed expenses, Price per Unit, Expenses per unit, Breakeven point and use the names in the computations. Format money as currency.
Use conditional formatting to highlight when the breakeven point is less than 2,000,000 in the information table.
Use Goal seek to find out Fixed Expenses if breakeven point is set to 3,000,000
|
Sony Entertainment
|
|
|
|
|
Fixed Expenses
|
$10,000,000.00
|
|
Expenses per unit
|
mce_markernbsp; 2.45
|
|
Price per Unit
|
mce_markernbsp; 5.00
|
|
Breakeven point
|
|
|
|
|
|
Data Table for different Prices per Unit
|
|
|
Price per Unit
|
Breakeven Point
|
|
|
|
|
mce_markernbsp; 5.00
|
|
|
mce_markernbsp; 5.20
|
|