Question Assignment description
Susan Wong Case Examine Fall 2105.docx Susan Wong Template Fall 2015.xlsx (Downside and Template are in hyperlinks above!!!! )The issue has no less than three (three) constraints and no less than two (2) determination variables. The issue shall be bounded and possible. It is going to even have a single optimum resolution (in different phrases, it gained’t have alternate optimum options). The issue may even embrace a element that includes sensitivity Assessment and using the shadow value.You can be handing over two (2) deliverables, a quick writeup of the challenge and the spreadsheet displaying your work.Writeup.Your writeup ought to introduce your resolution to the challenge by describing the issue. Accurately determine what kind of downside that is. For instance, you need to notice if the issue is a maximization or minimization downside, in addition to determine the sources that constrain the answer. Establish every variable and clarify the standards concerned in organising the mannequin. This ought to be encapsulated in a single (1) or two (2) succinct paragraphs.After the introductory paragraph, write out the L.P. mannequin for the issue. Embody the target operate and all constraints, together with any non-negativity constraints. Then, you need to current the optimum resolution, based mostly in your work in Excel. Clarify what the outcomes imply.Lastly, write a paragraph addressing the a part of the issue pertaining to sensitivity Assessment and shadow value.Excel.As beforehand famous, please arrange your downside in Excel and discover the answer utilizing Solver. Clearly label the cells in your spreadsheet. You’ll flip in the complete spreadsheet, displaying the setup of the mannequin, and the outcomes.Your work shall be graded in keeping with the next rubric. Factors: 110Project 1: Linear Programming Case StudyCriteriaUnacceptableBelow 60% FMeets Minimal Expectations60-69% DFair70-79% CProficient80-89% BExemplary90-100% AExplain what kind of downside that is and the strategy you take (20%)Didn’t clarify what kind of downside that is and the strategy taken, or did so insufficiently.Insufficiently defined what kind of downside that is and the strategy takenPartially defined what kind of downside that is and the strategy takenSatisfactorily defined what kind of downside that is and the strategy takenThoroughly defined what kind of downside that is and the strategy takenObjective operate specified appropriately in writeup (10%)Goal operate is specified incorrectly, with each coefficients incorrect or lacking. Goal operate is specified, however one (1) coefficient is wrong.Coefficients for goal operate are appropriate, however whether or not that is a max or min downside is wrong.Goal operate is specified appropriately.Constraints are specified appropriately in writeup (10%)Constraints are specified incorrectly or lacking.Some constraints are appropriately specified.Most constraints are appropriately specified. All constraints are appropriately specified, purchase relevant nonnegativity constraints are omitted. All constraints are appropriately specified, together with nonnegativity constraints, if relevant.Specified L.P. Mannequin is appropriately translated to Excel (10%)Specified L.P. Mannequin is incorrectly translated into ExcelSpecified mannequin is translated to Excel in a partially appropriate mannerSpecified mannequin is translated to Excel in a largely appropriate mannerSpecified mannequin is appropriately translated to ExcelCorrect Reply is Obtained (10%)Appropriate optimum shouldn’t be obtainedCorrect optimum is obtainedCorrectly reply the sensitivity Assessment a part of the issue. (15%)Didn’t try the sensitivity Assessment a part of the issue or did so with lower than 60% accuracy and completenessInsufficiently defined and/or offered a partially appropriate reply to the sensitivity Assessment a part of the problemPartially defined and/or offered a partially appropriate reply to the sensitivity Assessment a part of the problemSatisfactorily defined and appropriately answered the sensitivity Assessment a part of the problemThoroughly defined and appropriately answered the sensitivity Assessment a part of the problemCorrectly reply the shadow value a part of the issue. (15%)Didn’t try the sensitivity Assessment a part of the issue or did so with lower than 60% accuracy and completenessInsufficiently defined and/or offered a partially appropriate reply to the sensitivity Assessment a part of the problemPartially defined and/or offered a partially appropriate reply to the sensitivity Assessment a part of the problemSatisfactorily defined and appropriately answered the sensitivity Assessment a part of the problemThoroughly defined and appropriately answered the sensitivity Assessment a part of the problem5. Writing / Grammar and mechanics(10%)Critical and chronic errors in grammar, spelling, and punctuation.Quite a few errors in grammar, spelling, and punctuation.Partially freed from errors in grammar, spelling, and punctuation.Largely freed from errors in grammar, spelling, and punctuation.Freed from errors in grammar, spelling, and punctuation.
