R
Runner77
High Guys,
I need some help writing a few formulas in the attached spreadsheet.
The Data_Input sheet where all the information will come from I have
set-up Name ranges for each category.
I need to write the following formulas in the calculation sheet.
1 Fixed costs per week
2 Variable costs per drink in normal hours
3 Variable Costs per Drink in Overtime
4 The breakeven point in the number of 375ml drinks per week Inoring
overtime
5 If the selling price per drinks changes, while all other data remains
the same, what is the minimum selling price per drink below which
overtime will be required to breakeven. I will need an If statement to
test whether overtime is required.
6 A formula that calculates the profit or loss in normal hours
7 Graph_Data sheet will need formulas to allow me to graph it
8 I need to calculate the number of drinks that must be sold to achieve
that target profit of $45,000.
9 A formular that will warn me that a target profit I keyed in will
require more that 15 hours overtime.
Thank You for Your Held in advance
Runner77
+-------------------------------------------------------------------+
|Filename: Breakeven.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4983 |
+-------------------------------------------------------------------+
I need some help writing a few formulas in the attached spreadsheet.
The Data_Input sheet where all the information will come from I have
set-up Name ranges for each category.
I need to write the following formulas in the calculation sheet.
1 Fixed costs per week
2 Variable costs per drink in normal hours
3 Variable Costs per Drink in Overtime
4 The breakeven point in the number of 375ml drinks per week Inoring
overtime
5 If the selling price per drinks changes, while all other data remains
the same, what is the minimum selling price per drink below which
overtime will be required to breakeven. I will need an If statement to
test whether overtime is required.
6 A formula that calculates the profit or loss in normal hours
7 Graph_Data sheet will need formulas to allow me to graph it
8 I need to calculate the number of drinks that must be sold to achieve
that target profit of $45,000.
9 A formular that will warn me that a target profit I keyed in will
require more that 15 hours overtime.
Thank You for Your Held in advance
Runner77
+-------------------------------------------------------------------+
|Filename: Breakeven.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4983 |
+-------------------------------------------------------------------+