Break Even Excel Template
carrifljinh23h3
breakevenexceltemplate.xlsxWeek 8 Assignment 2 Template
| Break-Even Point | ||||||||||||||||||||
| Part a. | Part b. | Part c. | Part d. | |||||||||||||||||
| Givens From Problem: | Costs | Dollars | No. | Dollars | No. | Dollars | No. | Dollars | No. | |||||||||||
| A | ||||||||||||||||||||
| B | ||||||||||||||||||||
| C | ||||||||||||||||||||
| D | ||||||||||||||||||||
| E | ||||||||||||||||||||
| F | ||||||||||||||||||||
| G | ||||||||||||||||||||
| H | ||||||||||||||||||||
| I | ||||||||||||||||||||
| A | B | C | D | |||||||||||||||||
| Reimbursement | Reimbursement | Reimbursement | Reimbursement | |||||||||||||||||
| Per Mammography (P) | ||||||||||||||||||||
| Fixed Costs | Fixed Costs | Fixed Costs | Fixed Costs | |||||||||||||||||
| Total Fixed Costs (TFC) | Total Fixed Costs (TFC) | Total Fixed Costs (TFC) | Total Fixed Costs (TFC) | |||||||||||||||||
| Variable Costs | Variable Costs | Variable Costs | Variable Costs | |||||||||||||||||
| Variables Costs based on Dollar Amount per Unit | Variables Costs based on Dollar Amount per Unit | Variables Costs based on Dollar Amount per Unit | Variables Costs based on Dollar Amount per Unit | |||||||||||||||||
| Sum: | Sum: | Sum: | Sum: | |||||||||||||||||
| Break-Even Point | Break-Even Point | Break-Even Point | Break-Even Point | |||||||||||||||||
| Break-Even Units (X) | X = TFC / (P - V) | Break-Even Units (X) | X = TFC / (P - V) | Break-Even Units (X) | X = TFC / (P - V) | Break-Even Units (X) | X = TFC / (P - V) | |||||||||||||
| Targeted Profit | Targeted Profit | Targeted Profit | Targeted Profit | |||||||||||||||||
| Targeted Profit (TF) | Targeted Profit (TF) | Targeted Profit (TF) | Targeted Profit (TF) | |||||||||||||||||
| Units required to reach targeted TF, X = (TFC + TF) / (P-V) | Units required to reach targeted TF, X = (TFC + TF) / (P-V) | Units required to reach targeted TF, X = (TFC + TF) / (P-V) | Units required to reach targeted TF, X = (TFC + TF) / (P-V) | |||||||||||||||||
