The LP relationships that follow were formulated by Richard Martin at the Long Beach Chemical Company. Maximize 4X1+12X1X2+5X3 Subject to: 2X1X2+2X3≤70 (C1) 10.9X1−4X2≥15.6 (C2) 10X1+3X2+3X3≥21 (C3) 16X2−13X3=17 (C4) −4X1−X2+4X3=5 (C5) 7X1+2X2+3X3≤80 (C6) For an LP, the objective function developed by Richard is (valid or onvalid) . Constraint C1 is a(n) (valid or onvalid) LP constraint. Constraint C2 is a(n) (valid or onvalid) LP constraint. Constraint C3 is a(n) (valid or onvalid) LP constra
Q: A "What-If" analysis: A department store sells two popular models of wireless headphones, model A…
A: As per the given information, the excel formulas will be as follows.
Q: Tom's, Inc., produces various Mexican food products and sells them to Western Foods, a chain of…
A: Range for constraint is that range for which the optimal solution stays same and does not change…
Q: Ruth Jones, the marketing manager for a department store chain is trying to decide on the optimal…
A: Brand equity is the stock of a brand's recognition and impressions that stakeholders, particularly…
Q: Use implicit enumeration to solve the following Integer Programing Model. min Z = 4x₁ - 8x₂ + 5x3 +…
A: Implicit enumeration: Implicit enumeration is based on the fact that each variable must equal 0 or 1…
Q: The government is auctioning off oil leases at two sites. At each site, 150,000 acres of land are to…
A: Land for auctioning = 150,000 acres Also, no bidder can receive more than 45% of the land being…
Q: The following table shows the average production costs per bushel of corn in five different sizes of…
A: Capacity utilization rate: - Capacity utilization rate is a metric that is utilized to process the…
Q: Dorian Auto manufactures luxury cars and trucks. The company believes that its most likely customers…
A: By locating the greatest or minimum point of intersection seen between the goal function line and,…
Q: Titebond blends Methanol and Toluene to produce two types of wood glues. Glue 1 must be at least 70%…
A: Here, I have considered that all glue produced could be sold, as per the question I would formulate…
Q: The input-output curve of a gas-fired generating unit is approximated by the following function: 4.2…
A: Input-output curve function: H(P)=120+9.3P+0.0025P2 MJ/h Minimum output = 200 MW Maximum output =…
Q: A farmer has 500 acres of available land and $100,000 to spend. He wants to plant the combination of…
A: Objective Functions and Constraints: Based on the given details, the objective…
Q: Make a planning model for this question. A bank issues several financial products at the beginning…
A: Note: The model is planned based on several rough estimates. Values proposed are just for…
Q: Formulate a linear programming model for this problem.
A: Linear programming is used to developed2 the relationship between objective of an organization and…
Q: An investment manager is considering stocks X1, X2, and X3 for investment. Market research shows the…
A: The question is related to the Linear Programming and is related to formulation.
Q: A manufacturing company makes two products (denoted as X and Y) through two ma- chines (denoted as A…
A: (1) maximize X + Y subject to 50 X + 24 Y <= 40 hours x 60 minutes per hour 30X +…
Q: Toby’s Trucking Company determined that the distance travelled per truck per year is normally…
A: Proportion is the amount or figure which is in between and mixes of the variables. Here in this…
Q: The USA Feeds, Inc. produces specially blended feed supplements. It has an order of 400 pounds of…
A:
Q: These are Hiwot and Durex. Hiwot requires 9 minutes to assemble and 2 minutes to package. While…
A: Let, x1 be the number of units of Hiwot tractors x2 be the number of units of Durex tractors
Q: Bhavika Investments, a group of financial advisors and retirement planners, is providing advice on…
A: Let, S = dollars invested in the stock fund M= dollars invested in money market fund
Q: Vladimir Ulanowsky is playing Keith Smithson in atwo-game chess match. Winning a game scores 1 match…
A:
Q: Tom's, Inc., produces various Mexican food products and sells them to Western Foods, New Mexico.…
A: Objective Functions and Constraints: Based on the given details, the objective…
Q: 7-37 Bbavika Investments, a group of financial advisors and retirement planners, is providing advice…
A: Decision Variable: Let, S be the dollars invested in the stock market M be the dollars invested in…
Q: A firm is planning to spend $75,000 on advertising. It costs $3000 per minute to advertise on…
A:
Q: A company produces 2 (two) 3(three) components (1,2,3). The company wants to determine the optimal…
A: Given,
Q: a wine maker has a stock of three different wines with the following characteristics Wine…
A: ANSWER IS AS FOLLOWS:
Q: Ajloun Manufacturing Company makes three products in a single factory. These products have the…
A:
Q: The table below shows information about the number of customers (in thousand) of a coffee shop per…
A: Find the Given details below: Given details: Year Quarters 1 2 3 4 2018 1.2 0.9 0.7 1.8…
Q: Bags & Box Cereals produces two types of cereals: basic and premium. Each type is sold in box of 100…
A: Given Information: About box of 100 grams 4 machines can package 200,000 boxes which means that,…
Q: :A couple wants to invest up to $20000. They can purchase a type A bond yielding 8% return and a…
A:
Q: Formulate and solve the following linear program: You are trying to create a budget to optimize the…
A: Maximize Z = 2F + 3S + 5E subject to F + S + E <= 1500 F + S <= 1100 S <= 800 E…
Q: • Formulate the problem of deciding how much of each product to make in the current week as a linear…
A: The linear programming method is a mathematical method by which the best outcome where profits are…
Q: Solve this problem in three ways; 1. Graphical 2. Excel solver 3. Sensitivity analysis/ report. a)…
A: Note: - Since we can only answer only up to three subparts and also it is not specified which…
Q: A shoe company forecasts the following demands during the next six months: month 1-200; month 2-260;…
A: Assume a shoe organization supplies sets of shoes in the coming a half year with standard time work…
Q: An investment company manages portfolios of stocks, bonds, and other investment alternatives. One of…
A: AS PART ONE IS ALREADY SOLVED. I AM JUMPING DIRECTLY TO QUESTION 2. Now we solve the above problem…
Q: Consider the Answer and Sensitivity Reports at the end of the questionnaire to answer the following…
A: What are the constraint quantity values? Referring the constraints table in the sensitivity report:…
Q: A motion picture industry analyst is studying movies based on epic novels. The following data were…
A: Regression analysis is a type of prescient displaying method which explores the connection between a…
Q: Dell computers Company is promoting to its products with 3 types of advertisements (Billboards,…
A: Given data: Types of advertisements=3 Dell company wants to have at least ≥5 ads/day Dell company…
Q: A company blends nitrogen and phosphorous to produce two types of fertilizers. Fertilizer 1 must be…
A: Let Xn1 be the amount in pounds of nitrogen used in fertilizer 1 and Xn2 be the amount in pounds of…
Q: An Air force is experimenting with three types of bombs P, Q and R in which three kinds of…
A: P = Explosion from bomb P Q = Explosion from bomb Q R = Explosion from bomb R
Q: race winner was awarded3 bonus points. But, the maximum number of points a driver could earn in any…
A:
Q: Investment Advisors, Inc., is a brokerage firm that manages stock portfolios for a number of…
A: Since we only answer up to 3 sub-parts, we’ll answer the first 3. Please resubmit the question and…
Q: A producer is currently selling three different brands (Brand A, Brand B, and Brand C) of fountain…
A: The given data is shown in a tabular form. Per unit data Brand A Brand B Brand C…
Q: A company is considering two insurance plans with the following types of coverage and premiums: Plan…
A: Linear programming toll is the which takes into consideration certain linear relationships to obtain…
Q: Solve by the Big M – method: Maximize Ζ= x1 + 2x2 −3x3 + x4…
A:
Q: Three types of gasoline are manufactured by a company – Regular, Super, and Extra. Regular should…
A: [Note: all percentages are expressed as decimal - 10% = 0.1, 11% = 0.11 etc.] 1000 barrels of…
Q: A gas company owns two refineries, 32 LPG bottling plants, and 367 retail outlets. The company has…
A: Performance management is a tool that enables the evaluation of the quality and efficiency of the…
Q: The values of the same 15 student in two subject A and B are given below the two numbers within the…
A: Rx Ry d=Rx-Ry d^2 1 10 -9 81 2 7 -5 25 3 2 1 1 4 6 -2 4 5 4 1 1 6 8 -2 4 7 3 4 16 8…
Q: he captain of a cricket team has to allot five middle batting positions to five batsmen. The average…
A: given,
Maximize
|
4X1+12X1X2+5X3
|
|
|
Subject to:
|
2X1X2+2X3≤70
|
(C1)
|
|
|
10.9X1−4X2≥15.6
|
(C2)
|
|
|
10X1+3X2+3X3≥21
|
(C3)
|
|
|
16X2−13X3=17
|
(C4)
|
|
|
−4X1−X2+4X3=5
|
(C5)
|
|
|
7X1+2X2+3X3≤80
|
(C6)
|
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
- Suppose that a regional express delivery service company wants to estimate the cost of shipping a package (Y) as a function of cargo type, where cargo type includes the following possibilities: fragile, semifragile, and durable. Costs for 15 randomly chosen packages of approximately the same weight and same distance shipped, but of different cargo types, are provided in the file P13_16.xlsx. a. Estimate a regression equation using the given sample data, and interpret the estimated regression coefficients. b. According to the estimated regression equation, which cargo type is the most costly to ship? Which cargo type is the least costly to ship? c. How well does the estimated equation fit the given sample data? How might the fit be improved? d. Given the estimated regression equation, predict the cost of shipping a package with semifragile cargo.An automobile manufacturer is considering whether to introduce a new model called the Racer. The profitability of the Racer depends on the following factors: The fixed cost of developing the Racer is triangularly distributed with parameters 3, 4, and 5, all in billions. Year 1 sales are normally distributed with mean 200,000 and standard deviation 50,000. Year 2 sales are normally distributed with mean equal to actual year 1 sales and standard deviation 50,000. Year 3 sales are normally distributed with mean equal to actual year 2 sales and standard deviation 50,000. The selling price in year 1 is 25,000. The year 2 selling price will be 1.05[year 1 price + 50 (% diff1)] where % diff1 is the number of percentage points by which actual year 1 sales differ from expected year 1 sales. The 1.05 factor accounts for inflation. For example, if the year 1 sales figure is 180,000, which is 10 percentage points below the expected year 1 sales, then the year 2 price will be 1.05[25,000 + 50( 10)] = 25,725. Similarly, the year 3 price will be 1.05[year 2 price + 50(% diff2)] where % diff2 is the percentage by which actual year 2 sales differ from expected year 2 sales. The variable cost in year 1 is triangularly distributed with parameters 10,000, 12,000, and 15,000, and it is assumed to increase by 5% each year. Your goal is to estimate the NPV of the new car during its first three years. Assume that the company is able to produce exactly as many cars as it can sell. Also, assume that cash flows are discounted at 10%. Simulate 1000 trials to estimate the mean and standard deviation of the NPV for the first three years of sales. Also, determine an interval such that you are 95% certain that the NPV of the Racer during its first three years of operation will be within this interval.Based on Babich (1992). Suppose that each week each of 300 families buys a gallon of orange juice from company A, B, or C. Let pA denote the probability that a gallon produced by company A is of unsatisfactory quality, and define pB and pC similarly for companies B and C. If the last gallon of juice purchased by a family is satisfactory, the next week they will purchase a gallon of juice from the same company. If the last gallon of juice purchased by a family is not satisfactory, the family will purchase a gallon from a competitor. Consider a week in which A families have purchased juice A, B families have purchased juice B, and C families have purchased juice C. Assume that families that switch brands during a period are allocated to the remaining brands in a manner that is proportional to the current market shares of the other brands. For example, if a customer switches from brand A, there is probability B/(B + C) that he will switch to brand B and probability C/(B + C) that he will switch to brand C. Suppose that the market is currently divided equally: 10,000 families for each of the three brands. a. After a year, what will the market share for each firm be? Assume pA = 0.10, pB = 0.15, and pC = 0.20. (Hint: You will need to use the RISKBINOMLAL function to see how many people switch from A and then use the RISKBENOMIAL function again to see how many switch from A to B and from A to C. However, if your model requires more RISKBINOMIAL functions than the number allowed in the academic version of @RISK, remember that you can instead use the BENOM.INV (or the old CRITBENOM) function to generate binomially distributed random numbers. This takes the form =BINOM.INV (ntrials, psuccess, RAND()).) b. Suppose a 1% increase in market share is worth 10,000 per week to company A. Company A believes that for a cost of 1 million per year it can cut the percentage of unsatisfactory juice cartons in half. Is this worthwhile? (Use the same values of pA, pB, and pC as in part a.)
- Stock market analysts are continually looking for reliable predictors of stock prices. Consider the problem of modeling the price per share of electric utility stocks (Y). Two variables thought to influence this stock price are return on average equity (X1) and annual dividend rate (X2). The stock price, returns on equity, and dividend rates on a randomly selected day for 16 electric utility stocks are provided in the file P13_15.xlsx. Estimate a multiple regression equation using the given data. Interpret each of the estimated regression coefficients. Also, interpret the standard error of estimate and the R-square value for these data.Dilberts Department Store is trying to determine how many Hanson T-shirts to order. Currently the shirts are sold for 21, but at later dates the shirts will be offered at a 10% discount, then a 20% discount, then a 40% discount, then a 50% discount, and finally a 60% discount. Demand at the full price of 21 is believed to be normally distributed with mean 1800 and standard deviation 360. Demand at various discounts is assumed to be a multiple of full-price demand. These multiples, for discounts of 10%, 20%, 40%, 50%, and 60% are, respectively, 0.4, 0.7, 1.1, 2, and 50. For example, if full-price demand is 2500, then at a 10% discount customers would be willing to buy 1000 T-shirts. The unit cost of purchasing T-shirts depends on the number of T-shirts ordered, as shown in the file P10_36.xlsx. Use simulation to determine how many T-shirts the company should order. Model the problem so that the company first orders some quantity of T-shirts, then discounts deeper and deeper, as necessary, to sell all of the shirts.The management of a technology company is trying to determine the variable that best explains the variation of employee salaries using a sample of 52 full-time employees; see the file P13_08.xlsx. Estimate simple linear regression equations to identify which of the following has the strongest linear relationship with annual salary: the employees gender, age, number of years of relevant work experience prior to employment at the company, number of years of employment at the company, or number of years of post secondary education. Provide support for your conclusion.
- Play Things is developing a new Lady Gaga doll. The company has made the following assumptions: The doll will sell for a random number of years from 1 to 10. Each of these 10 possibilities is equally likely. At the beginning of year 1, the potential market for the doll is two million. The potential market grows by an average of 4% per year. The company is 95% sure that the growth in the potential market during any year will be between 2.5% and 5.5%. It uses a normal distribution to model this. The company believes its share of the potential market during year 1 will be at worst 30%, most likely 50%, and at best 60%. It uses a triangular distribution to model this. The variable cost of producing a doll during year 1 has a triangular distribution with parameters 15, 17, and 20. The current selling price is 45. Each year, the variable cost of producing the doll will increase by an amount that is triangularly distributed with parameters 2.5%, 3%, and 3.5%. You can assume that once this change is generated, it will be the same for each year. You can also assume that the company will change its selling price by the same percentage each year. The fixed cost of developing the doll (which is incurred right away, at time 0) has a triangular distribution with parameters 5 million, 7.5 million, and 12 million. Right now there is one competitor in the market. During each year that begins with four or fewer competitors, there is a 25% chance that a new competitor will enter the market. Year t sales (for t 1) are determined as follows. Suppose that at the end of year t 1, n competitors are present (including Play Things). Then during year t, a fraction 0.9 0.1n of the company's loyal customers (last year's purchasers) will buy a doll from Play Things this year, and a fraction 0.2 0.04n of customers currently in the market ho did not purchase a doll last year will purchase a doll from Play Things this year. Adding these two provides the mean sales for this year. Then the actual sales this year is normally distributed with this mean and standard deviation equal to 7.5% of the mean. a. Use @RISK to estimate the expected NPV of this project. b. Use the percentiles in @ RISKs output to find an interval such that you are 95% certain that the companys actual NPV will be within this interval.An antique collector believes that the price received for a particular item increases with its age and with the number of bidders. The file P13_14.xlsx contains data on these three variables for 32 recently auctioned comparable items. Estimate a multiple regression equation using the given data. Interpret each of the estimated regression coefficients. Is the antique collector correct in believing that the price received for the item increases with its age and with the number of bidders? Interpret the standard error of estimate and the R-square value for these data.Suppose you have invested 25% of your portfolio in four different stocks. The mean and standard deviation of the annual return on each stock are shown in the file P11_46.xlsx. The correlations between the annual returns on the four stocks are also shown in this file. a. What is the probability that your portfolios annual return will exceed 30%? b. What is the probability that your portfolio will lose money during the year?
- The annual demand for Prizdol, a prescription drug manufactured and marketed by the NuFeel Company, is normally distributed with mean 50,000 and standard deviation 12,000. Assume that demand during each of the next 10 years is an independent random number from this distribution. NuFeel needs to determine how large a Prizdol plant to build to maximize its expected profit over the next 10 years. If the company builds a plant that can produce x units of Prizdol per year, it will cost 16 for each of these x units. NuFeel will produce only the amount demanded each year, and each unit of Prizdol produced will sell for 3.70. Each unit of Prizdol produced incurs a variable production cost of 0.20. It costs 0.40 per year to operate a unit of capacity. a. Among the capacity levels of 30,000, 35,000, 40,000, 45,000, 50,000, 55,000, and 60,000 units per year, which level maximizes expected profit? Use simulation to answer this question. b. Using the capacity from your answer to part a, NuFeel can be 95% certain that actual profit for the 10-year period will be between what two values?A careful analysis of the cost of operating an automobile was conducted by accounting manager Dia Bandaly. The following model was developed: y = 3,600+ 0.16x, where y is the annual cost and x is the miles driven. a) If the car is driven 15,000 miles this year, the forecasted cost of operating this automobile = $ b) If the car is driven 26,000 miles this year, the forecasted cost of operating this automobile = $ (enter your response as a whole number). (enter your response as a whole number).The manager wants to forecast the month 6's sales using the following historical data: Months Month 1 Month 2 Month 3 Month 4 Month 5 Sales 20 25 32 35 38 Please use the weight 0.45 for Month 5, weight 0.25 for Month 4, weight 0.2 for Month 3, and weight 0.1 for Month 2 to use the weighted moving average to forecast the demand of Month 6. Month 5 = 0.1*(25) +0.2*(32) + .25* (35) divided by 0.1 +0.2 +1.25 -17.65/0.55 = 32.09 Month 6= 0.1* (25) +0.2* (32) +0.25 (35) +0.45* (38) divided by 0.1 +0.2+0.45 = 34.75