A Company Wants to Purchase Large and Small Delivery Trucks

question 71

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:

Global War

A conflict involving major parts of the world; often involves multiple countries across different continents.

Waterboarding

A form of torture in which water is poured over a cloth covering the face and breathing passages of an immobilized captive, causing the individual to experience the sensation of drowning.

Toxic Assets

Financial assets whose value has fallen significantly and for which there is no longer a functioning market, making them difficult to sell without incurring a loss.

Initial Public Offering

The process by which a private company offers its shares to the public in a new stock issuance, often to raise capital.