Variable cells Cell Name Final Value Reduced Cost Objective Coefficient Allowable Increase Allowable Decrease $B$6 Activity 1 3 0 30 23 17 $C$6 Activity 2 6 0 40 50 10 $D$6 Activity 3 0 –7 20 7 1E+30 Constraints Cell Name Final Value Shadow Price Constraint R.H. Side Allowable Increase Allowable Decrease $E$2 Resource A 20 7.78 20 10 12.5 $E$3 Resource B 30 6 30 50 10 $E$4 Resource C 18 0 40 1E+30 22 If the right-hand side of Resource A changes to 10, then the objective function value: Multiple Choice will decrease by $12.50. will decrease by $125. will decrease by $77.80. will remain the same. can only be discovered by resolving the problem.

Variable cells Cell Name Final Value Reduced Cost Objective Coefficient Allowable Increase Allowable Decrease $B$6 Activity 1 3 0 30 23 17 $C$6 Activity 2 6 0 40 50 10 $D$6 Activity 3 0 –7 20 7 1E+30 Constraints Cell Name Final Value Shadow Price Constraint R.H. Side Allowable Increase Allowable Decrease $E$2 Resource A 20 7.78 20 10 12.5 $E$3 Resource B 30 6 30 50 10 $E$4 Resource C 18 0 40 1E+30 22 If the right-hand side of Resource A changes to 10, then the objective function value: Multiple Choice will decrease by $12.50. will decrease by $125. will decrease by $77.80. will remain the same. can only be discovered by resolving the problem.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 30P: A company manufacturers a product in the United States and sells it in England. The unit cost of...

See similar textbooks

Similar questions

