Excel spreadsheet
2 parts
part 1 quote form
User enters information and variables to create an 8.5x11 quote that is saved as PDF and emailed to a customer
Part2 price list
Using the same calculations user enters net cost and gross profit margin and price list is generated
## Deliverables
Attached file is an example of the calculations used. This needs to be modified.
The pricing is for custom screen printed or embroidered apparel. We buy the blank goods and they are either imprinted or embroidered by our subcontractors.
Part 1 Quote
* User enters customer name, item number, description, color, and size. This is for the customer view on the quote, not used for calculations
* Calculations based on/ user enters:
* Net cost of blank garment
* Type of decoration - screen print or embroidery
* Number of colors for screen print
* Number of stitches for embroidery
* Number of decoration locations
* Quantity
* Shipping in cost
* Miscellaneous cost field
* Gross profit desired
* Program calculates and displays
* Sell Price each
* Total
* Setup charge
* Professional form with our logo and static copy, and date
* User can over-ride calculated price on final form
Part 2 price list
There will be a list of common items
User will enter cost of blank goods
User will enter gross profit margin
Form will calculate prices in quantity breaks
one page using embroidery costs and one page using screen print costs.
- Additional price for print locations, colors, and additional stitches will be a separate line on the price list. Base prices are 1 color 1 side for screen print and 1 location 5,000 stitches for embroidery