Based on the following sensitivity report, what would be the change in the objective function value if the objective function coefficient for Product_2 increases to 14? Variable Cells Objective Coefficient Allowable Final Value Allowable Cell Name Reduced Cost Increase Decrease $B$2 $B$3 $B$4 Product 1 -2 12 1E+30 Product 2 Product_3 175 8 9 | 1 -1.5 1E+30 Constraints Final Shadow Price Constraint Allowable Allowable Cell Name Value R.H.Side Increase Decrease $H$9 Resource A 100 1E+30 100 SH$10 Resource B 525 800 1E+30 275 SH$11 ResourceC 700 1.75 700 366.6666667 700 (Round your answer to the nearest whole number.) Change in the objective function value
Q: CALCULATOR PRINTER VERSION 4 BACK NEX Problem 6.6 Patricia Zell, a dollmaker from Olney, Maryland,…
A: Break-even point = Fixed costcontibution per unit contribution per unit = selling price/unit -…
Q: Production and Materials Purchases Budgets White Corporation’s budget calls for the following sales…
A: The production and materials purchases budgets for the second quarter is as follows:
Q: Company A produces a product called Gen, which is a type of tyre The following is the information…
A: The detailed solution to the given question is given in Step 2.
Q: Q-7)for the LPP below: Max Z = 2X1+X2 S TO:X1+4X2 =2 2X1+2X2 > = 6 X1,X2 > = %3D %3D O The first…
A: Max Z = 2 x1 + x2 subject to x1 + 4 x2 = 2 2 x1 + 2 x2 ≥ 6 and…
Q: Refer to the following sensitivity report: Variable Cells Cell Name Final Value Reduced Cost…
A: Given Information: Variable Cells Cell Name Final Value Reduced Cost Objective…
Q: alternatives big average small large stock $22000…
A: Given that - Alternatives Big Average Small Large Stock $22,000 $12,000 -$2,000…
Q: Develop a production schedule to produce the exact production requirements by varying the workforce…
A:
Q: Steve's Scooer plans to sell it standard scooter for $500 and it chrome for $650. Steve purchases…
A: Weighted Average Contribution Margin per unit = (350x1 + 400 x 3) / 4 = $387.50 per unit 1. reach…
Q: Based on the following sensitivity report, how much should the firm be willing to pay for 76 more…
A: Below is the solution:-
Q: Drypers is one of the leading baby điaper brands in M diapers are proudly made in Malaysia by Vinda…
A: Given that: Pulp = 2070 Kg =2070000 grams SAP = 1007 Kg = 1007000 grams Adhesive Glue =66 Kg =66000…
Q: Based on the following sensitivity analysis, which of the following products would be considered…
A: Sensitivity analysis or study is a financial representation that defines how target variables are…
Q: Based on the following sensitivity report, what would be the impact of changing the objective…
A: The 100% rule expresses that the WBS incorporates 100% of the work characterized by the venture…
Q: B-1. Which is more desirable assuming data are COST Decertaine the course dagram. 90 60 (45) 45 99…
A: Given data: A consultant’s report indicates a 0.20 probability that demand will be low and 0.80…
Q: 6) Nicole has decided to go to school which costs her a total of P19,500 and give upi on a job that…
A: There are multiple different questions, as per Guideline, I have answered only first question.…
Q: EFE company manufactures and sells boats. The company's management accountant gathered the following…
A:
Q: Determine the board measure (BF) and the cost 2x4 = $1700 MBM MBM or FBM = Thousand Board Measure…
A: The board measures/board foot and the cost are computed as follows:
Q: The Gotham City News is moving to a paywall subscription service rather than a free news website…
A: Customer Lifetime Value refers to the total business value in terms of revenue can be generated from…
Q: Final Shadow Constraint Allowable Allowable Name Value Price R.H. Side Increase Decrease Protein 600…
A: The sensitive analysis in linear programming is an approach that shows the sensitivity of data due…
Q: Consider the sensitivity report below: CLO3 Variable Cells Final Reduced Objective Allowable…
A: A 'Sensitivity Report' describes how modifications in the coefficients of the objective function…
Q: . Mr. Mashabela operates a small novelty shop. Each morning he purchases a small quantity of daily…
A: Given data: For the past 200 days, The demand has been either 6, 7, 8, 9, 10. Therefore, the states…
Q: A leading manufacturer of video games is about to introduce four new games. The accompanying table…
A: The Break-even point occurs when the total cost and total revenue are even; the situation of no…
Q: One of your staff members developed the following excel optimal production plan. You must now review…
A: An optimal plan for the advancement of a monetary unit is drawn up based on the arrangement of an…
Q: Final Shadow Constraint Allowable Allowable Name Value Price RH. Side Increase Decrease Sum…
A: Supply Origins which has slack in Houston
Q: Sorin Incorporated, a company that produces and sells a single product, has provided its…
A: Contribution margin is the amount obtained by deducting the variable expenses attributable to a…
Q: c. From the following decision tree, develop a payoff table and calculate: * Maximax, Minimax…
A: The value for each of the payoffs and criteria are calculated in excel with the formulas shown in…
Q: Based on the following sensitivity report, what would be the change in the objective function value…
A: As per Brtleby guidelines, we can only solve one question at a time...Kindly upload the other…
Q: Develop a production schedule to produce the exact production requirements by varying the workforce…
A: Find the Given details below: Month January February March Total Forecasts 1020 1550 1220 3790
Q: The manufacturing costs of Calico Industries for three months of the year are provided below:…
A: ANSWER : Option : c) $0.36 per unit and $21,140
Q: If the objective function coefficient for Product_1 were decreased to a value of 3, which of the…
A: There is a sensitivity report given with allowable increase and decrease values for the objective…
Q: Define below mentioned structure table in your words and explain importance of path coefficient, T…
A: IMPORTANCE OF PATH COEFFICIENT1- It tells us the true nature of the cause and effect relationship.2-…
Q: Develop a production schedule to produce the exact production requirements by varying the workforce…
A: Given data is
Q: Fitzhugh Company has the following information available for the current year: Standard: 3.5 feet…
A: (a) Material purchase price variance = (Actual unit cost - standard unit cost) x Actual quantity…
Q: Mickey Limited is a manufacturing business that uses a standard costing system. The company’s flexed…
A: SALES Sales operation is the set of business activities that help a sales organization to run…
Q: Market Company’s policy is to have 30% of the next month's sales on hand at the end of the current…
A: Given- Month Projected Sales August 26,000 September 21,000 October 31,000
Q: Camille forecasts to sell 575 units of the perfume she is selling by the first week of December. At…
A: Since you have asked multiple questions, we will solve the first question for you. If you want any…
Q: Answer the following questions based on the following Sensitivity Report. Microsoft Excel…
A: 1) According to given sensitivity report, the profit of the watermelons per acre would drop by…
Q: Valencia Products makes automobile radar detectors and assembles two models: LaserStop and…
A: Given Information:
Q: Sycamore Plastics (SP) is a manufacturer of polyethylene plastic pellets used es a row material by…
A: Given data is
Q: What is the purpose of the SCOR Model and what are the five basic functions of the SCOR Model?
A: The supply chain operations reference model (SCOR) is an administration device used to address,…
Q: Variable cells Cell Name Final Value Reduced Cost Objective Coefficient Allowable Increase…
A: The allowable increase is infinity, so the highest it can go to is infinity.
Q: The optimum solution is: X = (round your response to two decimal places). Y = (round your…
A: The answer is as below:
Q: CVP Analysis with Income Taxes Cohen Company produces and sells socks. Variable cost is$6 per pair,…
A: Since we only answer up to 3 sub-parts, we’ll answer the first 3. Please resubmit the question…
Q: The objective of the Hot Oven is to find a balanced diet with minimum cost. a) Formulate a linear…
A: a) LP Formulation Minimize Cost Z = 0.5BB+2C+B+0.25BE+0.25S s.t. constraints -…
Q: 12
A: When the value of objective coefficient (OF) is changed from 1.95 to 2 the optimality range is not…
Q: b. Graph AVC, ATC and MC on the same graph. What is the relationship between the MC curve and the…
A: Part a has been already solved in question, so I'm helping u in parts b and c.
Q: Consider the LP problem in Figure QP2.5 and refer to the Solver sensitivity report in Figure QP2.6.…
A: Given- Sensitivity analysis report-
Q: GoodMed Drug Company produced an antibiotic that is supposed to treat several bacterial infections.…
A: CORPORATE SOCIAL RESPONSIBILITY: Corporate social responsibilities (CSR) refers to the social…
Q: David Austin recently purchased a chain of dry cleaners in northern Wisconsin. Although the business…
A: Given Fixed cost = $15,400Variable cost = $0.25 per shirtUnit price = $1.10 per shirt
Q: LP PROBLEM: Ozark Farms uses at least 800 lb. of special feed daily. The special feed is a mixture…
A: Given data is
Step by step
Solved in 2 steps
- Suppose that GLC earns a 2000 profit each time a person buys a car. We want to determine how the expected profit earned from a customer depends on the quality of GLCs cars. We assume a typical customer will purchase 10 cars during her lifetime. She will purchase a car now (year 1) and then purchase a car every five yearsduring year 6, year 11, and so on. For simplicity, we assume that Hundo is GLCs only competitor. We also assume that if the consumer is satisfied with the car she purchases, she will buy her next car from the same company, but if she is not satisfied, she will buy her next car from the other company. Hundo produces cars that satisfy 80% of its customers. Currently, GLC produces cars that also satisfy 80% of its customers. Consider a customer whose first car is a GLC car. If profits are discounted at 10% annually, use simulation to estimate the value of this customer to GLC. Also estimate the value of a customer to GLC if it can raise its customer satisfaction rating to 85%, to 90%, or to 95%. You can interpret the satisfaction value as the probability that a customer will not switch companies.Based on Grossman and Hart (1983). A salesperson for Fuller Brush has three options: (1) quit, (2) put forth a low level of effort, or (3) put forth a high level of effort. Suppose for simplicity that each salesperson will sell 0, 5000, or 50,000 worth of brushes. The probability of each sales amount depends on the effort level as described in the file P07_71.xlsx. If a salesperson is paid w dollars, he or she regards this as a benefit of w1/2 units. In addition, low effort costs the salesperson 0 benefit units, whereas high effort costs 50 benefit units. If a salesperson were to quit Fuller and work elsewhere, he or she could earn a benefit of 20 units. Fuller wants all salespeople to put forth a high level of effort. The question is how to minimize the cost of encouraging them to do so. The company cannot observe the level of effort put forth by a salesperson, but it can observe the size of his or her sales. Thus, the wage paid to the salesperson is completely determined by the size of the sale. This means that Fuller must determine w0, the wage paid for sales of 0; w5000, the wage paid for sales of 5000; and w50,000, the wage paid for sales of 50,000. These wages must be set so that the salespeople value the expected benefit from high effort more than quitting and more than low effort. Determine how to minimize the expected cost of ensuring that all salespeople put forth high effort. (This problem is an example of agency theory.)If a monopolist produces q units, she can charge 400 4q dollars per unit. The variable cost is 60 per unit. a. How can the monopolist maximize her profit? b. If the monopolist must pay a sales tax of 5% of the selling price per unit, will she increase or decrease production (relative to the situation with no sales tax)? c. Continuing part b, use SolverTable to see how a change in the sales tax affects the optimal solution. Let the sales tax vary from 0% to 8% in increments of 0.5%.
- 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.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.You want to take out a 450,000 loan on a 20-year mortgage with end-of-month payments. The annual rate of interest is 3%. Twenty years from now, you will need to make a 50,000 ending balloon payment. Because you expect your income to increase, you want to structure the loan so at the beginning of each year, your monthly payments increase by 2%. a. Determine the amount of each years monthly payment. You should use a lookup table to look up each years monthly payment and to look up the year based on the month (e.g., month 13 is year 2, etc.). b. Suppose payment each month is to be the same, and there is no balloon payment. Show that the monthly payment you can calculate from your spreadsheet matches the value given by the Excel PMT function PMT(0.03/12,240, 450000,0,0).
- The method for rating teams in Example 7.8 is based on actual and predicted point spreads. This method can be biased if some teams run up the score in a few games. An alternative possibility is to base the ratings only on wins and losses. For each game, you observe whether the home team wins. Then from the proposed ratings, you predict whether the home team will win. (You predict the home team will win if the home team advantage plus the home teams rating is greater than the visitor teams rating.) You want the ratings such that the number of predictions that match the actual outcomes is maximized. Try modeling this. Do you run into difficulties? (Remember that Solver doesnt like IF functions.) EXAMPLE 7.8 RATING NFL TEAMS9 We obtained the results of the 256 regular-season NFL games from the 2015 season (the 2016 season was still ongoing as we wrote this) and entered the data into a spreadsheet, shown at the bottom of Figure 7.38. See the file NFL Ratings Finished.xlsx. (Some of these results are hidden in Figure 7.38 to conserve space.) The teams are indexed 1 to 32, as shown at the top of the sheet. For example, team 1 is Arizona, team 2 is Atlanta, and so on. The first game entered (row 6) is team 19 New England versus team 25 Pittsburgh, played at New England. New England won the game by a score of 28 to 21, and the point spread (home team score minus visitor team score) is calculated in column J. A positive point spread in column J means that the home team won; a negative point spread indicates that the visiting team won. The goal is to determine a set of ratings for the 32 NFL teams that most accurately predicts the actual outcomes of the games played.Use the table below to answer the questions that follow and caculate the Expected Monetary Value(EMV) of the different outcomesDECISION TABLE WITH CONDITIONAL VALUESSTATE OF NATUREFAVORABLE OUTCOME UNFAVORABLE OUTCOMEALTERNATIVES ($) ($)Start a big Company 2,000,000 -500,000Start a small company 800,000 -200,000Build Nothing 0 0Probabilities 0.3 0.7Calculate the following The EMV Maximin criterion Maximax criterion Minimax criterionThe original z-score formula intended for public manufacturing companies is shown below: Altman Z-Score = (1.2 × X1) + (1.4 × X2) + (3.3 × X3) + (0.6 × X4) + (0.99 × X5) The inputs for our z-score calculation are the following: X1 = Working Capital ÷ Total Asset X2 = Retained Earnings ÷ Total Assets X3 = EBIT ÷ Total Assets X4 = Market Capitalization ÷ Total Liabilities X5 = Sales ÷ Total Assets The following assumptions will be used for our modeling exercise. Current Assets = $60 million Current Liabilities = $40 million Fixed Assets = $100 million Net Income = $10 million Dividends = $2 million Sales = $60 million COGS and SG&A = $40 million P/E Multiple = 8.0x Total Liabilities = $120 million What is the Z-score?
- 4. What is the optimized Z value for this following LP problem? Minimize Z= 3x + 10y, subject to (1) 2x + 4y ≤ 12 and (2) 5x + 2y ≥ 10 and (3) x, y ≥ 0. Answer: ______________Based on the following sensitivity analysis, which of the following products would be considered most sensitive to changes or errors in the objective function coefficient? A. Product_2 B. Product_1 C. Product_3 Variable Cells Cell Name Final Value Reduced Cost Objective Coefficient AllowableIncrease AllowableDecrease $B$2 Product_1 0 −2 25 13 5 $B$3 Product_2 175 0 25 8 9 $B$4 Product_3 0 −1.5 25 11 3 Constraints Cell Name Final Value Shadow Price Constraint R.H.Side AllowableIncrease AllowableDecrease $H$9 Resource_A 0 0 100 1E+30 100 $H$10 Resource_B 525 0 800 1E+30 275 $H$11 Resource_C 700 1.75 700 366.6666667 700Dataware is trying to determine whether to give a $10 rebate, cut the price $6, or have no price change on a software product. Currently, 40,000 units of the product are sold each week for $45 apiece. The variable cost of the product is $5. The most likely case appears to be that a $10 rebate will increase sales 30%, and half of all people will claim the rebate. For the price cut, the most likely case is that sales will increase 20%.a. Given all other assumptions, what increase in sales from the rebate would make the rebate and price cut equally desirable?b. Dataware does not really know the increase in sales that will result from a rebate or price cut. However, the company is sure that the rebate will increase sales by between 15% and 40% and that the price cut will increase sales by between 10% and 30%. Perform a sensitivity analysis (two-way data table) that could be used to help determine Dataware’s best decision.