Unit Cost Calculation
Hi Folks,
We have a unit cost spreadsheet that was built in openoffice. I'd like to convert it to numbers and clean it up to be "numbers style" (i.e. not one gigantic table with a bunch of different sections). I'm having some trouble organizing this though. Here is what we have right now:
Row a contains things like the names of raw materials, types of packaging, & labor.
The first couple of column contain calculations on these like cost per KG of raw materials, cost per unit for packaging, etc).
The following columns contain each product. So each product has a column where you can enter in how much of each raw material, packaging, & labor are required to make it. The next column displays the cost for all of these things. At the bottom of this column is a summation of the total cost for this product. Then there is another spreadsheet that pulls these numbers to calculate margins and things of that nature.
I can accomplish all of this in numbers, separating all of the functional sections into different tables, but the problem is this: Say I go to add a new raw material or a new type of packaging, when I add a row, the rows in all the other tables become "off" by a row. That is, if I add a new raw material, then the table that has the product formulas no longer reflects the right amounts of each raw material because it's been thrown off by that row. Am I approaching this wrong, or is there some way to make numbers keep track of row/column additions & deletions across tables that reference each other? Thanks.
We have a unit cost spreadsheet that was built in openoffice. I'd like to convert it to numbers and clean it up to be "numbers style" (i.e. not one gigantic table with a bunch of different sections). I'm having some trouble organizing this though. Here is what we have right now:
Row a contains things like the names of raw materials, types of packaging, & labor.
The first couple of column contain calculations on these like cost per KG of raw materials, cost per unit for packaging, etc).
The following columns contain each product. So each product has a column where you can enter in how much of each raw material, packaging, & labor are required to make it. The next column displays the cost for all of these things. At the bottom of this column is a summation of the total cost for this product. Then there is another spreadsheet that pulls these numbers to calculate margins and things of that nature.
I can accomplish all of this in numbers, separating all of the functional sections into different tables, but the problem is this: Say I go to add a new raw material or a new type of packaging, when I add a row, the rows in all the other tables become "off" by a row. That is, if I add a new raw material, then the table that has the product formulas no longer reflects the right amounts of each raw material because it's been thrown off by that row. Am I approaching this wrong, or is there some way to make numbers keep track of row/column additions & deletions across tables that reference each other? Thanks.
Macbook pro, Mac OS X (10.5.7)
