need help on how to calculate the points of indifference between option A and B in excel. as well as the profit loss at point of indifference

File Edit View Go Tools Window Help HW5-6 Assignment.pdf (page 1 of 3) a Sea and encouroge to office hours for help. Please bring your class notes, an electronic version of the worksheets you completed r you have done the independent work and made an honest attempt at the assignment, we welcome w, your pt at each homework part, and equations for each cell that you have done or attempted on paper ART 1: Break-Even and Point of Indifference Analyses No new Excel functions are required for this part. Option B Create a worksheet called PointsOfinterest that2 will let a user enter revenue per unit of output, as 3 Rev/Unit well as Fixed and variable cost per unit for two different options. From that, compute each option's break-even point and the volume at Option A 25.5 91 22.25! 600 I 5 Var Cost which a rational manager without other input would be indifferent between the two options. 78.8 58.5 Break-Even 8 Profit Point of Indifference between Opt A & B You'll need to put appropriate formulas in the cells surrounded by dark lines and values in the 9 cells that are shaded (you don't actually need to u shade them or put borders around them - that's 11 Profit (loss)at point of Indifference just to help you know what are inputs and what are computations). Be sure that you never see an 12 error or any other weird output, regardless of what a user enters (including nothing) 112 Units $548 HINT: Before doing anything in Excel, on paper use variables for each input above, such as: Ra -revenue/unit for A; Re revenue/unit for B; FA Fixed cost for A; F Fixed cost for B; VA variable cost for A v-variable cost for B; q quantity Using those variables, solve for the point at profit is zero for each option. Use for each break-even, but . 2 3 4