Please use Excel formulas to find the missing yellow fields and subsequently provide a breakeven analysis. Questions
Question:
Please use Excel formulas to find the missing yellow fields and subsequently provide a breakeven analysis.
Questions are:
1. Determine Total Sales
2. Determine Total Expenses
3. For Breakeven Analysis, how many units do you approximately need to sell to break even? (C29)
HINT: Think about variable and fixed costs and how that impacts the cost of each unit sold
4. Represent your Breakeven Analysis Data on a Line Graph
HINT: Using the Break Even Analysis chart, graph both Total Sales and Total Expenses. Enter "Units Sold" on the Horizontal Axis and "Gross Profit" on the Vertical Axis
In your final report, state your findings based on the Breakeven Analysis. What does the breakeven amount tell you about profitability?
Fundamentals of Thermodynamics
ISBN: 978-0471152323
6th edition
Authors: Richard E. Sonntag, Claus Borgnakke, Gordon J. Van Wylen