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:

Environmental Pressures

External factors or stimuli that can affect an individual's behavior, decisions, or psychological state.

Gender-role Socialization

The process through which individuals learn the behaviors, attitudes, and expectations typically associated with their assigned gender from societal norms, cultural practices, and family upbringing.

Parents

Adults who have a child or children, including biological, adoptive, step, and foster roles, responsible for supporting and raising their offspring.

Schools

Institutions dedicated to the education and learning of students under the guidance of teachers, ranging from primary to tertiary levels.