Spreadsheet: 126984d1320092586-copy-and-paste-filtered-data-planned-orders-dummy
Sheet: Sheet1

 |  |  |  | Resource/ |  | LT(weeks)
 |  | Part Lookup | PartLookup | Part Number | Description | PO > REL | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00
 | SPECIAL | 1 | 2
XA10022 |  |  |  | XA10022 | A | 8
XA10022 |  |  |  |  | MOVE HIGHLIGHTED RANGE ONE COLUMN TO THE [NAME] | [NAME] |  |  |  |  | 150000 |  |  |  |  | 150000 |  |  | 300000
XA10022 |  |  |  |  |  | Scheduled Delivery | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
XA10022 |  |  |  |  |  | Delivered/Retest | 0
XA10022 |  |  |  |  |  | ON-Hand | 510580.2615 | 510580.2615 | 429580.2615 | 375580.2615 | 348580.2615 | 267580.2615 | 240580.2615 | 213580.2615 | 159580.2615 | 132580.2615 | 105580.2615 | 51580.26150000002
XA10022 |  |  |  |  |  | [NAME] | 0 | 81000 | 54000 | 27000 | 81000 | 27000 | 27000 | 54000 | 27000 | 27000 | 54000 | 54000 | 513000
XA10022 |  |  |  |  |  | Inventory | 510580.2615 | 429580.2615 | 375580.2615 | 348580.2615 | 267580.2615 | 240580.2615 | 213580.2615 | 159580.2615 | 132580.2615 | 105580.2615 | 51580.26150000002 | -2419.738499999978
XA10022 |  |  |  |  |  | 0.03 | 15317.407845 | 12887.407845 | 11267.407845 | 10457.407845 | 8027.407845000001 | 7217.407845000001 | 6407.407845000001 | 4787.407845000001 | 3977.407845000001 | 3167.407845000001 | 1547.407845000001 | -72.59215499999932
XA10022 |  |  |  |  |  | Safety Stock | 108000 | 108000 | 108000 | 108000 | 108000 | 108000 | 108000 | 108000 | 108000 | 108000 | 108000 | 108000
XA10022 |  |  |  |  |  | MOH   (6month avg) | 11.34622803333333 | 8.678389121212122 | 8.346228033333334 | 8.606920037037037 | 6.606920037037038 | 6.682785041666667 | 5.273586703703704 | 3.940253370370371 | 3.273586703703704 | 2.606920037037038 | 1.273586703703704 | -0.05974662962962908
XA10022 |  |  |  |  |  | MOH (12month avg) | 11.94339792982456 | 10.0486610877193 | 8.785503192982457 | 8.153924245614036 | 6.259187403508773 | 5.627608456140352 | 4.99602950877193 | 3.732871614035088 | 3.101292666666667 | 2.469713719298246 | 1.206555824561404 | -0.05660207017543807
XA10030 |  |  |  | XA10030 | B | 9
XA10030 |  |  |  |  | MOVE HIGHLIGHTED RANGE ONE COLUMN TO THE [NAME] | [NAME] |  |  |  |  |  |  | 10000 |  | 6000 |  | 12000 |  | 28000
XA10030 |  |  |  |  |  | Scheduled Delivery | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
XA10030 |  |  |  |  |  | Delivered/Retest | 0
XA10030 |  |  |  |  |  | ON-Hand | 35919 | 26300.86946 | 21300.86946 | 21300.86946 | 11300.86946 | 10250.86946 | 250.8694600000017 | -799.1305399999983 | -5799.130539999998 | -11849.13054 | -11849.13054 | -17899.13054
XA10030 |  |  |  |  |  | [NAME] | 9618.13054 | 5000 | 0 | 10000 | 1050 | 10000 | 1050 | 5000 | 6050 | 0 | 6050 | 5000 | 58818.13054
XA10030 |  |  |  |  |  | Inventory | 26300.86946 | 21300.86946 | 21300.86946 | 11300.86946 | 10250.86946 | 250.8694600000017 | -799.1305399999983 | -5799.130539999998 | -11849.13054 | -11849.13054 | -17899.13054 | -22899.13054
XA10030 |  |  |  |  | Std Cost | 0.759 | 19962.35992014 | 16167.35992014 | 16167.35992014 | 8577.359920140001 | 7780.409920140001 | 190.4099201400013 | -606.5400798599987 | -4401.540079859999 | -8993.49007986 | -8993.49007986 | -13585.44007986 | -17380.44007986
XA10030 |  |  |  |  |  | Safety Stock | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000
XA10030 |  |  |  |  |  | MOH   (6month avg) | 4.424263743877169 | 4.716059659040591 | 4.716059659040591 | 2.045406237104073 | 2.65681281900648 | 0.0534712880994675 | -0.2071180665226777 | -1.503014394816414 | -3.071048952051835 | -3.071048952051835 | -4.639083509287256 | -5.934979837580993
XA10030 |  |  |  |  |  | MOH (12month avg) | 5.365869853775193 | 4.345776228745811 | 4.345776228745811 | 2.305588978687047 | 2.091369317430877 | 0.05118206737211305 | -0.1630375938840571 | -1.183131218913439 | -2.417444505198991 | -2.417444505198991 | -3.651757791484543 | -4.671851416513925
XA10065 |  |  |  | XA10065 | C | 17
XA10065 |  |  |  |  | MOVE HIGHLIGHTED RANGE ONE COLUMN TO THE [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 0
XA10065 |  |  |  |  |  | Scheduled Delivery | 25769.205 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
XA10065 |  |  |  |  |  | Delivered/Retest | 65442.58
XA10065 |  |  |  |  |  | ON-Hand | 25962.14125 | 117173.92625 | 117173.92625 | 117173.92625 | 117173.92625 | 117173.92625 | 111976.32625 | 110532.52625 | 109088.72625 | 107644.92625 | 103891.12625 | 102447.32625
XA10065 |  |  |  |  |  | [NAME] | 0 | 0 | 0 | 0 | 0 | 5197.6 | 1443.8 | 1443.8 | 1443.8 | 3753.8 | 1443.8 | 1443.8 | 16170.4
XA10065 |  |  |  |  |  | Inventory | 117173.92625 | 117173.92625 | 117173.92625 | 117173.92625 | 117173.92625 | 111976.32625 | 110532.52625 | 109088.72625 | 107644.92625 | 103891.12625 | 102447.32625 | 101003.52625
XA10065 |  |  |  |  |  | 2.1 | 246065.245125 | 246065.245125 | 246065.245125 | 246065.245125 | 246065.245125 | 235150.285125 | 232118.305125 | 229086.325125 | 226054.345125 | 218171.365125 | 215139.385125 | 212107.405125
XA10065 |  |  |  |  |  | Safety Stock | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000
XA10065 |  |  |  |  |  | MOH   (6month avg) | 135.2631132638141 | 105.857734438522 | 86.95438053480433 | 73.77936378423759 | 52.92886721926101 | 45.62206873955972 | 60.43992030293088 | 59.65044086286089 | 58.86096142279089 | 56.80835862314085 | 56.01887918307086 | 55.22939974300087
XA10065 |  |  |  |  |  | MOH (12month avg) | 86.95438053480436 | 86.95438053480436 | 86.95438053480436 | 86.95438053480436 | 86.95438053480436 | 83.09725888042351 | 82.02581970761392 | 80.95438053480434 | 79.88294136199477 | 77.0972588804235 | 76.02581970761392 | 74.95438053480433
XA10072 |  |  |  | XA10072 | D | 9
XA10072 |  |  |  |  | MOVE HIGHLIGHTED RANGE ONE COLUMN TO THE [NAME] | [NAME] |  |  |  |  | 50000 |  |  |  | 50000 |  |  | 50000 | 150000
XA10072 |  |  |  |  |  | Scheduled Delivery | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
XA10072 |  |  |  |  |  | Delivered/Retest | 0
XA10072 |  |  |  |  |  | ON-Hand | 71377.6912 | 71377.6912 | 50377.6912 | 36377.6912 | 29377.6912 | 8377.691200000001 | 1377.691200000001 | -5622.308799999999 | -19622.3088 | -26622.3088 | -33622.3088 | -47622.3088
XA10072 |  |  |  |  |  | [NAME] | 0 | 21000 | 14000 | 7000 | 21000 | 7000 | 7000 | 14000 | 7000 | 7000 | 14000 | 14000 | 133000
XA10072 |  |  |  |  |  | Inventory | 71377.6912 | 50377.6912 | 36377.6912 | 29377.6912 | 8377.691200000001 | 1377.691200000001 | -5622.308799999999 | -19622.3088 | -26622.3088 | -33622.3088 | -47622.3088 | -61622.3088
XA10072 |  |  |  |  | Std Cost | 0.036 | 2569.5968832 | 1813.5968832 | 1309.5968832 | 1057.5968832 | 301.5968832 | 49.59688320000004 | -202.4031167999999 | -706.4031167999999 | -958.4031167999999 | -1210.4031168 | -1714.4031168 | -2218.4031168
XA10072 |  |  |  |  |  | Safety Stock | 28000 | 28000 | 28000 | 28000 | 28000 | 28000 | 28000 | 28000 | 28000 | 28000 | 28000 | 28000
XA10072 |  |  |  |  |  | MOH   (6month avg) | 6.118087817142857 | 3.925534379220779 | 3.118087817142857 | 2.797875352380952 | 0.7978753523809525 | 0.1476097714285715 | -0.5354579809523808 | -1.868791314285714 | -2.535457980952381 | -3.202124647619048 | -4.535457980952381 | -5.868791314285714
XA10072 |  |  |  |  |  | MOH (12month avg) | 6.440092439097744 | 4.545355596992481 | 3.282197702255639 | 2.650618754887218 | 0.7558819127819549 | 0.1243029654135339 | -0.5072759819548871 | -1.770433876691729 | -2.40201282406015 | -3.033591771428571 | -4.296749666165413 | -5.559907560902255
XA10170 |  |  |  | XA10170 | E | 14
XA10170 |  |  |  |  | MOVE HIGHLIGHTED RANGE ONE COLUMN TO THE [NAME] | [NAME] |  |  |  |  |  |  |  |  |  | 5000 |  | 8000 | 13000
XA10170 |  |  |  |  |  | Scheduled Delivery | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
XA10170 |  |  |  |  |  | Delivered/Retest | 0
XA10170 |  |  |  |  |  | ON-Hand | 31356.8824 | 31356.8824 | 27856.8824 | 24356.8824 | 20856.8824 | 17356.8824 | 17356.8824 | 13856.8824 | 10356.8824 | 10356.8824 | 6856.882400000002 | 3356.882400000002
XA10170 |  |  |  |  |  | [NAME] | 0 | 3500 | 3500 | 3500 | 3500 | 0 | 3500 | 3500 | 0 | 3500 | 3500 | 0 | 28000
XA10170 |  |  |  |  |  | Inventory | 31356.8824 | 27856.8824 | 24356.8824 | 20856.8824 | 17356.8824 | 17356.8824 | 13856.8824 | 10356.8824 | 10356.8824 | 6856.882400000002 | 3356.882400000002 | 3356.882400000002
XA10170 |  |  |  |  |  | 2.6 | 81527.89424000001 | 72427.89424000001 | 63327.89424000001 | 54227.89424000001 | 45127.89424000001 | 45127.89424000001 | 36027.89424000001 | 26927.89424000001 | 26927.89424000001 | 17827.89424000001 | 8727.894240000007 | 8727.894240000007
XA10170 |  |  |  |  |  | Safety Stock | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500
XA10170 |  |  |  |  |  | MOH   (6month avg) | 13.43866388571429 | 9.55093110857143 | 8.35093110857143 | 8.938663885714286 | 7.438663885714286 | 7.438663885714286 | 5.938663885714286 | 4.438663885714287 | 4.438663885714287 | 2.938663885714286 | 1.438663885714287 | 1.438663885714287
XA10170 |  |  |  |  |  | MOH (12month avg) | 13.43866388571429 | 11.93866388571429 | 10.43866388571429 | 8.938663885714286 | 7.438663885714286 | 7.438663885714286 | 5.938663885714286 | 4.438663885714287 | 4.438663885714287 | 2.938663885714286 | 1.438663885714287 | 1.438663885714287