Question: just part 4) Variable Cells Final Value Name Product A Product B Reduced Cost 0 0 1000 800 Objective Coefficient 200 280 Allowable Increase 24

just part 4) just part 4) Variable Cells Final Value Name

Variable Cells Final Value Name Product A Product B Reduced Cost 0 0 1000 800 Objective Coefficient 200 280 Allowable Increase 24 220 Allowable Decrease 88 30 Final Value Constraints Name Steel Available Manufacturing Minutes Assembly Minutes 40000 120000 92000 Shadow Constraint Allowable Allowable Price R.H. Side Increase Decrease 8.8 40000 909 10000 0.6 120000 40000 5714 0 96000 Inf 4000 1- Determine the optimal values for each decision variable and the value of the objective function (15 marks) 2- Identify the slack of each constraint (10 marks) 3. The company is considering increasing the price for product A to 250. Will this price affect the optimal solution? (10 marks) 4- The company is considering using overtime to increase the available assembly time. What would you advise the company to do regarding this option? What is the maximum price the company would be willing to pay for an additional assembly hour? How many overtime hours should the company consider? (20 marks)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Considering the following excel sensitivity report: Variable Cells \ table [ [ Cell , Name, \ table [ [ Final ] , [ Value ] ] , \ table [ [ Reduced ] , [ Cost ] ] , \ table [ [ Objective ] , [...

By using the sensitivity report given by Solver, answer the following questions. Adjustable Cells Cell Name $B$4 $$ invested Fund 1 $C$4 $$ invested Fund 2 $D$4 $$ invested Fund 3 $E$4 $$ invested...

please solve it on page solve part 2a Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$6 Factory A Store 1 240 0 15 5 1E+30 $C$6...

Please keep at least 4 decimals for your answer. Tracksaws, Inc. makes tractors and lawn mowers. The firm makes a profit of $30 on each tractor and $30 on each lawn mower, and they sell all they can...

John, a meat market manager for local supermarket, is preparing a processing plan to stock the shelves with sausage, mince (or ground meat), and jerky. These meat products can be prepared by using...

Next Page Question 1 (0.4 points) Use the Solver sensitivity report to answer the following question. What's the maximum value of the coefficient of Variable 2 that can be increased without change...

2. Remember the Sonoma Apple problem in the previous homework. This problem is based on that but realize it is a bit different. The problem was solved in Excel and the sensitivity report is shown...

Consider the following sensitivity report. Adjustable Cells Cell Name $D$3 Quantity Produced SS $E$3 Quantity Produced AS SF$3 Quantity Produced SC $G$3 Quantity Produced DC Final Reduced Objective...

Problem 2. A furniture manufacturer produces four products (Desks, Tables, Chairs, and Bookshelves). The production process consists of Assembly, Painting, Finishing, and Packaging. LP problem has...

Microsoft Excel Sensitivity Report (Obtained Using Standard LP/Quadratic Engine) Decision Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease...

P18-1A Combat Fire, Inc. manufactures steel cylinders and nozzles for two models of fire extinguishers: (1) a home fire extinguisher and (2) a commercial fire extinguisher. The home model is a...

Read the scenario below and discuss how you can rectify this situation. Scenario One of your KPIs in your operational plan was to increase the number of over 50s joining the club in the first month....

Conducting breakeven analysis at a company - wide level helps in: Question 1 8 options: Ignoring individual product profitability Evaluating overall operational profitability Only assessing fixed...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...