Quote Generator---Help! RRS feed

  • Question

  • Ok, so I just started a new job and the new owner has given me the task of setting up a quote generator in excel to expidite phone calls. My problem is that there is such an immense amount of data, I don't even know where to begin. I'm attaching the sheet with all my information if someone could help me I would really appreciate it!

    I have 11 zones totaling 90 cities. 7 zones are in WV 4 are in MD. For each zone there are different prices for A) daily rental fee B) Haul per truck fee C) Delivery fee D) Tonnage fee

    So when I enter a city I want it to pull up the prices related to that city and be able to input the amount of days and estimated amount of tonnage and haul per trucks and it gives me an estimate.

    (days rented*rental fee)+(number of estimated hauls*haul per truck fee)+(estimated tonnage*tonnage fees)+delivery fee=estimate!

    ta-da so easy yet so difficult!

    Friday, January 23, 2015 7:46 PM

All replies