A Company Needs to Purchase Several New Machines to Meet

question 25

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 in cells G4 and E7 for this Excel spreadsheet implementation of the following formulation? ​ ​
​

---

Definitions:

Plastic Objects

Manufactured articles made from various types of polymers, often characterized by their durability, light weight, and versatility in usage.

Nacirema

A term used in anthropology and sociology to examine aspects of the behavior and society of American people, derived by spelling 'American' backwards, popularized by Horace Miner in his article on body rituals.

Sociologists

Social scientists who study the development, structure, and functioning of human society, including social behaviors, cultures, and institutions.

Personal Space

The physical area surrounding individuals that they consider psychologically theirs, infringement of which can cause discomfort or distress.