Question: EXCEL Needed Using the data below. A breakeven analysis is needed. With a graph that displays the intersection of the total cost lines (breakeven points)

EXCEL Needed

Using the data below. A breakeven analysis is needed. With a graph that displays the intersection of the total cost lines (breakeven points) in excel please.

Here is the problem worked out:

Two different manufacturing processes are being considered for making a new product. The first process is less capital-intensive, with fixed costs of only $52,600 per year and variable costs of $650 per unit. The second process has fixed costs of $408,000 but variable costs of only $220 per unit.

What is the break-even quantity, beyond which the second process becomes more attractive than the first?

The volume at which the second process becomes more attractive is 827 units.

EXCEL Needed Using the data below. A breakeven

Detail: Plot total cost columns in line chart. Quantity in x-axis. Increase max quantity as needed to see all intersections.

I need the image of how to do it in excel.

The excel work can be seen below: Cost of Process 1 Quantity Cost of Process 2 826.00 589,500.00 589,720.00 826.51 589,832.56 589,832.56 827.00 590,150.00 589,940.00 Formulas in excel: H 50 Quantity 51 826 52 826.511627906977 53 827 Cost of Process 1 =52600+(650*H51) =52600+(650*H52) =52600+(650*H53) Cost of Process 2 =408000+(220*151) -408000+(220*H52) -408000+(220"H53)

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 General Management Questions!