Solve the following linear programming problem using simplex method. A printing company makes three grades of wall posters. The better-quality posters sell for Rs. 2.50, intermediate quality for Rs.2.00 and the poorer quality poster for Rs. 1.50. Paper costs Rs. 0.75 for each of the better-quality posters and Rs.0.50 and Rs. 0.25 for each intimidates and poorer quality poster respectively. Because of poor quality paper, the less expensive posters require two minutes of printing time while the other two require 1 minute of printing time only. The department is allocated Rs.150 per day for paper. There are 480 minutes of printing time available daily and each minute that is used to estimate to cost the company Rs. 0.25. In addition, the department incurs a fixed daily cost of Rs. 125, which are not affected by the quantity and quality of papers produced. You are asked to suggest as to how much each type of posters is to produce in order to maximize daily profit?

Solve the following linear programming problem using simplex method. A printing company makes three grades of wall posters. The better-quality posters sell for Rs. 2.50, intermediate quality for Rs.2.00 and the poorer quality poster for Rs. 1.50. Paper costs Rs. 0.75 for each of the better-quality posters and Rs.0.50 and Rs. 0.25 for each intimidates and poorer quality poster respectively. Because of poor quality paper, the less expensive posters require two minutes of printing time while the other two require 1 minute of printing time only. The department is allocated Rs.150 per day for paper. There are 480 minutes of printing time available daily and each minute that is used to estimate to cost the company Rs. 0.25. In addition, the department incurs a fixed daily cost of Rs. 125, which are not affected by the quantity and quality of papers produced. You are asked to suggest as to how much each type of posters is to produce in order to maximize daily profit?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 35P

See similar textbooks

Similar questions

Six months before its annual convention, the American Medical Association must determine how many rooms to reserve. At this time, the AMA can reserve rooms at a cost of 150 per room. The AMA believes the number of doctors attending the convention will be normally distributed with a mean of 5000 and a standard deviation of 1000. If the number of people attending the convention exceeds the number of rooms reserved, extra rooms must be reserved at a cost of 250 per room. a. Use simulation with @RISK to determine the number of rooms that should be reserved to minimize the expected cost to the AMA. Try possible values from 4100 to 4900 in increments of 100. b. Redo part a for the case where the number attending has a triangular distribution with minimum value 2000, maximum value 7000, and most likely value 5000. Does this change the substantive results from part a?
It costs a pharmaceutical company 75,000 to produce a 1000-pound batch of a drug. The average yield from a batch is unknown but the best case is 90% yield (that is, 900 pounds of good drug will be produced), the most likely case is 85% yield, and the worst case is 70% yield. The annual demand for the drug is unknown, with the best case being 20,000 pounds, the most likely case 17,500 pounds, and the worst case 10,000 pounds. The drug sells for 125 per pound and leftover amounts of the drug can be sold for 30 per pound. To maximize annual expected profit, how many batches of the drug should the company produce? You can assume that it will produce the batches only once, before demand for the drug is known.
Barbara Flynn sells papers at a newspaper stand for $0.40. The papers cost her $0.30, giving her a $0.10 profit on each one she sells. From past experience Barbara knows that: a) 20% of the time she sells 150 papers. b) 20% of the time she sells 200 papers. c) 30% of the time she sells 250 papers. d) 30% of the time she sells 300 papers. Assuming that Barbara believes the cost of a lost sale to be $0.05 and any unsold papers cost her $0.30 and she orders 250 papers. Use the following random numbers: 14, 4, 13, 9, and 25 for simulating Barbara's profit. (Note: Assume the random number interval begins at 01 and ends at 00.) Based on the given probability distribution and the order size, for the given random number Barbara's sales and profit are (enter your responses for sales as integers and round all profit responses to two decimal places): Random Number Sales Profit 14 4 13 9 25
A home improvement store sells hydrangea plants during the spring planting season. The hydrangeas cost the store $15 per unit, and sell to customers for $45, but any leftovers at the end of the season are salvaged to a local landscaper for $7/unit. A competitor has advertised that it guarantees 99% of customers find the product they’re looking for in stock. The competitor’s posted price for hydrangeas is $50, and they salvage to the same local landscaper for $7/ hydrangea plant. If the competitor’s advertised service level is correct for hydrangeas and they follow an optimal stocking policy, what does it imply their cost per hydrangea is?
A purchasing agent for a particular type of silicon wafer used in the production ofsemiconductors must decide among three sources. Source A will sell the siliconwafers for $2.50 per wafer, independently of the number of wafers ordered. Source Bwill sell the wafers for $2.40 each but will not consider an order for fewer than3,000 wafers, and Source C will sell the wafers for $2.30 each but will not acceptan order for fewer than 4,000 wafers. Assume an order setup cost of $100 and anannual requirement of 20,000 wafers. Assume a 20 percent annual interest rate forholding cost calculations.a. Which source should be used, and what is the size of the standing order?
A purchasing agent for a particular type of silicon wafer used in the production ofsemiconductors must decide among three sources. Source A will sell the siliconwafers for $2.50 per wafer, independently of the number of wafers ordered. Source Bwill sell the wafers for $2.40 each but will not consider an order for fewer than3,000 wafers, and Source C will sell the wafers for $2.30 each but will not acceptan order for fewer than 4,000 wafers. Assume an order setup cost of $100 and anannual requirement of 20,000 wafers. Assume a 20 percent annual interest rate forholding cost calculations.b. What is the optimal value of the holding and setup costs for wafers when theoptimal source is used?
Rajan wanted a radio from Jacky's. It appears that Rajan is particularly interested in purchasing a Radio from the inexpensive retailer's sales manager for consumer electronics. He tells Jacky, the salesperson at the inexpensive store where he thinks he'll get the best deal, that his old radio died and he wants to listen to his favourite tunes. He wants a replacement radio as quickly as possible. In three and a half weeks, Rajan's favourite model will be 10% off.He suspects Rajan won't wait and will find another job. Jacky will earn less on the lowered price. He thinks that telling Rajan of the sale makes little sense.When Jacky tells Rajan that the radio set he wants is no longer available and won't be for another week, Rajan is enraged. Fearing losing the business, Jacky begs his sales manager, Michelle, to speed up delivery. Michelle says it's impossible and suggests Jacky tell Rajan the store can get the set in 24 hours and sell him the demo model. Michelle says the sample is new…
ABC Corporation has recently given out a nine-month contract to a construction subcontractor. At the end of the first month, it becomes obvious that the subcontractor is not reporting costs according to an appropriate WBS level. ABC Corporation asks the subcontractor to change its cost reporting procedures. The subcontractor states that this cannot be done without additional funding. This problem has occurred with other subcontractors as well. What can ABC Corporation do about this?
Irwin’s sells a particular model of fan, with most of the sales being made in thesummer months. Irwin’s makes a one-time purchase of the fans prior to eachsummer season at a cost of $40 each and sells each fan for $60. Any fans unsoldat the end of the summer season are marked down to $29 and sold in a special fallsale. Virtually all marked-down fans are sold. The following is the number of salesof fans during the past 10 summers: 30, 50, 30, 60, 10, 40, 30, 30, 20, 40.a. Estimate the mean and the variance of the demand for fans each summer.b. Assume that the demand for fans each summer follows a normal distribution,with mean and variance given by what you obtained in part (a). Determine theoptimal number of fans for Irwin’s to buy prior to each summer season.c. Based on the observed 10 values of the prior demand, construct an empiricalprobability distribution of summer demand and determine the optimal numberof fans for Irwin’s to buy based on the empirical distribution.d. Based on your…
3. Gursoy is selling Christmas trees. She purchases trees for $10 and sells for $25 each. The number of trees she can sell is normally distributed with a mean of 100 and standard deviation of 30. How many trees should Gursoy purchase?
A young computer engineer has $12,000 to invest and three different investment options (funds) to choose from. Type 1 guaranteed investment funds offer an expected rate of return of 7%, Type 2 mixed funds (part is guaranteed capital) have an expected rate of return of 8%, while an investment on the Stock Exchange involves an expected rate of return of 12%, but without guaranteed investment capital. Computer engineer has decided not to invest more than $2,000 on the Stock Exchange in order to minimize the risk. Moreover for tax reasons, she needs to invest at least three times more in guaranteed investment funds than in mixed funds. Assume that at the end of the year the returns are those expected; she is trying to determine the optimum investment amounts. (a) Express this problem as a linear programming model with two decision variables.(b) Solve the problem with the graphical solution procedure and define the optimum solution.
Martin owns an older home, which requires minor renovations. However, the neighborhood where Martin lives mostly includes newly constructed luxury homes. Why might Martin's home increase in value? Based on the principle of substitution, the value of Martin's house will equal the value of the newly constructed homes in the neighborhood. ○ The value of Martin's home will decrease due to the new competition in the neighborhood. Based on the principle of regression, the newly constructed homes in the neighborhood will increase the home values of the entire neighborhood. Based on the principle of progression, the newly constructed homes in the neighborhood will increase the home values of the entire neighborhood.