I have made a list of 28 online pharmacies containing prices of 75 drugs in order to find out what pharmacy is the cheapest by calculating the total basket value.
Because non of the pharmacy has 100% products, I have to calculate price of the products that are missing. I don't want calculate the average price and use it in case the pharmacy doesn't have the specific product - it won't be fair towards cheap pharmacies that don't have many of the products.
I want to calculate the average price of the missing product taking into account price level of other products that are avaliable in certain pharmacy - if the pharmacy in cheap, I assume that the missing product will be cheap as well.
13 freelancer đang chào giá trung bình $33 cho công việc này
Hi. I am an affiliate chartered accountant (equivalent to CPA) and a financial expert since 2009. i can take care of your weighted average cost issue as per requirement. Please contact and discuss the details.