2. Are there any binding constraints for this model? If so, which one and what does...

Transcribed Image Text:

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. 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.