View the step-by-step solution to:

# You can use either Solver, Lindo or excel to resolve problems. Be sure to indicate all variables and explain all models. All work must be done...

You can use either Solver, Lindo or excel to resolve problems. Be sure to indicate all variables and explain all models. All work must be done individually.
➢ Identify / define the variables that are used in your model
➢ List any assumptions

1. (20 points) - A soda producer makes and sells two products, Classic Cola and Diet Cola. If this company spends X1 dollars on promotion of Classic Cola in a particular western city, it can sell at 75 X1^ 0.5 12-packs of Classic Cola each week there. Moreover, if this company spends X2 dollars on promotion of Diet Cola in a particular western city, it can sell at 50X2^0.5 12-packs of Diet Cola each week there. Each 12-pack of Classic Cola sells for \$3.00 and costs \$0.80 to produce and ship to customers in this western city. Each 12-pack of Diet Cola sells for \$3.50 and costs \$1.00 to produce and ship to customers in this western city. A total of \$10,000 is available for promotion each week in this city. The soda producer seeks to maximize its weekly profit. Formulate and solve an appropriate optimization model to help this soda producer identify the best promotional strategies for its two products.

Hi. Pl find the solution. Pl rate me 5 stars. Assign me... View the full answer

Let Classic Cola advtg spend be X1 &amp; Diet Cola advtg spend be X2.
Profit of X1 per week = \$3 - \$0.80 = \$2.20
Profit of X2 per week = \$3.50 - \$1.00 = \$2.50
Maximize Profit = 2.20*75*X1^0.5 +...

### Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

### -

Educational Resources
• ### -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents