CornFused9899
New Member
- Joined
- Jun 17, 2018
- Messages
- 2
I have a worksheet that lists necessary components to meet an objective and then several source inventories. I would like a way to pick the combination that best fits the needs and the combination with the fewest sources that meets the needs.
[TABLE="width: 378"]
<tbody>[TR]
[TD="colspan: 3"][TABLE="width: 378"]
<colgroup><col><col span="4"></colgroup><tbody>[TR]
[TD]
Needs[/TD]
[TD]Item 1[/TD]
[TD]Item 2[/TD]
[TD]Item 3[/TD]
[TD]Item 4[/TD]
[/TR]
[TR]
[TD]Qtr 1[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]41[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]18[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sources [/TD]
[TD]Item 1[/TD]
[TD]Item 2[/TD]
[TD]Item 3[/TD]
[TD]Item 4[/TD]
[/TR]
[TR]
[TD]JA1[/TD]
[TD="align: right"]19.6[/TD]
[TD="align: right"]14.7[/TD]
[TD="align: right"]4.9[/TD]
[TD="align: right"]2.5[/TD]
[/TR]
[TR]
[TD]BJR1[/TD]
[TD="align: right"]42.3[/TD]
[TD="align: right"]41.4[/TD]
[TD="align: right"]13.4[/TD]
[TD="align: right"]6.9[/TD]
[/TR]
[TR]
[TD]PRP11[/TD]
[TD="align: right"]2.6[/TD]
[TD="align: right"]1.3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0.48[/TD]
[/TR]
[TR]
[TD]CRSP[/TD]
[TD="align: right"]49.1[/TD]
[TD="align: right"]34.8[/TD]
[TD="align: right"]5.7[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]PRP9[/TD]
[TD="align: right"]20.4[/TD]
[TD="align: right"]17.8[/TD]
[TD="align: right"]4.9[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]BCN60[/TD]
[TD="align: right"]13.5[/TD]
[TD="align: right"]10.9[/TD]
[TD="align: right"]4.6[/TD]
[TD="align: right"]2.4[/TD]
[/TR]
[TR]
[TD]FRM1[/TD]
[TD="align: right"]19.3[/TD]
[TD="align: right"]18.3[/TD]
[TD="align: right"]1.6[/TD]
[TD="align: right"]0.57[/TD]
[/TR]
[TR]
[TD]PRP7[/TD]
[TD="align: right"]34.8[/TD]
[TD="align: right"]33.9[/TD]
[TD="align: right"]3.5[/TD]
[TD="align: right"]1.5[/TD]
[/TR]
[TR]
[TD]PRP-A[/TD]
[TD="align: right"]7.9[/TD]
[TD="align: right"]5.2[/TD]
[TD="align: right"]1.4[/TD]
[TD="align: right"]0.69[/TD]
[/TR]
[TR]
[TD]PRP6[/TD]
[TD="align: right"]4.4[/TD]
[TD="align: right"]5.1[/TD]
[TD="align: right"]1.5[/TD]
[TD="align: right"]0.69[/TD]
[/TR]
[TR]
[TD]BCN10[/TD]
[TD="align: right"]1.1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0.96[/TD]
[TD="align: right"]0.33[/TD]
[/TR]
[TR]
[TD]BCN9[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1.8[/TD]
[TD="align: right"]1.1[/TD]
[TD="align: right"]0.28[/TD]
[/TR]
[TR]
[TD]BCN30[/TD]
[TD="align: right"]11.8[/TD]
[TD="align: right"]10.3[/TD]
[TD="align: right"]3.6[/TD]
[TD="align: right"]1.4[/TD]
[/TR]
[TR]
[TD]BCN08[/TD]
[TD="align: right"]1.8[/TD]
[TD="align: right"]1.4[/TD]
[TD="align: right"]1.1[/TD]
[TD="align: right"]0.33[/TD]
[/TR]
[TR]
[TD]PRP5[/TD]
[TD="align: right"]1.4[/TD]
[TD="align: right"]1.2[/TD]
[TD="align: right"]0.94[/TD]
[TD="align: right"]0.33[/TD]
[/TR]
[TR]
[TD]PRP-B[/TD]
[TD="align: right"]6.8[/TD]
[TD="align: right"]5.4[/TD]
[TD="align: right"]4.6[/TD]
[TD="align: right"]1.8[/TD]
[/TR]
[TR]
[TD]PRP-N[/TD]
[TD="align: right"]33[/TD]
[TD="align: right"]4.3[/TD]
[TD="align: right"]41[/TD]
[TD="align: right"]31[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]Best Fit Combination:[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 3"]Fewest sources Combination:[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 378"]
<tbody>[TR]
[TD="colspan: 3"][TABLE="width: 378"]
<colgroup><col><col span="4"></colgroup><tbody>[TR]
[TD]
Needs[/TD]
[TD]Item 1[/TD]
[TD]Item 2[/TD]
[TD]Item 3[/TD]
[TD]Item 4[/TD]
[/TR]
[TR]
[TD]Qtr 1[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]41[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]18[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sources [/TD]
[TD]Item 1[/TD]
[TD]Item 2[/TD]
[TD]Item 3[/TD]
[TD]Item 4[/TD]
[/TR]
[TR]
[TD]JA1[/TD]
[TD="align: right"]19.6[/TD]
[TD="align: right"]14.7[/TD]
[TD="align: right"]4.9[/TD]
[TD="align: right"]2.5[/TD]
[/TR]
[TR]
[TD]BJR1[/TD]
[TD="align: right"]42.3[/TD]
[TD="align: right"]41.4[/TD]
[TD="align: right"]13.4[/TD]
[TD="align: right"]6.9[/TD]
[/TR]
[TR]
[TD]PRP11[/TD]
[TD="align: right"]2.6[/TD]
[TD="align: right"]1.3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0.48[/TD]
[/TR]
[TR]
[TD]CRSP[/TD]
[TD="align: right"]49.1[/TD]
[TD="align: right"]34.8[/TD]
[TD="align: right"]5.7[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]PRP9[/TD]
[TD="align: right"]20.4[/TD]
[TD="align: right"]17.8[/TD]
[TD="align: right"]4.9[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]BCN60[/TD]
[TD="align: right"]13.5[/TD]
[TD="align: right"]10.9[/TD]
[TD="align: right"]4.6[/TD]
[TD="align: right"]2.4[/TD]
[/TR]
[TR]
[TD]FRM1[/TD]
[TD="align: right"]19.3[/TD]
[TD="align: right"]18.3[/TD]
[TD="align: right"]1.6[/TD]
[TD="align: right"]0.57[/TD]
[/TR]
[TR]
[TD]PRP7[/TD]
[TD="align: right"]34.8[/TD]
[TD="align: right"]33.9[/TD]
[TD="align: right"]3.5[/TD]
[TD="align: right"]1.5[/TD]
[/TR]
[TR]
[TD]PRP-A[/TD]
[TD="align: right"]7.9[/TD]
[TD="align: right"]5.2[/TD]
[TD="align: right"]1.4[/TD]
[TD="align: right"]0.69[/TD]
[/TR]
[TR]
[TD]PRP6[/TD]
[TD="align: right"]4.4[/TD]
[TD="align: right"]5.1[/TD]
[TD="align: right"]1.5[/TD]
[TD="align: right"]0.69[/TD]
[/TR]
[TR]
[TD]BCN10[/TD]
[TD="align: right"]1.1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0.96[/TD]
[TD="align: right"]0.33[/TD]
[/TR]
[TR]
[TD]BCN9[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1.8[/TD]
[TD="align: right"]1.1[/TD]
[TD="align: right"]0.28[/TD]
[/TR]
[TR]
[TD]BCN30[/TD]
[TD="align: right"]11.8[/TD]
[TD="align: right"]10.3[/TD]
[TD="align: right"]3.6[/TD]
[TD="align: right"]1.4[/TD]
[/TR]
[TR]
[TD]BCN08[/TD]
[TD="align: right"]1.8[/TD]
[TD="align: right"]1.4[/TD]
[TD="align: right"]1.1[/TD]
[TD="align: right"]0.33[/TD]
[/TR]
[TR]
[TD]PRP5[/TD]
[TD="align: right"]1.4[/TD]
[TD="align: right"]1.2[/TD]
[TD="align: right"]0.94[/TD]
[TD="align: right"]0.33[/TD]
[/TR]
[TR]
[TD]PRP-B[/TD]
[TD="align: right"]6.8[/TD]
[TD="align: right"]5.4[/TD]
[TD="align: right"]4.6[/TD]
[TD="align: right"]1.8[/TD]
[/TR]
[TR]
[TD]PRP-N[/TD]
[TD="align: right"]33[/TD]
[TD="align: right"]4.3[/TD]
[TD="align: right"]41[/TD]
[TD="align: right"]31[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]Best Fit Combination:[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 3"]Fewest sources Combination:[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]