Apparel quote/price list form

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