The Oudoor Fumiture Corporation manufactures twro products, pionic tables and be

Question

The Oudoor Fumiture Corporation manufactures twro products, pionic tables and benches, for use in yards and parks. The fim has two main resources: aluminum alloy and redwood for benches. use. The anticipated unit profits are $70 for tables and $50 for t of red wood and 2 pound of aluminum aly, wheroas the bench needs 3 foot of red wood and 1 pour of aluminum alloy in the production process A supplier delivers 240 feet of red wood and 100 pounds of the aluminum alloy We want to find how many tables and branches should Outdoor Furniture Corporation produce each week to Using the excel weekdly 1. Define the dedision variables and write the objective function model (10 points) 2. Define the constraints of the problem (20 points) 3 Solve the problem using solver and find which is the optimal amount of X and Y that maximize the proft and how much are the profits? (20 points)

Explanation / Answer

Aluminium Alloy (pounds) Redwood (feet) Profit Per unit Units Profit Table (x) 2 4 70 30 2100 Bench (y) 1 3 50 40 2000 Total used 100 240 100 240 Total Profit 4100 Total profit is decision variable Z = 70x + 50y Constraints are 100 >= 2x + 1y 240 >= 4x +3y Units for max profit are X = 30 and Y = 40 Max profit is 4100

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.