Utilize simplex method in excel showing formulas

Assignment Help Operation Management

Reference no: EM13759635

The Pinewood Furniture Company produces chairs and tables from two resources----labor and wood. The company has 80 hours of labor and 36 board -ft. of wood available each day. Demand for chairs is limited to 6 per day. Each chair requires 8 hours of labor and 2 board-ft. of wood, whereas a table requires 10 hours of labor and 6 board-ft. of wood. The profit derived from each chair is $400 and from each table $100. The company wants to determine the number of chairs and tables to produce each day in order to maximize profit.

a. Formulate a linear programming model for this problem. Utilize Simplex Method in excel showing formulas.

b. How much labor and wood will be used if the optimal numbers of chairs and tables are produced?

Reference no: EM13759635

Questions Cloud

Identifies management personnel-nature of the organization : Determine an organization you will analyze and evaluate over the six weeks of this course. The organization can be one in which you work, one in which you have access, or one of such substance that significant internet material is available for your ..

Assuming that coefficient is kept constant at present value : A company produces two products, A and B. The unit revenues are $2 and $3, respectively. Determine the optimality condition for ~ that will keep the optimum unchanged. Determine the optimality ranges for CA and C8, assuming that the other coefficient..

Using qualitative risk analysis matrix : Imagine that you are a member of a project team that has been charged to develop a new product for the residential building industry. Using a qualitative risk analysis matrix, develop a risk assessment for a project based on the following information..

Formulate a linear programming model for this problem : The Elixer Drug Company produces a drug from two ingredients. Each ingredient contains the same three antibiotics, in different proportions. One gram of ingredient 1 contributes 3 units, and 1 gram of ingredient 2 contributes 1 unit of antibiotic 1; ..

Utilize simplex method in excel showing formulas : The Pinewood Furniture Company produces chairs and tables from two resources----labor and wood. The company has 80 hours of labor and 36 board -ft. of wood available each day. Demand for chairs is limited to 6 per day. formulate a linear programming ..

Advantages and disadvantages multiple job evaluations : Advantages/Disadvantages Multiple Job Evaluations. You are the manager of 10 people in a large organization. All of them become very suspicious and upset when they receive a memo from the HR department saying their jobs are going to be evaluated. How..

Determine the walmarts economic order quantity : The demand for spring water at the SLC WalMart is 600 liters per week. The setup cost for placing an order to replenish inventory is $25. The order is delivered by the supplier which charges WalMart $0.10/liter for the cost of transportation from the..

Owns the many species found in nature : Critically assess Merck's deal with INBio. Was it ethically justifiable? Why or why not? Who, if anyone, owns the many species found in nature? Do they belong to the people who own the land or water on or in which they are found?

Identifies the eight categories of human development : create a table that identifies the eight categories of human development, summarizes the importance of the asset to the development of all youth

User Account

All Pages