An analyst is constructing a simple model to determine the gross and net profit of a product, given its profit per unit, quantity sold, and the total costs assigned to the product. The calculation for gross profit is Profit per Unit times Quantity. The calculation for Net Profit is Gross Profit minus Total Costs. A B 1 2 Profit per Unit 2 3 Quantity 19,400 4 Gross Profit 5 6 Total Costs 9,600 7 8 Net Profit With the values for Profit per Unit, Quantity, and Total Costs shown above, what should the model return for the following calculated cells

An analyst is constructing a simple model to determine the gross and net profit of a product, given its profit per unit, quantity sold, and the total costs assigned to the product. The calculation for gross profit is Profit per Unit times Quantity. The calculation for Net Profit is Gross Profit minus Total Costs. A B 1 2 Profit per Unit 2 3 Quantity 19,400 4 Gross Profit 5 6 Total Costs 9,600 7 8 Net Profit With the values for Profit per Unit, Quantity, and Total Costs shown above, what should the model return for the following calculated cells

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter6: Optimization Models With Integer Variables

Section6.4: Fixed-cost Models

Problem 20P

See similar textbooks

Similar questions

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.
Another way to derive a demand function is to break the market into segments and identify a low price, a medium price, and a high price. For each of these prices and market segments, we ask company experts to estimate product demand. Then we use Excels trend curve fitting capabilities to fit a quadratic function that represents that segments demand function. Finally, we add the segment demand curves to derive an aggregate demand curve. Try this procedure for pricing a candy bar. Assume the candy bar costs 0.55 to produce. The company plans to charge between 1.10 and 1.50 for this candy bar. Its marketing department estimates the demands shown in the file P07_47.xlsx (in thousands) in the three regions of the country where the candy bar will be sold. What is the profit-maximizing price, assuming that the same price will be charged in all three regions?
A person sells and installs A, B and C. The table shows, for example, that it takes 3 hours to sell a unit of B, it takes 4 hours to install it, and net profit per unit is $ 40. Product No. of Units Selling Hours per Unit Installation Hours per Unit Profit per Unit A x 1 1 $10 B y 3 4 40 C z 2 1 10 During a 38-hour week, the person allots no more than 18 hours to selling and no more than 20 hours to installation. Find the combination of number of units of A, B, C that would yield maximum profit.
Can you show how to put it in Excel? XYZ store sells regular and premium nut mixes. Premium mix contains three quarters pound of cashews and one quarter of peanuts, and the regular mix has half pound of cashews and half pound peanuts per bag. The shop has 200 pounds of cashews and 300 pounds of peanuts to work with. Cashews cost $1.50 per pound, and peanuts cost 60 cents per pound. Premium mix will sell for $2.90 per pound, and the standard mix will sell for $2.55 per pound. The owner esimtes that no more than 200 bags of one types can be sold. What is the best combinations of products that maximizes profits? Make sure to create a feasible solution with countable number of products (no partials)
A company manufactures two products. If it chargesprice pi for product i, it can sell qi units of product i,where q1 = 60 - 3p1 + p2 and q2 = 80 - 2p2 + p1. Itcosts $5 to produce a unit of product 1 and $12 to produce a unit of product 2. How many units of eachproduct should the company produce, and what pricesshould it charge, to maximize its profit? Use spreadsheet modelling in Excel
A company manufactures two products. If it charges aprice pi for product i, it can sell qi units of product i, whereq1 60 3p1 p2 and q2 80 2p2 p1. It costs $25to produce a unit of product 1 and $72 to produce a unit ofproduct 2. How many units of each product should beproduced to maximize profits?
Imagine that a firm produces good X with just two factors: capital, which is fixed in supply; and labour, which is variable. The effect on total output (TPP) of increasing the number of workers is shown in column (2) of the table below. (We will fill in columns (3) and (4) ) The relationship between the output (total physical product) of good X and the number of workers employed (1) No. of workers (2) TPP (3) APP (4) MPP 0 1 2 3 4 5 6 7 8 9 0 10 26 41 52 60 65 67 67 63 ……. ……. ……. ……. ……. ……. ……. ……. ……. ……. ……. ……. ……. ……. ……. ……. ……. ……. …….
Show cells in excel with step by step using solver and the sum product function show how to calculate weighted risk Wall Street firms commonly use linear programming models to select their bond portfolios. A firm is considering the following 5 bonds: Bond Annual Return rate (%) Risk measure Bond 9.2 5 Bond 5 3 Bond 6.1 2 Bond 3.5 4 Bond 1.2 1 In the table above, “risk measure” has a value between 1 and 5 with 5 indicating the riskiest bond and 1 the least risky bond. The firm has a budget of 1 million dollars for this investment. The firm wants to decide its investments in the 5 bonds to maximize the expected return of the portfolio, subject to constraints listed below: The weighted average risk of the portfolio should not exceed 4. At least 30% of the total investment can be invested in bond 3. To diversify the portfolio, the investment on each bond should be at least 10% of the total investment. The sum of investments made in…
A company produces and sells luxury goods and is able to control the demand for the product by varying the selling price. The relationship between price and demand is found to be p = 10 − 42 D2 + 2D where p is the price per unit in million dollars and D is the demand per year. The company is seeking to maximize its profit. The fixed cost is $59 million per year and the variable cost is $25 million per unit. The production capacity is 42 units per year, and the company produces at least 1 unit per month. a) Derive how to find the number of units that should be produced annually to maximize profit. b) What is the maximum profit per year? c) What is the annual breakeven point? d) What is the company’s range of profitable output per year?
A manager wants to know how many units of each product to produce on a daily basis in order toachieve the highest contribution to profit. Production requirements for the products are shown inthe following table.ProductMaterial 1(pounds)Material 2(pounds)Labor(hours)A 2 3 3.2B 1 5 1.5C 6 — 2.0Material 1 costs $5 a pound, material 2 costs $4 a pound, and labor costs $10 an hour. Product Asells for $80 a unit, product B sells for $90 a unit, and product C sells for $70 a unit. Availableresources each day are 200 pounds of material 1; 300 pounds of material 2; and 150 hours of labor.The manager must satisfy certain output requirements: The output of product A should not bemore than one-third of the total number of units produced; the ratio of units of product A to units ofproduct B should be 3 to 2; and there is a standing order for 5 units of product A each day. Formulate a linear programming model for this problem, and then solve
Calculate the weighted average cost of capital for Foggy Futures Weather Forecasters.The firm is in the 25% tax bracket. The optimal capital structure is listed below:SOURCE OF CAPITAL WEIGHTDebt 20%Preferred Stock 30%Common Stock 50% DebtThe firm can issue $1000 par value, 9% coupon interest bond with a 15 year maturity date. The bond has an average discount of $20 and flotation costs of $30 per bond. The selling price is $1,000Preferred Stock The firm can sell preferred stock with a dividend that is 10% of the current price of $95. The cost of issuing and selling the stock is expected to be $7 per shareCommon Stock The firm's common stock is currently selling for $100 per share. The firm expects to pay cash dividends of $12 per share next year. The dividends have been growing at 8%. The stock was discounted by $7, and the flotation costs amounted to $5 per share.
A firm is considering importing some products to sell in a local market. The unit price and cost for product i are p; and Cį, respectively. While the prices may be determined by the firm, the costs are given and fixed. For product i, the demand volume is Aį – Bipi, where A; and Bi are all given. The amount of budget that may be used to purchase all products is K. The demand volume may be fractional. Formulate a mathematical program that can find a purchasing plan that maximizes the firm's profit. Determine whether your program is an LP, IP, or NLP.