Setup a Formula to Calculate Carriage Costs based on List

Closed - This job posting has been filled and work has been completed.
Web, Mobile & Software Dev Other - Software Development Posted 9 months ago

Fixed Price

Delivery by July 31, 2014

$50.00

Budget

Details

I need a formula that works out the carriage cost of certain price breaks of products

So the quantities would be:

100 - 250 - 500 - 1000 - 2500

I have a column that tells me how many products fit in a carton.

I then have a list of the carton carriage rate.
I pthen have a list of the pallet carriage rate

At some point the cartons fit onto a pallet and extra cartons are charged separately.

So I need the formula creating that works out what the total carriage cost will be for that price break.

I'll give you a link to the google sheet that you can work on when I accept a freelancer.


About the Client

(4.84) 4 reviews

United Kingdom
Kent 03:10 PM

10 Jobs Posted
70% Hire Rate, 1 Open Job

$3,507 Total Spent
8 Hires, 4 Active

$9.45/hr Avg Hourly Rate Paid
318 Hours

Member Since Dec 9, 2013