Spreadsheet: 677448d1589363722-i-need-an-alternative-to-an-if-function-as-i-have-too-many-queries-to-be-able-o-use-the-if-stock-level-analysis
Sheet: Production Requirement

 |  | 2020-05-14 00:00:00
 |  | Big Machine |  |  | Small Macine |  |  | Big Machine |  |  | Small Macine |  |  | Big Machine |  |  | Small Macine |  |  | Big Machine |  |  | Small Macine |  |  | Big Machine |  |  | Small Macine |  |  | Big Machine |  |  | Small Macine |  |  | Big Machine |  |  | Small Macine |  |  | Big Machine |  |  | Small Macine |  |  | Big Machine |  |  | Small Macine |  |  | Big Machine |  |  | Small Macine |  |  | Big Machine |  |  | Small Macine |  |  | Big Machine |  |  | Small Macine |  |  | Big Machine |  |  | Small Macine |  |  | Big Machine |  |  | Small Macine |  |  | Big Machine |  |  | Small Macine |  |  | Big Machine |  |  | Small Macine |  |  | Big Machine |  |  | Small Macine |  |  | Big Machine |  |  | Small Macine |  |  | Big Machine |  |  | Small Macine |  |  | Big Machine |  |  | Small Macine |  |  | Big Machine |  |  | Small Macine |  |  | Big Machine |  |  | Small Macine |  |  | Big Machine |  |  | Small Macine |  |  | Big Machine |  |  | Small Macine |  |  | Big Machine |  |  | Small Macine |  |  | Big Machine |  |  | Small Macine |  |  | Big Machine |  |  | Small Macine |  |  | Big Machine |  |  | Small Macine |  |  | Big Machine |  |  | Small Macine |  |  | Big Machine |  |  | Small Macine |  |  | Big Machine |  |  | Small Macine |  |  | Big Machine |  |  | Small Macine |  |  | Big Machine |  |  | Small Macine |  |  | Big Machine |  |  | Small Macine |  |  | Big Machine |  |  | Small Macine |  |  | Big Machine |  |  | Small Macine |  |  | Big Machine |  |  | Small Macine |  |  | Big Machine |  |  | Small Macine |  |  | Big Machine |  |  | Small Macine |  |  | Big Machine |  |  | Small Macine |  |  | Big Machine |  |  | Small Macine |  |  | Big Machine |  |  | Small Macine |  |  | Big Machine |  |  | Small Macine |  |  | Big Machine |  |  | Small Macine |  |  | Big Machine |  |  | Small Macine |  |  | Big Machine |  |  | Small Macine |  |  | Big Machine |  |  | Small Macine
 |  | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3
Number of Packs Made |  | 1 | 2 | 3 | 4 | 5 | 6
Formulation Made |  | A | C | E | C | C | D | A | C | E | C | C | D | A | C | E | C | C | D | A | C | E | C | C | D | A | C | E | C | C | D | A | C | E | C | C | D | A | C | E | C | C | D | A | C | E | C | C | D | A | C | E | C | C | D | A | C | E | C | C | D | A | C | E | C | C | D | A | C | E | C | C | D | A | C | E | C | C | D | A | C | E | C | C | D | A | C | E | C | C | D | A | C | E | C | C | D | A | C | E | C | C | D | A | C | E | C | C | D | A | C | E | C | C | D | A | C | E | C | C | D | A | C | E | C | C | D | A | C | E | C | C | D | A | C | E | C | C | D | A | C | E | C | C | D | A | C | E | C | C | D | A | C | E | C | C | D | A | C | E | C | C | D | A | C | E | C | C | D | A | C | E | C | C | D | A | C | E | C | C | D | A | C | E | C | C | D | A | C | E | C | C | D | A | C | E | C | C | D | A | C | E | C | C | D | A | C | E | C | C | D | A | C | E | C | C | D | A | C | E | C | C | D | A | C | E | C | C | D | A | C | E | C | C | D | A | C | E | C | C | D | A | C | E | C | C | D | A | C | E | C | C | D | A | C | E | C | C | D | A | C | E | C | C | D | A | C | E | C | C | D | A | C | E | C | C | D | A | C | E | C | C | D
Redundancy Factor |  | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Weight Of Material
 | Large Machine
 | Small Machine
Cost p Kg
Redundancy Factor
Raw Materials
Total