please help just optional answers no need to fill columbs

sales, and profits. Use a spreadsheet to address these issues ed Spreadsheet The spreadsheet values outlined in yellow can be changed in order to determine possible outcomes. You can find the initial values in the corresponding blue cells in columns E and F. Start by entering the initial values into columns B and C. Then review the questions below and adjust the values in columns B and C to determine the correct answers. A B D E F 1 Initial Initial 2 Break-Even Profit Analysis Break Even Profit 3 Analysis Total Fixed Costs $ 30,000.00 $ 30,000.00 4 Assumed Selling Price $ 1.20 5 $ 120 Average Variable Cost $ 0.80 $ 0.80 6 Target Profit 7 $ 10,000.00 Your Estimate of Sales Quantity 8 80,000 Unit Fixed Cost Contribution $ 0.00 $ 0.00 5 0.40 $ 9 0.40 10 At Break Even (or Target Profit) 11 Needed Sales (Units) NaN NaN 75,000 12 100,000 Needed Sales (Dollars) NaN NaN $ 13 90,000.00 $ 120,000.00 Total Costs NaN NaN $ 14 90,000.00 $ 110,000.00 Average Cost Per Unit NaN NaN 15 $ 1 20 $ 1.10 16 At Your Estimate of Sales Quanity 17 Revenue at Your Quantity $ 0.00 18 $ 96,000.00 Total Cost at Your Quantity 0.00 19 s 94,000.00 Average Cost/Unit at Your Quantity NaN 20 $ 1.18 Profit at Your Quantity $ 0.00 $ 2,000 00 $ a. If the selling price were increased by 10%, how many units would need to be sold to break even? 57,692 75,000 98,322 107143 112,500 b. If the original selling price were decreased by 10%, how many units would need to be sold to break even? 57,692 75,000 98,322 107143 112,500 c. If you hope to earn a target profit of $15,000, how many units would you have to sell? (Note: Use the "profit analysis column in the spreadsheet) 57,692 75.000 98,322 107143 112,500 d. If you hope to earn a target profit of $15,000, what would your total cost be? $90,000 00 $94.000.00 $115,714 29 0 $120,000.00 UIZ 75,000 98,322 107,143 112,500 c. If you hope to earn a target profit of $15,000, how many units would you have to sell? (Note: Use the "profit analysis" column spreadsheet) 57,692 75,000 98,322 107,143 112,500 d. If you hope to earn a target profit of $15,000, what would your total cost be? $90,000.00 $94,000.00 $115,714.29 $120,000.00 $135,000.00 e. Using the "profit analysis" column, if your target profit is $15,000 and your fixed costs increase to $35,000, what would your dollars need to be? $96,000.00 $99,000.00 $125,000.00 $135,000.00 $150,000.00