All the information about super grain case can be found in the book for applied management science, would you like me to post a picture about the case?Mini Project- Modifying and Analyzing the Super Grain Case Study

(Due Date: December 4, 2016)

I- Consider the extension of the Super Grain Case study in section 3.4 and modify it to include at least the coverage of the following issues: (1) the corrections of infeasible exposure figures in the input data, (2) the corrections of the unnecessary charges in relation to the planning budget per ad, (3) the attainment of at least the 17 million exposures that were originally achieved using a minimum cost, and (4) the allocation of the amount of money that could be deducted/saved from the current allocated budget for the coupons without affecting the achievement of the targets listed in the case and how it could be utilized to enhance the results.

II- Extend the input analysis you submitted in Assignment-2 to cover for the final input analysis for your groups modified super grain model.

III- Solve your groups modified Super Grain model and prepare a managerial report that includes a description of your proposed new optimal solution.

IV- Apply the various appropriate parametric (sensitivity) analysis concepts you learnt in this course that could be used to provide a managerial report for your modified Super Grain Case Study. Your report must include complete input and output analysis along with your own recommendations to the Super Grain Company. Your report must include (1) An introduction to the Case original case with highlights to your proposed modifications to the existing model, (2) A summary of the modified model along with a full description of the optimal solution, (3) A full-fledged sensitivity analysis that covers possible variations in the objective function coefficients, right hand sides (RHS) of the constraints, and other input parameters

V- Provide a managerial report highlighting a brief summary of the modified case along with clear recommendations based on the results obtained from the analysis.

The question is a completion of the following pictures using solver and it is in applied management course and requires making assumptions

HOME NSERT PAGE LAYOUT cut Calibri copy B I U <>