Prepare a quotation from your rate card
Pick items from your own rate card and get a clean quote.
- ForDistributors, contractors and service firms that quote every day.
- HelperQuotes
- ModeBerri Strawberry 1
- AttachExcel sheet
Copy the prompt
This is my rate card. Make a quotation for [customer type] for [items and quantities], with a [percent] discount on the total. Show it as a table and add delivery and validity lines.
Change the words in [brackets] to your own.
What to attach
An Excel sheet (.xlsx). Berri reads the first sheet, so keep the data there.
Run it
Berri opens with the prompt filled in and the Quotes helper picked. Nothing is sent until you press send.
Run this in BerriTips
- Ask Berri to open the quote in Canvas to edit wording before you copy it.
- Keep your rate card on the first sheet so Berri reads the right one.
Prepare a quotation from your rate cardQuotes
XLSrate-card.xlsx
This is my rate card. Make a quotation for a school for 60 desks, 60 chairs and 4 almirahs, with a 5% discount on the total. Show it as a table and add delivery and validity lines.
Reading rate-card.xlsx
Quotation for the school:
| Item | Qty | Rate | Amount |
|---|---|---|---|
| Student desk | 60 | Rs 2,400 | Rs 1,44,000 |
| Student chair | 60 | Rs 1,150 | Rs 69,000 |
| Steel almirah | 4 | Rs 11,500 | Rs 46,000 |
| Less 5% | Rs 12,950 |
Total Rs 2,46,050. Delivery in 10 working days. Valid for 15 days.
Figures here are made up to show the shape of the answer. Yours come from your own file and words.