Linear programming: production problem | Human Resource Management homework help

A manufacturing company produces four different models of integrated circuits. Each type of circuit requires material, labor, and machine time. The optimal combination of the four types of circuits is limited by the constraints of availability for these three resources. The formulation of the linear programming production problem is:

Don't use plagiarized sources. Get Your Custom Essay on
Linear programming: production problem | Human Resource Management homework help
Just from $13/Page
Order Essay

Maximize Z = 12x1 + 10x2 + 15x3 + 11x4 (objective function for profit)

Subject to the following constraints:

Material: 5x1 + 3x2 + 4x3 + 2x4 = 240 pounds
Machine time: 6x1 + 8x2 + 2x3 + 3x4 = 240 hours
Labor: 2x1 + 3x2 + 3x3 + 2x4 = 180 hours

Nonnegativity: x1, x2, x3, x4 = 0

Where: x1 = quantity of Product 1 produced
           x2 = quantity of Product 2 produced
           x3 = quantity of Product 3 produced
           x4 = quantity of Product 4 produced

Use Microsoft Excel and Solver to find the optimal solution for the production problem. Be sure that values selected by the computer are integers (as it doesn’t make any sense to discuss producing part of a unit of a product).

Include your interpretation of the results by stating:

  • How many of each product will be produced?
  • What is the profit for the optimal solution?
  • What resource(s) is limiting the production?

Submit the solution for the production problem in a Microsoft Excel worksheet with proper labeling for columns and all required calculations. Submit your interpretations in a 1- to 2-page Microsoft Word document.

Support your responses with examples.

Cite any sources in APA format.

Submission Details

Name your documents SU_MGT4059_W3_A2_LastName_FirstInitial.docx and SU_MGT4059_W3_A2_LastName_FirstInitial.xlsx.

Submit your documents to the W3 Assignment 2 Dropbox by Tuesday, November 26, 2013.

Assignment 2 Grading Criteria

Maximum Points

Correctly implemented this problem in Microsoft Excel using the Solver add-in.

60

Determined how many units of each product would be produced.

45

Determined the profit for the optimal allocation of resources.

35

Discussed the resource(s) that is limiting the system from producing even more units of product (and, thereby, earning more profit).

50

Written components.

10

Total:

200

Grab 16% Discount On This Paper
Pages (550 words)
Approximate price: -

Why Choose Us

Quality Papers

We value our clients. For this reason, we ensure that each paper is written carefully as per the instructions provided by the client. Our editing team also checks all the papers to ensure that they have been completed as per the expectations.

Professional Academic Writers

Over the years, MyEssay.Help has managed to secure the most qualified, reliable and experienced team of writers. The company has also ensured continued training and development of the team members to ensure that it keep up with the rising Academic Trends.

Affordable Prices

Our prices are fairly priced in such a way that ensures affordability. Additionally, you can get a free price quotation by clicking on the "Place Order" button.

On-Time delivery

We pay strict attention on deadlines. For this reason, we ensure that all papers are submitted earlier, even before the deadline indicated by the customer. For this reason, the client can go through the work and review everything.

100% Originality

At MyEssay.help, all papers are plagiarism-free as they are written from scratch. We have taken strict measures to ensure that there is no similarity on all papers and that citations are included as per the standards set.

Customer Support 24/7

Our support team is readily available to provide any guidance/help on our platform at any time of the day/night. Feel free to contact us via the Chat window or support email: support@myessay.help.

Try it now!

Grab 16% Discount On This Paper

We'll send you the first draft for approval by at
Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

MyEssay.help has stood as the world’s leading custom essay writing services providers. Once you enter all the details in the order form under the place order button, the rest is up to us.

Essays

Essay Writing Services

At MyEssay.help, we prioritize on all aspects that bring about a good grade such as impeccable grammar, proper structure, zero-plagiarism and conformance to guidelines. Our experienced team of writers will help you completed your essays and other assignments.

Admissions

Admission and Business Papers

Be assured that you’ll definitely get accepted to the Master’s level program at any university once you enter all the details in the order form. We won’t leave you here; we will also help you secure a good position in your aspired workplace by creating an outstanding resume or portfolio once you place an order.

Editing

Editing and Proofreading

Our skilled editing and writing team will help you restructure you paper, paraphrase, correct grammar and replace plagiarized sections on your paper just on time. The service is geared toward eliminating any mistakes and rather enhancing better quality.

Coursework

Technical papers

We have writers in almost all fields including the most technical fields. You don’t have to worry about the complexity of your paper. Simply enter as much details as possible in the place order section.

                                                                                     Place Order