In Example 11.1, the possible profits vary from negative to positive for each of the 10 possible bids examined. a. For each of these, use @RISKs RISKTARGET function to find the probability that Millers profit is positive. Do you believe these results should have any bearing on Millers choice of bid? b. Use @RISKs RISKPERCENTILE function to find the 10th percentile for each of these bids. Can you explain why the percentiles have the values you obtain?
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.
A company manufacturers a product in the United States and sells it in England. The unit cost of manufacturing is 50. The current exchange rate (dollars per pound) is 1.221. The demand function, which indicates how many units the company can sell in England as a function of price (in pounds) is of the power type, with constant 27556759 and exponent 2.4. a. Develop a model for the companys profit (in dollars) as a function of the price it charges (in pounds). Then use a data table to find the profit-maximizing price to the nearest pound. b. If the exchange rate varies from its current value, does the profit-maximizing price increase or decrease? Does the maximum profit increase or decrease?
When you use a RISKSIMTABLE function for a decision variable, such as the order quantity in the Walton model, explain how this provides a fair comparison across the different values tested.
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.
Integrated Products Corporation (IPC) needs to estimate its PC sales for next year.The most recent six years of revenue data for the company’s line of XT PersonalComputers, and those of the industry, is found in the table below:Year XT PC Sales Revenue($’000,000)All Industry PC Sales Revenue($’000,000,000)1 2.4 4.62 5.9 8.63 15.5 10.74 27.8 14.85 35.9 18.56 38.1 19.4Required:A. Assuming that the sales data above are representative of sales expected nextyear, use time series regression analysis to forecast next year’s sales revenues(there is no seasonal effect).B. Perform a regression analysis between the annual sales revenues of XTPersonal Computers and all industry PC annual sales revenues. What is theforecast for next year’s sales revenue for XT Personal Computers if the estimateof next year’s industry PC sales revenues is $21.9 billion? C. Advise management at Integrated Products Corporation (IPC) which of the twosales estimates from parts A and B above they should use. Justify your…
Integrated Products Corporation (IPC) needs to estimate its PC sales for next year.The most recent six years of revenue data for the company’s line of XT PersonalComputers, and those of the industry, is found in the table below:Year XT PC Sales Revenue($’000,000)All Industry PC Sales Revenue($’000,000,000)1 2.4 4.62 5.9 8.63 15.5 10.74 27.8 14.85 35.9 18.56 38.1 19.4Required:A. Assuming that the sales data above are representative of sales expected nextyear, use time series regression analysis to forecast next year’s sales revenues(there is no seasonal effect).B. Perform a regression analysis between the annual sales revenues of XTPersonal Computers and all industry PC annual sales revenues. What is theforecast for next year’s sales revenue for XT Personal Computers if the estimateof next year’s industry PC sales revenues is $21.9 billion?
In 2020, a manufacturing company instituted a total quality management (TQM) program producingthe comparative report shown below:[LO 17-5]Summary COQ Report(in thousands)2019 2020 % ChangePrevention costs $ 200 $ 300 +50Appraisal costs 210 315 +50Internal failure costs 190 114 −40External failure costs 1,200 621 −48Total COQ $1,800 $1,350 −25On the basis of this report, which one of the following statements is most likely correct?a. An increase in conformance costs resulted in a higher-quality product and, therefore, a decreasein nonconformance costs.b. An increase in inspection costs was solely responsible for the decrease in quality costs.c. Quality costs such as scrap and rework decreased by 48%.d. Quality costs such as returns and repairs under warranty decreased by 40%.e. Nonconformance costs increased by 50% and conformance costs decreased by approximately 47%.
SOLVE IN EXCEL AND PROVIDE SENSITIVITY REPORT PLEASE SHOW ALL FORMULA IN EXCEL A company blends nitrogen and phosphorous to produce two types of fertilizers. Fertilizer 1 must be at least 50% nitrogen and sells for $55 per pound. Fertilizer 2 must be at least 55% phosphorous and sells for $45 per pound. The company can purchase up to 9000 pounds of nitrogen at $20 per pound and up to 12,000 pounds of phosphorous at $12 per pound. Assuming that all fertilizer produced can be sold, determine the optimal blending plan for the company. What is the maximum profit? Suppose the company could acquire 1,000 pounds more of either nitrogen or phosphorous. Which should it choose? What would be the resulting impact on profit?
#17FAVORABLE UNFAVORABLEMARKET MARKETEQUIPMENT ( $) ($)Sub 100 300,000 –200,000Oiler J 250,000 –100,000Texan 75,000 –18,000For example, if Ken purchases a Sub 100 and ifthere is a favorable market, he will realize a profitof $300,000. On the other hand, if the market is unfavorable, Ken will suffer a loss of $200,000. ButKen has always been a very optimistic decisionmaker.(a) What type of decision is Ken facing?(b) What decision criterion should he use?(c) What alternative is best? #18Although Ken Brown (discussed in Problem 3-17) is the principal owner of Brown Oil, his brother Bob iscredited with making the company a financial success. Bob is vice president of finance. Bob attributeshis success to his pessimistic attitude about business and the oil industry. Given the information fromProblem 3-17, it is likely that Bob will arrive at a different decision. What decision criterion should Bobuse, and what alternative…
Hi is this correct?The management of an oil company is trying to decide whether to drill for oil in a particular fieldin the Gulf of Mexico. It costs the company $600 thousand to drill in the selected field. Themanagement believes that if oil is found in this field, its estimated value will be $3400 thousand. Atpresent, this oil company believes that there is a 45% chance that the selected field actually containsoil. Before drilling, the oil company can hire a team of geologists to perform seismographic tests at acost of $55 thousand. Based on similar tests in other fields, the tests have a 25% false negative rate(no oil predicted when oil is present) and a 15% false positive rate (oil predicted when no oil ispresent).A. Assume the oil company wants to maximize its expected net earnings. Please utilize decisiontree analysis to determine its optimal strategy.B. Calculate the expected value of the information (EVI/EVSI) provided by the team ofgeologists.C. Calculate and interpret EVPI…
Please show the steps by using the formula for each Salalah Methanol company management is considering three competing investment Projects Option1: Starting a unit in Sohar, Option 2: Starting a unit in Musandam and Option 3: Starting a unit in Muscat. The initialinvestment for all the projects are 11000 and the cost of capital is 4.05% Year Sohar Musandam Muscat 1 1100 2160 3225 2 3100 3260 4250 3 3800 4360 5475 4 4600 5460 6300 5 5100 6900 7000 Use the information below and help the management in choosing the most desirable Project using a. Payback period b. Discounted payback c. Net Present value d. Profitability Index. You have to suggest to the management which project to choose and why

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS

GET THE APP

About FAQ Academic Integrity Sitemap Document Sitemap

Contact Bartleby Contact Research (Essays)High School Textbooks Literature Guides Concept Explainers by Subject Essay Help Mobile App

GET THE APP

Privacy

Your CA Privacy Rights

Your NV Privacy Rights

About Ads

Manage My Data

bartleby, a Learneo, Inc. business

Cell	Name	Final Value	Reduced Cost	Objective Coefficient	Allowable Increase	Allowable Decrease
$B$6	Activity 1	3	0	30	23	17
$C$6	Activity 2	6	0	40	50	10
$D$6	Activity 3	0	–7	20	7	1E+30