Question: How to I enter the data below in excel in creating a CVP graph with break even points. (a) Glacial Company estimates that variable costs

How to I enter the data below in excel in creating a CVP graph with break even points.

(a) Glacial Company estimates that variable costs will be 62.5% of sales, and fixed costs will total $600,000. The selling price of the product is $4.

(b) Compute the break-even point in (1) unitits and (2) dollars.

(c) Assuming actual sales are $2 million, compute the margin of safety in (1) dollars and (2) as a ratio.

Please provide data input and formula used in creating the CVP graph

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!