Formulate linear programming model

Assignment Help Management Theories

Reference no: EM131858786

Question: Consider a resource-allocation problem having the following data:

	Resource Usage per Unit of each activity		Amount of Resource Available
	Resource Usage per Unit of each activity
Resource	A	B
1	1	2	10
2	1	3	12
Unit Profit in ($)	2	5

The objective is to determine the number of units of each activity to undertake so as to maximize the profit.

1. Formulate linear programming model for this problem on a spreadsheet

2. Use excel solver to find the optimal solution

3. Express the model in mathematical form

4. Suppose the profit for activity A changes to $4. Will this change the optimal production quantities? What could be said about the change in total profit? (use sensitivity analysis repot to answer to this question)

5. Suppose the available amount of resource for resource 1 increases to 20. What could be said about the change in shadow price?

Reference no: EM131858786

Questions Cloud

What type of forensic serological analysis : This swab is from the victim's right thigh where the perpetrator had bitten the victim. The skin was torn where the bite mark was swabbed.

What factors does organization use : Consider several employers in your area, such as a college, hospital, retail store, auto dealership, or governmental agency.

Reading miranda rights : Should evidence that was gathered by the police in an unlawful way e.g. without a warrant or without reading Miranda rights

What would be a good area of criminal justice : What would be a good area of criminal justice to embrace as a career in order to make a difference in our criminal justice system?

Formulate linear programming model : The objective is to determine the number of units of each activity to undertake so as to maximize the profit. Use excel solver to find the optimal solution

What would be a good area of criminal justice : What would be a good area of criminal justice to embrace as a career in order to make a difference in our criminal justice system? Discuss.

Write a program that reads postfix expressions : Write a program that reads postfix expressions and prints their values. Each input expression should be entered on its own line.

What is a well worked plan to put a stop to soliciting : What is a well worked plan to put a stop to soliciting. What are two plans that you would consider to be most efficient & why do you think it will work

Examine the harmonic oscillations by modelling the motion : examine the harmonic oscillations by modelling the motion of a mass-spring system with differential equations - determine the behavior of the mass-spring system

User Account

All Pages