A Company Wants to Purchase Large and Small Delivery Trucks

question 17

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 formulation and associated integer solution, what values should go in cells B2:E16 of the spreadsheet?

---

Definitions:

Major Setback

A significant or substantial problem, failure, or delay that prevents progress or the achievement of objectives, often requiring considerable effort to overcome.

Consolidation

The process of combining multiple companies, assets, or financial statements into a single entity, often to achieve greater efficiency, market share, or financial stability.

Rule of Reason

A legal doctrine used in antitrust law, determining the legality of a business practice based on its overall reasonableness and its impact on competition.

American Tobacco

The American Tobacco Company was a major American tobacco company founded in 1890 by J.B. Duke, which played a significant role in the development of the tobacco industry in the United States.