| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Order ID | Date Key | Channel Key | Prom Key | State Key | Prd Key | Unit Cost | Unit Price | Order Qty | Sales | Profit |
2 | 2569 | 41675 | CH002 | Promo-007 | NA | Prod-4001 | 42.47035918 | 188.5 | 12 | 2262 | 2219.529641 |
3 | 6202 | 41079 | CH004 | Promo-000 | OY | Prod-4001 | 43.14964257 | 188.5 | 12 | 2262 | 2218.850357 |
4 | 8984 | 41247 | CH004 | Promo-010 | BE | Prod-4001 | 59.78185531 | 188.5 | 13 | 2450.5 | 2390.718145 |
5 | 12485 | 41260 | CH004 | Promo-003 | OG | Prod-4001 | 39.20958336 | 188.5 | 8 | 1508 | 1468.790417 |
6 | 16663 | 41355 | CH004 | Promo-000 | AN | Prod-4001 | 138.1838506 | 188.5 | 10 | 1885 | 1746.816149 |
7 | 17681 | 41185 | CH004 | Promo-000 | BO | Prod-4001 | 17.70628963 | 188.5 | 10 | 1885 | 1867.29371 |
8 | 19342 | 41348 | CH004 | Promo-007 | EK | Prod-4001 | 122.4949627 | 188.5 | 12 | 2262 | 2139.505037 |
9 | 1355 | 41720 | CH003 | Promo-000 | DE | Prod-4002 | 97.35619205 | 188.5 | 10 | 1885 | 1787.643808 |
10 | 3605 | 41166 | CH004 | Promo-000 | AK | Prod-4002 | 93.58700534 | 188.5 | 10 | 1885 | 1791.412995 |
11 | 4074 | 41050 | CH004 | Promo-000 | JI | Prod-4002 | 26.87548439 | 188.5 | 10 | 1885 | 1858.124516 |
12 | 5226 | 41345 | CH004 | Promo-000 | DE | Prod-4002 | 114.3087822 | 188.5 | 10 | 1885 | 1770.691218 |
13 | 5825 | 41092 | CH004 | Promo-001 | EB | Prod-4002 | 149.0920122 | 188.5 | 12 | 2262 | 2112.907988 |
14 | 6207 | 41487 | CH003 | Promo-002 | OG | Prod-4002 | 1.561613638 | 188.5 | 9 | 1696.5 | 1694.938386 |
15 | 10230 | 41895 | CH003 | Promo-000 | KW | Prod-4002 | 33.98270339 | 188.5 | 20 | 3770 | 3736.017297 |
16 | 10344 | 41963 | CH002 | Promo-010 | KW | Prod-4002 | 111.661276 | 188.5 | 39 | 7351.5 | 7239.838724 |
17 | 16667 | 40988 | CH004 | Promo-000 | EB | Prod-4002 | 96.74878894 | 188.5 | 10 | 1885 | 1788.251211 |
18 | 20434 | 41812 | CH004 | Promo-001 | ZA | Prod-4002 | 68.17770733 | 188.5 | 12 | 2262 | 2193.822293 |
19 | 7530 | 41001 | CH004 | Promo-000 | ED | Prod-4003 | 157.984784 | 188.5 | 20 | 3770 | 3612.015216 |
20 | 7903 | 40987 | CH004 | Promo-000 | ED | Prod-4003 | 70.11348232 | 188.5 | 10 | 1885 | 1814.886518 |
21 | 10959 | 41513 | CH003 | Promo-000 | KW | Prod-4003 | 36.07706151 | 188.5 | 10 | 1885 | 1848.922938 |
22 | 11138 | 41161 | CH004 | Promo-000 | DE | Prod-4003 | 45.64584569 | 188.5 | 10 | 1885 | 1839.354154 |
23 | 15832 | 41202 | CH003 | Promo-010 | KW | Prod-4003 | 151.1123491 | 188.5 | 26 | 4901 | 4749.887651 |
24 | 17034 | 41888 | CH003 | Promo-003 | OG | Prod-4003 | 138.8822517 | 188.5 | 8 | 1508 | 1369.117748 |
25 | 20502 | 41396 | CH004 | Promo-005 | ON | Prod-4003 | 108.3281846 | 188.5 | 12 | 2262 | 2153.671815 |
26 | 288 | 41203 | CH001 | Promo-009 | EB | Prod-4004 | 97.54567271 | 188.5 | 52 | 9802 | 9704.454327 |
27 | 812 | 40891 | CH003 | Promo-010 | KW | Prod-4004 | 92.27648823 | 188.5 | 26 | 4901 | 4808.723512 |
28 | 906 | 41042 | CH004 | Promo-000 | KD | Prod-4004 | 152.177079 | 188.5 | 10 | 1885 | 1732.822921 |
29 | 6741 | 40993 | CH004 | Promo-000 | BO | Prod-4004 | 100.6918406 | 188.5 | 10 | 1885 | 1784.308159 |
30 | 8711 | 40900 | CH002 | Promo-004 | EB | Prod-4004 | 14.06068063 | 188.5 | 18 | 3393 | 3378.939319 |
31 | 9570 | 41927 | CH004 | Promo-009 | EB | Prod-4004 | 41.38659869 | 188.5 | 13 | 2450.5 | 2409.113401 |
32 | 9872 | 41257 | CH004 | Promo-004 | BO | Prod-4004 | 74.32819165 | 188.5 | 9 | 1696.5 | 1622.171808 |
33 | 14475 | 41807 | CH004 | Promo-001 | KD | Prod-4004 | 36.28074245 | 188.5 | 10 | 1885 | 1848.719258 |
34 | 16453 | 41595 | CH003 | Promo-010 | KW | Prod-4004 | 17.44213783 | 188.5 | 26 | 4901 | 4883.557862 |
35 | 16914 | 41142 | CH004 | Promo-000 | ON | Prod-4004 | 163.8189768 | 188.5 | 10 | 1885 | 1721.181023 |
36 | 18106 | 41342 | CH004 | Promo-000 | EB | Prod-4004 | 87.16826229 | 188.5 | 10 | 1885 | 1797.831738 |
37 | 19460 | 41972 | CH004 | Promo-009 | AK | Prod-4004 | 116.4994667 | 188.5 | 13 | 2450.5 | 2334.000533 |
38 | 1564 | 41112 | CH002 | Promo-000 | KW | Prod-4005 | 85.13612844 | 188.5 | 10 | 1885 | 1799.863872 |
39 | 2567 | 40887 | CH004 | Promo-004 | EB | Prod-4005 | 87.81153217 | 188.5 | 9 | 1696.5 | 1608.688468 |
40 | 4083 | 41678 | CH004 | Promo-004 | BO | Prod-4005 | 166.4096301 | 188.5 | 9 | 1696.5 | 1530.09037 |
41 | 5502 | 40987 | CH003 | Promo-000 | DE | Prod-4005 | 87.47498086 | 188.5 | 20 | 3770 | 3682.525019 |
42 | 6386 | 41282 | CH004 | Promo-004 | BO | Prod-4005 | 89.32495886 | 188.5 | 9 | 1696.5 | 1607.175041 |
43 | 8596 | 41067 | CH003 | Promo-001 | DE | Prod-4005 | 111.6760973 | 188.5 | 12 | 2262 | 2150.323903 |
44 | 8689 | 41612 | CH004 | Promo-009 | CR | Prod-4005 | 78.30033717 | 188.5 | 13 | 2450.5 | 2372.199663 |
45 | 10064 | 41144 | CH004 | Promo-002 | OY | Prod-4005 | 70.91481876 | 188.5 | 9 | 1696.5 | 1625.585181 |
46 | 11941 | 41455 | CH002 | Promo-000 | KW | Prod-4005 | 61.15901805 | 188.5 | 12 | 2262 | 2200.840982 |
47 | 15015 | 41368 | CH003 | Promo-007 | OG | Prod-4005 | 124.4803668 | 188.5 | 12 | 2262 | 2137.519633 |
48 | 8518 | 40892 | CH004 | Promo-004 | FC | Prod-4006 | 49.6239203 | 188.5 | 9 | 1696.5 | 1646.87608 |
49 | 10280 | 41771 | CH004 | Promo-000 | ED | Prod-4006 | 23.43034848 | 188.5 | 10 | 1885 | 1861.569652 |
50 | 11480 | 40994 | CH004 | Promo-000 | CR | Prod-4006 | 104.2780645 | 188.5 | 10 | 1885 | 1780.721935 |
51 | 15005 | 41452 | CH004 | Promo-001 | EB | Prod-4006 | 77.81727455 | 188.5 | 12 | 2262 | 2184.182725 |
52 | 15172 | 40904 | CH002 | Promo-003 | NA | Prod-4006 | 68.25427741 | 188.5 | 8 | 1508 | 1439.745723 |
53 | 17099 | 41653 | CH003 | Promo-004 | DE | Prod-4006 | 87.70055394 | 188.5 | 18 | 3393 | 3305.299446 |
54 | 18553 | 41540 | CH004 | Promo-000 | DE | Prod-4006 | 24.42630802 | 188.5 | 10 | 1885 | 1860.573692 |
55 | 18695 | 41119 | CH004 | Promo-001 | BO | Prod-4006 | 94.51316014 | 188.5 | 12 | 2262 | 2167.48684 |
56 | 792 | 40900 | CH004 | Promo-004 | BO | Prod-4007 | 86.11509852 | 188.5 | 9 | 1696.5 | 1610.384901 |
57 | 1201 | 40976 | CH004 | Promo-000 | DE | Prod-4007 | 42.02809691 | 188.5 | 10 | 1885 | 1842.971903 |
58 | 2476 | 40900 | CH004 | Promo-004 | AN | Prod-4007 | 109.2925638 | 188.5 | 9 | 1696.5 | 1587.207436 |
59 | 8187 | 41174 | CH004 | Promo-000 | KT | Prod-4007 | 22.15910486 | 188.5 | 20 | 3770 | 3747.840895 |
60 | 8929 | 41977 | CH004 | Promo-009 | ED | Prod-4007 | 146.4075539 | 188.5 | 13 | 2450.5 | 2304.092446 |
61 | 10460 | 41233 | CH004 | Promo-009 | ED | Prod-4007 | 143.850339 | 188.5 | 13 | 2450.5 | 2306.649661 |
62 | 14490 | 41524 | CH004 | Promo-000 | ZA | Prod-4007 | 114.6705885 | 188.5 | 10 | 1885 | 1770.329412 |
63 | 20274 | 41152 | CH004 | Promo-002 | OG | Prod-4007 | 64.80784195 | 188.5 | 9 | 1696.5 | 1631.692158 |
64 | 21220 | 41048 | CH004 | Promo-000 | ED | Prod-4007 | 141.7816455 | 188.5 | 10 | 1885 | 1743.218354 |
65 | 2171 | 41712 | CH004 | Promo-000 | BO | Prod-4008 | 145.8881592 | 188 | 10 | 1880 | 1734.111841 |
66 | 170 | 41677 | CH002 | Promo-004 | EB | Prod-4009 | 161.6413693 | 188 | 9 | 1692 | 1530.358631 |
67 | 3676 | 41286 | CH004 | Promo-004 | ZA | Prod-4009 | 42.1084353 | 188 | 9 | 1692 | 1649.891565 |
68 | 4273 | 41419 | CH002 | Promo-005 | KW | Prod-4009 | 130.3594194 | 188 | 24 | 4512 | 4381.640581 |
69 | 12141 | 41059 | CH001 | Promo-000 | EB | Prod-4009 | 40.94800104 | 188 | 10 | 1880 | 1839.051999 |
70 | 12360 | 40901 | CH004 | Promo-010 | BE | Prod-4009 | 49.06865136 | 188 | 13 | 2444 | 2394.931349 |
71 | 19099 | 41266 | CH004 | Promo-004 | ED | Prod-4009 | 67.52001691 | 188 | 9 | 1692 | 1624.479983 |
72 | 20333 | 41905 | CH004 | Promo-000 | AK | Prod-4009 | 112.0456797 | 188 | 10 | 1880 | 1767.95432 |
73 | 20719 | 41061 | CH004 | Promo-000 | BO | Prod-4009 | 97.84825616 | 188 | 10 | 1880 | 1782.151744 |
74 | 21482 | 41585 | CH003 | Promo-009 | DE | Prod-4009 | 23.48669128 | 188 | 13 | 2444 | 2420.513309 |
75 | 21679 | 41212 | CH003 | Promo-009 | DE | Prod-4009 | 163.8645198 | 188 | 26 | 4888 | 4724.13548 |
76 | 21784 | 40967 | CH002 | Promo-004 | EB | Prod-4009 | 37.57200025 | 188 | 9 | 1692 | 1654.428 |
77 | 1690 | 41436 | CH004 | Promo-001 | BO | Prod-4010 | 41.19347809 | 188 | 12 | 2256 | 2214.806522 |
78 | 5401 | 41153 | CH004 | Promo-000 | KT | Prod-4010 | 153.7062495 | 188 | 10 | 1880 | 1726.29375 |
79 | 5761 | 41749 | CH003 | Promo-005 | KW | Prod-4010 | 107.2211503 | 188 | 12 | 2256 | 2148.77885 |
80 | 6431 | 41299 | CH004 | Promo-004 | AK | Prod-4010 | 29.942026 | 188 | 9 | 1692 | 1662.057974 |
81 | 11266 | 40927 | CH001 | Promo-004 | EB | Prod-4010 | 29.368406 | 188 | 36 | 6768 | 6738.631594 |
82 | 11836 | 41529 | CH004 | Promo-000 | DE | Prod-4010 | 55.29997356 | 188 | 10 | 1880 | 1824.700026 |
83 | 15689 | 40899 | CH004 | Promo-004 | ED | Prod-4010 | 117.7960593 | 188 | 9 | 1692 | 1574.203941 |
84 | 15716 | 41578 | CH004 | Promo-009 | BO | Prod-4010 | 124.1352796 | 188 | 13 | 2444 | 2319.86472 |
85 | 15820 | 41708 | CH004 | Promo-006 | KE | Prod-4010 | 38.32008433 | 188 | 9 | 1692 | 1653.679916 |
86 | 19238 | 41277 | CH003 | Promo-010 | KW | Prod-4010 | 67.72932972 | 188 | 13 | 2444 | 2376.27067 |
87 | 20088 | 40975 | CH002 | Promo-000 | EB | Prod-4010 | 94.00829039 | 188 | 20 | 3760 | 3665.99171 |
88 | 21409 | 40949 | CH001 | Promo-004 | EB | Prod-4010 | 101.9669985 | 188 | 45 | 8460 | 8358.033001 |
89 | 7098 | 40928 | CH004 | Promo-007 | BA | Prod-4011 | 161.8856414 | 188 | 12 | 2256 | 2094.114359 |
90 | 2556 | 41075 | CH004 | Promo-001 | ZA | Prod-4011 | 142.298509 | 188 | 12 | 2256 | 2113.701491 |
91 | 8529 | 41069 | CH003 | Promo-000 | OG | Prod-4011 | 2.855697633 | 188 | 10 | 1880 | 1877.144302 |
92 | 9211 | 41617 | CH001 | Promo-004 | EB | Prod-4011 | 67.00370612 | 188 | 9 | 1692 | 1624.996294 |
93 | 10125 | 40899 | CH004 | Promo-010 | ON | Prod-4011 | 163.9791548 | 188 | 13 | 2444 | 2280.020845 |
94 | 10916 | 41012 | CH004 | Promo-000 | OG | Prod-4011 | 19.01610364 | 188 | 10 | 1880 | 1860.983896 |
95 | 11939 | 41078 | CH004 | Promo-000 | EN | Prod-4011 | 152.6001769 | 188 | 12 | 2256 | 2103.399823 |
96 | 13570 | 41117 | CH003 | Promo-002 | OG | Prod-4011 | 1.502985599 | 188 | 18 | 3384 | 3382.497014 |
97 | 16151 | 41165 | CH004 | Promo-000 | ZA | Prod-4011 | 126.5379075 | 188 | 10 | 1880 | 1753.462092 |
98 | 21211 | 41111 | CH002 | Promo-001 | EB | Prod-4011 | 162.422795 | 188 | 24 | 4512 | 4349.577205 |
99 | 22329 | 41355 | CH004 | Promo-000 | ED | Prod-4011 | 31.11733182 | 188 | 10 | 1880 | 1848.882668 |
100 | 7688 | 41264 | CH004 | Promo-010 | KT | Prod-4012 | 94.71245287 | 188 | 13 | 2444 | 2349.287547 |