A company produces two products using three raw materials. I-he company has a limited amount of...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A company produces two products using three raw materials. I-he company has a limited amount of raw materials for next week production. Production manager of the company has used linear programming to find the product mix which maximizes the profit. Following is the sensitivity report of spread sheet formulation. Adjustable Cells Name $C$12 Product 1 Constraints 'Units Produced Cell $E$7 $D$12 Product 2 Units Produced Name Material 1 Used Final Reduced Objective Value 4 12 Final Value 4 24 Allowable Allowable Cost Coefficient Increase Decrease 36 0 0 Shadow Price 0 150 300 500 R.H. Side 8 450 24 36 IE+30 Constraint Allowable Allowable Decrease Increase 1E+30 $E$8 Material 2 Used $E$9 Material 3 Used 100 a) What is the maximum unit profit of product I that does not change the existing optimal product mix? 300 12 300 12 4 12 12 b) If the company has a limited amount of money to buy additional raw materials, which raw material should they buy first? Give reasons for your answer. A company produces two products using three raw materials. I-he company has a limited amount of raw materials for next week production. Production manager of the company has used linear programming to find the product mix which maximizes the profit. Following is the sensitivity report of spread sheet formulation. Adjustable Cells Name $C$12 Product 1 Constraints 'Units Produced Cell $E$7 $D$12 Product 2 Units Produced Name Material 1 Used Final Reduced Objective Value 4 12 Final Value 4 24 Allowable Allowable Cost Coefficient Increase Decrease 36 0 0 Shadow Price 0 150 300 500 R.H. Side 8 450 24 36 IE+30 Constraint Allowable Allowable Decrease Increase 1E+30 $E$8 Material 2 Used $E$9 Material 3 Used 100 a) What is the maximum unit profit of product I that does not change the existing optimal product mix? 300 12 300 12 4 12 12 b) If the company has a limited amount of money to buy additional raw materials, which raw material should they buy first? Give reasons for your answer.
Expert Answer:
Answer rating: 100% (QA)
This image depicts a sensitivity report from a linear programming model which is a summary of the op... View the full answer
Related Book For
Operations Management
ISBN: 9781259270154
6th Canadian Edition
Authors: William J Stevenson, Mehran Hojati, James Cao
Posted Date:
Students also viewed these general management questions
-
Ken and Larry, Inc., supplies its ice cream parlors with three flavors of ice cream: chocolate, vanilla, and banana. Due to extremely hot weather and a high demand for its products, the company has...
-
UNO 1& A Particle of mass m moves along a curve (x-c)+y= c, At t, discuss the following points of system in detail. (a) An appropriate figure any %3D time the (B) Are there any constraints in the...
-
Prove that the equation is a h71 dz / 970 converges if and
-
Alleghany Community College operates four departments. The square footage used by each department is shown below. Alleghany's annual building rental cost is $320,000 What amount of rent expense that...
-
What is the nature of research and development costs?
-
The following are the per capita GDP figures (rounded to the nearest hundred) for eight European countries according to the World Bank. The monetary figures are in international dollars; for...
-
Define the concept of differential analysis. How is this concept different from the traditional approaches used to assess acquisitions?
-
The following were selected from among the transactions completed during the current year by Indigo Co., an appliance wholesale company: Jan. 13. Sold merchandise on account to Boylan Co., $32,000....
-
Agencies have been entrusted with a vast amount of power to carry out their missions. Social changes can quickly develop as a result of changes in laws or public policy. During times of rapid changes...
-
Defend the significance of LG considering the opinions of an executive jury when formulating the business's inventory management policy.
-
Two oscillating dipoles are located in the x-y plane (on the y-axis) at y = a and y = -a. Their dipole moments are oriented in the direction. Assume that our observation point is located at a...
-
make a class named BankCustomer . A bank customer should include four pieces of information as customer_id (type String), customer_id (type String), saving_accounts (type SavingAccount[], an array of...
-
The following was submitted under the original assignment of "write small program that uses dynamic binding".. now what is requested is to suggest another way to take advantage of the dynamic biding...
-
Suppose a, b, and c are int variables and a = 5 and b = 6. What value is assigned to each variable after each statement executes? If a variable is undefined at a particular statement, report UND...
-
Complete the program so that each cell of array sum contains the sum of the corresponding cells of valA and valB: class Exercise3 { public static void main(String[] args) { int[] valA = {13, -22, 82,...
-
Find all the "daffodil numbers" between 100 and 999 and output them. "Daffodil number" refers to a three-digit number, and the cube of each digit is exactly equal to the number itself. For example,...
-
Restaurant/bar liability for intoxicated patrons who harm third parties, at common law through today (Dram shop law) 1 Break the topic down historically with reference to the earliest known legal...
-
The production budget of Artest Company calls for 80,000 units to be produced. If it takes 30 minutes to make one unit and the direct labor rate is $16 per hour, what is the total budgeted direct...
-
Car sharing is a model of car rental in which people rent cars for short periods of time, often by the hour. The car has to be located close to the customer's residence or workplace, so cars are...
-
Refer to Solved Problem 1. Start with 20 permanent workers. Prepare a minimum cost plan that may use some combination of hiring ($250 per worker), subcontracting ($8 per unit, maximum of 20 units per...
-
What are the key enablers for successful implementation of JIT/lean?
-
In a cluster sample, the population is divided into groups, and a random sample from each group is drawn. In Exercises 1316, determine whether the statement is true or false. If the statement is...
-
True or false: The way that questions are worded on a survey may have an effect on the responses.
-
In a case-control study, the outcome has occurred before the subjects are sampled. In Exercises 1116, determine whether the statement is true or false. If the statement is false, rewrite it as a true...
Study smarter with the SolutionInn App