+ Reply to Thread
Results 1 to 5 of 5

Explaining VARIANCE in Sales across two time frames

  1. 07-03-2019, 10:09 PM #1
    chandramouliarun
    chandramouliarun is offline
    Forum Contributor
    Join Date
    10-18-2016
    Location
    Chicago, USA
    MS-Off Ver
    Office 365
    Posts
    220

    Explaining VARIANCE in Sales across two time frames

    Hi All,

    Hope you are doing well!...I am trying to explain the variance in sales across two timeframes and I need to explain the difference in sales with the help of other information that I have such as

    Availability: The percentage of time the product was available in the week
    BuyBox:The percentgae of the time the product had optimal competitive price
    Quantity
    Minimum Price: The floor price below which the product cant sell..
    Cost and manufacturer advertised price...

    Can anyone please help in explaing the variance ins sales using the variables that I have...Any help will be appreciated,.,Attached the file...

    Thanks,
    ARUN
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-03-2019, 11:23 PM #2
    Gregb11
    Gregb11 is offline
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    2,826

    Re: Explaining VARIANCE in Sales across two time frames

    I'm not sure I understand - are you asking us to do an analysis of your data, or a specific Excel question regarding your data?
    Reply With QuoteRegister To Reply
  3. 07-04-2019, 01:51 AM #3
    chandramouliarun
    chandramouliarun is offline
    Forum Contributor
    Join Date
    10-18-2016
    Location
    Chicago, USA
    MS-Off Ver
    Office 365
    Posts
    220

    Re: Explaining VARIANCE in Sales across two time frames

    Hi Greg,

    Apologies that I was not clear!...I am trying to decompose the sales decrease value across the variables Availability,buy box, cost, freight price, min price and MAP -meaning - if the sales decrease is say 100% I am trying to attribute due to availability decrease of 30$ , due to buy box increase of 10$, freight price- decrease of 60$, other cost -decrease of 20$..I am trying to create a relationship/equation for the same...
    Reply With QuoteRegister To Reply
  4. 07-04-2019, 10:26 AM #4
    Gregb11
    Gregb11 is offline
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    2,826

    Re: Explaining VARIANCE in Sales across two time frames

    Maybe someone else can understand, but I'm not seeing a specific Excel how-to question, but more of need to analyze the data.
    Last edited by Gregb11; 07-04-2019 at 10:27 AM. Reason: typo
    Reply With QuoteRegister To Reply
  5. 07-04-2019, 10:53 AM #5
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,647

    Re: Explaining VARIANCE in Sales across two time frames

    Are you looking for someone to build an entire solution for you? If so, the Commercial Services section would be more appropriate, as you can buy points and then offer payment to your helper.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sales price volume mix variance analysis - who can explain!
    By Crawfinator1 in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 02-11-2021, 03:37 AM
  2. How to count multiple time frames and multiple entires in those time frames
    By laurencubed in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-29-2016, 05:03 PM
  3. Using time frames with formulas
    By MZing81 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-22-2015, 02:19 PM
  4. Excel VBA with Internet Explorer (frames within frames?)
    By dluhut in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 04-17-2014, 10:21 AM
  5. [SOLVED] Divide Time Period across different Time Frames (Calculating Interest)
    By kopapa in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-21-2013, 03:09 PM
  6. Formula for Time frames
    By Ricardo9211 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-18-2011, 02:37 PM
  7. converting time frames
    By kylefoley76 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-07-2010, 05:45 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1