Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please explain all steps! thank you Problem PM-92. A manager wants to determine how many units of each product to produce weekly to maximize profits.

image text in transcribed

Please explain all steps! thank you

Problem PM-92. A manager wants to determine how many units of each product to produce weekly to maximize profits. Production requirements for the products are: Product Material 1 Material 2 Labour A 3 kg 2 kg 4 hr B 1 4 2 5 none 3.5 Material 1 costs $7 per kilogram, material 2 costs $5 per kilogram, and labour costs $15 per hour. Product A sells for $101 a unit, product B sells for $67 a unit, and product C sells for $97.50 a unit. Each week there are 300 kilograms of material 1: 400 kilograms of material 2; and 200 hours of labour. There is a regular order of 10 units of product Ceach week. The LP model for this problem is: Max 10A + 10B + 10C Subject to: 3A + B + 5C S 300 (constraint 1) 2A + 4B 400 (constraint 2) 4A + 2B +3.5C S 200 (constraint 3) C210 (constraint 4) A,B,C20 The model is entered into Excel and Solver is used to find the optimal solution. The Sensitivity Report is: Adjustable Cells Cell SB$4 SC$4 SD$4 Name Optimal Values. A Optimal Values: B Optimal Values Final Reduced Value Cost 0 -10 82.5 0 10 0 Objective Coefficient 10 10 10 Allowable Allowable Increase Decrease 10 1E+30 1E430 4.285 7.5 1E+30 Constraints Cell Name $E$7 Constraint 1 $E$8 Constraint 2 SESE Constraint 3 SE$10 Constraint 4 Final Value 132.5 330 200 10 Shadow Price 0 0 5 -75 Constraint R.H.S. Side 300 400 200 10 Allowable Allowable Increase Decrease 1E+30 167.5 1E+30 70 35 165 47.142 10 Consider the LP problem in the figure. What is the optimal objective function value? 925 825 100 92.5 none of these

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Finance questions