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?

Calculate discounts and determine the cost of inventory considering the payment terms.

Record transactions related to purchases, sales, and returns under a perpetual inventory system.

Understand the treatment of freight costs in inventory accounting.

Recognize the effect of inventory transactions on the cost of goods sold.

---

Definitions:

Gifford Pinchot

An American forester and politician who served as the first Chief of the US Forest Service and was a key figure in the conservation movement.

Scientific Forestry

A method of managing forests based on principles of conservation and sustainability, often through the application of scientific research.

France and Germany

Two major European countries with a complex history of rivalry and cooperation, playing significant roles in European politics and the development of the European Union.

Poland

A country located in Central Europe, known for its historical heritage, cultural contributions, and resilience through periods of conflict and division.