Kylie and Derek Hurdy own Hurdy Headphones, a company that manufactures wireless and noise-cancelling headphones and personalized earphones in Pittsburgh, Pennsylvania. As an intern at the company, you are developing workbook that includes the financial details of± each product line. Kylie and Derek have asked you to use the data to analyse scenarios that involve cutting expenses and raising prices. They want you to find the most profitable mix products using the most cost-e²ective means o± production. Switch to the Wireless worksheet. Perform a break-even analysis ±or wireless headphones as follows? a. In cell B27, use Goal Seek to set cellB27to a value o±0.
b. Change the number of units sold in cellB26to break even, or reach a Gross Profit of $0.
(Hint: The number format applied to cell B27 will display the value of $0 as $ -.)