Quote calculator
Price a quote from your price list, customer type, quantity and tax, and see the margin.
Three tabs. Settings holds the tax rate and discounts. Price list holds each product's price and cost. Quotes works out the discount, tax, total and margin for each quote from those two.
Try this templateAsk it things like
- “What is the total on quote Q-2003?”
- “What is the margin on quote Q-2001?”
- “What is the total value of quotes we have sent but not won yet?”
- “How many quotes did we win?”
- “Which quotes got the bulk discount?”
What you can do
- Look up quotes
- Create a quote
- Update a quote's status
- Change a price
- Change the tax rate or a discount
What is in the sheet
Settings: Setting, Value
Price list: SKU, Product, Unit price, Unit cost
Quotes: Quote ID, Date, Customer, Customer type, SKU, Quantity, Product, Unit price, Discount, Subtotal, Tax, Total, Margin, Status