Microsoft Office Tutorials and References
In Depth Information
You will find these examples in the Excel Chapter 16 file:
1. On the Review sheet for the Excel
le called Chapter 16, you will see the
example below. The right side of the
gure shows the formulas used to calculate
nd the break-even price for this sheet.
2. On the same sheet, calculate the minimum number of units the
Use Goal Seek to
rm has to sell in
order to break even.
3. On the same sheet,
gure out what should be the maximumManufacturing Cost
per Unit in order to break even.
4. What is the highest Fixed Monthly Expenses possible in the same statement to
2. 6,250 units