+ Reply to Thread
Results 1 to 4 of 4

S-Curve help in income statement

  1. #1
    Registered User
    Join Date
    04-09-2015
    Location
    new york
    MS-Off Ver
    2010
    Posts
    18

    S-Curve help in income statement

    I could use some help on this.

    If I open a store every few months or so, each store has an s-curve in the number of items it can sell in 12 months (it starts of at 0 in the first months, then speeds up by the sixth month and plateus by the 10th months, etc).

    If I open new stores every few months, each store will have its own S-curve.

    The total will give me the product sales for each month.

    What I can't get is the excel formula to make this happen. My S-curve is in the "S-curve tab". S-curve v2.xlsx

  2. #2
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: S-Curve help in income statement

    So are you trying to fit coefficients to a Sigmoid Function or what?

    Please Login or Register  to view this content.
    And pull across; that give you the kind of thing you're looking for?
    (cells in red are the coefficients you'd need to adjust).
    Click the [* Add Reputation] Button to thank people for help!
    Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
    Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.

  3. #3
    Registered User
    Join Date
    04-09-2015
    Location
    new york
    MS-Off Ver
    2010
    Posts
    18

    Re: S-Curve help in income statement

    I created an s-curve in the "S-Curve" tab.

    Basically everytime I open a store in the revenue TAB that revenue curve from the S-CURVE tab gets applied.

    say I open on Jan, my revenue for jan is 0, Feb 10, March 15, April 20, etc, and after Dec it stays at 165.

    Now if I open another store in June, my revenue for that store in June is 0, July 10, August 15, Sep 20, etc...

    I can then total each month to get the revenue for each month for all the stores.

  4. #4
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: S-Curve help in income statement

    Then I don't understand what your question is.

    What is the range on the spreadsheet that you want a function for??

+ 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. summing up months in income statement
    By ammartino44 in forum Excel General
    Replies: 3
    Last Post: 05-28-2015, 12:30 PM
  2. problem with using if error in income statement
    By brandedadnan in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-19-2014, 08:59 AM
  3. if statement adjustment ( income tax calculation)
    By oshodibo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-07-2014, 06:33 AM
  4. [SOLVED] Formula for Income Statement in financial statement
    By Zunit in forum Excel General
    Replies: 6
    Last Post: 07-02-2012, 02:21 PM
  5. G/L Income Statement Template Setup
    By pinny in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-28-2006, 08:12 PM
  6. 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
  7. [SOLVED] is there a template for an income and expenditure statement in Ex.
    By soak93 in forum Excel General
    Replies: 1
    Last Post: 02-27-2005, 08:06 PM

Tags for this Thread

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