A Company Needs to Purchase Several New Machines to Meet

question 43

Essay

A company needs to purchase several new machines to meet its future production needs. It can purchase three different types of machines A, B, and C. Each machine A costs $80,000 and requires 2,000 square feet of floor space. Each machine B costs $50,000 and requires 3,000 square feet of floor space. Each machine C costs $40,000 and requires 5,000 square feet of floor space. The machines can produce 200, 250 and 350 units per day respectively. The plant can only afford $500,000 for all the machines and has at most 20,000 square feet of room for the machines. The company wants to buy as many machines as possible to maximize daily production.
What are the key formulas for this Excel spreadsheet implementation of the following formulation?

---

Definitions:

Positive Externalities

Benefits experienced by third parties or society at large from an economic transaction, such as improved public health or education levels, not reflected in market prices.

Subsidies

Financial support from the government to businesses, individuals, or other governmental bodies to encourage or maintain an activity that has a public good.

Liability Rules

Legal principles that determine how the responsibility for damages or losses is allocated among parties in legal disputes.

Pollution

The occurrence or entry of harmful or toxic materials into the environment.