Explain the properties of linear programming model

Assignment Help Operation Management

Reference no: EM131760073

Strategic Decision with Management Sciences

Read the following case and answer the questions that follow it.

Ruwais Furniture Manufacturing (RFM) makes 2 products: Antique wood chairs and Modern wood chairs.

For every Antique chair, RFM makes a profit of 22 AED. For every Modern chair, a profit of 15 AED.

RFM uses 2 resources to make its chairs: oak wood and pine wood. The company has 450 meters of oak wood and 420 meters of pine wood available.

Total labour time available is 300 hours

To make 1 Antique wood chair, 3 meters of oak and 2 meters of pine are required. It takes 2 hours labour time to make one antique chair.

To make 1 Modern wood chair, 2 meters of oak and 1 meters of pine are required. It takes 1.5 hours of labour time to make one modern chair.

To determine the optimal solution (number of each product to be produced and the profit), start by formulating the above as an LP problem:

Answer:

I. Variables:

II. Objective function

III. Constraints

IV. To solve this LP problem, formulate it in Excel:

V. Using Excel Solver, what is the optimal solution?

VI. Produce the Sensitivity report. If an additional 20 hours of labour available, what will be the new profit?

VII. Explain the properties of a linear programming model.

VIII. What is the purpose of the Sensitivity report in solving a linear programming problem?

Reference no: EM131760073

Questions Cloud

Describe the functionality of the new technology selected : Describe the functionality of the new technology selected for implementation and the challenges associated with the current cybersecurity policy.

Prior claim on assets and income : Q1. In terms of risk, preferred stock is safer than common stock because it has a prior claim on assets and income.

A limited liability partnership pays income taxes : A partnership can be changed to a corporation later, when profits are assured". A limited liability partnership (LLP) pays income taxes.

Can you identify one non verbal cue you do on purpose : What messages do they send? Is this the message you intend?Your paper should be about the nonverbal messages that you are sending.

Explain the properties of linear programming model : Ruwais Furniture Manufacturing (RFM) makes 2 products: Antique wood chairs and Modern wood chairs. Explain the properties of a linear programming model.

Determine budgeted payments for purchases of raw material : (Direct material purchases and budgeted payments) Campbell Manufacturing intends to start business on January I,20I4. Production plans for the first four month.

Critically analyse the role of it project management : ITC505 - ICT Project Management - reflect on and synthesise the key elements of the IT project management framework, including project stakeholders

Can you trace how you see yourself to the appraisals reflect : Write a response containing the results with sources from the readings to clarify what you found.

Attempt to explain stock market behavior : There are many theories that attempt to explain stock market behavior. Discusses market anomalies that contradict the efficient market hypothesis.

User Account

All Pages