Calculating variable costs per item

Topic

New Reply

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.

Reply | Quote

Replies

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.:cheers:

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote