Computing breakeven sales and sales needed to earn a target profit; graphing CVP relationships; performing sensitivity analysis National Investor Group is opening an office in Portland, Oregon. Fixed monthly costs are office rent ($8,100), depreciation on office furniture ($1,700), utilities ($2,000), special telephone lines ($1,500), a connection with an online brokerage service ($2,500), and the salary of a financial planner ($5,200). Variable costs include payments to the financial planner (9% of revenue), advertising (11% of revenue), supplies and postage (4% of revenue), and usage fees for the telephone lines and computerized brokerage service (6% of revenue). Requirements Use the contribution margin ratio approach to compute Nationals breakeven revenue in dollars. If the average trade leads to $1,000 in revenue for National, how many trades must be made to break even? Use the equation approach to compute the dollar revenues needed to earn a monthly target profit of $12,600. Graph National’s CVP relationships. Assume that an average trade leads to $1,000 in revenue for National. Show the breakeven point, the sales revenue line, the fixed cost line, the total cost line, the operating loss area, the operating income area, and the sales in units (trades) and dollars when monthly operating income of $12,600 is earned. Suppose that the average revenue National earns increases to $1,500 per trade. Compute the new breakeven point in trades. How does this affect the breakeven point?

Computing breakeven sales and sales needed to earn a target profit; graphing CVP relationships; performing sensitivity analysis

National Investor Group is opening an office in Portland, Oregon. Fixed monthly costs are office rent ($8,100), depreciation on office furniture ($1,700), utilities ($2,000), special telephone lines ($1,500), a connection with an online brokerage service ($2,500), and the salary of a financial planner ($5,200). Variable costs include payments to the financial planner (9% of revenue), advertising (11% of revenue), supplies and postage (4% of revenue), and usage fees for the telephone lines and computerized brokerage service (6% of revenue).

Requirements

1. Use the contribution margin ratio approach to compute Nationals breakeven revenue in dollars. If the average trade leads to $1,000 in revenue for National, how many trades must be made to break even?
2. Use the equation approach to compute the dollar revenues needed to earn a monthly target profit of $12,600.
3. Graph National’s CVP relationships. Assume that an average trade leads to $1,000 in revenue for National. Show the breakeven point, the sales revenue line, the fixed cost line, the total cost line, the operating loss area, the operating income area, and the sales in units (trades) and dollars when monthly operating income of $12,600 is earned.
4. Suppose that the average revenue National earns increases to $1,500 per trade. Compute the new breakeven point in trades. How does this affect the breakeven point?