Student book Task 2 Please enter your name and WGU ID number in the boxes below. Quantitative Analysis for Business QAT1 Assignment 309.3.1-01 - Version LMF0613 Note: In order to get credit for your work it is crucial that you enter your student number correctly. Student Name: Jenna Jenkins Student Number: 515867 After you enter your Student Number, hit the "HOME" key to return to the top of the worksheet. Scroll down to unlocked cells to show work. Given: The contribution to profit from the private label Brand X is $100 per case compared to only $12.50 per case from the company's nationally advertised Brand Y. The recipe for a case of X is 1 unit of Nutrient, 3 units of Color, 15 units of Flavor and 10 units of Grain. The recipe for a case of Y is 2 units of Nutrient, 1 unit of Color, 1 unit of Flavor and 1 unit of Grain. The ingredients are in short supply, so it must use no more than 200 units of Nutrient, no more than 500 units of Color, no more than 250 units of Flavor, and no more than 500 units of Grain. 0 0 0 graph3 Show work below: The first step is to find the objective function. The formula looks like this, which is Brand X and Brand Y and the cost put together. 100x + 12.50y To get the calculation for the profit line, we use the objective function above, and replace X and Y with the profit line coordinates. The coordinates are 0 for the x and 400 for the y. 100*0 + 12.50*400 = 5,000 PART B I began by making a chart/ table of the cases and constraints CASE X 1x 3x 15x 10x NUTRIENT COLOR FLAVOR GRAIN + + + + CASE Y 2y 1y 1y 1y <200 (10.34,94.83)