Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

2. Are there any binding constraints for this model? If so, which one and what does that tell management? Is there surplus in any


image

2. Are there any binding constraints for this model? If so, which one and what does that tell management? Is there surplus in any of the vitamins? What does this tell management about purchasing? 3. In an effort to get this program started, a local farm has offered to donate ALL of the apples for the first year for all enrolled students. Reformulate the linear model (not solving) to show how this would change. Once the formulation is complete, solve for the new optimal diet using the new cost of apples. 4. A large donor has come on board to support the city in this initiative. This donor has given the city $100,000 dollars for the program but has specified that the money MUST be used to promote the program to families. Therefore, management has decided that this money will be the project advertising budget. The goal of this advertising budget is to maximize the number of people reached. The ads must be ordered ahead of time and there are 3 different types of ads to choose from. There is Television, Billboards, and Social media. It is assumed that every ad purchased is used and the number of people reached is listed below. These ads are subject to the following constraints: A) Television ads require 2 hours of labor and cost $2k each B) Social Media ads require 1 hour of labor and cost $1k each C) Billboards require 5 hours of labor and cost $6K each MEDIA # OF PEOPLE REACHED PER AD Television Social Media Billboards 30K 25K 22K Formulate the advertising linear model and solve for the optimal way to spend this money using the solver program. Do NOT delete any solver reports. (10 points) Case Synopsis (include a brief summary of the case and the business issue(s)being studied) (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.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

MIS Essentials

Authors: David M. Kroenke

4th edition

978-0133546590, 133546594, 978-0133807479

More Books

Students also viewed these Finance questions

Question

Define line and staff authority

Answered: 1 week ago

Question

Define the process of communication

Answered: 1 week ago

Question

Explain the importance of effective communication

Answered: 1 week ago

Question

* What is the importance of soil testing in civil engineering?

Answered: 1 week ago