+ Reply to Thread
Results 1 to 3 of 3

How can I plot out income and expense for a product to reveal the break even point?

  1. #1
    Registered User
    Join Date
    07-30-2013
    Location
    United States
    MS-Off Ver
    exce 2010
    Posts
    1

    How can I plot out income and expense for a product to reveal the break even point?

    Hi,

    Any help you can provide would be greatly appreciated. I have no idea where to start.

    I am trying to accomplish the following:

    We manufacture "wig-its." There is a one time cost to us of x for each unit. There is a x per month cost to us to administrate a subscription. There is a one time customer acquisition fee of X. The customer signs up for 36 months. The customer pays us x every month.

    Is there a way to create a spreadsheet that will allow me to sell 50 units this month and show where down the 36 months we reach a break even point? Then next month, lets say we sell 30 units. Is there a way to incorporate the following 36 months into what we sold the previous month (which will now only have 35 months to go)? In the third month, we sell even more units. Is there a way to look 22 months down the line to see where we are in turns of profit or loss, either separately or in aggregate for all three months that we made sales?

    It would be great to be able to change any variable, whether it is unit cost, per month cost, acquisition fee, how much the customer pays us, etc. The units sold month to month should also be allowed to be variable.

    Like I said, I have no idea where to start, so if you can point me in a direction, that would be great!

    Thanks, and all the best,

    Robert
    Last edited by zenduder; 07-30-2013 at 04:34 PM. Reason: typo

  2. #2
    Registered User
    Join Date
    07-19-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    92

    Re: How can I plot out income and expense for a product to reveal the break even point?

    Since you want to be able to vary the units sold arbitrarily each month (your example: 50 this mo, 30 next, etc.) you need a row of months. So something brute force like this will show you what's what.

    Take a look at this attachment. Hopefully my labels are clear enough.
    Attached Files Attached Files
    Last edited by mike65535; 08-01-2013 at 08:30 AM. Reason: Trying to get attachment to "stick" LOL

  3. #3
    Registered User
    Join Date
    07-19-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    92

    Re: How can I plot out income and expense for a product to reveal the break even point?

    Ignore this post - essentially a dupe - site hiccupped.
    +++++++++++++++++++++++++++++++++++++++
    OK, try again for the attachment...
    Attached Files Attached Files
    Last edited by mike65535; 08-01-2013 at 08:33 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Money income/expense chart with color indicators for every payment type
    By manu.jarvinen in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-04-2009, 08:38 AM
  2. Linking Check Registry to Income and Expense
    By AllElements in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-05-2006, 11:21 PM
  3. [SOLVED] Re: Income/Expense Spreadsheet
    By Home in forum Excel General
    Replies: 0
    Last Post: 06-14-2006, 05:00 PM
  4. What template is best to show an income and expense statement
    By Leinad Retep in forum Excel General
    Replies: 0
    Last Post: 03-13-2006, 12:00 AM
  5. How do I set up my expense/income statement in excel?
    By Jean in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 05-05-2005, 03:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1