I require the 5 tasks listed in the QAT Tasks Document The associated spreadsheets that must be filled out, and rubrics are included in the zip file.The graduate uses optimizing models and other models as aids for making more informed decisions.

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. The candidate accurately determines, with sufficient 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 Y that should be produced. 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. The candidate accurately determines, with sufficient support, the total profit that would be generated by the production levels determined in parts C1 and C2. When the candidate uses sources, the candidate provides appropriate in-text citations and references accurately or with only minor deviations from APA style.

The candidate provides adequate articulation of response. The candidate accurately identifies the objective function. 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. The candidate accurately provides 4 algebraic constraints as described in the scenario given in the attached QAT1 Task 2 Spreadsheet.

The candidate provides adequate articulation of response. The candidate accurately determines the average materials cost per unit. The candidate accurately determines the average labor cost per unit. The candidate accurately determines the average utilities cost per unit. The candidate accurately determines the average total cost per unit. The candidate accurately provides the 3 random interval tables needed to correctly determine the costs from part A1. The candidate provides a reasonable description, with sufficient support, of how the candidate correctly used the random interval tables from part A2 to populate the “QAT1 Task 1 Spreadsheet.” The candidate accurately determines the selling price per unit that should be established for the new product using the simulation results. The candidate provides a reasonable description, with sufficient support, of how the candidate arrived at the selling price from part B. When the candidate uses sources, the candidate provides appropriate in-text citations and references accurately or with only minor deviations from APA style.