Computation of break-even-point in unitscreate a worksheet

Assignment Help Corporate Finance

Reference no: EM13356869

Computation of Break-even-point in units.

Create a worksheet with a data table (Hint: look in the book for the data table)

for Sony Entertainment that analyzes the breakeven point for CD prices between $5.00 and $10.00 in .20 increments.

Break Even point = Fixed Expenses / (Price per unit - Expense per unit)

Fixed Expenses = $10,000,000 (name this cell and 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 calculations.

Format money as currency.

Use conditional formatting to highlight when the breakeven point is less than 2,000,000 in the data table.

*** Use Goal seek to calculate Fixed Expenses if breakeven point is set to 3,000,000

Sony Entertainment

Fixed Expenses	$10,000,000.00
Expenses per unit	$ 2.45
Price per Unit	$ 5.00
Breakeven point

Data Table for different Prices per Unit
Price per Unit	Breakeven Point

$ 5.00
$ 5.20

Reference no: EM13356869

Questions Cloud

Computation of workers cost supplies to be purchased and : computation of workers cost supplies to be purchased and bad debt expenses.the hospital expects to employ workers in

Multiple choice questions on break even analysis decision : multiple choice questions on break even analysis decision making.1. the assembly line workers at precision tools have

Multiple choice questions on cvp analysis profitability : multiple choice questions on cvp analysis profitability ratios variance analysis.1.nbspnbsp garth company sells a

Break-even-sales units and the bep chart1nbspnbsp east : break-even-sales units and the bep chart.1.nbspnbsp east publishing company is doing an analysis of a proposed new

Computation of break-even-point in unitscreate a worksheet : computation of break-even-point in units.create a worksheet with anbspdata tablenbsphint look in the book for the data

Computation of break even number of students of a : computation of break even number of students of a college.houghton college is planning to begin a new graduate degree

Computation of break even volume of service revenueaqua : computation of break even volume of service revenue.aqua systems engineering provides consulting services to city water

Computation of equivalent units using weighted average : computation of equivalent units using weighted average method.jones sodas adds materials at the beginning of the

Preparation of workers cost supplies to be purchased and : preparation of workers cost supplies to be purchased and expenses budget of service sector - hospitalthe hospital

User Account

All Pages