You would set up a sheet for all the fruit you process, showing the Details
of your products, such as Gross weight and Nett weight. It is then simply a
matter of multiplying the number of boxes by its (the box's) weight, and
deviding by the nett weight per item to determine the number of items to
order. If you need to order by weight, then multiply the obtained number by
the gross weight.
Say A2 is the name of the product, B2 the Gross weight, C2 the waste, then
D2 =
=B2-C2 to get the nett weight.
Say you have your boxes listed in A10 (200 grm) and A11 (400 gram)
In B10 and B11 list the order quantities.
In C10 enter =B10*A10/D2
In C11 enter =B11*A11/D2
Ideally, you would however set up your product list on one sheet, and do
your calculations on another. You would the use VLOOKUP to reference the
products list, with offset columns.Lets say your products list is called
products, and is made up of a range A2:D20.
On Sheet 2, in A1 you enter ITEM, in A2, you type in the product you wish to
provide. B1 bears 200 and C1 bears 400. In B2 and C2 you enter the number
of boxes required. In B3 you enter
=IF(B2="","",B2*B1/VLOOKUP(A2,products,4,FALSE))This will give you the number
of items to order.If you want weight, iso qty, change this formula to read
=IF(B2="","",B2*B1/VLOOKUP(A2,products,4,FALSE)*VLOOKUP(A2,products,2 ,FALSE)). That will give you weight required.
"AKFRUIT" wrote:
Hello Forum
Hope you can help me solve this one.
I pack fruit in 200 and 40o gram cartons. This is pure fruit with the
waste taken off.
EG - 1 pineapple will weigh 1200 grams whole. Once I have prepared this
then the following is the breakdown (Waste skin is 800g) and (pure fruit
400 grams).
Therefore if a customer orders 70 boxes of the 200 gram carton and 40
cartons of the 400 grams I need to calculate how much whole pineapple
in weight do I have to order.
Hope you understand and please someone help me.
Thanks
Martin
--
AKFRUIT
------------------------------------------------------------------------
AKFRUIT's Profile: http://www.excelforum.com/member.php...o&userid=33796
View this thread: http://www.excelforum.com/showthread...hreadid=535640