Question: HERE IS MY QUESTION The sensitivity analysis generated by Excel Solver is given below: Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost

HERE IS MY QUESTION

The sensitivity analysis generated by Excel Solver is given below: Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$7 # of items Chairs 450 0 80 13.33333333 10 $C$7 # oi items Tables 10 0 350 50 50 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $E$4 Materials 10000 2 10000 3000 250 Craftsmen $E$5 hours 1950 10 1950 50 450 Answer the following questions using the report: i) What are the ranges within which the income from each product can lie, without requiring you to resolve the problem? g) What are the ranges within which the 'Materials' anil the 'Craftsmen hours: must lie? h) Ifthe company now decides that it can increase its budget for materials to $1 1 000 what e'ect will this have on your solution? i) Ifthey decide to increase their craftsmen hours to 1975 hours, what effect will this have on your solution

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 Mathematics Questions!

Correct your numerical answers to 4 DECIMAL PLACES when necessary. please Help before 14pm?????? (c) Below is the sensitivity report generated with Excel with some numbers omitted. Variable Cells...

Please help! Answer the following multiple choice based on the table 1) What is the Final Value of MB? A. 38181.12 B. 0 C. 38181.15 D. 0.045 2) What is Allowable Increase for MB? A.0 B.infinity...

Answer the following questions using the sensitivity report shown below. a) Report the optimal solution and the objective function. what is the range of optimality for coefficient of x? (4 marks) b)...

An investment company currently has $ 1 million dollar available for investment in five different stocks. The company wants to maximize the interest earned over the next year. The five investment...

You are the purchasing manager of a sandwich food truck that operates on the local level. Given the resources, you ran the Linear Programming pool and produced wing ferro B c D E G H Variable Cells...

1) what's is the range of optimality for each product?2) what is the reduced cost for those listed and what do they mean? 3) what is the range of feasibility for each constraint?4) what is the shadow...

the following questions using the sensitivity report of a profit function shown below: a) Report the optimal solution and the optimal value of the objective function. b) Calculate the amounts of...

Fran Farnsworth travels throughout the Maritimes selling a line of three health care products. Each box of Flex costs $3 from her supplier, takes Fran 10 minutes (on average) to sell, costs $0.50 to...

Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$11 $ amount in MB ? -0.045 0.085 ? ? $C$11 $ amount in CD 0 ? 0.05 0.015 1E+30 $D$11...

Technologies and Logistic Introduction In the early of 21st century end of 20th century, the age of technology has been spread and popularized throughout hundred countries in the world for decades....

What are the key factors that complicate the audit of a multinational company? Explain A) What responsibility if any, does an account of a public company have when he or she discovers that the...

A donee s basis in property received as a gift is increased if the donor paid gift tax because of the gift. Group of answer choices True False

A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash...