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:

Economic

Pertains to the production, distribution, and consumption of goods and services, and the analysis of behaviors and decisions related to these processes.

Fallacy of Composition

The erroneous belief that what is true for a part is necessarily true for the whole, particularly in economics.

Model

A simplified representation of reality, often mathematical, used to analyze and predict complex systems or phenomena.

Predictor

An indicator or factor that suggests the likely outcome or future direction of something, often used in the context of economic or statistical analysis.