+ Reply to Thread
Results 1 to 14 of 14

Formula to calculate daily sales needed to reach a specific target

Hybrid View

  1. 12-15-2016, 04:01 PM #1
    JohnTopley
    JohnTopley is offline
    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
    28,526

    Re: Formula to calculate daily sales needed to reach a specific target

    I have looked at using "averages" for each day but to no avail: in this specific case the required future daily sales FAR exceed the current sales volumes so a simple calculation of a single common daily amount will suffice.

    To meet your 110000 target you need daily sales of >3500 which well in excess of current sales.
    Last edited by JohnTopley; 12-15-2016 at 04:12 PM.
    Reply With QuoteRegister To Reply
  2. 12-17-2016, 05:04 AM #2
    smsmworld
    smsmworld is offline
    Registered User
    Join Date
    09-05-2016
    Location
    cairo
    MS-Off Ver
    Office 2016
    Posts
    39

    Re: Formula to calculate daily sales needed to reach a specific target

    Thank you so much sir for your efforts. would breaking down Sun-Thu to calculate each day separately, make it easier?
    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. Daily Sales Target Sheet
    By geejaysimp in forum Excel General
    Replies: 11
    Last Post: 10-06-2022, 04:44 AM
  2. [SOLVED] Looking for a way to calculate items needed to reach target %
    By UNCDave13 in forum Excel General
    Replies: 13
    Last Post: 01-24-2017, 02:05 AM
  3. sales Report to calculate formula for Daily prodution by salesman
    By shan2an in forum Excel General
    Replies: 1
    Last Post: 07-20-2015, 09:49 AM
  4. Formula regarding daily target sales calculation
    By jasonschafer in forum Excel General
    Replies: 1
    Last Post: 01-20-2015, 09:32 AM
  5. Finding a Daily Average needed to reach a Monthly goal
    By photoant in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-02-2014, 09:19 PM
  6. Need auto updating calculation of daily sales needed to meet monthly sales goals
    By mmaibl2011 in forum Excel General
    Replies: 2
    Last Post: 10-17-2013, 11:52 AM
  7. [SOLVED] Daily AVG needed to reach monthly goal - Example Attached
    By rufus40444 in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 02-20-2013, 02:47 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1