Given the model in the Multiserver Simulation.xlsmfile, what unit cost parameters should be used if we are interested in “optimizing” the system? Choose repre-sentative inputs and unit costs, and then illustrate how to use the simulation outputs to estimate total system costs.
Q: Find the maximum and minimum values of the function Z = 8X1 + 5X2, subject to the following: 3X1 –…
A: The value of the objective function at each of these extreme points is as follows: Extreme…
Q: An ad campaign for a new snack chip will be conducted in a limited geographical area and can use TV…
A: Given data is Medium Cost Reached Quality TV 500 10000 30 Radio 200 3000 40 Newspaper 400…
Q: We have separated the examples in this chapter into operations, finance, marketing, and sports…
A: In operations, another problem that could be attacked is minimizing the number of defective products…
Q: The management of the Keribels Company wishes to apply the Miller-Orr model to manage its cash…
A: Given data, Transaction cost =$100 Cash flow variance=75000 I =0.05%
Q: You have prepared a coin flipping simulation. In your simulation, a value of less than 0.5 is…
A: ANSWER : Given the value less then 0.5 is designated as " Heads " 0.180 Heads 0.571 Tails…
Q: Suppose you are an HR (human resources) manager at a big university, and you sense that the…
A: As an HR manager at a big university, it will create a great responsibility to cope up with the…
Q: A firm wants to determine its production rate over the next twelve months. expected demand for its…
A: Decision Variable: Suppose Pi = Production in month-i for i=1,2,3...,12 Si = Shortage in month-i…
Q: My current income is $40,000. I believe that I owe$8,000 in taxes. For $500, I can hire a CPA to…
A:
Q: strategy that maximizes the department store chain's expected profit earned by purchasing and…
A: πij= Revenue from regular price +Revenue from closeoutprice-cost of purchase =…
Q: Health care is continually in the news. Can (or should)simulation be used to help solve, or at least…
A: Let’s first understand what are the problems of health care these days and how can we solve them…
Q: Suppose you are a financial analyst and your company runs many simulation models to estimate the…
A: Simulation modeling: A simulation model is a computerized model that would depict or imitate a…
Q: A company manufactures two products. If it charges price pi for product i, it can sell qi units of…
A: Given, q1 = 60 - 3p1 + p2 q2 = 80 - 2p2 + p1.
Q: The aim of the objective function for Attaran Corporation should be to Maximize the objective value.…
A: Let number of portable Air conditioners manufactured be x and number of portable heaters…
Q: In a nonlinear programming model, for any set of values of the decision variables, whether or not…
A: False
Q: Which of the following statements is true regarding the advantages of using simulations? a. Its…
A: Option D is correct.
Q: We must invest all our money in two stocks: x and y.The variance of the annual return on one share…
A:
Q: A buyer for a large department store chain must place orders with an athletic shoe manufacturer six…
A: Given, Cost Price = $65 Selling Price = $85 Closeout sell price = $55 Demand (100s of pairs)…
Q: Explain the steps to be followed in Monte Carlo simulation
A: Monte Carlo simulation makes use of the concept of producing random numbers to generate values for…
Q: You own a coffee shop in a metro Toronto shopping mall. It is Friday evening and you are trying to…
A: We have to find the value of payoff for quality baked(Q)+demand(D) by using below formula
Q: A company operates under hard budget constraints and has a WACC of 12%. In the current year it can…
A: Below is the solution:-
Q: Select the least accurate statement regarding simulation. In a simulation, correlation between two…
A: In insights, connection or reliance is any factual relationship, if causal, between two arbitrary…
Q: TRUE OR FALSE In a simplex maximization slack variable is added to convert the objective function…
A: Slack variables are added to convert the objective function to the equation.
Q: Vladimir Ulanowsky is playing Keith Smithson in atwo-game chess match. Winning a game scores 1 match…
A:
Q: TRUE OR FALSE The objective function may be expressed as an equation or as an inequality
A: An objective function indicating a mathematical function that designed in a problem to optimize the…
Q: Two companies are producing widgets. It costs the first company q12 dollars to produce q1 widgets…
A: Given: First company Second company q12 dollars 0.5q22 dollars
Q: You have prepared a coin flipping simulation. In your simulation, a value of less than 0.5 is…
A: Given simulations random numbers : 0.021, 0.323, 0.200, 0.157, 0.278, 0.886, 0.699, 0.038, 0.315,…
Q: The condition of nonnegativity requires that: a. the objective function cannot be less than zero…
A: Linear programming can be used to find the best feasible solution to a problem. An optimum solution…
Q: Appliances Unlimited (AU) sells refrigerators. Anyrefrigerator that fails before it is three years…
A: Warranty refers to a facility that is provided to consumers in case of any malfunctioning product…
Q: Why is the RISKCORRMAT function necessary?How does @RISK generate random inputs by default,that is,…
A: RISKCORMMAT is considered as an function that helps in correlating two or more variables in the…
Q: You have $50,000 to invest in three stocks. Let Ri be the random variable representing the annual…
A: The question can be solved using Excel solver. Objective: To find a minimum variance (minimum risk)…
Q: Select the least accurate statement regarding RISKSIMTABLE. RISKSIMTABLE is a feature that is…
A: The RiskSimtable function is used to enter a list of values which is used to enter a list of values,…
Q: Bullseye Shirt Company makes three types of shirts: athletic, varsity, and surfer. The shirts are…
A: Decision Variable: Suppose- Xij be the yards of fabric of the ith ingredient used in the jth…
Q: Dataware is trying to determine whether to give a $10 rebate, cut the price $6, or have no price…
A: Consider creating a $10 rebate for a $45 product. Alternatives to a rebate would be to reduce the…
Q: A Make-or-Buy DecisionTriple X Company manufactures and sells refrigerators. It makes some of the…
A: If part has been manufactured: Fixed cost: $50,000 Labor cost: $1,25,000 Factory overhead: $60,000…
Q: 85. Health care is continually in the news. Can (or should)simulation be used to help solve, or at…
A: A marketing strategy is a business overall plan for attracting prospective consumers and turning…
Q: G z Product Mix Example Product 3 P01 P02 P03 P04 Profit/unit: 26 35 25 37 Hours : Machine available…
A: The question is related to optimum product mix. The limiting factor is machine hours. First we have…
Q: Based on Morrison and Wheat (1984). When his team is behind late in the game, a hockey coach usually…
A: There are two teams having average of 0.05 goals per minute. If goalkeeper is pulled out, your score…
Q: The management of the Keribels Company wishes to apply the Miller-Orr model to manage its cash…
A: Given data, Transaction cost =$100 Cash flow variance=75000 I =0.05%
Q: 7. Investment Advisors, Inc., is a brokerage firm that manages stock portfolios for a number of…
A: Given, Max 3U+5H s.t 25U+50H <= 80000 0.5U+0.25D <= 700 U <= 1000 U,H >= 0
Q: The manager of a bakery knows that the number of chocolate cakes he can sell on any given day is a…
A:
Q: MacBurger has just opened a fast-food restaurant inBloomington. Currently, i0 customers frequent…
A: Currency Frequency of Mac Burger is i_{0} customers and (N-i_{0}) customers frequent another…
Q: A company operates under hard budget constraints and has a WACC of 12%. In the current year it can…
A: THE ANSWER IS AS BELOW:
Q: INFORMA Furniture buys two products for resale: big shelves (B) and medium shelves (M). Each big…
A: Linear Programming is also called Linear optimization. Linear programming is used to find the best…
Q: An electronics firm is currently manufacturing an item that has a variable cost of 25Php/unit and a…
A: Given, Fixed cost- 700000 V.C- 50/UNIT
Q: a. Formulate a linear programming model that can be used to determine the number of gallons of…
A: Since you have posted a question with multiple sub-parts, we will solve the first three sub-parts…
Q: You have prepared a coin flipping simulation. In your simulation, a value of less than 0.5 is…
A: In a random experiment, the probability is an indicator of how likely an occurrence is to take…
Given the model in the Multiserver Simulation.xlsm
file, what unit cost parameters should be used if we are
interested in “optimizing” the system? Choose repre-
sentative inputs and unit costs, and then illustrate how to
use the simulation outputs to estimate total system costs.
Step by step
Solved in 3 steps
- If you want to replicate the results of a simulation model with Excel functions only, not @RISK, you can build a data table and let the column input cell be any blank cell. Explain why this works.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.)In the cash balance model from Example 11.5, the timing is such that some receipts are delayed by one or two months, and the payments for materials and labor must be made a month in advance. Change the model so that all receipts are received immediately, and payments made this month for materials and labor are 80% of sales this month (not next month). The period of interest is again January through June. Rerun the simulation, and comment on any differences between your outputs and those from the example.
- Suppose you begin year 1 with 5000. At the beginning of each year, you put half of your money under a mattress and invest the other half in Whitewater stock. During each year, there is a 40% chance that the Whitewater stock will double, and there is a 60% chance that you will lose half of your investment. To illustrate, if the stock doubles during the first year, you will have 3750 under the mattress and 3750 invested in Whitewater during year 2. You want to estimate your annual return over a 30-year period. If you end with F dollars, your annual return is (F/5000)1/30 1. For example, if you end with 100,000, your annual return is 201/30 1 = 0.105, or 10.5%. Run 1000 replications of an appropriate simulation. Based on the results, you can be 95% certain that your annual return will be between which two values?Rerun the new car simulation from Example 11.4, but now use the RISKSIMTABLE function appropriately to simulate discount rates of 5%, 7.5%, 10%, 12.5%, and 15%. Comment on how the outputs change as the discount rate decreases from the value used in the example, 10%.The simulation output from Example 11.6 indicates that an investment heavy in stocks produces the best results. Would it be better to invest entirely in stocks? Answer this by rerunning the simulation. Is there any apparent downside to this strategy?
- 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.Rerun the new car simulation from Example 11.4, but now introduce uncertainty into the fixed development cost. Let it be triangularly distributed with parameters 600 million, 650 million, and 850 million. (You can check that the mean of this distribution is 700 million, the same as the cost given in the example.) Comment on the differences between your output and those in the example. Would you say these differences are important for the company?Use excel for this problem A trust officer at the Blacksburg National Bank needs to determine how to invest $150,000 in the following collection of bonds to maximize the annual return. Bond Annual Return Maturity Risk Tax Free A 9.5% Long High Yes B 8.0% Short Low Yes C 9.0% Long Low No D 9.0% Long High Yes E 9.0% Short High No The officer wants to invest at least 40% of the money in short-term issues and no more than 20% in high-risk issues. At least 25% of the funds should go in tax-free investments, and at least 45% of the total annual return should be tax free. Formulate the LP model for this problem. Create the spreadsheet model and use Solver to solve the problem.
- Home mortgage lenders often charge points on a loan in order to avoid exceeding a legal limit on interest rates or to make their rates appear competitive with those of other lenders. As an example, with a two-point loan, the lender would loan only $98 for each $100 borrowed. The borrower would receive only $98 but would have to make payments just as if he or she had received $100. In this way, the lender can make more money while keeping his or her interest rate lower. Suppose that you receive a loan of $260,000 payable at the end each month for 30 years with an interest rate of 9% compounded monthly, but you have been charged three points. What is the effective interest rate on this home mortgage loan?A farm consists of 600 acres of land, of which 500 acres will be planted with corn, soybeans, and wheat, according to these conditions: At least half of the planted acreage should be in corn No more than 200 acres should be soybeans The ratio of corn to wheat planted should be 2:1 It costs $20 an acre to plant corn, $15 an acre to plant soybeans, and $12 an acre to plant wheat Formulate this problem as an LP model that will minimize planting cost while achieving the specified conditions.