70.2K

Verified Solution

Link Copied!

For an answer to be graded as correct, you must use an Excel formula: 1. Begin each formula with an = sign.

2. Reference cells, instead of entering values.

I need the answers for 3 and 4

Given the following information complete a CVP analysis for JPL, Inc.:
Unit sales. A4	11,200 B4	units
Selling price per unit A5	$75 B5	per unit
Variable expenses per unit A6	$45 B6	per unit
Fixed expenses A7	$210,000 B7
Required:
Use the data to answer the following.
(Use cells A4 to C7 from the given information, as well as A15 to B37 to complete this question. All answers should be input and displayed as positive values.)
1. Compute the CM ratio and variable expense ratio.
Selling price per unit	$75 B15	per unit
Variable expenses per unit	45 B16	per unit
Contribution margin per unit	$30 B17	per unit
CM ratio	40% B19
Variable expense ratio	60% B20
2. Compute the break-even sales.
Break-even in unit sales	7,000 B23	units
Break-even in dollar sales	$525,000 B24
3. Compute the margin of safety.
Margin of safety in dollars A27	? B27
Margin of safety percentage A28	? B28
4. Compute the degree of operating leverage.
Sales A31	B31 ?
Variable expenses A32	B32 ?
Contribution margin A33	B33 ?
Fixed expenses A34	B34 ?
Net operating income A35	B35 ?
Degree of operating leverage A37	B37 ?

Answer & Explanation Solved by verified expert

See Answer