breakeven formulas
 

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

breakeven formulas
 

Hello Runner77,

Are you looking for someone to write a bussiness application for you?

Sincerely,
Leith Ross


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

breakeven formulas
 

Hi Leith

Yes please need some help with the formulas as in my previous post. If
you could help that would be great.

Regards
Mark


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

breakeven formulas
 

How about you make a start, then ask us a specific question when you get
stuck.
Otherwise I can suggest some companies you can employ to design your
application at a cost.

NickHK

"Runner77" wrote in
message ...

Hi Leith

Yes please need some help with the formulas as in my previous post. If
you could help that would be great.

Regards
Mark


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