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:

Psychotropic Drug

A chemical substance that changes brain function and results in alterations in perception, mood, or consciousness.

Psychological Symptoms

Manifestations of mental or emotional distress, which may include anxiety, depression, mood swings, or behavioral changes.

Psychosis

Loss of contact with reality, most often evidenced as delusions or hallucinations.

Mania

A state characterized by racing thoughts, pressured speech, irritability or euphoria, and impaired judgment.