strategy that maximizes the department store chain's expected profit earned by purchasing and subsequently selling pairs of the new tennis shoes. Is a decision tree really necessary
Q: A company is considering two insurance plans with coverage and premiums shown in the table. (For…
A: NOTE: As you have posted multiple questions, the first question is solved as per guidelines. You are…
Q: A buyer for a large sporting goods store chain must place orders for professional footballs with the…
A: a) Let us consider the following given above data Here we first construct the payoff table. We know…
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: 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: There are three investments, B1, B2 and B3. All of them have the same expected value and each with…
A: Given data is
Q: Stonebuilt Concrete produces a specialty cement used in construction of roads. Stonebuilt is a…
A: LN(Q) = Intercept + β1 LN(P) + β2 LN(M) + β3 LN(PR) + µ
Q: Michael has decided to invest $40,000 in three types of funds. Fund A has projected an annual return…
A:
Q: A computer reseller needs to decide how many laptops to order next month. The lowest end laptop…
A: From the above mentioned information the demand probabilities for, P (0) = 0.3, P (1) = 0.4, P(2)…
Q: Chapter 4. Tyler is hoping to get a lot of custom cake and cookie orders in his new bakery for…
A: Please note that as you have posted multiple questions in a single post, as per the guidelines,…
Q: Explain why it is problematic to include a constraint such as the following in an LP model for a…
A: Linear programming:It is a mathematical model where a linear function is maximized or minimized…
Q: Build a linear programming model to develop an investment portfolio that minimizes total risk under…
A: NOTE: WE ARE ONLY ALLOWED TO DO THE FIRST THREE SUB-PARTS AT A TIME. PLEASE POST THE REST QUESTIONS…
Q: The Sanders Garden Shop mixes two types of grass seed into a blend. Each type of grass has been…
A: Introduction:The given problem is a linear programming Cost Minimization problem. The problem is…
Q: Q2. What is the optimal solution and what is the value of the objective function? Show the relevant…
A: Q2.To find the objective function value Let us define the objective function and decision variables…
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: A computer reseller needs to decide how many laptops to order next month. The lowest end laptop…
A: Hi There, thanks for posting the question. But as per Q&A authoring guidelines, we must answer…
Q: The Schoch Museum (see Problem 30 in Chapter 11) is embarking on a five-year fundraising campaign.…
A: Donation refers to the instance of act concerning which a contribution, grant or gift is being…
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: Leach Distributors packages and distributes industrial supplies. A standard shipment can be packaged…
A: Based on the data given, we understand it is a Linear Programming Problem. The decision variables…
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: [Ad] Suppose the cost of a full-page color ad in the U.S. national edition of The Wall Street…
A: Given are the values for the cost of advertisement in different vehicle and also their audience…
Q: Drawthe budget constraint for a consumer with standard preferences.
A: For the First Part here is the solution: If the consumer had an income of $3,000 and the cost of…
Q: An advertising firm desires to reach two types of audiences-customers with annual income of more…
A: linear programming, a numerical displaying procedure in which a linear capacity is augmented or…
Q: A person starting in Columbus must visit Great Falls, Odessa, and Brownsville, and then return home…
A: Given, Columbus Great Falls Odessa Brownsville Columbus --- 102 79 56…
Q: The Camera Shop sells two popular models of digital SLR cameras (Camera A Price: 220, Camera B…
A:
Q: Chapter 4. Tyler is hoping to get a lot of custom cake and cookie orders in his new bakery for…
A: Note - Hi! Thank you for the question, As per the honour code, we are allowed to answer three…
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: 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: In a typical network model representation of the transportation problem, the nodes indicate a.…
A: A transportation problem indicating a method of identifying the optimal resources allocation based…
Q: A person wants to invest in one of three alternative investment plans: stocks, bonds or a savings…
A: Following is the given information:
Q: GM manufactures bikini swimming suits. Their business is highly seasonal, with expected demands…
A: LPP FORMULATION Let's define the variables first, let x1 be the total volume of suits (in dozens) to…
Q: Select all of the true statements: When we successfully find a solution to a linear programming…
A: Note - We are authorized to answer one question at a time, since you have not mentioned which…
Q: Consider a capital budgeting problem with seven project represented by binary (0 or 1) variables X1,…
A: As no specific data is specified in the question, we consider the given question asks for just to…
Q: Consider a toy retailer with warehouses in St. Louis and Kansas City, Missouri. The warehouses stock…
A: Given Unit Cost of toy (Cu)= $10 Holding cost(h) = 20% of toys value = $2 Shipping cost(λ) = $500…
Q: JJ is the financial manager in charge of the company pension fund at Arm Inc. JJ knows that the fund…
A: LP model is following: Decision variables: Let M = initial allocation of money X1 = units of bond 1…
Q: An investment advisor at RMC Financial Services wants to develop a model that can be used to…
A: x1 ,x2,x3 and x4 are corresponding ratio of stocks ,bonds, mutual funds and cash- x1+x2+x3+x4 = 1 x1…
Q: The cost of producing a certain commodity consists of P45.00 per unit for labor and material cost…
A: Formula to be used; Break even quantity = Fixed cost / Contribution margin
Q: Chapter 4. Tyler is hoping to get a lot of custom cake and cookie orders in his new bakery for…
A: From the above given data, Ordering cost, o=$20 per order Unit cost,u=$5 Inventory holding…
Q: FORUM Furniture buys two products for resale: big shelves (B) and medium shelves (M). Each big shelf…
A: B = Number of Big shelves M = Number of Medium shelves Objective function: Maximize Z = 360B + 250M…
Q: You are trying to decide how many vitamin pills to take. SuperV brand vitamin pills each contain 2…
A: WE ARE ALLOWED TO DO THE FIRST THREE SUB-PARTS ONLY. THE ANSWER IS AS BELOW:
Q: Leach Distributors packages and distributes industrial supplies. A standard shipment can be packaged…
A: The question is related to the Linear programming. The question is of maximization of Linear…
Q: Chapter 4. Tyler is hoping to get a lot of custom cake and cookie orders in his new bakery for…
A: The primary purpose of EOQ model is to reduce the total annual ordering and holding cost to the…
Q: Cox Electric makes electronic components and has estimated the following for a new design of one of…
A: Given data: Fixed Cost = $7,000 Material cost per unit = $0.15 Labor cost per unit = $0.10 Revenue…
Q: The manager of a bakery knows that the number of chocolate cakes he can sell on any given day is a…
A:
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: It costs $300 to buy a lawn mower from a lawn supply store. Assume that you can keep a lawn mower…
A: Build up a bookkeeping page enhancement model for mower purchasing for the following 10 years that…
Q: Ford has four automobile plants. Each is capable of producing the Taurus, Lincoln or Escort but it…
A: Integer programming: Integer programming represents the optimization of a linear function directed…
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…
A buyer for a large department store chain must place orders with an athletic shoe manufacturer six months prior to the time the shoes will be sold in the department stores. The buyer must decide on November 1 how many pairs of the manufacturer's newest model of tennis shoes to order for sale during the coming summer season. Assume that each pair of this new brand of tennis shoes costs the department store chain $65 per pair. Furthermore, assume that each pair of these shoes can then be sold to the chain's customers for $85 per pair. Any pairs of these shoes remaining unsold at the end of the summer season will be sold in a closeout sale next fall for $55 each. The probability distribution of consumer demand for these tennis shoes during the coming summer season has been assessed by
a. Identify the strategy that maximizes the department store chain's expected profit earned by purchasing and subsequently selling pairs of the new tennis shoes. Is a decision tree really necessary? If so, what does it add to the analysis? If not, why not?
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
- In Problem 12 of the previous section, suppose that the demand for cars is normally distributed with mean 100 and standard deviation 15. Use @RISK to determine the best order quantityin this case, the one with the largest mean profit. Using the statistics and/or graphs from @RISK, discuss whether this order quantity would be considered best by the car dealer. (The point is that a decision maker can use more than just mean profit in making a decision.)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.
- Sometimes curvature in a scatterplot can be fit adequately (especially to the naked eye) by several trend lines. We discussed the exponential trend line, and the power trend line is discussed in the previous problem. Still another fairly simple trend line is the parabola, a polynomial of order 2 (also called a quadratic). For the demand-price data in the file P13_10.xlsx, fit all three of these types of trend lines to the data, and calculate the MAPE for each. Which provides the best fit? (Hint: Note that a polynomial of order 2 is still another of Excels Trend line options.)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?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%.
- Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand will grow at 5% a year. If the company builds a plant that can produce x units of Wozac per year, it will cost 16x. Each unit of Wozac is sold for 3. Each unit of Wozac produced incurs a variable production cost of 0.20. It costs 0.40 per year to operate a unit of capacity. Determine how large a Wozac plant the company should build to maximize its expected profit over the next 10 years.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.Referring to Example 11.1, if the average bid for each competitor stays the same, but their bids exhibit less variability, does Millers optimal bid increase or decrease? To study this question, assume that each competitors bid, expressed as a multiple of Millers cost to complete the project, follows each of the following distributions. a. Triangular with parameters 1.0, 1.3, and 2.4 b. Triangular with parameters 1.2, 1.3, and 2.2 c. Use @RISKs Define Distributions window to check that the distributions in parts a and b have the same mean as the original triangular distribution in the example, but smaller standard deviations. What is the common mean? Why is it not the same as the most likely value, 1.3?
- 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?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.)You are considering a 10-year investment project. At present, the expected cash flow each year is 10,000. Suppose, however, that each years cash flow is normally distributed with mean equal to last years actual cash flow and standard deviation 1000. For example, suppose that the actual cash flow in year 1 is 12,000. Then year 2 cash flow is normal with mean 12,000 and standard deviation 1000. Also, at the end of year 1, your best guess is that each later years expected cash flow will be 12,000. a. Estimate the mean and standard deviation of the NPV of this project. Assume that cash flows are discounted at a rate of 10% per year. b. Now assume that the project has an abandonment option. At the end of each year you can abandon the project for the value given in the file P11_60.xlsx. For example, suppose that year 1 cash flow is 4000. Then at the end of year 1, you expect cash flow for each remaining year to be 4000. This has an NPV of less than 62,000, so you should abandon the project and collect 62,000 at the end of year 1. Estimate the mean and standard deviation of the project with the abandonment option. How much would you pay for the abandonment option? (Hint: You can abandon a project at most once. So in year 5, for example, you abandon only if the sum of future expected NPVs is less than the year 5 abandonment value and the project has not yet been abandoned. Also, once you abandon the project, the actual cash flows for future years are zero. So in this case the future cash flows after abandonment should be zero in your model.)