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.