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] } }