Costing model for sales people

Richiejjj

Board Regular
Joined
Feb 18, 2002
Messages
237
Hi

Can somebody advise a good excel book / templates for designing a model to be used by a sales team in the production of quotes.

The model will contain a large range of inputs including number of people, hours, rates, consumables required, types of service, etc.

Quite a complex input process, that I want to ensure is simply and easy to use by non-excel heads.

Thanks
Richie
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

wigi

Well-known Member
Joined
Jul 10, 2006
Messages
7,958
Office Version
  1. 365
Platform
  1. Windows
  2. Mobile
  3. Web
Quite a complex input process, that I want to ensure is simply and easy to use by non-excel heads.

Hey Richie

I would suggest that you start with a basic setup, and once you encounter issues you can start a topic in the Excel subforum for your question.

You know better than us how the sheet must look like and what it should be able to do.

We can only guess and that's probably why you haven't had any replies yet.
 

Watch MrExcel Video

Forum statistics

Threads
1,130,346
Messages
5,641,598
Members
417,225
Latest member
LukiiMaxim96

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top