A Company Wants to Purchase Large and Small Delivery Trucks

question 26

Essay

A company wants to purchase large and small delivery trucks. The company wants to purchase about 10 large and 15 small trucks. Each large truck costs $30,000 and has a 10 ton capacity. Each small truck costs $20,000 and has a 7 ton capacity. The company wants to have about 200 tons of capacity and spend about $600,000.
Based on the following goal programming formulation, associated solution, and spreadsheet model, what formulas should go in cells D6:E6, B9:E9, and B16 of the spreadsheet?

---

Definitions:

Existing Promisor

A party in a contractual agreement who has previously committed to perform a specific duty or obligation.

Contractual Promises

Commitments made within a contract that are binding and enforceable by law, requiring parties to perform or refrain from certain actions.

Absolute Promises

Unconditional commitments made by one party to another, requiring full performance without contingencies or reliance on future events.

Implied-in-Law Condition

A legally imposed condition in a contractual agreement, not explicitly stated, created to ensure fairness and justice, often derived from the nature of the agreement or parties' intentions.