Required: Develop an Excel spreadsheet that uses the following inputs to calculate the following outputs.
Inputs Outputs
Variable cost per unit Break-even point in units
Total fixed costs Break-even point in sales (dollars)
Sales price per unit Units sales required to achieve a target profit
Target profit Sales (dollars) required to achieve a target profit
Unit contribution margin
Assume that this report is going to be used by one of your clients. For this Excel assignment and all Excel assignments going forward unless otherwise specified, it is expected that your report:
1. Will use cell referencing to calculate outputs when appropriate.
2. Will clearly indicate which cells should be manipulated by the user (inputs).
3. Is organized in a way that the information is easy to navigate and useful for decision making.
4. Will document relevant assumptions.
5. Will be submitted as an Excel file. (.numbers files or links will be given a grade of zero)