Question: Please see attached homework document below. I need help with solving the problem HOMEWORK/LINEAR PROGRAMMING Consider the following scenario, A publishing house publishes three weekly

Please see attached homework document below. I need help with solving the problem

Please see attached homework document below. I

HOMEWORK/LINEAR PROGRAMMING Consider 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: Production (hr.) Paper (lb.) 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. Your model should include an objective function and all relevant constraints (including non-negativity constraints). Provide all relevant equations and/or inequalities in your formulation b. Solve the model by using Excel solver. Include a screenshot of your problem solution in Excel. c. Include a screenshot of the answer report, sensitivity report and limits report

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 Mathematics Questions!