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
Get step-by-step solutions from verified subject matter experts
