# Build an algorithm for our website

2. I need a formulae that will automate and produce accurate and

optimal deals for my group buying site.

The Variables for this include :

1. Freight calculator - [url removed, login to view] -to

calculate the cost of freight - ( height x width x depth = rate per m3 ,

weight in kg where relevant. -

2. customs rates and taxes for various countries and common goods

electricity, telephone, internet etc...maybe a fix sum \$10-\$20

4. Cost of goods, - supplier price , cash price? , container load

price? usd?

5. how many of the goods can fit into the container

6. based on questionaire - and average industry information - the likely

quantity of ordering ie. for example a restaurant would order based on

how many tables they have, number of employees, estimated turnover a

month or year. ie. A figure through research that the average asian

restaurant in melbourne has about 20 tables 4 employees and turns over 1

million a year - goes through 200kg of rice a week. 8 x 25kg bags or 32

bags a month.

and they have storage for 32 bags. (which fits well on one pallet).

7. So once all the variables are inputed and the profit margin is added

- the deal caculator will calculate optimal sell price and qty and

delivery /logistics offering.

8. The calculator will also Vett the sell price against the local

competition price. And can be set as a variable.

The price must be cheaper than LIKE FOR LIKE product by 20%. Then

it will let it past to be published.

An example is listed below to aid understanding :

We have decided to do a deal on 25kg jasmine restaurant grade rice for

restaurants in the Australian city of Melbourne. The supplier is in the

Mekong Delta , Vietnam

Costing Variables - USD AUD EUROs

Product Cost (PC) \$15 Target Cost (TC) Cheapest Local Price

(CLP) plus Customize Packaging

Freight Calculator --- see template on website provided

h - 80cm width 55cm d 28cm , kg 25kg

20ft container - \$3000 USD

Average order - 32 bags per restaurant - one full pallet.

Tax \$1000

duty \$500

local port charges \$500

Average freight to end customer of one pallet x expressed as per bag -

\$160 per pallet \$5 per bag

profit margin - \$5 a bag x 1000 bags. ( estimated fit into 20ft

container) - manually entered.

what is the cheapest sell price in melbourne (manually entered) \$35

Once all the variables are entered , the calculator will give the

optimal sell price for us and tell us whether

the deal is feasible and able to go ahead.

Then we can proceed to the next level.

( 0 reviews ) Vietnam

Project ID: #6120803

## 4 freelancers are bidding on average \$164 for this job

ognjen011

A proposal has not yet been provided

\$147 USD in 3 days
(43 Reviews)
5.7
pranshua1

Hi, Can we talk? Please check my profile for the reviews and the work I have done in th.e past I will give you the best results I promise and I won't ask for any money before your work is done. Cash Back Guara More

\$222 USD in 5 days
(6 Reviews)
3.9
pmullappilly

Hi, I have 15 years of experience in electronic circuit design,programming and [login to view URL] experience include microcontroller and FPGA based system design using C,VHDL and verilog. I can do this work for you. Than More

\$111 USD in 7 days
(0 Reviews)
0.0
kashmira1983

Hi..Before i introduce myself i would like to tell you that my husband works for cargo commercial department and he understand the logistic world . About me I have been part of strategic planning for 5 years an More

\$177 USD in 7 days
(0 Reviews)
0.0