Formulate this problem as linear programming

Assignment Help Operation Management

Reference no: EM131144688

A carpenter makes tables and chairs. Each table can be sold at the price of $100 and each chair at the price of $40. The carpenter works a maximum of 40 hours per week and spends 5 hours to make a table and 2 hours to make a chair. Each table needs 50 pounds of wood and 30 screws. Each chair needs 20 pounds of wood and 10 screws. Each pound of wood costs him $0.75 and 100 screws cost him $5. Customer demand requires that he makes at least twice as many chairs as tables. The carpenter stores the finished products in his garage, and there is room for a maximum of 9 furniture pieces each week. He should make at least 2 chairs each week. How many tables and chairs should he make to maximize his profit during a week?

Formulate this problem as a linear programming. (Write complete definition of D.V., O.F., and constraints)

Solve in Excel. (Please, print 2 spreadsheets: 1. Shows the values of the optimal solution, 2. Shows formula you use. You can see your formula by using ctrl+~).

Reference no: EM131144688

Questions Cloud

With the inventory representing large percentage of assets : With the inventory representing a very large percentage of assets, how does one control costs?

Why might the above relationship signal a recession : What expectations must people have regarding future interest rates?

How many autoimmunity tests per year will have to be perform : How many autoimmunity tests per year will have to be performed on the array machine to break even? Given the present volume of tests, would there be an annual net contribution and, if so, how much?

How did the industrial revolution affect the role of women : How did the Industrial Revolution affect the role of women?- Was this change universal throughout all of Europe?

Formulate this problem as linear programming : A carpenter makes tables and chairs. Each table can be sold at the price of $100 and each chair at the price of $40. The carpenter works a maximum of 40 hours per week and spends 5 hours to make a table and 2 hours to make a chair. Formulate this pro..

Computing trend and seasonal factor from linear regression : Computing Trend and Seasonal Factor From a Linear Regression Line Obtained With Excel," located in Chapter 18 of the textbook. Write a 150-300-word paragraph explaining the market research, panel consensus, historical analogy, and Delphi method quali..

What do such high returns imply about the market : what do such high returns imply about the market's expectations regarding the future profitability of U.S. firms?

How ethnocentrism is important element of american history : Examine how ethnocentrism is an important element of American history in the development of a diverse culture, while at the same time increasing social distance.

Development of a strategic analysis guides : Development of a strategic analysis guides all decisions made regarding your compensation systems throughout the project - Limiting the number of jobs removes one level of complexity from the simulation and allows you to focus on learning the functi..

User Account

All Pages