How do I set up excel to make estimating(pricing) easier?

[Ann from CCC]

I am trying to find out how to use excel as a estimating or pricing program.
Does anyone know how to do this?

 

[L. Howard Kittle]

Hi Ann,

I can send you a simple (fake) sample worksheet of pricing out the cost of
manufacturing and shipping a washing machine. It may help you to get
going. It uses drop down lists and VLOOKUP formulas to estimate the price
of different options and shipping prices based on different zones.

Regards,
Howard

 

[Gord Dibben]

Ann

See if any of these MS Templates will do the trick.

http://office.microsoft.com/en-us/results.aspx?Scope=TC&Query=estimate



Gord Dibben Excel MVP

On Tue, 29 Mar 2005 15:25:05 -0800, Ann from CCC <Ann from

 

[Ann from CCC]

Hi Ann,

I can send you a simple (fake) sample worksheet of pricing out the cost of
manufacturing and shipping a washing machine. It may help you to get
going. It uses drop down lists and VLOOKUP formulas to estimate the price
of different options and shipping prices based on different zones.

Regards,
Howard




I would appreciate the help. You can send it to [email protected]

Thanks,
Ann

 

[scott]

Hi Ann,

I am an estimator...and we used to use excel as our template.....if
interested you may email me for more details.

Scott

[email protected]

 

[scott]

Ann

Opps..sent comments to [email protected]


sorry

 

[scott]

Geez .......

My correct email is....

[email protected]



sorry again!!!!