+ Reply to Thread
Results 1 to 3 of 3

Excel Commission/ Bonus Spreadsheet with several % and dollar amount deductions?

  1. #1
    Registered User
    Join Date
    03-21-2017
    Location
    Petoskey, MI
    MS-Off Ver
    15.32
    Posts
    1

    Excel Commission/ Bonus Spreadsheet with several % and dollar amount deductions?

    My boss is requesting an Excel Spreadsheet that I can't seem to find a template for...and I'm not THAT skilled in Excel to make one.

    Wants it to read like this

    Customer - Retail Cost $ - Deduct 5% - Deduct 15% overhead, Deduct Materials $ , Deduct Labor $, = Total Profit to business $, 5% Bonus from Total Profit


    PLEASE HELP ME....I'm going to try to create this in the meantime...wish me luck haha

  2. #2
    Registered User
    Join Date
    06-04-2014
    Location
    USA
    MS-Off Ver
    Office 2016
    Posts
    72

    Re: Excel Commission/ Bonus Spreadsheet with several % and dollar amount deductions?

    Could you create a sample row of data with expectations for each of the variables you listed? This will ensure that we are clear with the request from there it would be pretty straight forward to build in the calculations.

  3. #3
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,684

    Re: Excel Commission/ Bonus Spreadsheet with several % and dollar amount deductions?

    What information are you planning to enter into the spreadsheet

    are you trying to find the retail cost - or working the profit out

    Retail cost

    so to deduct 5%

    = cell with retail cost *0.95

    where will the 15% be deducted from ,the retail cost of the cell that already has 5% deducted ?

    where are you getting the material cost from
    where are you getting the labour cost from

    once you have the total profit for the business -
    you then want to calculate 5% bonus
    = cell with total profit * 0.05

    BUT if you are taking that out of the business then its not a total profit
    its more of a margin figure

    the profit will be after ALL the deductions

    Net profit - before tax

    attach the spreadsheet , that you have created ?
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ 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. Accounts Spreadsheet - Formula for working out amount deductions
    By JBO007 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-25-2016, 12:06 PM
  2. [SOLVED] Calculate Projected Annual amount from Dollar value (Amount) and varying time intervals
    By old dawg in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-16-2016, 07:29 PM
  3. Formula for Staff Bonus / Commission
    By drdevin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-10-2015, 01:41 PM
  4. Monthly salary + commission - tax deductions
    By gaz76 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-25-2015, 10:44 AM
  5. Replies: 4
    Last Post: 09-14-2011, 06:23 PM
  6. [SOLVED] Excel Function for max of percentage or dollar amount
    By Keeprogoal in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-28-2006, 04:35 PM
  7. How do I add the same dollar amount to all cells in excel?
    By CNewman in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-09-2006, 09:50 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