Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Instructions: This assignment has two questions. The full credits are 20. Problem 1 (10 points): Tom opens a plant. The plant can produce two

image text in transcribed

Instructions: This assignment has two questions. The full credits are 20. Problem 1 (10 points): Tom opens a plant. The plant can produce two products: a chair and a table. Each chair can earn $6, and each table can earn $8. Each chair costs 2 hours of labor and 4 pounds of wood to make, and each table costs 3 hours and 5 pounds of wood to make. The plant has 20 hours of labor and 40 pounds of wood available. Tom wants to maximize his profits by producing these two types of products. Please formulate this problem using linear programing. (1) Please define the decision variables in this problem. (2 points). (2) Please list the objective function. (3 points) (3) Please list all constraints. (5 points) Problem 2 (10 points) A company is producing two types of products: bowl and mug. Each bowl needs to have 2 hours of labor, and 4 pounds of clay, which can earn 100 dollars per unit. For each mug, it needs to have 3 hours of labor, and 1 pounds of clay, which can earn 20 dollars per unit. The total number of available labor is 80 hours, and the total number of available clay is 100 pounds. Please use EXCEL SOLVER to find the optimal solutions and the optimal value of the objective function to maximize the earnings. That is, (a) What is the optimal number of bowls to produce? (3 points) (b) What is the optimal number of mugs to produce? (3 points) (c) What is the optimal value of the objective function? (4 points)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Understanding Management

Authors: Richard L Daft, Dorothy Marcic

6th Edition

9780324581782, 324581785, 978-0324568387

More Books

Students also viewed these General Management questions

Question

explain the principles of sound lending in pointers

Answered: 1 week ago