Breakeven Sales & Data Tables using Excel

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Flupsie
    New Member
    • Nov 2019
    • 3

    #1

    Breakeven Sales & Data Tables using Excel

    I have tried to compute the breakeven sales for a service department
    and made use use data tables in Excel to estimate the Net
    Profit based on various sales, I get an incorrect answer. The
    breakeven sales in the data table should be zero. This has stumped me
    as my formula for breakeven appears to be correct

    It would be appreciated if you could check my sample data and advise
    where I have gone wrong
    Attached Files
  • Flupsie
    New Member
    • Nov 2019
    • 3

    #2
    I resolved my problem in computing the estimated Net Profit using data tables.

    My Breakeven was 100% but I was getting an incorrect answer when computing forecasted Net Profit based on increased sales data when using a data table.

    My Contribution margin was 27.1111% (GP %)

    To resolve the problem is incorrect forecasted net profit , I set my variable costs to be Sales * (1-0.271111) and now I get correct forecasted net profit

    Comment

    Working...