Spreadsheet: 79995d1280244289-excel-2007-pivot-table-formulas-test-data-set
Sheet: Sheet4

Date | WHB | WHS | No charge | Customer type | Product number | Product class | Pick or ship quantity | Item number | Lot size | Sales | Standard material cost | Standard labor  cost | Standard fixed  cost | Standard variable cost | SFCOST | Record | General ledger account number | Lot number of a product | KIT | Order number | Order suffix number | Invoice number | Order type | Inventory type | Make/buy | Commodity | RMA disposition | Credit reason | A=ATO model entry mode, M=ATO model sales | Lowest level where the product exists | Where-used flag | Routing flag | Exploded quantity | Product structure change flag for MRP prod | Routing change flag | Actual  Cost | Margin | Margin % | Review
100715 | 2 | 18 |  | 8 | LENOXLOCKER | LP | 386 | 1 | 0 | 105146.4 | 53109.4312 | 6206.687 | 5632.0874 | 7934.7318 | 72882.9374 |  |  | 318619 |  | 754199 | 0 | 4100641 | SI | A | M |  |  |  | W | 0 |  | 1 | 0 | C | 1 | 72882.9374 | 34678.14999999999 | 0.3120292430547745 | 1
100719 | 2 | 18 |  | 8 | LENOXLOCKER | LP | 258 | 2 | 0 | 65658.42 | 41410.8576 | 3692.8314 | 3371.544 | 4744.3362 | 53219.5692 |  |  | 283054 |  | 477581 | 0 | 4101462 | SI | A | M |  |  |  | W | 0 |  | 1 | 0 | C | 1 | 53219.5692 | 43643.04629999997 | 0.2833784265764436 | 1
100719 | 2 | 18 |  | 8 | LENOXLOCKER | LP | 201 | 1 | 0 | 48692.25 | 31478.7105 | 3061.23 | 2773.7799 | 3908.9475 | 41222.6679 |  |  | 318566 |  | 477581 | 0 | 4101462 | SI | A | M |  |  |  | W | 0 |  | 1 | 0 | C | 1 | 41222.6679 | 43643.04629999997 | 0.2833784265764436 | 1
100721 | 2 | 1 | 2 | D | MG-2 | WE | 20 | 2 | 0 | 46192.8 | 9886.6 | 942.07 | 1941.58 | 2447.96 | 15218.21 |  |  | 221288 | K | 777946 | 0 | 4102200 | SI | A | E |  |  |  | W | 0 |  |  | 0 |  |  | 15218.21 | 62937.6948 | 0.6769449197908126 | 1
100716 | 2 | 18 |  | 8 | LENOXLOCKER | LP | 206 | 1 | 0 | 42658.48 | 21134.055 | 3168.6096 | 2870.8984 | 4045.84 | 31219.403 |  |  | 318872 |  | 744749 | 0 | 4101065 | SI | A | M |  |  |  | W | 0 |  | 1 | 0 | C | 1 | 31219.403 | 19200.82440000001 | 0.358052924663305 | 1
100702 | 1 | 1 | 2 | D | MF2949 | WM | 28 | 1 | 0 | 39200 | 17313.23 | 1494.2 | 2966.18 | 3736.29 | 25509.9 |  |  | 229658 | K | 773101 | 0 | 4097823 | SI | A | E |  |  |  | W | 0 |  |  | 0 |  |  | 25509.9 | 18360.3024 | 0.346090512111272 | 1
100722 | 2 | 18 | 2 | 9 | PSS215 | TP | 1 | 1 | 0 | 36635.14 | 17856.1 | 1160.79 | 1172.14 | 1368.6 | 21557.63 |  |  | 317999 | K | 756102 | 0 | 4102646 | SI | A | E |  |  |  | W | 0 |  |  | 0
100713 | 2 | 18 | 2 | 8 | PSM248 | TP | 1 | 1 | 0 | 36342.6 | 22276.69 | 1464.4 | 1450.8 | 1709.61 | 26901.5 |  |  | 318165 | K | 615090 | 0 | 4099866 | SI | A | E |  |  |  | W | 0 |  |  | 0 |  |  | 26901.5 | 9441.099999999999 | 0.2597805330383627 | 1
100716 | 2 | 18 | 2 | 8 | CS0927 | TC | 1 | 1 | 0 | 32800.26 | 19412.57 | 2100.9 | 2201.26 | 2539.08 | 26253.81 |  |  | 318385 | K | 636593 | 0 | 4101061 | SI | A | E |  |  |  | W | 0 |  |  | 0 |  |  | 26253.81 | 5457.949199999999 | 0.166399571222911 | 3
100709 | 2 | 18 |  | 8 | LENOXZLOCKER | LP | 69 | 1 | 0 | 31443.3 | 13867.8132 | 947.3838 | 865.4808 | 1217.7327 | 16898.4105 |  |  | 291937 |  | 759425 | 0 | 4099090 | SI | A | M |  |  |  | W | 0 |  | 1 | 0 | C | 1 | 16898.4105 | 17565.395 | 0.4930758991379998 | 1
100721 | 2 | 18 | 2 | 8 | CS0927 | TC | 1 | 1 | 0 | 30808.63 | 18578.9 | 2009.54 | 2111.22 | 2433.34 | 25133 |  |  | 318383 | K | 636583 | 0 | 4102186 | SI | A | E |  |  |  | W | 0 |  |  | 0 |  |  | 25133 | 5675.630000000001 | 0.1842220832279787 | 3
100723 | 1 | 1 | 2 | C | WF2704 | WC | 10 | 1 | 0 | 30728.97 | 6461.66 | 851.02 | 1897.13 | 2364.69 | 11574.5 |  |  | 146660 | K | 790474 | 0 | 4103240 | SI | A | E |  |  |  | W | 0 |  |  | 0 |  |  | 11574.5 | 19893.7378 | 0.625476338547696 | 1
100726 | 1 | 1 | 2 | D | MG-3 | WE | 10 | 1 | 0 | 26636.4 | 5046.37 | 1770.15 | 3756.78 | 4774.91 | 15348.21 |  |  | 212526 | K | 784200 | 0 | 4103542 | SI | A | E |  |  |  | W | 0 |  |  | 0 |  |  | 15348.21 | #N/A | #N/A | #N/A
100721 | 1 | 1 |  | D | HSL1 | WE | 14 | 3 | 0 | 26117.84 | 2511.1604 | 1015.3178 | 2227.9404 | 2791.5566 | 8545.9752 |  |  | 319719 |  | 777946 | 0 | 4102200 | SI | A | M |  |  |  | W | 0 |  | 1 | 0 |  | 1 | 8545.9752 | 62937.6948 | 0.6769449197908126 | 1
100708 | 2 | 18 |  | 8 | LENOXLOCKER | LP | 108 | 1 | 0 | 25871.4 | 13210.2576 | 1653.5448 | 1518.2964 | 2134.1772 | 18516.276 |  |  | 154442 |  | 741636 | 0 | 4098678 | SI | A | M |  |  |  | W | 0 |  | 1 | 0 | C | 1 | 18516.276 | 14116.50520000001 | 0.3603092381963132 | 1
100726 | 1 | 1 | 2 | C | WF2704 | WC | 7 | 1 | 0 | 25101.87 | 3120.87 | 475.26 | 1065.99 | 1330.06 | 5992.18 |  |  | 143183 | K | 795067 | 0 | 4103635 | SI | A | E |  |  |  | W | 0 |  |  | 0 |  |  | 5992.18 | #N/A | #N/A | #N/A
100713 | 1 | 1 |  | D | WC7459FM | XW | 22 | 1 | 0 | 24420 | 4865.7334 | 2034.0606 | 3751.8316 | 5582.9752 | 16234.6008 |  |  | 145490 |  | 773509 | 0 | 4099885 | SI | A | M |  |  |  | W | 0 |  | 1 | 0 | C | 1 | 16234.6008 | 15135.2544 | 0.3903655834107087 | 1
100714 | 1 | 1 | 2 | D | MG-2 | WE | 8 | 1 | 0 | 23265.12 | 4209.24 | 1132.61 | 2398.24 | 3048.99 | 10789.08 |  |  | 206436 | K | 778162 | 0 | 4100274 | SI | A | E |  |  |  | W | 0 |  |  | 0 |  |  | 10789.08 | 13010.47 | 0.5306687734937872 | 1
100706 | 1 | 1 |  | C | MF2944 | WM | 8 | 1 | 0 | 22414.95 | 5984.2472 | 448.3624 | 924.3448 | 1167.4856 | 8524.44 |  |  | 105201 |  | 776793 | 0 | 4098097 | SI | A | M |  |  |  | W | 0 |  | 1 | 0 | C | 1 | 8524.44 | 13890.51 | 0.6196984601794784 | 1
100715 | 1 | 1 | 2 | C | WF2704 | WC | 6 | 1 | 0 | 22031.77 | 3708.77 | 493.48 | 1107.33 | 1381.59 | 6691.17 |  |  | 143712 | K | 788794 | 0 | 4100788 | SI | A | E |  |  |  | W | 0 |  |  | 0 |  |  | 6691.17 | 15340.6 | 0.6962944874606081 | 1
100722 | 2 | 2 |  | 1 | 175-110000 | MP | 140 | 1 | 0 | 21749 | 9521.036 | 2146.354 | 3682.434 | 3715.796 | 19065.62 |  |  |  |  | 785238 | 1 | 4102691 | SI | F | M |  |  |  |  | 0 |  | 1 | 0 |  | 3 | 19065.62 | 2972.086399999997 | 0.09789938791603547 | 7
100721 | 2 | 18 |  | 8 | LENOXLOCKER | LP | 107 | 1 | 0 | 20736.6 | 12199.1449 | 1654.2307 | 1498.7597 | 2112.1479 | 17464.2832 |  |  | 319107 |  | 760506 | 0 | 4102190 | SI | A | M |  |  |  | W | 0 |  | 1 | 0 | C | 1 | 17464.2832 | 3343.952999999998 | 0.1595309133654815 | 3
100721 | 1 | 1 | 2 | D | MG-3 | WE | 6 | 1 | 0 | 20662.5 | 4203.96 | 364.45 | 753.79 | 949.06 | 6271.26 |  |  | 221289 | K | 777946 | 0 | 4102200 | SI | A | E |  |  |  | W | 0 |  |  | 0 |  |  | 6271.26 | 62937.6948 | 0.6769449197908126 | 1
100713 | 1 | 1 | 2 | D | CRS-3 | WE | 10 | 2 | 0 | 20620 | 4340.25 | 1145.21 | 2389.56 | 3031.15 | 10906.17 |  |  | 319472 | K | 776009 | 0 | 4099889 | SI | A | E |  |  |  | W | 0 |  |  | 0 |  |  | 10906.17 | 18447.58 | 0.4708657920261372 | 1
100723 | 1 | 1 |  | C | S19-325BF | EC | 17 | 1 | 0 | 20029.18 | 6792.911 | 2351.8242 | 3671.0939 | 4790.3756 | 17606.2047 |  |  |  |  | 781011 | 0 | 4103180 | SI | P | M |  |  |  |  | 0 |  | 1 | 0 |  | 3 | 17606.2047 | 2422.975300000002 | 0.1209722664632302 | 3
100721 | 1 | 1 | 2 | D | MG-2 | WE | 16 | 1 | 0 | 20000 | 8291.92 | 925.9 | 1956.52 | 2481.09 | 13655.43 |  |  | 192417 | K | 784022 | 0 | 4102218 | SI | A | E |  |  |  | W | 0 |  |  | 0 |  |  | 13655.43 | 8143.509999999998 | 0.3084662878787878 | 1