case study linear programming excel solver

Even the smartest students need writing assistance at some point during their academic career. Should you lock yourself in a room and spend the entire weekend trying to write a paper? We promise you that the paper that you pay for won’t be resold or submitted elsewhere. It will also be written according to the instructions that you and your professor provide. Our excellent essays stand out among the rest for a reason. Don’t just take our word, check them out by yourself.

Order a Similar Paper Order a Different Paper

please see attached Case Study

read the Case, try to solve it, answer the following questions

instructions below

1. (20 points) Case Synopsis (include a brief summary of the case and the business issue(s)being studied) 2. (20 points) Methodology (including a discussion of what information was provided and how you used this information to analyze the problem) organize the available data and type out your full mathematical programming model including defining your decision variables. 3. (40 points) Findings and Conclusions (include summary of analysis results) Based on your analysis, what is Sunrise Grill’s (complete) optimal marketing decision?

A schedule showing the recommended number of SiriusXM, Social Media, and Internet Radio advertisements and the budget allocation for each medium. Show the total exposure rate and indicate the total number of potential new customers reached. Also address the following two questions:

a. How would the total exposure change if an additional $20,000 were added to the advertising budget?

b. After reviewing KK’s recommendation, the Sunrise Grill management team asked how the recommendation would change if the objective of the advertising campaign was to maximize the number of potential new customers reached. Develop the media schedule under this objective. Show the total exposure and indicate the total number of potential new customers reached. 4. (20 points + up to 10 points extra credit) Recommendations. What other factors need to be considered in making the recommendations? Do you agree with the decisions from your quantitative analysis? Why or why not? Using both of these recommendations you made in the findings and conclusions section and your own management perspective (other issues to consider), what is your recommendation for the Sunrise Grill’s advertising campaign?. For extra credit, you can also do some outside research on Digital Marketing campaigns and/or base your opinion on your knowledge and/or experience with Digital Marketing (be sure to site any outside sources used).

*Based on a case problem from Anderson, Sweeney, Williams, Camm, Cohran, Fry, Ohlmann, An Introduction to Management Science, 14th Editi

Do you need help with this or a different assignment? In a world where academic success does not come without efforts, we do our best to provide the most proficient and capable essay writing service. After all, impressing professors shouldn’t be hard, we make that possible. If you decide to make your order on our website, you will get 15 % off your first order. You only need to indicate the discount code GET15.

Order a Similar Paper Order a Different Paper