Product Mix Model using Excel Solver for MBI Corporation
Introduction: A small retail store is trying to decide on the best use of its advertising budget of $1,000 per month. The store can advertise on local radio for $5 per minute or on local TV for $100 per minute. Each minute of TV advertisement generates 25 times as many sales as each minute of radio advertisement. The store