breakeven formulas

  • Thread starter Thread starter Runner77
  • Start date Start date
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 |
+-------------------------------------------------------------------+
 
Hello Runner77,

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

Sincerely,
Leith Ross
 
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
 
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
 
Back
Top