A B D E F G . J K L M . N o Q R s 1 # of Candles Price $ 1.50 $ 1.75$ 2.00 $ 2.25$ 2.50 $ 2.75$ 3.00 $ 3.25$ 3.50 $ 3.75 30 28 $2.50 5 10 $2,100.00 15 20 2 Income 3 Volume of Candles per color 4 Number of colors 5 Average Price 6 Gross Revenue 7 Monthly Costs 8 Fixed Expenses 9 Candle Molds 10 Rent 11 Admin Salaries 12 Insurance 13 Total Fixed Costs 25 30 35 $769.00 $560.00 $650.00 $230.00 $2,209.00 40 45 50 14 55 Variable Expenses Material & Marketing Costs (per candle per color) 15 $0.50 60 16 Total Variable Costs $420.00 65 17 Net Income -$529.00 9 5 On the Breakeven use the data in the break-even analysis to complete the two-variable data table in range H4:Q16 with the Price across the rows and the Volume of Candles per Color down each column. Hint: To clarify, we are talking about the Data Table that is found under the What If Analysis on the Data ribbon. Don't forget to enter a link to the Net Income cell address in the corner of the data table so that Excel knows what values you want inside the table. Use D5 for the row input and D3 as the column input. Also remember that you can't edit just a part of a data input table. If something goes wrong, delete the entire range that you did incorrectly (they may all be zeros) and try again. 10 6 On the Breakeven worksheet, do a goal seek analysis to find out how many candles (Volume of Candles Per Color) must be sold in order to make $3500 in net income? Hint: Remember that you can't put dollar signs or