MARKUP

Description

The markup is used to calculate all of your figures beginning with your product discounted price from manufacturer material costs labor costs commissions 3 added to total before tax to compensate for credit card fees 3 cash discount set up for clients who pay cash All of this information is transferred to the contract template
This was done in two separate workbooks so that the markup could not be accidentally sent to the client by email Once information is calculated you can then email the invoice right from excel.
http://www.docstoc.com/docs/6083760/INVOICE---CONTRACT

Reviews

Shared by: Debbie Adams

Tags

contract, invoices, calculations, commissions, sales, forms, form, template, templates

Stats

views:: 21
rating:: not rated
reviews:: 0
posted:: 5/19/2009
language:: English
pages:: 0

Public Domain

COMPANY NAME Client Address City, State, Zip Home # Work # LOCATION 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 0 COST OF WINDOW 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 MATERIAL Material & Costs 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Markup % Markup Total 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Labor QTY Price Manufacturer % Manu Dis. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.0 Cost of 1 Window 0.0 Total Cost Qty x Cost of 1 window 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Comm% W H STYLE Date: Term of Sale Job Address Mobile # Email Notes INSTALLATION GLASS ` SQ.FT. 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Comm Total 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3%TOTAL DISCOUNT 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Total with 3% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00 $0.00 TAX RATE 9.5% 9.5% 9.5% 9.5% 9.5% 9.5% 9.5% 9.5% 9.5% 9.5% 9.5% 9.5% 9.5% 9.5% 9.5% 9.5% 9.5% 9.5% 9.5% 9.5% 9.5% Total Tax 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Total 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $0.00