Question: [Use Excel to solve this problem] Please carefully read the following scenario: A publishing house publishes three weekly magazinesDaily Life, Agriculture Today, and Surfs Up.

[Use Excel to solve this problem] Please carefully read the following scenario: A publishing house publishes three weekly magazinesDaily Life, Agriculture Today, and Surfs Up. Publication of one issue of each of the magazines requires the following amounts of production time and paper: 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 Surfs 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 Surfs 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. The total number of constraints in this problem (excluding non-negativity constraints) is:

2

9

3

6

5

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!