A Small Town Wants to Build Some New Recreational Facilities

question 60

Essay

A small town wants to build some new recreational facilities. The proposed facilities include a swimming pool, recreation center, basketball court and baseball field. The town council wants to provide the facilities which will be used by the most people, but faces budget and land limitations. The town has $400,000 and 14 acres of land. The pool requires locker facilities which would be in the recreation center, so if the swimming pool is built the recreation center must also be built. Also the council has only enough flat land to build the basketball court or the baseball field. The daily usage and cost of the facilities (in $1,000) are shown below.
Based on this ILP formulation of the problem what formulas should go in cells F5:F12 of the following Excel spreadsheet?

---

Definitions:

Diamonds

Precious stones consisting of a clear and typically colorless crystalline form of pure carbon, often used in jewelry.

Price-Taking Firm

A price-taking firm is a company that must accept the market price for its product, having no influence on the price due to its small size relative to the industry.

Market Power

The ability of a firm to control the price and output of products in its market, often due to limited competition.

Government-Set Barriers

Regulations and policies established by governments to control the entry of firms into certain markets or to protect domestic industries from foreign competition.