Results 1 to 8 of 8

Shift annual costs forward based on new start date

Threaded View

  1. #1
    Registered User
    Join Date
    05-26-2018
    Location
    Sydney
    MS-Off Ver
    2013
    Posts
    1

    Shift annual costs forward based on new start date

    Hi all!

    (FYI, this is my first post so apologies if I haven't properly followed conventions in some way )

    Context

    I have a sheet containing costs data, with costs recorded by FY as per the attached (mocked-up extract).

    The costs are inputs from a client and implicitly assume a particular start date within a particular FY (i.e. they generally start in 2018 and are generally less in 2018, implying that the client is assuming they start the build & run of the particular technology around halfway through the year), which I plan to request from the client.

    However, this start date is quite uncertain at this stage, and the sheet needs to be readily flexible according to variation in the particular start date.

    The relevant costs are essentially fixed, not variable with respect to volume.

    Question

    How can I set up the sheet / what formula can I use to shift costs back and forth based on a new start date (and implied current start date)?

    I can only think of quite clunky formulae and I wonder if someone has a more elegant solution?

    Many thanks in advance for any assistance you can provide!

    Kind regards,
    Rachel

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 08-25-2017, 03:46 AM
  2. [SOLVED] How to make automatic 'parallel shift' based on specific start date?
    By wintheranders in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-29-2016, 07:16 AM
  3. Replies: 5
    Last Post: 08-04-2014, 06:42 PM
  4. [SOLVED] 5 year annual turnover calculated from start date - needs slight adjustment
    By aaaaaaiden in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-03-2013, 07:30 AM
  5. [SOLVED] Excel Formula to Show Type of Shift Based on Start and End Time
    By bjnockle in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 07-03-2013, 09:48 PM
  6. How to spread annual forecasts by month across fiscal years by variable start date
    By gbolanis in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-21-2013, 11:59 AM
  7. Count working shift in start and end date
    By eojchin in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-25-2013, 12:48 AM

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