Using the Question 2 worksheet, find the amount of units to break-even. a. Ensure you have used Goal Seek in order to find this quantity. b. Provide a screenshot of the Goal Seek Dialog Box in A17:C27. Only provide the Goal Seek dialog box. c. In the textbox provided in E4:J12, provided an explanation of the analysis that was performed.

OM 300 HW 3 Inputs Unit Sales Price $25 Annual Fixed Cost $70,000 Unit Variable Cost $16 Response: The profit level for the base case annually is $110,000. Quantity Made and Sold 20,000 ? X Goal Seek C15 1 Calculations and Outputs Annual Revenue $500,000 Annual Variable Costs $320,000 Annual Fixed Cost $70,000 Annual Total Cost $390,000 Annual Profit (Loss) ($110,000 Set cell: To value: By changing cell: OK Cancel