A firm is planning to spend $75,000 on advertising. It costs $3000 per minute to advertise on television and $1000 per minute to advertise on radio. If the firm buys X minutes of television advertising and Y minutes of radio advertising, its revenue in thousands of dollars is given by -0.3x^2-0.4y^2+0.8xy+5x+10y. How can the firm maximize its revenue? Formulate the written model and solver model.
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: Consider the sports ratings model . If you were going to give more recent games more weight, how…
A: The sports ratings model calculates the ratings of a sports team based on actual and predicted point…
Q: After entering the data shown below in cells B2, B3, B6, and B10, what values should appear in the…
A: Below is the solution:-
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: When calculating a company’s free cash flow from earnings before interest and taxes we must add back…
A: Answer d) They are non-cash expenditures.
Q: What sales price will be necessary to achieve a target profit of $1 million?
A: The unit variable cost, fixed cost, target profit, and target volume, sales price to accomplish the…
Q: Suppose you want to invest a maximum amount of $20,000 in a portfolio with the objective to maximize…
A: note: only formulation has been asked.
Q: The political pollster Canter is preparing for a national election. It would like to poll at least…
A: Given Information:
Q: The relationship between marketing expenditures (x) and sales (y is given by the following formula,…
A: Given equation - y= 6x - 0.40(x)2 +7
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: A market analyst working for a small appliance manufacturer finds that if the firm produces and…
A: Answer (a) When given a graph of a profit equation with the number of items produced on the x-axis…
Q: The relationship between marketing expenditures (x) and sales (y) is given by the following formula,…
A:
Q: The manager of a restaurant chain in Izmir is trying to decide on the types and amounts of…
A: Given information, Television Commercial cost = 30000 Customers = 50,000 Potential customers for…
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: 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: 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: We must invest all our money in two stocks: x and y.The variance of the annual return on one share…
A:
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: [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: 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: Your company orders packs of gums and, then, sells them to retailers. The profit you get from each…
A: A payoff matrix is a table where techniques of one player are recorded in lines and those of the…
Q: A large food chain owns a number of pharmacies that operate in a variety of settings. Some are…
A: Hours of Operation Average Revenue 40 5958 44 6662 48 6004 48 6011 60 7250 70 8632 72…
Q: A company produces widgets at plants 1 and 2. It costs 135x1y2 dollars to produce x units at plant 1…
A: Total cost=135×7001/2+260×10001/3=3,571.77+2,599.99=6,171.76
Q: A local finance company quotes a 16 percent interest rate on one-year loans. So, if you borrow…
A: The timeline is: To find the APR and EAR, we need to use the actual cash flows of the loan. In…
Q: Write an equation giving profit as a function of the number of lightweight compasses produced. (ii)…
A: (i) p=30-3q
Q: What is the difference between the independent and dependent variable? How do you determine which…
A: A variable is a particular trademark or amount that can be estimated and is countable. Variables…
Q: Which one is valid for use in an LP problem? O log x1 + x1 x2 +3x3 <=100 3x1+4x2 <5 x3 Maximize x1 +…
A: Linear programming is a technique to accomplish the best result in a numerical model whose…
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: 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: If a company currently has $1000 cash, $300 income every month and $200 profit every month, how many…
A: Given that: Cash in Hand = $1000 Income(Revenue) =$300 Profit = $200
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: A trail mix company has 200 pounds of peanuts and 150 pounds of raisins. A batch of house mix takes…
A: Given Information:
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: Taxes The function T(x) represents the tax bill T of a single person whose adjusted gross income is…
A: Since you have posted a question with multiple sub-parts, we will solve first three sub-parts for…
Q: 40. Mutual Funds In 2015, the Phoenix/Zweig Advisors Zweig Total Return fund (ZTR) was expected to…
A: Z = Investment amount in ZTR M = Investment amount in MSP The objective is to maximize the return.…
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: 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: 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: ayue Is The company is evaluating three different expansion plans: Minor, moderate, or major. They…
A:
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: LEASE USE SIMPLEX METHOD. Thank you! Suppose a company manufactures different electronic components…
A: Let us assume x1 as the no.of components of A to be produced, x2 for B and x3 for C. It is also…
Q: ABC Co. produces a product in the United Kingdom at a cost of £0.55 per unit which it then sells in…
A: Cost of Product =£0.55 per unit Selling Price= €1.25 per unit.
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…
A firm is planning to spend $75,000 on advertising. It costs $3000 per minute to advertise on television and $1000 per minute to advertise on radio. If the firm buys X minutes of television advertising and Y minutes of radio advertising, its revenue in thousands of dollars is given by -0.3x^2-0.4y^2+0.8xy+5x+10y. How can the firm maximize its revenue? Formulate the written model and solver model.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 3 images
- The eTech Company is a fairly recent entry in the electronic device area. The company competes with Apple. Samsung, and other well-known companies in the manufacturing and sales of personal handheld devices. Although eTech recognizes that it is a niche player and will likely remain so in the foreseeable future, it is trying to increase its current small market share in this huge competitive market. Jim Simons, VP of Production, and Catherine Dolans, VP of Marketing, have been discussing the possible addition of a new product to the companys current (rather limited) product line. The tentative name for this new product is ePlayerX. Jim and Catherine agree that the ePlayerX, which will feature a sleeker design and more memory, is necessary to compete successfully with the big boys, but they are also worried that the ePlayerX could cannibalize sales of their existing productsand that it could even detract from their bottom line. They must eventually decide how much to spend to develop and manufacture the ePlayerX and how aggressively to market it. Depending on these decisions, they must forecast demand for the ePlayerX, as well as sales for their existing products. They also realize that Apple. Samsung, and the other big players are not standing still. These competitors could introduce their own new products, which could have very negative effects on demand for the ePlayerX. The expected timeline for the ePlayerX is that development will take no more than a year to complete and that the product will be introduced in the market a year from now. Jim and Catherine are aware that there are lots of decisions to make and lots of uncertainties involved, but they need to start somewhere. To this end. Jim and Catherine have decided to base their decisions on a planning horizon of four years, including the development year. They realize that the personal handheld device market is very fluid, with updates to existing products occurring almost continuously. However, they believe they can include such considerations into their cost, revenue, and demand estimates, and that a four-year planning horizon makes sense. In addition, they have identified the following problem parameters. (In this first pass, all distinctions are binary: low-end or high-end, small-effect or large-effect, and so on.) In the absence of cannibalization, the sales of existing eTech products are expected to produce year I net revenues of 10 million, and the forecast of the annual increase in net revenues is 2%. The ePIayerX will be developed as either a low-end or a high-end product, with corresponding fixed development costs (1.5 million or 2.5 million), variable manufacturing costs ( 100 or 200). and selling prices (150 or 300). The fixed development cost is incurred now, at the beginning of year I, and the variable cost and selling price are assumed to remain constant throughout the planning horizon. The new product will be marketed either mildly aggressively or very aggressively, with corresponding costs. The costs of a mildly aggressive marketing campaign are 1.5 million in year 1 and 0.5 million annually in years 2 to 4. For a very aggressive campaign, these costs increase to 3.5 million and 1.5 million, respectively. (These marketing costs are not part of the variable cost mentioned in the previous bullet; they are separate.) Depending on whether the ePlayerX is a low-end or high-end produce the level of the ePlayerXs cannibalization rate of existing eTech products will be either low (10%) or high (20%). Each cannibalization rate affects only sales of existing products in years 2 to 4, not year I sales. For example, if the cannibalization rate is 10%, then sales of existing products in each of years 2 to 4 will be 10% below their projected values without cannibalization. A base case forecast of demand for the ePlayerX is that in its first year on the market, year 2, demand will be for 100,000 units, and then demand will increase by 5% annually in years 3 and 4. This base forecast is based on a low-end version of the ePlayerX and mildly aggressive marketing. It will be adjusted for a high-end will product, aggressive marketing, and competitor behavior. The adjustments with no competing product appear in Table 2.3. The adjustments with a competing product appear in Table 2.4. Each adjustment is to demand for the ePlayerX in each of years 2 to 4. For example, if the adjustment is 10%, then demand in each of years 2 to 4 will be 10% lower than it would have been in the base case. Demand and units sold are the samethat is, eTech will produce exactly what its customers demand so that no inventory or backorders will occur. Table 2.3 Demand Adjustments When No Competing Product Is Introduced Table 2.4 Demand Adjustments When a Competing Product Is Introduced Because Jim and Catherine are approaching the day when they will be sharing their plans with other company executives, they have asked you to prepare an Excel spreadsheet model that will answer the many what-if questions they expect to be asked. Specifically, they have asked you to do the following: You should enter all of the given data in an inputs section with clear labeling and appropriate number formatting. If you believe that any explanations are required, you can enter them in text boxes or cell comments. In this section and in the rest of the model, all monetary values (other than the variable cost and the selling price) should be expressed in millions of dollars, and all demands for the ePlayerX should be expressed in thousands of units. You should have a scenario section that contains a 0/1 variable for each of the binary options discussed here. For example, one of these should be 0 if the low-end product is chosen and it should be 1 if the high-end product is chosen. You should have a parameters section that contains the values of the various parameters listed in the case, depending on the values of the 0/1 variables in the previous bullet For example, the fixed development cost will be 1.5 million or 2.5 million depending on whether the 0/1 variable in the previous bullet is 0 or 1, and this can be calculated with a simple IF formula. You can decide how to implement the IF logic for the various parameters. You should have a cash flows section that calculates the annual cash flows for the four-year period. These cash flows include the net revenues from existing products, the marketing costs for ePlayerX, and the net revenues for sales of ePlayerX (To calculate these latter values, it will help to have a row for annual units sold of ePlayerX.) The cash flows should also include depreciation on the fixed development cost, calculated on a straight-line four-year basis (that is. 25% of the cost in each of the four years). Then, these annual revenues/costs should be summed for each year to get net cash flow before taxes, taxes should be calculated using a 32% tax rate, and taxes should be subtracted and depreciation should be added back in to get net cash flows after taxes. (The point is that depreciation is first subtracted, because it is not taxed, but then it is added back in after taxes have been calculated.) You should calculate the company's NPV for the four-year horizon using a discount rate of 10%. You can assume that the fixed development cost is incurred now. so that it is not discounted, and that all other costs and revenues are incurred at the ends of the respective years. You should accompany all of this with a line chart with three series: annual net revenues from existing products; annual marketing costs for ePlayerX; and annual net revenues from sales of ePlayerX. Once all of this is completed. Jim and Catherine will have a powerful tool for presentation purposes. By adjusting the 0/1 scenario variables, their audience will be able to see immediately, both numerically and graphically, the financial consequences of various scenarios.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.)
- 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).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?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?