Break Even Analysis with JMP, possible?

Question

Dear All,

Is it possible to analyse the Break-Even point(s) in JMP?

I have a simple annual Revenue and Expenses data attached which is only based on months which happened this year.

I need to calculate and display the break even point in Currency and Date.

I guess first I need to fill the days to fit the end of month values. I could do by placing Date at X axis and Cumulative[REVENUE] or Cumulative[EXPENSES] at Y axis ( Fit Y by X) but I am unable to place both the REV and EXP to the same axis. I guess If I could pull out the curve equation as a formula I could do something with Profiler but I couldn't go so far...

Could someone show me the light please?

BBN.jmp

brady_brady · Answer

Sait,

Please try running the attached script with your table as the current table. For some reason the text of the script became corrupt after pasting, so I am guessing you could not get the script to run properly. I tried a few times to paste the script into an edited version of my post, to no avail.

Hopefully by including it as an attachment, you will be able to run it.

Cheers,

Brady

SaitCScript.jsl

brady_brady · Answer

Hi saitcopuroglu, try running the script below with your table current. It will fit splines (which can be adjusted to your liking), save the predictions and find the break-even point. The break-even row will be subsetted and a message printed to the log as to the time.

You could then plot the predicted values vs. each other, etc.

Cheers,

Brady

Code deleted, as it was not pasting properly.

saitcopuroglu · Answer

Dear Scott,

Thank you very much for the reply.

Yes it helps as the main logic, but I would like to do it more precise and automated and would like to go much further.

Instead of manually looking for BE Point by CrossHair Tool, I am willing JMP to do it and display it for me.

I'm expected to do it everyday during the season (Resort Hotel Business) and once I can do it with this simple table which respresents the estimated budget revenue and expenses, later on the actual revenue and expenses come to play which I would like to compare with budget revenue and expenses. ​Also beside the BE point I would like to do the same for Total Profit Max point.

For all this I guess I need to first fill the blank rows (days) to fit the curve of Rev and Exp. I know I can estimate a polynomial equation and save predicted formula which will fill the rows for me but should I do it with Fit Y by X or Time Series or Fit Model or Profiler? The next step which I am really in dark is how will I make JMP to calculate and display those informations: Budget BE Point, Actual BE Point, Budget Total Profit Max Point, Actual Total Profit Max Point..etc..

Because the actual data will flow day by day the predicted Revenue and Expenses Formula Column data will vary..

Hope you can help further,

many thanks in advance.