# How to calculate the quantity ?

#### nacggk

##### New member
Customer requirements

Supplier list

PRESSED BARLEY, 1 KG PKT

I have 2 spreadsheets which one shows what customers want to buy and another which shows the supplier's list.
As the customers required quantity does not match with my list, the spreadsheet is showing an error message #NA.
After amending the description on the customers required list to the same as the supplier list, how should I calculate the quantity for how many packets, and bottles ?

Below is the correct packets and bottles but how to calculate this ?
Pickled radish whole, 1kg - 5 pkt
Anchvy sauce liquid 800ml - 12 bottles
Pressed barley, 1kg - 4 pkt

#### Attachments

• 2.8 KB Views: 3

#### Dr.Peterson

##### Elite Member
I'm not quite sure of the context, but as I read it, for the pickled radish you need to calculate the total amount requested (500 g per packet times 10 packets = 5000 g = 5 kg) and then calculate the number of the supplier's packets that will provide that amount (5 kg / 1 kg per packet = 5 packets).

This assumes, of course, that all that matters is the total quantity, not the actual packets.

#### nacggk

##### New member
Thanks. How about the anchovy sauce? Why to get 12 bottles?

#### Dr.Peterson

##### Elite Member
That will depend on the density of the sauce, which you'd have to find separately. You have two different ways of measuring it, which requires more than mere conversion.

IF the sauce has the same density as water (1 g/ml), then 800 ml would be 800 grams = 0.8 kg per bottle. The customer needs 10 kg, which is 10 kg/0.8 kg/btl = 12.5 bottles. If the 12 is exactly correct, the density would be (10,000 g) / (12 * 800 ml) = 1.04 g/ml. Do you have information that would tell you this?