A Company Needs to Purchase Several New Machines to Meet

question 9

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.
Enter the numbers in the appropriate cells of range B5:F10 in the Excel spreadsheet to solve this problem based on the following formulation.

---

Definitions:

Essential Elements

Fundamental components or aspects that are necessary for something to function or be understood.

Op Art

An artistic movement of the 1960s in which painters sought to produce optical illusions of motion and depth using only geometric forms on two-dimensional surfaces.

Pointillist Manner

A painting technique in which small, distinct dots of color are applied in patterns to form an image, associated with Post-Impressionism.

Bridget Riley

A British painter known for her work in the op-art movement, creating optical illusions and dynamic visual effects through abstract patterns.