Question 24 1 F [Use Excel to solve this problem] Please carefully read the following scenario: A publishing house publishes three weekly magazinesDaily 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: Paper (Ib.) 0.2 Daily Life Agriculture Today Surf's Up Production (hr.) 0.01 0.03 0.02 0.5 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 $10 for Daily Life, $1 for Agriculture Today, and $5 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. Given the constraints in this problem, the optimal revenue is: $18,000 $60,500 $52,500 $48,000 $25,500