Spaces:
Sleeping
Sleeping
| import pandas as pd | |
| margin_data = [ | |
| (0, 0.4), (150, 0.5), (210, 0.525), (275, 0.55), (345, 0.575), | |
| (840, 0.6), (1563, 0.625), (2600, 0.65), (4290, 0.66), (6030, 0.67) | |
| ] | |
| emb_data = { | |
| "Stitches Creation Inc.": { | |
| "Quantity": ["0-11", "12-17", "18-23", "24-35", "36-59", "60-119", "120-239", "240-599","600+"], | |
| "1-1,000": [10.00, 5.00, 4.00, 3.25, 2.75, 2.25, 2.00, 1.75, 1.50], | |
| "1,000-2,000": [11.00, 5.50, 4.40, 3.60, 3.05, 2.53, 2.27, 2.01, 1.75], | |
| "2,001-3,000": [12.00, 6.00, 4.80, 3.95, 3.35, 2.81, 2.54, 2.27, 2.00], | |
| "3,001-4,000": [13.00, 6.50, 5.20, 4.30, 3.65, 3.09, 2.81, 2.53, 2.25], | |
| "4,001-5,000": [14.00, 7.00, 5.60, 4.65, 3.95, 3.37, 3.08, 2.79, 2.50], | |
| "5,001-6,000": [15.00, 7.50, 6.00, 5.00, 4.25, 3.65, 3.35, 3.05, 2.75], | |
| "6,001-7,000": [16.00, 8.00, 6.40, 5.35, 4.55, 3.93, 3.62, 3.31, 3.00], | |
| "7,001-8,000": [17.00, 8.50, 6.80, 5.70, 4.85, 4.21, 3.89, 3.57, 3.25], | |
| "8,001-9,000": [18.00, 9.00, 7.20, 6.05, 5.15, 4.49, 4.16, 3.83, 3.50], | |
| "9,001-10,000": [19.00, 9.50, 7.60, 6.40, 5.45, 4.77, 4.43, 4.09, 3.75], | |
| "10,001-11,000": [20.00, 10.00, 8.00, 6.75, 5.75, 5.05, 4.70, 4.35, 4.00], | |
| "11,001-12,000": [21.00, 10.50, 8.40, 7.10, 6.05, 5.33, 4.97, 4.61, 4.25], | |
| "12,001-13,000": [22.00, 11.00, 8.80, 7.45, 6.35, 5.61, 5.24, 4.87, 4.50], | |
| "13,001-14,000": [23.00, 11.50, 9.20, 7.80, 6.65, 5.89, 5.51, 5.13, 4.75], | |
| "14,001-15,000": [24.00, 12.00, 9.60, 8.15, 6.95, 6.17, 5.78, 5.39, 5.00], | |
| "15,001-16,000": [25.00, 12.50, 10.00, 8.50, 7.25, 6.45, 6.05, 5.65, 5.25], | |
| "16,001-17,000": [26.00, 13.00, 10.40, 8.85, 7.55, 6.73, 6.32, 5.91, 5.50], | |
| "17,001-18,000": [27.00, 13.50, 10.80, 9.20, 7.85, 7.01, 6.59, 6.17, 5.75], | |
| "18,001-19,000": [28.00, 14.00, 11.20, 9.55, 8.15, 7.29, 6.86, 6.43, 6.00], | |
| "19,001-20,000": [29.00, 14.50, 11.60, 9.90, 8.45, 7.57, 7.13, 6.69, 6.25] | |
| }, | |
| "Nextshirt Printing Co. Ltd.": { | |
| "Quantity": ["0-3", "4-12", "13-24", "25-36", "37-72", "73-144", "145-288", "289-500", "500+"], | |
| "0-4999": [4.45, 4.24, 4.04, 3.85, 3.62, 3.08, 2.89, 2.78, 2.78], | |
| "5000-5999": [5.60, 5.39, 5.20, 5.01, 4.61, 4.24, 4.05, 3.94, 3.94], | |
| "6000-6999": [5.97, 5.76, 5.58, 5.39, 5.01, 4.61, 4.42, 4.31, 4.31], | |
| "7000-7999": [6.36, 6.15, 5.96, 5.76, 5.39, 5.01, 4.82, 4.71, 4.71], | |
| "8000-8999": [6.76, 6.55, 6.35, 6.15, 5.76, 5.39, 5.20, 5.09, 5.09], | |
| "9000-9999": [7.13, 6.92, 6.74, 6.55, 6.15, 5.76, 5.57, 5.46, 5.46], | |
| "10000-10999": [7.51, 7.30, 7.11, 6.92, 6.55, 6.15, 5.96, 5.85, 5.85], | |
| "11000-11999": [7.90, 7.69, 7.50, 7.30, 6.92, 6.55, 6.36, 6.25, 6.25], | |
| "12000+": [12.00, 5.75, 4.70, 3.95, 3.40, 3.00, 2.65, 2.30, 2.00]#dummy | |
| }, | |
| "Elements Imprint": { | |
| "Quantity": ["1-5", "6-23", "24-59", "60-149", "150-299", "300-599", "600-1199", "1200+"], | |
| "0-1,000": [13.75, 5.75, 3.70, 2.55, 2.30, 1.85, 1.60, 1.50], | |
| "1,001-2,000": [13.75, 6.40, 4.20, 2.85, 2.60, 2.10, 1.85, 1.75], | |
| "2,001-3,000": [13.86, 6.99, 4.50, 3.20, 2.90, 2.40, 2.15, 2.00], | |
| "3,001-4,000": [13.97, 7.10, 4.80, 3.55, 3.15, 2.65, 2.40, 2.25], | |
| "4,001-5,000": [14.63, 7.60, 5.15, 3.85, 3.40, 2.90, 2.65, 2.50], | |
| "5,001-6,000": [15.35, 8.20, 5.45, 4.20, 3.60, 3.18, 2.90, 2.75], | |
| "6,001-7,000": [16.15, 8.80, 5.75, 4.50, 3.70, 3.45, 3.20, 2.95], | |
| "7,001-8,000": [16.95, 9.40, 6.10, 4.85, 3.85, 3.70, 3.45, 3.20], | |
| "8,001-9,000": [17.75, 10.00, 6.40, 5.20, 4.20, 3.95, 3.70, 3.45], | |
| "9,001-10,000": [18.98, 10.60, 6.75, 5.50, 4.50, 4.25, 3.90, 3.70], | |
| "10,001-11,000": [19.80, 11.22, 7.05, 5.85, 4.80, 4.50, 4.15, 3.95], | |
| "11,001-12,000": [20.58, 11.85, 7.35, 6.15, 5.10, 4.75, 4.45, 4.20], | |
| "12,001-13,000": [21.35, 12.45, 7.70, 6.50, 5.35, 5.05, 4.70, 4.45], | |
| "13,001-14,000": [22.10, 13.05, 8.00, 6.85, 5.75, 5.30, 4.95, 4.65], | |
| "14,001-15,000": [22.88, 13.65, 8.35, 7.15, 6.00, 5.55, 5.20, 4.90], | |
| "15,001-16,000": [23.75, 14.25, 8.65, 7.50, 6.35, 5.85, 5.45, 5.10], | |
| "16,001-17,000": [24.50, 14.85, 8.95, 7.80, 6.60, 6.10, 5.70, 5.35], | |
| "17,001-18,000": [25.25, 15.45, 9.30, 8.15, 6.95, 6.35, 5.95, 5.55], | |
| "18,001-19,000": [26.00, 16.05, 9.60, 8.50, 7.20, 6.65, 6.20, 5.80], | |
| "19,001-20,000": [26.68, 16.65, 9.95, 8.80, 7.50, 6.85, 6.45, 6.05], | |
| } | |
| } | |
| screen_data = { | |
| "Stitches Creation Inc. (Light)": { | |
| "1-Color Screenprint": pd.DataFrame({ | |
| "Qty": ["below 12", "13 - 18", "19 - 24", "25 - 36", "37 - 60", "61 - 120","121 - 240", "241 - 600"], | |
| "5x5": [5.50, 4.20, 3.50, 2.80, 2.10, 1.50, 1.20, 1.00], | |
| "12x12": [6.20, 4.70, 4.00, 3.20, 2.35, 1.65, 1.30, 1.10], | |
| "18x18": [8.00, 6.00, 5.10, 4.00, 3.00, 2.10, 1.65, 1.40] | |
| }), | |
| "2-Color Screenprint": pd.DataFrame({ | |
| "Qty": ["below 12", "13 - 18", "19 - 24", "25 - 36", "37 - 60", "61 - 120","121 - 240", "241 - 600"], | |
| "5x5": [8.20, 6.20, 5.10, 4.00, 2.90, 2.00, 1.50, 1.20], | |
| "12x12": [9.55, 7.15, 6.00, 4.70, 3.35, 2.25, 1.70, 1.35], | |
| "18x18": [13.00, 9.65, 8.10, 6.20, 4.50, 3.00, 2.20, 1.80] | |
| }), | |
| "3-Color Screenprint": pd.DataFrame({ | |
| "Qty": ["below 12", "13 - 18", "19 - 24", "25 - 36", "37 - 60", "61 - 120","121 - 240", "241 - 600"], | |
| "5x5": [10.90, 8.20, 6.70, 5.20, 3.70, 2.50, 1.80, 1.40], | |
| "12x12": [12.90, 9.60, 8.00, 6.20, 4.35, 2.85, 2.10, 1.60], | |
| "18x18": [18.00, 13.30, 11.10, 8.40, 6.00, 3.90, 2.75, 2.20], | |
| }), | |
| "4-Color Screenprint": pd.DataFrame({ | |
| "Qty": ["below 12", "13 - 18", "19 - 24", "25 - 36", "37 - 60", "61 - 120","121 - 240", "241 - 600"], | |
| "5x5": [13.60, 10.20, 8.30, 6.40, 4.50, 3.00, 2.10, 1.60], | |
| "12x12": [16.25, 12.05, 10.00, 7.70, 5.35, 3.45, 2.50, 1.85], | |
| "18x18": [23.00, 16.95, 14.10, 10.60, 7.50, 4.80, 3.30, 2.60], | |
| }), | |
| "5-Color Screenprint":pd.DataFrame({ | |
| "Qty": ["below 12", "13 - 18", "19 - 24", "25 - 36", "37 - 60", "61 - 120","121 - 240", "241 - 600"], | |
| "5x5": [16.30, 12.20, 9.90, 7.60, 5.30, 3.50, 2.40, 1.80], | |
| "12x12": [19.60, 14.50, 12.00, 9.20, 6.35, 4.05, 2.90, 2.10], | |
| "18x18": [28.00, 20.15, 17.10, 12.80, 9.00, 5.70, 3.85, 3.00], | |
| }), | |
| "6-Color Screenprint": pd.DataFrame({ | |
| "Qty": ["below 12", "13 - 18", "19 - 24", "25 - 36", "37 - 60", "61 - 120","121 - 240", "241 - 600"], | |
| "5x5": [19.00, 14.20, 11.50, 8.80, 6.10, 4.00, 2.70, 2.00], | |
| "12x12": [22.95, 16.95, 14.00, 10.70, 7.35, 4.65, 3.30, 2.35], | |
| "18x18": [33.00, 24.25, 20.10, 15.00, 10.50, 6.60, 4.40, 3.40], | |
| }), | |
| "7-Color Screenprint": pd.DataFrame({ | |
| "Qty": ["below 12", "13 - 18", "19 - 24", "25 - 36", "37 - 60", "61 - 120","121 - 240", "241 - 600"], | |
| "5x5": [21.70, 16.20, 13.10, 10.00, 6.90, 4.50, 3.00, 2.20], | |
| "12x12": [26.30, 18.95, 16.00, 12.20, 8.35, 5.25, 3.70, 2.65], | |
| "18x18": [38.00, 27.90, 23.10, 17.20, 12.00, 7.50, 4.95, 3.90], | |
| }), | |
| "8-Color Screenprint": pd.DataFrame({ | |
| "Qty": ["below 12", "13 - 18", "19 - 24", "25 - 36", "37 - 60", "61 - 120","121 - 240", "241 - 600"], | |
| "5x5": [24.40, 18.20, 14.70, 11.20, 7.70, 5.00, 3.30, 2.40], | |
| "12x12": [29.65, 21.85, 18.00, 13.70, 9.35, 5.85, 4.10, 2.85], | |
| "18x18": [43.00, 31.55, 26.10, 19.40, 14.00, 8.50, 5.40, 4.20], | |
| }), | |
| "9-Color Screenprint": pd.DataFrame({ | |
| "Qty": ["below 12", "13 - 18", "19 - 24", "25 - 36", "37 - 60", "61 - 120","121 - 240", "241 - 600"], | |
| "5x5": [27.10, 20.20, 16.30, 12.40, 8.50, 5.50, 3.60, 2.60], | |
| "12x12": [33.00, 24.30, 20.00, 15.20, 10.35, 6.45, 4.50, 3.10], | |
| "18x18": [48.00, 35.20, 29.10, 21.60, 15.00, 9.30, 6.05, 4.60], | |
| }), | |
| }, | |
| "Stitches Creation Inc. (Dark)": { | |
| "1-Color Screenprint": pd.DataFrame({ | |
| "Qty": ["below 12", "13 - 18", "19 - 24", "25 - 36", "37 - 60", "61 - 120","121 - 240", "241 - 600"], | |
| "5x5": [8.20, 6.20, 5.20, 4.00, 2.95, 2.00, 1.50, 1.25], | |
| "12x12": [9.50, 7.15, 6.00, 4.60, 3.40, 2.30, 1.75, 1.40], | |
| "18x18": [13.00, 9.80, 8.20, 6.25, 4.60, 3.10, 2.30, 1.80] | |
| }), | |
| "2-Color Screenprint": pd.DataFrame({ | |
| "Qty": ["below 12", "13 - 18", "19 - 24", "25 - 36", "37 - 60", "61 - 120","121 - 240", "241 - 600"], | |
| "5x5": [10.90, 8.20, 6.85, 5.20, 3.80, 2.50, 1.85, 1.50], | |
| "12x12": [13.00, 9.65, 8.00, 6.10, 4.45, 2.95, 2.20, 1.70], | |
| "18x18": [18.00, 13.50, 11.20, 8.50, 6.20, 4.05, 2.95, 2.25] | |
| }), | |
| "3-Color Screenprint": pd.DataFrame({ | |
| "Qty": ["below 12", "13 - 18", "19 - 24", "25 - 36", "37 - 60", "61 - 120","121 - 240", "241 - 600"], | |
| "5x5": [13.60, 10.20, 8.50, 6.40, 4.65, 3.00, 2.20, 1.75], | |
| "12x12": [16.50, 12.15, 10.00, 7.60, 5.50, 3.60, 2.65, 2.00], | |
| "18x18": [23.00, 17.20, 14.20, 10.75, 7.80, 5.00, 3.60, 2.70] | |
| }), | |
| "4-Color Screenprint": pd.DataFrame({ | |
| "Qty": ["below 12", "13 - 18", "19 - 24", "25 - 36", "37 - 60", "61 - 120","121 - 240", "241 - 600"], | |
| "5x5": [16.30, 12.20, 10.15, 7.60, 5.50, 3.50, 2.55, 2.00], | |
| "12x12": [20.00, 14.65, 12.00, 9.10, 6.55, 4.25, 3.10, 2.30], | |
| "18x18": [28.00, 20.90, 17.20, 13.00, 9.40, 6.00, 4.25, 3.15] | |
| }), | |
| "5-Color Screenprint":pd.DataFrame({ | |
| "Qty": ["below 12", "13 - 18", "19 - 24", "25 - 36", "37 - 60", "61 - 120","121 - 240", "241 - 600"], | |
| "5x5": [19.00, 14.20, 11.80, 8.80, 6.35, 4.00, 2.90, 2.25], | |
| "12x12": [23.50, 17.15, 14.00, 10.60, 7.60, 4.90, 3.55, 2.60], | |
| "18x18": [33.00, 24.60, 20.20, 15.25, 11.00, 7.10, 4.75, 3.60] | |
| }), | |
| "6-Color Screenprint": pd.DataFrame({ | |
| "Qty": ["below 12", "13 - 18", "19 - 24", "25 - 36", "37 - 60", "61 - 120","121 - 240", "241 - 600"], | |
| "5x5": [21.70, 16.20, 13.45, 10.00, 7.20, 4.50, 3.25, 2.50], | |
| "12x12": [27.00, 19.65, 16.00, 12.10, 8.65, 5.55, 4.00, 2.90], | |
| "18x18": [38.00, 28.30, 23.20, 17.50, 12.60, 7.85, 5.55, 4.05] | |
| }), | |
| "7-Color Screenprint": pd.DataFrame({ | |
| "Qty": ["below 12", "13 - 18", "19 - 24", "25 - 36", "37 - 60", "61 - 120","121 - 240", "241 - 600"], | |
| "5x5": [24.40, 18.20, 15.10, 11.20, 8.05, 5.00, 3.60, 2.75], | |
| "12x12": [30.50, 22.15, 18.00, 13.60, 9.70, 6.20, 4.45, 3.20], | |
| "18x18": [43.00, 32.00, 26.20, 19.75, 14.20, 8.80, 6.20, 4.50] | |
| }), | |
| }, | |
| "Nextshirt Printing Co. Ltd.":{ | |
| "1-Color ScreenPrint": pd.DataFrame({ | |
| "Qty": ["below 6", "6 to 12", "13 - 18", "19 - 24", "25 - 36", "37 - 48","49 - 72", "73 - 96", "97 - 144", "145 - 288", "289 - 500", "Above 500"], | |
| "4x4": [7.42, 4.61, 4.13, 3.53, 2.88, 2.49, 2.13, 1.79, 1.51, 1.19, 0.89, 0.73], | |
| "12x12": [10.47, 6.17, 5.45, 4.51, 3.55, 2.96, 2.49, 1.96, 1.59, 1.35, 1.05, 0.85], | |
| "14x16": [11.87, 7.27, 6.34, 5.19, 4.13, 3.53, 3.02, 2.47, 2.08, 1.75, 1.35, 1.14], | |
| "Darks": [0.35, 0.35, 0.35, 0.35, 0.35, 0.25, 0.25, 0.25, 0.25, 0.15, 0.15, 0.15], | |
| "Fleece": [0.6, 0.6, 0.6, 0.6, 0.6, 0.5, 0.5, 0.5, 0.5, 0.45, 0.45, 0.45], | |
| "90% Poly+": [0.55, 0.55, 0.55, 0.55, 0.55, 0.45, 0.45, 0.45, 0.45, 0.3, 0.3, 0.3], | |
| "Sleeves & Legs":[0.40,0.40,0.40,0.40,0.40,0.40,0.40,0.40,0.40,0.40,0.40,0.40] | |
| }), | |
| "2-Color ScreenPrint": pd.DataFrame({ | |
| "Qty": ["below 6", "6 to 12", "13 - 18", "19 - 24", "25 - 36", "37 - 48","49 - 72", "73 - 96", "97 - 144", "145 - 288", "289 - 500", "Above 500"], | |
| "4x4": [11.0, 7.16, 6.17, 4.91, 3.93, 3.43, 2.84, 2.30, 1.83, 1.58, 1.19, 1.0], | |
| "12x12": [16.74, 10.40, 8.77, 6.76, 5.28, 4.64, 3.74, 2.81, 2.30, 1.83, 1.48, 1.23], | |
| "14x16": [19.29, 12.69, 10.55, 7.93, 6.34, 5.55, 4.54, 3.23, 2.71, 2.29, 1.95, 1.73], | |
| "Darks": [0.45, 0.45, 0.45, 0.45, 0.45, 0.35, 0.35, 0.35, 0.35, 0.25, 0.25, 0.25], | |
| "Fleece": [0.6, 0.6, 0.6, 0.6, 0.6, 0.5, 0.5, 0.5, 0.5, 0.45, 0.45, 0.45], | |
| "90% Poly+": [0.55, 0.55, 0.55, 0.55, 0.55, 0.45, 0.45, 0.45, 0.45, 0.3, 0.3, 0.3], | |
| "Sleeves & Legs":[0.40,0.40,0.40,0.40,0.40,0.40,0.40,0.40,0.40,0.40,0.40,0.40] | |
| }), | |
| "3-Color ScreenPrint": pd.DataFrame({ | |
| "Qty": ["below 6", "6 to 12", "13 - 18", "19 - 24", "25 - 36", "37 - 48","49 - 72", "73 - 96", "97 - 144", "145 - 288", "289 - 500", "Above 500"], | |
| "4x4": [16.11, 10.13, 8.53, 6.58, 5.25, 4.35, 3.73, 3.04, 2.58, 2.02, 1.72, 1.51], | |
| "12x12": [25.81, 15.87, 12.88, 9.72, 7.71, 6.32, 5.26, 3.82, 3.17, 2.75, 2.31, 2.01], | |
| "14x16": [29.55, 17.87, 14.91, 11.29, 9.09, 7.65, 6.27, 4.77, 4.05, 3.40, 3.0, 2.56], | |
| "Darks": [0.55, 0.55, 0.55, 0.55, 0.55, 0.45, 0.45, 0.45, 0.45, 0.35, 0.35, 0.35], | |
| "Fleece": [0.6, 0.6, 0.6, 0.6, 0.6, 0.5, 0.5, 0.5, 0.5, 0.45, 0.45, 0.45], | |
| "90% Poly+": [0.55, 0.55, 0.55, 0.55, 0.55, 0.45, 0.45, 0.45, 0.45, 0.3, 0.3, 0.3], | |
| "Sleeves & Legs":[0.40,0.40,0.40,0.40,0.40,0.40,0.40,0.40,0.40,0.40,0.40,0.40] | |
| }), | |
| "4-Color ScreenPrint": pd.DataFrame({ | |
| "Qty": ["below 6", "6 to 12", "13 - 18", "19 - 24", "25 - 36", "37 - 48","49 - 72", "73 - 96", "97 - 144", "145 - 288", "289 - 500", "Above 500"], | |
| "4x4": [18.88, 11.74, 9.95, 7.72, 6.07, 5.18, 4.37, 3.71, 3.21, 2.43, 2.29, 2.06], | |
| "12x12": [30.81, 18.37, 15.36, 11.86, 9.2, 7.82, 6.27, 4.86, 4.07, 3.13, 2.75, 2.62], | |
| "14x16": [35.8, 21.26, 18.58, 15.17, 10.8, 9.34, 7.62, 5.99, 5.19, 3.92, 3.55, 3.33], | |
| "Darks": [0.65, 0.65, 0.65, 0.65, 0.65, 0.55, 0.55, 0.55, 0.55, 0.45, 0.45, 0.45], | |
| "Fleece": [0.6, 0.6, 0.6, 0.6, 0.6, 0.5, 0.5, 0.5, 0.5, 0.45, 0.45, 0.45], | |
| "90% Poly+": [0.55, 0.55, 0.55, 0.55, 0.55, 0.45, 0.45, 0.45, 0.45, 0.3, 0.3, 0.3], | |
| "Sleeves & Legs":[0.40,0.40,0.40,0.40,0.40,0.40,0.40,0.40,0.40,0.40,0.40,0.40] | |
| }), | |
| "5-Color ScreenPrint": pd.DataFrame({ | |
| "Qty": ["below 6", "6 to 12", "13 - 18", "19 - 24", "25 - 36", "37 - 48","49 - 72", "73 - 96", "97 - 144", "145 - 288", "289 - 500", "Above 500"], | |
| "4x4": [23.87, 14.02, 11.79, 9.04, 7.09, 6.05, 5.09, 4.28, 3.76, 2.84, 2.68, 2.54], | |
| "12x12": [39.36, 22.53, 18.66, 13.93, 10.88, 9.34, 7.26, 5.87, 4.88, 3.56, 3.15, 3.10], | |
| "14x16": [46.2, 26.02, 22.05, 17.14, 12.87, 11.05, 9.00, 7.21, 6.02, 4.51, 4.02, 3.74], | |
| "Darks": [0.8, 0.8, 0.8, 0.8, 0.8, 0.65, 0.65, 0.65, 0.65, 0.55, 0.55, 0.55], | |
| "Fleece": [0.55, 0.55, 0.55, 0.55, 0.55, 0.45, 0.45, 0.45, 0.45, 0.40, 0.40, 0.40], | |
| "90% Poly+": [0.55, 0.55, 0.55, 0.55, 0.55, 0.45, 0.45, 0.45, 0.45, 0.3, 0.3, 0.3], | |
| "Sleeves & Legs":[0.40,0.40,0.40,0.40,0.40,0.40,0.40,0.40,0.40,0.40,0.40,0.40] | |
| }), | |
| "6-Color ScreenPrint": pd.DataFrame({ | |
| "Qty": ["below 6", "6 to 12", "13 - 18", "19 - 24", "25 - 36", "37 - 48","49 - 72", "73 - 96", "97 - 144", "145 - 288", "289 - 500", "Above 500"], | |
| "4x4": [28.07, 16.41, 13.69, 10.36, 8.15, 6.89, 5.45, 4.95, 4.33, 3.35, 3.07, 2.94], | |
| "12x12": [46.62, 26.69, 22.32, 14.22, 12.60, 10.85, 8.35, 6.92, 5.73, 4.07, 3.47, 3.33], | |
| "14x16": [55.03, 30.88, 25.52, 19.03, 14.98, 12.74, 10.34, 8.53, 6.96, 5.18, 4.42, 4.21], | |
| "Darks": [0.9, 0.9, 0.9, 0.9, 0.9, 0.75, 0.75, 0.75, 0.75, 0.65, 0.65, 0.65], | |
| "Fleece": [0.6, 0.6, 0.6, 0.6, 0.6, 0.5, 0.5, 0.5, 0.5, 0.45, 0.45, 0.45], | |
| "90% Poly+": [0.55, 0.55, 0.55, 0.55, 0.55, 0.45, 0.45, 0.45, 0.45, 0.3, 0.3, 0.3], | |
| "Sleeves & Legs":[0.40,0.40,0.40,0.40,0.40,0.40,0.40,0.40,0.40,0.40,0.40,0.40] | |
| }), | |
| }, | |
| "Elements Imprint":{ | |
| "1-Color ScreenPrint": pd.DataFrame({ | |
| "Qty": ["below 12", "12 - 24", "25 - 99", "100 - 299", "300 - 499", "500 - 999","1000 - 2400", "2401 - 5000"], | |
| "Up to 5 Inch.": [7.20, 3.60, 2.60, 1.65, 1.60, 1.55, 1.50, 1.45], | |
| "Up to 13 Inch": [9.30, 4.65, 2.75, 2.15, 2.00, 1.70, 1.60, 1.40] | |
| }), | |
| "2-Color ScreenPrint": pd.DataFrame({ | |
| "Qty": ["below 12", "12 - 24", "25 - 99", "100 - 299", "300 - 499", "500 - 999","1000 - 2400", "2401 - 5000"], | |
| "Up to 5 Inch.": [7.60, 3.80, 2.80, 1.85, 1.80, 1.75, 1.60, 1.65], | |
| "Up to 13 Inch": [9.80, 4.90, 2.95, 2.40, 2.15, 1.95, 1.90, 1.70] | |
| }), | |
| "3-Color ScreenPrint": pd.DataFrame({ | |
| "Qty": ["below 12", "12 - 24", "25 - 99", "100 - 299", "300 - 499", "500 - 999","1000 - 2400", "2401 - 5000"], | |
| "Up to 5 Inch": [8.00, 4.00, 3.00, 2.45, 2.05, 1.95, 1.90, 1.90], | |
| "Up to 13 Inch": [10.10, 5.05, 3.20, 2.65, 2.35, 2.20, 2.10, 2.00] | |
| }), | |
| "4-Color ScreenPrint": pd.DataFrame({ | |
| "Qty": ["below 12", "12 - 24", "25 - 99", "100 - 299", "300 - 499", "500 - 999","1000 - 2400", "2401 - 5000"], | |
| "Up to 5 Inch": [8.40, 4.20, 3.20, 2.65, 2.25, 2.20, 2.15, 2.05], | |
| "Up to 13 Inch": [10.60, 5.30, 3.45, 2.95, 2.50, 2.45, 2.30, 2.20] | |
| }), | |
| "5-Color ScreenPrint": pd.DataFrame({ | |
| "Qty": ["below 12", "12 - 24", "25 - 99", "100 - 299", "300 - 499", "500 - 999","1000 - 2400", "2401 - 5000"], | |
| "Up to 5 Inch": [8.90, 4.45, 3.45, 2.95, 2.50, 2.45, 2.35, 2.25], | |
| "Up to 13 Inch": [11.10, 5.55, 3.65, 3.25, 2.70, 2.65, 2.60, 2.50] | |
| }), | |
| "6-Color ScreenPrint": pd.DataFrame({ | |
| "Qty": ["below 12", "12 - 24", "25 - 99", "100 - 299", "300 - 499", "500 - 999","1000 - 2400", "2401 - 5000"], | |
| "Up to 5 Inch": [0.00, 0.00, 0.00, 4.85, 4.50, 4.45, 4.40, 4.30], | |
| "Up to 13 Inch": [0.00, 0.00, 0.00, 5.30, 5.05, 4.85, 4.90, 4.70] | |
| }), | |
| "7-Color ScreenPrint": pd.DataFrame({ | |
| "Qty": ["below 12", "12 - 24", "25 - 99", "100 - 299", "300 - 499", "500 - 999","1000 - 2400", "2401 - 5000"], | |
| "Up to 5 Inch": [0.00, 0.00, 0.00, 6.05, 5.70, 5.65, 5.60, 5.50], | |
| "Up to 13 Inch": [0.00, 0.00, 0.00, 6.55, 6.45, 6.35, 6.25, 6.20] | |
| }), | |
| "8-Color ScreenPrint": pd.DataFrame({ | |
| "Qty": ["below 12", "12 - 24", "25 - 99", "100 - 299", "300 - 499", "500 - 999","1000 - 2400", "2401 - 5000"], | |
| "Up to 5 Inch": [0.00, 0.00, 0.00, 6.25, 6.00, 5.95, 5.90, 5.80], | |
| "Up to 13 Inch": [0.00, 0.00, 0.00, 6.80, 6.70, 6.60, 6.50, 6.45] | |
| }), | |
| "9-Color ScreenPrint": pd.DataFrame({ | |
| "Qty": ["below 12", "12 - 24", "25 - 99", "100 - 299", "300 - 499", "500 - 999","1000 - 2400", "2401 - 5000"], | |
| "Up to 5 Inch": [0.00, 0.00, 0.00, 6.65, 6.30, 6.25, 6.20, 6.10], | |
| "Up to 13 Inch": [0.00, 0.00, 0.00, 7.05, 6.95, 6.85, 6.75, 6.65] | |
| }), | |
| }, | |
| } | |
| full_data = { | |
| "Nextshirt Printing Co. Ltd.": { | |
| "Quantity": ["0-6", "7-12", "13-24", "25-36", "37-72", "73-144", "145-288", "289-500"], | |
| "6 sqin": [9.37, 4.65, 2.29, 1.50, 0.72, 0.33, 0.27, 0.24], | |
| "12 sqin": [9.37, 4.65, 2.29, 1.50, 0.74, 0.61, 0.54, 0.51], | |
| "16 sqin": [9.37, 4.65, 2.29, 1.50, 0.93, 0.79, 0.73, 0.70], | |
| "24 sqin": [9.37, 4.65, 2.29, 1.56, 1.30, 1.16, 1.10, 1.06], | |
| "48 sqin": [9.37, 4.65, 2.92, 2.66, 2.39, 2.26, 2.20, 2.17], | |
| "64 sqin": [9.37, 4.65, 3.65, 3.39, 3.13, 3.00, 2.51, 2.48], | |
| "100 sqin": [9.37, 6.10, 5.30, 5.05, 4.79, 4.00, 3.28, 3.25], | |
| "132 sqin": [9.37, 8.12, 7.33, 7.07, 6.80, 5.72, 4.72, 4.69], | |
| "224 sqin": [9.68, 12.17, 11.33, 11.06, 10.78, 9.14, 7.57, 7.54], | |
| "288 sqin": [13.83, 14.73, 13.94, 13.69, 13.42, 11.39, 9.44, 9.41] | |
| }, | |
| "Elements Imprint": { | |
| "Quantity": ["0-19", "20-99", "100-249", "250-499","500+"], | |
| "0-4 Wide":[28.00, 4.70, 4.50, 4.15, 3.85], | |
| "4-8 Wide": [38.00, 7.45, 6.35, 5.25, 4.70], | |
| "8-11 Wide": [50.00, 11.00, 7.95, 7.45, 6.90], | |
| "11-14 Wide": [60.00, 14.50, 11.25, 10.75, 10.50] | |
| } | |
| } | |