← Reading listFIND THE BEST FEASIBLE BUNDLE OF INDIVISIBLE PROJECTS
Text

Operations research decision workshop / 6 MIN READ

Find the best feasible bundle of indivisible projects

A high value-to-cost ratio can select the wrong bundle when projects cannot be divided.

Published by SNS Media Tech

AI-assisted research and analysis for the SNS Creative Fieldbook

Sources checked 2026-11-07

An attractive recommendation needs an explanation of the alternatives it leaves behind.

What you will leave with: A reproducible recommendation whose commercial assumptions remain visible.

Use this when

  • A creative team is comparing complete project proposals with a shared spending ceiling.
  • A ratio-ranked shortlist leaves an unexplained gap in the available allowance.

Not a cash-flow forecast, dependency schedule or authorization to spend.

Define what the teaching values mean

Google describes the knapsack problem as maximizing the value of a subset within a capacity limit. Here projects are indivisible, costs consume one budget, and benefits are additive.

A fictional studio considers three independent demonstration packages. Costs are in teaching currency units, not rupees or dollars. Values are stipulated benefit points on one explicitly additive teaching scale, not revenue forecasts or survey ranks. A real sponsor would need to defend that scale before this comparison could support a commercial recommendation.

Write what delivery includes for each package. If an apparently inexpensive proposal leaves essential finishing work for someone else, its quoted cost is not comparable. Ask the owner to resolve the scope rather than adjusting a score privately. Keep the original proposal and the corrected interpretation together so the comparison cannot conceal a change in what would be delivered.

Sources for this sectionThe Knapsack Problem →

Enumerate the alternatives completely

SciPy’s formulation uses integer variables and bounds. Let each inclusion variable be 0 or 1. For A, B and C, costs are 6, 5, 5 and values 12, 9, 9. Budget is 10. The eight rows, written as selection: cost, value, are none: 0, 0; A: 6, 12; B: 5, 9; C: 5, 9; AB: 11, 21; AC: 11, 21; BC: 10, 18; ABC: 16, 30. Reject rows costing above 10, then compare values. BC wins with 18.

Preserve the rejected rows in the teaching sheet. They help a reviewer distinguish an attractive but unavailable option from one that was simply overlooked. Label the empty row explicitly rather than treating a blank cell as a missing record. Ask another reader to reconstruct the list without looking at the answer; an omitted alternative is harder to notice than an incorrect addition.

For a larger real problem, an analyst may need appropriate optimization software. This small exercise deliberately stays inspectable by hand. Do not claim that a short list prepared from memory has the same completeness as this fully enumerated fixture, and do not present a time-limited software answer as a proved optimum without reviewing its result status.

Sources for this sectionmilp →

Explain why the attractive shortcut loses

A’s ratio is 12/6 = 2, versus 9/5 = 1.8 for B or C. Taking A first leaves 4, insufficient for either other project. Its value 12 loses to BC’s 18. At budget 11, AB and AC tie at 21. The extra currency unit changes the best bundle, not merely the unused balance.

Use that contrast to discuss the recommendation, not to criticize the person who suggested the shortcut. The ratio made an understandable local comparison; the missing question concerned the consequences of that choice for everything else. Present the original shortlist alongside the complete fixture so the commercial owner can see exactly why the recommendation changed.

Before carrying the lesson into a real proposal, investigate shared benefits and prerequisites. Two packages might reach the same audience, or one might be unusable without another. Those facts would require a revised model, not an invented discount to make the worksheet look realistic. Pause when the sponsor cannot explain the relationship between the proposed benefit points.

Sources for this sectionmilp →

Recommend a bundle without inventing authority

Attach the scope descriptions and unresolved commercial evidence to the recommendation. The arithmetic answers the stipulated teaching question; it does not establish that any package is valuable in the marketplace. A sponsor may reasonably decide to gather evidence, change the brief or decline the entire opportunity.

Keep a competing objective visible rather than quietly changing scores. If a package is required for an existing commitment, the owner should state that requirement and ask for a revised comparison. Do not report the earlier answer as though it already incorporated the new obligation.

Close with the proposed choice, the evidence most likely to change it and the person authorized to decide. Retain the earlier version if assumptions change. That record makes a later review about the quality of the decision basis, rather than a contest over which proposal looked most persuasive at the outset.

Make the reasoning concrete.

A studio director wants an auditable recommendation before considering a purchase.

Present the persuasive shortlist

Opening: Show only the favored proposal and its pitch.

Hypothesis: The discussion will be quick.

Risk: The owner cannot inspect the alternatives that disappeared.

Present the complete comparison

Opening: Bring the fixture and scope questions to review.

Hypothesis: The owner can challenge the actual decision basis.

Risk: The commercial evidence may still be too weak to proceed.

The studio uses the second approach and makes no spending commitment.

Take the questions into your next brief.

Use these prompts in your own notes. Nothing is submitted from this page.

  1. Meaning

    What evidence would justify the teaching score in an actual proposal?

  2. Scope

    What work is included in each quoted package?

  3. Completeness

    Can another reader reconstruct the entire fixture?

  4. Relationship

    Which shared benefit or prerequisite would invalidate the assumptions?

  5. Decision

    What evidence would make the sponsor reconsider?

Watch for the wrong conclusion.

  • Treating an ordinal preference rank as an additive benefit measure.
  • Omitting an inconvenient proposal without explaining why.
  • Reporting a mathematical answer as purchasing approval.

Your next action

Rebuild the fictional comparison independently, then write the commercial question its arithmetic cannot settle.

Sources & scope

The decision reasoning and fictional inputs are original. Method statements and mathematical applications remain attributed, including later restatements. Documentation was read on the stated date; no installed solver version is asserted. Local exhaustive arithmetic was executed, not real operations. No purchasing, staffing, shipment, scheduling or account change is authorized.

  • The Knapsack Problem →Primary documentation · Supports: Supports the stated model.
  • milp →Primary documentation · Supports: Supports the mathematical formulation.