Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Given results after developing the excel LP and Solver: Question 4: Sensitivity Analysis (20 Points) Using the Excel Solver results in Table, address the following

image text in transcribed
Given results after developing the excel LP and Solver: Question 4: Sensitivity Analysis (20 Points) Using the Excel Solver results in Table, address the following questions: (4 points per question) Exodogs Star Slurp 3 Availability 3500 S 5 a. What is the objective function and its optimal value? 0 1 350 3 2 360 Profit $10 320 b. What are the slack/surplus values for different constraints? 0 180.0 Number produce Potit contribution Total (per wed) 33600 50 $3600 c. What happens to the optimal solution if the coefficient of "Number produced Star" changes to 20 minutes on slide 30? Sathy Raw Vartable Fiul Raluced Objective Allowable Allowable Value Collidest er Decrease Cell Name Cou d. What % of available "Labor amount used" can be decreased without it affecting the current (given) optimam solution? -10 10 10 TES berdeel te SHINero Sur 10 20 1E10 Saw Cost Allowable Aliwale N. le Der How much should the "Star" product unit profit of S10 be increased by so the manufacturer can produce them? C 35 1136 LAU al Show Criat Valse ILLS 140 3500 11 30 10 300

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

Public Finance A Contemporary Application Of Theory To Policy

Authors: David N. Hyman

5th Edition

0030113172, 978-0030113178

More Books

Students also viewed these Finance questions