Set Up the Following Cell Entries in Excel Using Goal Seek,what Should the Selling Price Per Unit Be

question 33

Essay

Set up the following cell entries in Excel:
$$\begin{array} { | l | r | } \hline \text { Variable costhurit } & \$ 1.5 \\\hline \text { Fixed cost } & \$ 90 \\\hline \text { Bellirg price/urit } & \$ 3 \\\hline \text { Breakevern (urits) } & 60 \\\hline \text { Breakeven in dollars (\$) } & \$ 180 \\\hline\end{array}$$
Using Goal Seek,what should the selling price per unit be in order to realize a breakeven amount of $200?

---

Definitions:

Butanoic Acid

An organic compound with the formula C4H8O2, also known as butyric acid, characterized by its unpleasant smell and occurrence in butter and animal fat.

Bromoacetone

An organic compound with the formula C3H5BrO, used in the past as a tear gas.

Bromodiiodomethane

A halogenated methanol compound with the formula CH2BrI2, often used in organic synthesis and as a dense fluid for mineral separation.

Necessary Reagents

Specific chemicals required to carry out a particular chemical reaction.