i need help solving this please

AutoSave . Off) Quiz 1 -Instructions - Protected View - Saved to this PC - Search Julio Lantigua X File Home Insert Design Layout References Mailings Review View Help Share Comments Computer Literacy Quiz 1 Part 4 - What-If Analysis: Goal Seek (10%) Open the What-If sheet in the Quiz 1 Data File.xlex workbook file you downloaded from the assignment page on Blackboard. Proceed as described below. Scenario Explanation: At the top of the page is a form designed to project a business's profit or loss, aka Net Income. By definition, Net Income equals Revenue minus Expenses. However, some expenses are fixed and others will vary depending on how much you sell. The more sales revenue we project the more variable expenses there will be. This model deals with this fact by including an estimated "operating profit on sales" field as percent and assuming that variable expenses are the projected sales revenue times 1 minus operating profit percent. For example, if the operating profit on sales is 15% than the variable expenses on sales is 85%. Assignment Use the Goal Seek function to locate the breakeven point where Net Income is zero under two different scenarios. 1) Determine what the value of Sales Revenue would have to be for Net Income to be 0. a. Run the What-If Goal Seek function. b. Record your results in cell C12 on the page c. Undo and proceed to scenario 2. Note: You must use the original data for scenario 2 2) Determine what the value the Operating Profit on Sales would have to b for Net Income to be 0. a. Run the What-if Goal Seek function. b. Record your results in cell C13 on the page Submission When complete, post the following files to this Quiz's assignment page on Blackboard 1) The new workbook file you created in Part 1. 2) The Quiz 1 Data File workbook that you updated as required in parts 2, 3 and 4. Page 3 of 3 781 words Focus - - + 100% 3:52 PM Type here to search 9 9 W X 2/19/2021Julio Lantigua X AutoSave . Off quiz 1 data file - Saved . Search Page Layout Formulas Review View Help Share Comments File Home Insert Data X Cut _ AutoSum Calibri 11 ~ A" A ae Wrap Text General LIX [B Copy Fill Insert Delete Format Sort & Find & Paste $ ~ % 9 08 28 Conditional Format as Cell Analyze EEE EE Merge & Center Formatting * Table Styles Clear Filter * Select v Data Format Painter Cells Editing Analysis Clipboard Font Alignment Number Styles C23 X V fic C D E F G H K L M N O P Q R S A B Projecting Net Income N Assumes Variable Expenses = Sales Revenue * (1- Percent Operating Profit) Operating Profit on Sales 15% Fixed Expense $ 500,000 Variable Expenses $ 637,500 Total Expenses $ 1,137,500 Sales Revenue $750,000 Net Income ($387,500) Record 11 Part A - Whatif Goal Seek Result 12 1) Goal is Net Income=0 by Changing Sales Revenue 13 2) Goal is Net Income=0 by Changing % Operating profit 14 15 16 17 18 19 20 21 22 23 24 25 26 products State Sales Tax What-If + - - + 100% 3:52 PM Type here to search 9 9 W X 2/19/2021