Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Breakeven Day - Formula | Excel Discussion (Misc queries) | |||
Breakeven graph | Excel Discussion (Misc queries) | |||
Breakeven/ Math Question.... | Excel Worksheet Functions | |||
breakeven analysis chart | Charts and Charting in Excel | |||
Breakeven Chart | Charts and Charting in Excel |