Reference no: EM1316584
Developing a mathematical programming model to maximize the total costs
MTM produces motion pictures in Texas and distributes them nationwide. Currently, it is considering ten possible films. These include dramas, comedies, and action adventures. The success of each film depends somewhat on both the strength of the subject matter and the appeal of the cast. Estimating the cost of a film and its potential box office draw is inexact at best. However, the studio must rely on its experts' opinions to help it evaluate which projects to undertake. Table below lists the films currently under consideration, their rating, type, cost and cast information.
Table:
Film
|
|
|
No-Name Cast
|
Big Star Cast
|
Rating
|
Type
|
Cost
|
Box Office Gross
|
Cost
|
Box Office Gross
|
Two-Edged Sword
|
PG-13
|
Action
|
$5M
|
$8M
|
$10M
|
$15M
|
Lady in Waiting
|
R
|
Drama
|
$12M
|
$20M
|
$25M
|
$35M
|
Yesterday
|
PG
|
Drama
|
$8M
|
$10M
|
$12M
|
$26M
|
Golly Gee
|
PG
|
Comedy
|
$7M
|
$12M
|
$15M
|
$26M
|
Why I Cry
|
PG-13
|
Drama
|
$15M
|
$30M
|
$30M
|
$45M
|
Captain Kid
|
PG
|
Comedy
|
$10M
|
$20M
|
$17M
|
$28M
|
Oh Yes!
|
R
|
Comedy
|
$4M
|
$7M
|
$8M
|
$12M
|
Nitty Gritty
|
PG
|
Comedy
|
$11M
|
$15M
|
$14M
|
$20M
|
The Crash
|
R
|
Action
|
$20M
|
$28M
|
$40M
|
$65M
|
Bombs Away
|
R
|
Action
|
$25M
|
$37M
|
$50M
|
$80M
|
In addition to these production costs, each move will have a $1million advertising budget, which will increase to $3 million if the move is to have a big star case. Assume that the studio receives 80% of a film's gross receipts. The company would like to maximize its net profit (gross profit - production costs - advertising costs) for the year. MTM has a production budget of $100 million and an advertising budget of $15 million. In addition, it would like to adhere to the following restrictions:
1. At least half the films produced should have a rating of PG or PG-13.
2. At least two comedies are to be produced.
3. If The Crash is produced, Bombs Away will not be.
4. At least one drama is to be produced.
5. At least two films should have big-name casts.
6. At least two PG films should be produced.
7. At least one action move with a big-name cast should be produced.
Develop a mathematical programming model and solve. Discuss your results [total profits, total costs, etc].