Question
Alice makes two types of accessories (Product 1 and 2) for selling in the handcraft market. Each of them requires various units of Acrylic, Metal,
Alice makes two types of accessories (Product 1 and 2) for selling in the handcraft market. Each of them requires various units of Acrylic, Metal, and Nylon. The unit costs of Acrylic, Metal, and Nylon are $5, $10, and $3 respectively. Now, she wants to determine the number of Product 1 and 2 to be made to maximize the total profit. For each unit of Product 1, three units of Acrylic, one unit of Metal, and two units of Nylon are required. For each unit of Product 2, one units of Acrylic, and four units of Nylon are required. The supplier has 300 units of Acrylic, unlimited Metal, and 200 units of Nylon. Amy decides to set the unit price of Product 1 as $80, and $60 for Product 2. After analysing the demand of each product, she decides to produce at least 10 units of Product 2 but no more than 50 units.
Q1 Formulate and solve a linear programming model for this problem on a spreadsheet.
Step by Step Solution
3.48 Rating (168 Votes )
There are 3 Steps involved in it
Step: 1
Let x1 be the number of units of Product 1 to be produced and x2 be the number of units of ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started