In general economics a price Quantity function (PQF) is known.
To determine this function: a firm decides to do some test sales in some certain shops . the price was a varied in these shops.
(attached in pdf )
find out the function for the (PQF) .
estimate the price for a given max. production quantity by scaling to 200 shops.
p.s. prefered by excel
Have you done any of these?