Analyzing the super grain case input and output results

Assignment Help Other Subject

Reference no: EM132319336 , Length: word count:2000

Applied Management Science Project - Modifying and Analyzing the Super Grain Case Study

Instructions: In this project you are required to do a model in excel based on the excel sheet and need to put some data in the parents of young children and the young children who are exposed to tv and link it to the exposure of TV so the model can make sense we are also required to do solver table as the instructions are given under phase 1 and 2

Phase-I

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 discrepancies between the exposures per a single TV ad and the total number of children & parents reached per a single TV ad,

(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 relaxation of the strict constraint related to the coupons budget and its effect on the achievement of the targets listed in the case.

II- Submit a report analyzing the super grain case input and output results along with all the assumptions and modifications you did to the original model in section 3.4 using your own words.

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

Phase-II

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.

VI- Your final report should include the following sections

Introduction (summary) to the original Mixed Super Grain case using your own words
List of all the assumptions and/or modifications that you are introducing to the case with proper justification(s)
Summary of the modified model including full definitions of the variables, objective functions and constraints in both text and algebraic formats.
Comments on the solver output for your modified Super Grain model
Full sensitivity / parametric analysis to the modified super grain model
Conclusions and Recommendations based on the obtained results from the above analysis.

Attachment:- Assignment Files.rar

Reference no: EM132319336

Questions Cloud

Discuss the it budgeting practices that deliver value : Discuss the IT Budgeting practices that deliver value. Which of the practices do you consider to be the most important and why?

Major electronics and appliances retail store : What is your 'killer idea' to counter the drift from bricks-and-mortar retail to online?

How much for acquired intangible assets from the purchase : Identifiable R & D of $100,000. ABC will record how much for acquired Intangible Assets from the Purchase of XYZ Inc?

Describe what are the foundational laws : In a very brief and easy to understand format, create a presentation that can be used to instruct individuals and groups on the basic substantive content.

Analyzing the super grain case input and output results : BUS306 Applied Management Science Project- Modifying and Analyzing the Super Grain Case Study, Abu Dhabi University, UAE

At what amount should vibe record this building : Vibe Company purchased the net assets of Atlantic Company in a business combination accounted for as a purchase. As a result, goodwill was recorded.

Prepare all journal entries for denizen corporation : Denizen's fiscal year ends on december 31. the forward contract was to hedge an anticipated purchase of electronic goods on january 30, 20x9.

Porters five competitive forces : How does the retail industry implement business strategy to deal with the Porters five competitive forces.

Compute the rate of return on common? stockholders equity : A company originally issued 10,000 shares of $9.00 par value common stock at $17.00 per share. The board of directors declares a 14?% stock dividend.

Reviews

len2319336

6/10/2019 2:31:10 AM

Word Count- 2000 Words. Instructions: In this project we are required to do a model in excel based on the excel sheet is sent we need to put some data in the parents of young children and the young children who are exposed to tv and link it to the exposure of TV so the model can make sense we are also required to do solver table as the instructions are given on the word documents under phase 1 and 2. Enclosed is a sample excel sheet, kindly provide me with your explanation and how I can make a similar one.

Write a Review

Required(*) Message

User Account

All Pages