Computing value of coefficient in objective function

Reference no: EM1315478

Q1) A plant in developing country can produce 5 different products in any combination. Each product needs time on each of these machines, as listed in the table below. Every figures are in minutes per pound of product.

	Machine-Time (min/lb)
Product	1	2	3
A	12	8	5
B	7	9	10
C	8	4	7
D	10	0	3
E	7	11	2

Each machine is available 128 hours per week. Products A, B, C, D, and E are merely competitive, and any amounts made may be sold at per pound prices of= $5, $4, $5, $4 and $4 respectively. Variable labour costs are= $4 per hour for machine 1 and 2, and $3 per hour for machine 3. Material costs are= $2 for each pound of products A and C, and $1 for each pound of products B, D and E. Management wants to maximize profit to firm. Solver LP solution and sensitivity.

(a) What is Excel formula in B9 giving first value of coefficient in the objective function?

(b) How many hours are spent on each of 3 machines and what are the units of shadow prices on constraints which control machine capacity?

(d) How much can sales price of product A rise before the optimal production changes?

Reference no: EM1315478

Questions Cloud

Profit maximizing level of output-perfectly competitive firm : Consider the Figure below that represents a perfectly competitive firm

Think the industry environment is significantly dissimilar : Do you think the industry environment is significantly dissimilar today.

Computation of promised yield to maturity for cardiotronics : Computation of promised yield to maturity for Cardiotronic's zero coupon bonds and the probability of default that is implicit in the price of Cardiotronics outstanding zero-coupon bonds

Maximization of economic profit for high mark : High Mark Industries sells solar water heaters to households interested in lower energy bills and sustainable energy.

Computing value of coefficient in objective function : What is Excel formula in B9 giving first value of coefficient in the objective function?

Two pure strategy equilibria of a zero-sum game : Elucidate how which any two pure strategy equilibria of a zero-sum game are interchangeable also equivalent.

Creating the object oriented program : Create an abstract Employee class and two pure virtual functions - calculatePay() and displayEmployee(). Abstract Employee class will avoid a programmer from generating an object based on the Employee.

Costa rican supplier and their contract : Dell Electronics just stumbled upon a new supplier of personal computer (PC) circuitry in Costa Rica that can supply standardized computer inputs at $70 per PC.

Mean difference among the group categories-anova : Using ANOVA, determine if there is a significant difference in the six year graduation rate by type.

User Account

All Pages