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

Most significant or descriptive home parameters

For this discussion, identify what you consider to be the three most significant or descriptive home parameters (that is, price mean, price mode, home size mean, home size mod

Execute the sustainable performance phase

If an organization chooses not to execute the Sustainable performance phase, what would be the impact upon the organization? How would you go about convincing management that

Other qualitative factors should be considered in decision

Presswick Industries supplies plastics used for medical applications such as pharmaceutical injections and collecting laboratory samples. Presswick produces the containers and

Performance feedback-goal difficulty-goal specificity

The goal of the Apollo 11 moon flight was to put a man on the moon. According to Mark Garfield, who worked at NASA on the Apollo mission, Apollo 11 was off-course 90 percent o

Illustrate what was poka-yoke shingo created

Existing method involved assemblers taking individual springs from a box containing several hundred also then placing two of m behind an ON button also two more behind an OF

State where contributory negligence is the law

Mrs. Robinson (in the Volkswagen Audi case) never establishes residency in Arizona, returns to New York, and files her case in federal district court in New York, alleging div

Supply chain-value chain and integrated value chain

The Internet marketing paradigm includes both marketing inputs and marketing actions. Discuss the major components of both the inputs and the actions? Discuss the importance o

Operations reflect each of those management strategies

Identify MNEs whose operations reflect each of those management strategies. Then discuss the ways in which organized labor can possibly affect (or has affected) their pursui


Write a Review

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd