• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Break Even Analysis

A

ahamed982

New Member
Hi their!!

Basically I want to come up with a dash board that can visualize the break even ..

Here is the question ;

We are into fish processing business and the fish purchase price and sales prices are highly volatile and market driven, which we have no control. We always bound to adjust our margin to cope with market requirement. Therefore, I want to come up with a dash board that can visualize (by graph) our profit subject to the following conditions;

By how much the target profit will deviate from projected profit if ;

1. Sales price change within given range (projected profit at different QTY while Fish price remain same)
Variables - sales price & qty

2. Purchase price change within given range (projected profit at different QTY while sales price remain same)
Variables - purchase price & qty

3. Break even QTY under above mentioned 2 scenarios

I have attached the file herewith.
Thank you in advance. :)
 

Attachments

  • Break even analysis.xlsx
    36.4 KB · Views: 25
Dear Narayan

Thanks for the information,

Im sorry, I was looking for help on, how I can represent the result (output) in a visually appealing manner, not about how to process it

Thanks ..
 
Hi Ahamed ,

Sorry , but the kind of help you are asking for is time-consuming , since you have not created the data itself , leave alone the dashboard part of it ; I leave it to others to help you out on this.

Narayan
 
You must log in or register to reply here.
Back
Top