Results 1 to 2 of 2

Thread: Breakeven Sales & Data Tables using Excel

  1. #1
    New Member
    Join Date
    Nov 2019
    Location
    Cape Town
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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 Attached Files

  2. #2
    New Member
    Join Date
    Nov 2019
    Location
    Cape Town
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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

Similar Threads

  1. DATA TABLES FOR PASTEL EVOLUTION
    By jonesey in forum Accounting Forum
    Replies: 0
    Last Post: 10-Oct-13, 03:54 PM
  2. [Question] exporting data in pastel to excel
    By bernardshap in forum Accounting Forum
    Replies: 5
    Last Post: 28-Aug-12, 01:19 PM
  3. The VALUE OF DATA - It can turn sales around!
    By bjsteyn in forum Technology Forum
    Replies: 0
    Last Post: 16-Aug-12, 07:44 PM
  4. Replies: 1
    Last Post: 22-Jun-12, 07:30 PM

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •