Reference no: EM13741541
You are to solve Problem 30 in Chapter 4 on page 158 of your textbook. It's about publishing three weekly magazines. You can use QM for Windows to perform a sensitivity analysis for Objective function coefficients and the RHS values of the constraints. Be sure give the shadow price/dual values for an extra hr of production time or an extra lb of paper.
Be sure to follow instructions written for Assignment 1, Linear Programming Case Study.
Assignment 1. Linear Programming Case Study
Your instructor will assign a linear programming
project for this assignment according to the following specifications.
It will be a problem with at least three (3) constraints and at least two (2) decision variables. The problem will be bounded and feasible. It will also have a single optimum solution (in other words, it won't have alternate optimal solutions). The problem will also include a component that involves sensitivity analysis and the use of the shadow price.
You will be turning in two (2) deliverables, a short writeup of the project and the spreadsheet showing your work.
Writeup.
Your writeup should introduce your solution to the project by describing the problem. Correctly identify what type of problem this is. For example, you should note if the problem is a maximization or minimization problem, as well as identify the resources that constrain the solution. Identify each variable and explain the criteria involved in setting up the model. This should be encapsulated in one (1) or two (2) succinct paragraphs.
After the introductory paragraph, write out the L.P. model for the problem. Include the objective function and all constraints, including any non-negativity constraints. Then, you should present the optimal solution, based on your work in Excel. Explain what the results mean.
Finally, write a paragraph addressing the part of the problem pertaining to sensitivity analysis and shadow price.
Excel.
As previously noted, please set up your problem in Excel and find the solution using Solver. Clearly label the cells in your spreadsheet. You will turn in the entire spreadsheet, showing the setup of the model, and the results.
Prob. 30
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 (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.
b. Solve the model by using the computer.
|
Problems arising from the purchase of eighty chairs
: BBI was a large international bank with operations throughout the world. It had recently purchased an office building and had hired the well-known architect Peter Tropper to do the major design and renovation plans.
|
|
If r is rational (r not equal to 0) and x is irrational
: 1) Rudin, Ch. 1, Problem 1: If r is rational (r not equal to 0) and x is irrational, prove that r+x and rx are irrational.2) If (a_n), (b_n) are rational sequences, and lim a_n = a, lim b_n = b, show that: lim(a_n+b_n) = a+b, and lim(a_n b_n) = ab. 3..
|
|
What effect does immigration have on wages
: What effect does immigration have on wages and does immigration help or hurt a country's output and What are the advantages of immigration?
|
|
How would you compare arun and coyote
: How would you compare Arun. and Coyote (from the Dine bahane. in the Native American unit)? How are they similar and different? Is their significance in their respecti.
|
|
An extra hr of production time or an extra lb of paper.
: You are to solve Problem 30 in Chapter 4 on page 158 of your textbook. It's about publishing three weekly magazines. You can use QM for Windows to perform a sensitivity analysis for Objective function coefficients and the RHS values of the constraint..
|
|
A mailman has special delivery mail for 10 customers
: A mailman has special delivery mail for 10 customers. In how many ways can he arrange his schedule to deliver to all 10?
|
|
Role of financial management in a firm
: Summarize the role of management as it relates to finance in a corporation. In your post, address the following:
|
|
Financial management challenges and ethics
: Find at least two articles from the Ashford University Library that highlight and discuss two of the biggest challenges facing financial managers today.
|
|
Present and future values and expected returns
: Assume interest rates for bonds today is 5% for an AAA rated bond. Calculate the price of the bond you have selected relative to the 5%. Is the bond selling at a premium or a discount? Why? Be sure to show how you arrived at your answer. What oth..
|