complete the following linear programming problem with sensitivity anysis

Covering Chapter 5 (Quantitative Business Modeling)

******See the attached word file

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now

Also, please understand what e1 means when you view the sensitivity report. For instance,1+e1=1*10^1=10, 1+e2=1*10^2=100, and 1+e3=1*10^3=1000. Then you will be able to generalize for a different number like 1+e8=1*10^8=100000000.

As you work on part d, please be careful, as I am not asking you to select a resource that has the largest shadow price. You might have to select two or three resources according to the sensitivity report.

Complete each homework assignment in two (2) parts.

First, complete the mathematical requirements for each assigned question and subpart in a separate Excel tab.

Second, complete the narrative description requirements of the assignment in a Word document. Complete the narrative in the Word document. When the question asks for calculations, make reference to the appropriate tab in the Excel file for reference. Also, please include (1)sensitivity report, (2)answerreport and (3)programming tab within the same spreadsheet.

– Show mathematical steps in detail to receive full credits

– You must use the “Solver” add-in for excel to complete this assignment

You can reference the following videos for guidance on completing the problem:

https://calbaptist.webex.com/calbaptist/ldr.php?RCID=aee120f7857ccc8441110a963e60e8bf

https://calbaptist.webex.com/calbaptist/ldr.php?RCID=313990268516cde67fca8cb55d9b612a

https://calbaptist.webex.com/calbaptist/ldr.php?RCID=7b5a69393491ce51065bc034fb3857ff

**I will tip generously for 100% on this assignment