0 graph5 Show work below: Evaluation Results Author: Mary Norman Date Evaluated: 01/14/2017 06:25:23 AM (MST) DRF template: Quantitative Analysis for Business (UG, QAT11114) Program: Quantitative Analysis for Business (UG, QAT11114) Evaluation Method: Using Rubric Evaluation Summary for Quantitative Analysis: Task 2 Optimizing Production Final Score: Does not Meet Overall comments: 01/14/17: Please confer with a course mentor before working further on this assessment. The constraint equations for nutrient, color, flavor, and grain are identified, explained, and accurate. The point identified in Section A1, (13, 137) is incorrect and does not lie on the blackdashed line. The profit of $3013 is incorrect. The approach to determine the optimal point given the feasible region is incorrect. All responses in Section C are impacted. Detailed Results (Rubric used: QAT Task 2 (1014)) Articulation of Response (clarity, organization, mechanics) (0) 0=Unsatisfactory/Not Present (1) 1=Needs Improvement (2) 2=Competent The candidate provides unsatisfactory articulation of response. The candidate provides weak articulation of response. The candidate provides adequate articulation of response. (0) 0=Unsatisfactory/Not Present (1) 1=Needs Improvement (2) 2=Competent The candidate does not accurately identify the objective function. Not applicable. The candidate accurately identifies the objective function. Criterion Score: 2.00 A. Objective Function Criterion Score: 2.00 Comments on this criterion: 12/31/16: The objective function, 100x + 12.5y, is accurate. A1. Total Profit (0) 0=Unsatisfactory/Not Present (1) 1=Needs Improvement (2) 2=Competent The candidate does not accurately determine the total profit to be made if the company produces a combination of cases of Brand X and Brand Y that lies on the blackdashed objective function line, as shown on the graph in the attached \"QAT1 Task 2 Spreadsheet.\" Not applicable. The candidate accurately determines the total profit to be made if the company produces a combination of cases of Brand X and Brand Y that lies on the black dashed objective function line, as shown on the graph in the attached \"QAT1 Task 2 Spreadsheet.\" Criterion Score: 0.00 Comments on this criterion: 01/14/17: The objective function is correctly identified. The analysis appears to incorporate the constraints in identifying the point (13, 137). This is an incorrect approach. The response to this task prompt is to determine the total profit for a point that lies on the blackdashed line. The calculated profit of $3013 is incorrect. Printed on: 02/03/2017 05:51:00 PM (EST) determine the total profit for a point that lies on the blackdashed line. The calculated profit of $3013 is incorrect. 01/10/17 The total profit of $2375 is provided. The formula used is correct. An incorrect coordinate on the profit line of (5,150) is observed. 12/31/16: The objective function is identified. The calculated profit of $5,000 in Row 62 is incorrect. The analysis appears to utilize the point (25, 200). This point does not lie on the blackdashed line. B. Four Constraints (0) 0=Unsatisfactory/Not Present (1) 1=Needs Improvement (2) 2=Competent The candidate does not accurately provide any algebraic constraints as described in the scenario given in the attached \"QAT1 Task 2 Spreadsheet.\" The candidate accurately provides 1-3 algebraic constraints as described in the scenario given in the attached \"QAT1 Task 2 Spreadsheet.\" The candidate accurately provides 4 algebraic constraints as described in the scenario given in the attached \"QAT1 Task 2 Spreadsheet.\" Criterion Score: 2.00 Comments on this criterion: 01/14/17: Constraints are accurate. 01/10/17 The constraints of Flavor and Grain are addressed with an inequality statement. The constraints of Nutrient and Color are partially addressed with a total value only. A value for X and Y is also needed. 12/31/16: The constraints for flavor and grain are correct. The constraints for nutrient and color are incomplete. B1. Minimum or Maximum Constraints (0) 0=Unsatisfactory/Not Present (1) 1=Needs Improvement (2) 2=Competent The candidate does not provide an appropriate description of why each of the four written constraints from part B is a minimum or a maximum constraint. The candidate provides an appropriate description, with insufficient support, of why each of the four written constraints from part B is a minimum or a maximum constraint. The candidate provides an appropriate description, with sufficient support, of why each of the four written constraints from part B is a minimum or a maximum constraint. Criterion Score: 2.00 Comments on this criterion: 01/10/17 Each constraint is noted to be ether a maximum or minimum with an explanation for why. 12/31/16: The constraints are appropriately identified as a maximum or minimum. A description of why each constraint is a maximum or minimum could not be located. C1. Cases of Brand X (0) 0=Unsatisfactory/Not Present (1) 1=Needs Improvement (2) 2=Competent The candidate does not accurately determine the number of cases of Brand X that should be produced. The candidate accurately determines, with insufficient support, the number of cases of Brand X that should be produced. The candidate accurately determines, with sufficient support, the number of cases of Brand X that should be produced. Criterion Score: 0.00 Comments on this criterion: 01/14/17: The point (1, 290) is identified and does lie within the feasible region. This point does not represent the optimal mix. The identified cases of Brand X, 1, are incorrect. 01/10/17 The cases of Brand X at 5 is provided. This amount is a point on the feasible region. The amount for X at 5 is not the amount of Brand X that will yield the greatest profit. 12/31/16: An analysis is provided. The cases identified for Brand X, 30, are not correct. The point (30, 150) does not lie within the feasible region. C2. Cases of Brand Y (0) 0=Unsatisfactory/Not Present (1) 1=Needs Improvement (2) 2=Competent The candidate does not accurately determine the number of cases of Brand Y The candidate accurately determines, with insufficient support, the number of cases The candidate accurately determines, with sufficient support, the number of cases of Printed on: 02/03/2017 05:51:00 PM (EST) that should be produced. of Brand Y that should be produced. Brand Y that should be produced. Criterion Score: 0.00 Comments on this criterion: 01/14/17: The point (1, 290) is identified and does lie within the feasible region. This point does not represent the optimal mix. The identified cases of Brand Y, 290, are incorrect. 01/10/17 The amount for Brand Y at 250 is observed. This point is on the feasible region. It is not the optimal amount of Brand Y that should be produced. 12/31/16: An analysis is provided. The cases identified for Brand Y, 150, are not correct. The point (30, 150) does not lie within the feasible region. C3. Feasible Region (0) 0=Unsatisfactory/Not Present (1) 1=Needs Improvement (2) 2=Competent The candidate does not provide an appropriate discussion of how the feasible region was used to arrive at the calculations for parts C1 and C2. The candidate provides an appropriate discussion, with insufficient support, of how the feasible region was used to arrive at the calculations for parts C1 and C2. The candidate provides an appropriate discussion, with sufficient support, of how the feasible region was used to arrive at the calculations for parts C1 and C2. Criterion Score: 1.00 Comments on this criterion: 01/14/17: The nutrient and grain constraints are appropriately identified as defining the feasible region. The approach to determine the optimal point given the feasible region is incorrect. The identified point (1, 290) is not the optimal production point. 01/10/17 The work correctly notes that Nutrient and Grain are the constraints that comprise the feasible region. It is unclear how the feasible region is used to determine the optimal cases of Brand X and Y. 12/31/16: Utilizing the constraints to define the feasible region is appropriate. The analysis misinterprets how to utilize the constraints. The identified feasible region is incorrect/unclear. C4. Total Profit (0) 0=Unsatisfactory/Not Present (1) 1=Needs Improvement (2) 2=Competent The candidate does not accurately determine the total profit that would be generated by the production levels determined in parts C1 and C2. The candidate accurately determines, with insufficient support, the total profit that would be generated by the production levels determined in parts C1 and C2. The candidate accurately determines, with sufficient support, the total profit that would be generated by the production levels determined in parts C1 and C2. Criterion Score: 0.00 Comments on this criterion: 01/14/17: Applying the objective function is an appropriate methodology. The calculated profit of $3725 and point (1, 290) are not the optimal profit/mix. 01/10/17 A profit of $3625 is presented. The method used to compute this value is accurate. The coordinate of (5, 250) is incorrect. 12/31/16: The objective function is utilized. The identified profit of $3,000 is incorrect. The point (30, 150) does not lie within the feasible region. D. Sources (0) 0=Unsatisfactory/Not Present (1) 1=Needs Improvement (2) 2=Competent When the candidate uses sources, the candidate does not provide intext citations and references. When the candidate uses sources, the candidate provides appropriate intext citations and references with major deviations from APA style. When the candidate uses sources, the candidate provides appropriate intext citations and references accurately or with only minor deviations from APA style. Criterion Score: 2.00 Printed on: 02/03/2017 05:51:00 PM (EST) Taskstream 12/31/16, 12:27 PM QUANTITATIVE ANALYSIS Competency 309.3.1: Decision-Making Models - The graduate uses optimizing models and other models as aids for making more informed decisions. Introduction: Graphical models enable a manager to visualize the objective function (profit line), constraints, and possible solutions to a given problem, and to make more informed decisions based on that information. In this task you will be using your knowledge of graphical models, the given scenario, and the attached \"QAT1 Task 2 Spreadsheet\" to complete the assessment. Scenario: Company A produces and sells a popular pet food product packaged under two brand names, with formulas that contain different proportions of the same ingredients. Company A made this decision so that their national branded product would be differentiated from the private label product. Some product is sold under the company's nationally advertised brand (Brand Y), while the re-proportioned formula is packaged under a private label (Brand X) and is sold to chain stores. Because of volume discounts and other stipulations in the sales agreements, the contribution to profit from the Brand Y product sold to distributors under the company's national brand is only $12.50 per case compared to $100 per case for private label product Brand X. There are four ingredients involved in the two products. The recipes specifying the use of each ingredient in the two product brands are given in the \"QAT1 Task 2 Spreadsheet\". Also note that an ingredient may either be in limited supply or may have government regulations requiring a minimum or maximum amount. Task: Note: Save file linked under "File Attachments" to your computer, then open the file. When the file opens, enter your name and student ID as they appear in Taskstream into the respective boxes so the task questions and problems will populate the worksheet. Some students are not able to see the graph in the Excel file. If after entering your name and student number into the file you see the narrative but the graph does not appear, contact ecare@wgu.edu and request that a screenshot of your file/graph be sent to you. Students can take advantage of a free offer for Microsoft Office. Please click on this link and enter your WGU student email to find out eligibility: http://office.microsoft.com/en-us/office-ineducation-FX104367920.aspx. Students would need to use their @my.wgu.edu account. Contact https://support.office.com/ for more information and tech support. A. Identify the objective function. 1. Determine the total profit to be made if the company produces a combination of cases of Brand X and Brand Y that lies on the black-dashed objective function line (profit line), as shown on the graph in the attached \"QAT1 Task 2 Spreadsheet.\" B. Write the four constraints that are described in the scenario given in the attached \"QAT1 Task 2 Spreadsheet.\" 1. Describe why each of the four written constraints from part B is a minimum or a maximum constraint. C. Analyze the optimum production yielding the greatest amount of profit by doing the following: 1. Determine the number of cases of Brand X that should be produced, showing all of your work. 2. Determine the number of cases of Brand Y that should be produced, showing all of your work. 3. Discuss how the feasible region was used to arrive at your calculations for parts C1 and C2. 4. Determine the total profit that would be generated by the production levels determined in parts https://folio.taskstream.com/Folio/BasicBlankStyle.asp?qyz=aL8JAH3WoTbBnLi0GX2&idx=directionsId_0 Page 1 of 2 Taskstream 12/31/16, 12:27 PM C1 and C2, showing all of your work. Note: Partial cases are allowed as part of the solution. D. When you use sources, include all in-text citations and references in APA format. Note To reduce unnecessary matches select ignore \"small matches <20 words\" and \"bibliography.\" note: for definitions of terms commonly used in the rubric, see rubric web link included evaluation procedures section. when using sources to support ideas elements an assessment, submission must include apa formatted in-text citations with a corresponding reference list any direct quotes or paraphrasing. it is not necessary that were consulted if they have been quoted paraphrased text assessment. no more than combined total 30% can be directly closely from outside sources, even cited correctly. tips on style, please refer handout guidelines file attachments: 1. qat1 task 2 spreadsheet save this your computer, then open file. opens, enter name student id as appear taskstream into respective boxes so questions problems will populate worksheet. 2. solver may used, should attached referenced submission. https:>