Grove Audio is considering the introduction of a new model of wireless speakers with the following

price and cost characteristics.

Required:

Using the Goal Seek function in Microsoft Excel, prepare an Excel spreadsheet to answer the

following questions:

a$.$ What number must Grove Audio sell to break even?

b$.$ What number must Grove Audio sell to make an operating profit of $$180,000$ per year?

Note: Please submit your file attachment response in one of the approved file formats; Word file

$(.$doc or $.$docx$),$ Excel file $(.$xls or $.$xlsx$),$ or PDF$.$ To submit photo or image files please paste them

into Word or PDF$.$ Consult with your instructor as needed on the preferred file attachment

format.