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 |
+-------------------------------------------------------------------+

--
Runner77
------------------------------------------------------------------------
Runner77's Profile: http://www.excelforum.com/member.php...o&userid=30388
View this thread: http://www.excelforum.com/showthread...hreadid=558718