A publishing house publishes three weekly magazines-daily life, agriculture today, and surf's up. Publication of one issue of each of the magazines requires the following amounts of production time and paper:
Production (hr.) Paper (lbs.)
Daily Life 0.01 0.2
Agriculture Today 0.03 0.5
Surf's Up 0.02 0.3
Each week the publisher has available 120 hours of production time and 3,000 pounds of paper. Total circulation for all three magazines must exceed 5,000 issues per week if the company is to keep its advertisers. The selling price per issue is $2.25 for daily life, $4.00 for agriculture today, and $1.50 for surf's up. Based on past sales, the publisher knows that the maximum weekly demand for daily life is 3,000 issues; for agriculture today, 2,000 issues; and for surf's up, 6,000 issues. The production manager wants to know the number of issues of each magazine to produce weekly in order to maximize total sales revenue.
a. formulate a linear programming model for this problem
b. solve the model by using the computer (excel)
Linear Programming is exemplified.