How to calculate the quantity ?

nacggk

New member
Joined
Mar 11, 2019
Messages
2
Customer requirements
11324

Supplier list

11326
11323
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

Dr.Peterson

Elite Member
Joined
Nov 12, 2017
Messages
3,595
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
Joined
Mar 11, 2019
Messages
2
Thanks. How about the anchovy sauce? Why to get 12 bottles?
 

Dr.Peterson

Elite Member
Joined
Nov 12, 2017
Messages
3,595
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?
 
Top