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?

Question

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?

Quizplus · Accepted Answer

The Answer of 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?

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