Question: Given results after developing the excel LP and so 10 minutes on slide Remove Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost

Given results after developing the excel LP and so 10 minutes on slide Remove Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease Type A x 15 0 B Type 8 0 6 2 Type C 2 0 .95 6.5 1E+30 2 Question 4: Sensitivity Analysts (20 points) Using the Excel Solver results in Table, address the following questions: What is the objective function and its optimal solution? b. How much more "steel" can we buy without changing the current optimal solution? c. Considering wood to be sunk cost, how much will it cost the company to order an additional 30 units of wood? komals Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease Wood 1 15 1 15 20 10 Steel 2 30 15 30 110 30 hours 3 15 0 70 1E430 55 d. Will the optimal solution remain unchanged if coefficient of "Type A increases to 9 and coefficient of "Type C" increases to 6.5? How much will it cost the company to buy 55 more "hours"? c. Reactions Record Share Screen Chat o 23 Participants

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!

Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease Type A x 5 0 3 5 3 Type B y 2 0 4 3 3 Type C z 0 -3.5 6 1E+30 8 Constraints Final Shadow C

Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease Type A x 4 0 5 4 2 Type B y 0 -3.5 3 2 1E+30 Type C z 3 0 5 6 2 Constraints Final Shadow...

help with the 3 following questions please: Questions Search Insert Draw Design Layout References Mailings Review View Help 1) A company can decide how many additional labor hours to acquire for a...

The tables that follow make up the sensitivity report for Eli Willy (a pharmaceutical distributor). Decision Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost...

Fashion Inc. produces advertisements (ads) for clients using four types of electronic media: radio, regular TV, cable TV and telephone. Partial minutes of a media type may be purchased. The objective...

Use the information below to answer parts A.-D. Each part is worth 3 points. Courtney's Cupcakes is a company that caters baked goods for events. Courtney has been hired to bake cupcakes for an...

The tables that follow make up the sensitivity report for Eli Willy (a pharmaceutical distributor). Decision Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost...

The tables that follow make up the sensitivity report for El Willy la pharmaceutical distributor) Decision Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient...

The tables that follow make up the sensitivity report for Eli Willy (a pharmaceutical distributor). Decision Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost...

I need an answer for question 8 7. The company is considering raising the profit per gallon for Vanilla and Banana ice creams by 1 AED each. Indicate whether the following statements are True (T) or...

Accounting XYZ ltd is a manufacturing concern, currently using a machinery which has a semi variable cost of 200,000$. Currently it is operating at 50% capacity, producing 5000 units. If it increases...

On, July 15, 2016, Tidnish Vessel Refitters Ltd. (Tidnish) signed a contract to refit a 25-year-old supertanker to meet new environmental standards and operate more efficiently. Tidnish has provided...

Question 9 Reconding a transaction in a journal is called a 3 pts Debit Credit T - Account Journal Entry

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...