+ Reply to Thread
Results 1 to 2 of 2

Need Daily Sales plan vs actual sales and revised sales plan.

  1. #1
    Registered User
    Join Date
    07-07-2019
    Location
    Bangladesh
    MS-Off Ver
    365
    Posts
    12

    Need Daily Sales plan vs actual sales and revised sales plan.

    Hello,

    I have a daily sales plan for a month. I need to compare the daily sales plan with the actual sales, and if the actual sales are less than the daily plan, I need to create a new revised plan using a specific formula. I have attached the file for your consideration.



    Regards,
    Ibrahim
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    31,026

    Re: Need Daily Sales plan vs actual sales and revised sales plan.

    First, there is a week's worth of "Actual" sales missing - so required daily target is incorrect - plus there is no explanation of the logic behind the daily targets.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

+ 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. Replies: 2
    Last Post: 03-08-2024, 10:31 AM
  2. [SOLVED] Help! Need variable daily sales targets to total monthly sales goal
    By Chronohog in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-31-2018, 02:54 PM
  3. Advanced IF Formula - For three tier sales compensation plan
    By AJD2016 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-11-2016, 02:22 PM
  4. Calculating Daily sales and dividing by weekly plan for retail formula!
    By cjdrucquer in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-09-2013, 02:30 PM
  5. Help for this sales plan?
    By brettmartin in forum Excel General
    Replies: 4
    Last Post: 08-20-2011, 06:02 PM
  6. Trying to create a comp plan for sales reps
    By Robert Brown in forum Excel General
    Replies: 3
    Last Post: 07-20-2006, 05:05 PM
  7. to compare sales plan vs actuals from two different worksheets?
    By Prabhu Gowda in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-24-2006, 08:00 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