In the Red Tomato example, assume that a $1 discount results in a 100% increase in consumption. In any given month and 20% of demand for two subsequent months is moved forward.

Required:

Using Excel Solver, decide whether Red Tomato should (i) not offer promotion, (ii) Offer promotion in January, or (iii) Offer promotion in April to maximize its profit.

Answer rating: 100% (QA)

To solve this problem using Excel Solver we need to set up a mathematical model that represents the ... View the full answer