How many tons of each product should be produced

Assignment Help Engineering Mathematics

Reference no: EM131294266

Assignment: Linear Programming Applications

SAPIC

Question 1:

SABIC , Inc. is a firm that produces chemical based products. In a particular process 3 Material are used to produce 2 products. The Material requirements per ton are:

Product	Material 1	Material 2	Material 3
Fuel additive	0.4	0	0.6
Solvent base	0.5	0.2	0.3

For the current production period SABIC has available the following quantities of each material. Because of spoilage, any materials not used for current production must be discarded.

Material Available for Production	# Tons
Material 1	20
Material 2	5
Material 3	21

If the contribution to the profit is 40 SAR for each ton of fuel additive and 30 SAR for each ton of solvent base,

1) Use given data to formulate a linear programming model.
2) Set up the template for this problem on Excel and show how you would solve this problem on Excel Solver.
3) What is the maximum profit?
4) How many tons of each product should be produced?
5) How many resources were used?

You are required to turn in an Excel file with the solution which include Excel sheet, Answer report and Sensitivity report and answer of previous questions.

Reference no: EM131294266

Questions Cloud

Describe the strategy spaces of the players : Describe the strategy spaces of the players - Compute the Nash equilibria of this game.

Determine the amount to be reported as the cost of the land : On March 1, 2017, Pharoah Company acquired real estate, on which it planned to construct a small office building, by paying $83,000 in cash. An old warehouse on the property was demolished at a cost of $8, 800; the salvaged materials were sold for $1..

What did you learn from the article : What was the purpose of the study described in the article?What was the method of the study described in the article?What was the conclusion of the study described in the article?

What are the tax consequences of the two distributions : Trumpeter Corporation, an accrual basis taxpayer, has lost money (undoubtedly as a tax plan) since its formation. At the start of the year, it has amassed a deficit in accumulated E&P of $340,000. Compute Trumpeter’s E & P for the year. What are the ..

How many tons of each product should be produced : Set up the template for this problem on Excel and show how you would solve this problem on Excel Solver. What is the maximum profit? How many tons of each product should be produced?

The declaration and payment of the cash dividend : Greenwood Corporation has 75,390 shares of common stock outstanding. It declares a $1 per share cash dividend on November 1 to stockholders of record on December 1. The dividend is paid on December 31. Prepare the entries on the appropriate dates to ..

How much gross income goes jason report : Ellie purchases an insurance policy on her life and names her brother. Jason, as the beneficiary. Ellie pays $32,000 in premiums for the policy during her life. When she dies, Jason collects the insurance proceeds of $500,000. As a result, how much g..

Require reconciliation of total governmental fund balances : Give examples of items/transactions that would require reconciliation of total governmental fund balances to net position of governmental activities.

User Account

All Pages