I want to compare 2 pieces of equipment to determine when the sales level, in units, and the cost will be the same for both pieces of equipment.
I know the capacity related costs, flexible costs per unit and the sales price per unit for each piece of equipment. How do you determine when the cost will be the same?
Equipment 1 Equipment 2
flexible costs per unit X1 Y1
capacity related costs ...
The solution explains how to compute the answer, and also includes an attachment which gives great details for using some Excel commands to build graphs.