+ Reply to Thread
Results 1 to 6 of 6

Cost per unit formula

  1. #1
    Registered User
    Join Date
    02-22-2009
    Location
    Devon, Alberta
    MS-Off Ver
    Excel 2007
    Posts
    2

    Cost per unit formula

    Calculating the cost in column l,m.& n based on unloading time in column g hourly rate in column o and total staff in column d

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Cost per unit formula

    L6: =24 * g6 * $o6

    m6: =24 * j6 * $o6

    n6: =24 * k6 * $o6
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    02-22-2009
    Location
    Devon, Alberta
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Cost per unit formula

    Thanks for your help. This worked

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Cost per unit formula

    You’re welcome. Would you please mark the thread as Solved?

    Click the Edit button on your first post in the thread

    Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes

  5. #5
    Registered User
    Join Date
    10-25-2014
    Location
    Columbus, Ohio
    MS-Off Ver
    8
    Posts
    1

    Re: Cost per unit formula

    I am looking for an excel template to track service workers unit cost

  6. #6
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,447

    Re: Cost per unit formula

    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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