Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Greeley, Colorado
    Posts
    188
    Thanks
    8
    Thanked 1 Time in 1 Post

    Calculating variable costs per item

    I have a set of data like below
    A B C C E F G
    Item NumSold Price Cost Markup %Total VariableCostsEa

    I have from my acctg program a total variable costs for the period and right now I'm just using the formula (G=F7*total variable costs) to get the amount. However, given that the Cost is different for several Items it seems to me this is not accurate. Can anyone de-clutter my mind here?

    I've attached a sample spreadsheet I'm working with.
    Attached Files Attached Files

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,435
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    What items make up you're variable costs? Is there any way to allocate them to a specific labor category?
    Unless you have a way to allocate these costs I don't see anything wrong with the way you're allocating the costs.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •