CAN YOU ANSWER THIS BY USING EXCEL FORMULAS, SO =f10, AND THEN PUT THE ANSWER NEXT TO IT.

A B C D E F G H K L M N 0 P P. Q R S S 1 2 3 500.00 4 5 Use Goal Seek 1. Create and input area.... similar to right - 2. Set Target Profit to equal Net operating income 3. Construct a Contribution Margin Income Statement with formulas 4. Open Goal Seek.... We want to achieve a value of $0 net operating income "Set Cell" "Break-Even(this is cell in your statement) 5. By changing cell: "Referto Units Sold"input cell 6. Repeat but set Net operating income to $115,000 Breakeven & Target Profit Analysis Selling Price $ Variable cost $ 300.00 Contribution Margin $ 200.00 Fixed Cost $ 80,000 Units Sold 800 Target Profit $ 100,000 6 7 8 9 10 11 12 13 14 Data Review View Developer Add-ins Help Acrobat Power Pivot 15 16 . 17 18 > A QA