+ Reply to Thread
Results 1 to 2 of 2

Calculate daily targets given: month, monthly budget, daily indexes

  1. #1
    Registered User
    Join Date
    09-06-2013
    Location
    Brisbane, qld
    MS-Off Ver
    Excel 2010
    Posts
    1

    Calculate daily targets given: month, monthly budget, daily indexes

    Hello excel experts,

    I am attempting to produce a spreadsheet to help track daily and weekly sales compared to budget - given a monthly budget. For example $300,000 budget for a 30 day month = $10,000 a day and $70000 per week. However I significant variances in trade on certain days of the week. E.g closed Sunday, quiet Saturday, busy Thursday. I have calculated indexes for each day of the week and can calculate daily budgets given a weekly budget but I can't do this using my monthly budget.

    I was hoping there was someway of allocating each day an index and supply a budget for a specific month (e.g. September 2013) and then have excel recognise how many of each day of the week fall in that month and calculate the daily budgets accordingly.

    Thanks in advance

  2. #2
    Registered User
    Join Date
    07-16-2013
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007
    Posts
    34

    Re: Calculate daily targets given: month, monthly budget, daily indexes

    please attach a workbook with desure result........

+ 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. Calculate Totals weekly and Monthly from daily Figures
    By mfjanoo in forum Excel General
    Replies: 3
    Last Post: 03-05-2012, 03:06 PM
  2. Need to calculate monthly averages from daily values
    By smiso24 in forum Excel General
    Replies: 2
    Last Post: 07-13-2011, 01:03 PM
  3. Replies: 2
    Last Post: 01-09-2010, 04:06 AM
  4. Help with forumla to calculate daily targets
    By Climaxgp in forum Excel General
    Replies: 5
    Last Post: 04-09-2009, 08:57 AM
  5. How Do You Calculate On-Going Daily/Monthly Interest?
    By StevenLAX in forum Excel General
    Replies: 1
    Last Post: 03-01-2005, 09:23 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1