Please Use Excel to draw a chart and explain steps on how to get the chart.

The operations manager at Sebago Manufacturing is considering three proposals for supplying a critical component for its new line of electric watercraft. Proposal one is to purchase the component, proposal two is make the component in-house using rebuilt equipment, and proposal three is to purchase new, highly automated equipment. The costs associated with each proposal are provided in the table below. At what quantity range will each option be preferred?

LOADING...

Click the icon to view the costs associated with each proposal. Part 2Proposal one will provide the lowest annual cost if between

and

components are required annually. (Enter your responses as whole numbers.)Part 3Proposal two will provide the lowest annual cost if between

and

components are required annually. (Enter your responses as whole numbers.)Part 4Proposal three will provide the lowest annual cost if greater than

components are required annually. (Enter your response as a whole number.)

Proposal Annual cost of capital required Variable cost of each component One: purchase $0.00 $25.50 Two: make with rebuilt equipment $125,000.00 $17.50 Three: make with new equipment $475,000.00 $13.50

Please Put the "quantity" in column A, ranging in equal increments from 0 to some large number. Put the total cost of each alternative in a separate column (= FC + VC*Quantity). Plot the total cost columns in a line chart. Use the quantity as x-axis label. Increase the max quantity as necessary (keeping the increments equal) to see all the breakeven intersections.