M
marsha
I want to use a spreadsheet to track inventory and value of inventory.
I think a 4 column spreadsheet would do it the way I need to track items.
The first column would be Items. Tomato sauce might be item one
for instance.
The second column would be Quantity. Under Quantity
on the Tomato row might be 12 cans.
The third column would be Case or Tub Price and would provide the
units per case and case price (so it might read 5 per case $25).
I need a formula for the fourth column which would be Price per item or
pound
(i.e. $5/can) which is derived by dividing the number of items per case
into the total cost of case.
The last and fifth column would also need a formula and would be
the Value of Inventory. So if there were only 4 cans, the value for that
row (the tomato sauce) would be 4 x $5 = $20.
I'm sorry to cover this in such detail but I have been doing this all by
hand every day. How do I put in the formulas to automatically get the
correct amounts without having to do the math every day??
Thanks very much to the kind soul who helps.
I think a 4 column spreadsheet would do it the way I need to track items.
The first column would be Items. Tomato sauce might be item one
for instance.
The second column would be Quantity. Under Quantity
on the Tomato row might be 12 cans.
The third column would be Case or Tub Price and would provide the
units per case and case price (so it might read 5 per case $25).
I need a formula for the fourth column which would be Price per item or
pound
(i.e. $5/can) which is derived by dividing the number of items per case
into the total cost of case.
The last and fifth column would also need a formula and would be
the Value of Inventory. So if there were only 4 cans, the value for that
row (the tomato sauce) would be 4 x $5 = $20.
I'm sorry to cover this in such detail but I have been doing this all by
hand every day. How do I put in the formulas to automatically get the
correct amounts without having to do the math every day??
Thanks very much to the kind soul who helps.